Overview
Covering a wide range of advanced skills for Microsoft Excel 2010, such as customising visual elements, workbook setting, conditional formatting and number formats, organising data and objects, automating tasks using macros and more, this selection of courses for financial management you will take your analsis, reporting and presentations to a higher level. This comprehensive 10 pack is designed to deliver advanced skills using Microsoft Excel 2010.
Pack inclusions:
- Customising visual elements in Excel 2010
- Workbook settings, conditional formatting and number formats in Excel 2010
- Organising data and objects in Excel 2010
- Verifying Excel 2010 data and formulas
- Automating Excel 2010 tasks using macros
- Analysing data with What-If Analysis in Excel 2010
- Adding visuals, themes, and styles to Excel workbooks
- PivotTable filters, calculations, and PowerPivot
- PivotTables and PivotCharts in Excel 2010
- Using Lookup, Reference, Math and Text Functions in Excel 2010
Audience
Anyone looking to expand their financial management skills using Microsoft Excel 2010.
Choose an offering for each one of the bundle components then click on 'Add To Cart' button below:
Adding Visuals, Themes, and Styles to Excel 2010 Workbooks (UK)
Overview
Excel has more than just charts to offer in the way of visual presentation. Nonchart-related graphic tools such as Shapes, SmartArt, WordArt, ClipArt, and Screenshots are all ways to enhance the visual impact of documents that tend to be dominated by dry numbers and text. This course focuses on these and other graphic elements that can be added to Excel 2010 spreadsheets. This course also introduces ways to change the themes and styles offered by Excel 2010.
For an optimal experience please check the minimum computer system requirements.
This online course forms part of the SkillsNet short course suite.
Please note this course is only available to CPA Australia members.
Objectives
This course focuses on these and other graphic elements that can be added to Excel 2010 spreadsheets. This course also introduces ways to change the themes and styles offered by Excel 2010.
Audience
Individuals and business users with basic computer literacy.
Offerings
There are no Offerings available for this course.
Analyzing Data with What-if Analysis in Excel 2010 (UK)
Overview
Excel 2010 provides powerful data-analysis tools that enable you to explore large amounts of data and to make educated business decisions based on that data. Using Goal Seek and Solver enables you to retrieve required results from formulas by determining the data the formula requires. And you can use additional what-if analysis components, data tables and scenarios, to forecast worksheet outcome models and to see how changing values in formulas affect the formula results.
Prerequisites: Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality
For an optimal experience please check the minimum computer system requirements.
This online course forms part of the SkillsNet short course suite.
Please note this course is only available to CPA Australia members.
Objectives
- Use Goal Seek for data analysis
- Use Solver to perform data analysis
- Create scenarios using the Scenario Manager
- Manage Excel 2010 what-if scenarios
- Create a data table for what-if analysis
- Recognise how to project values in a series
- Use what-if analysis to find out how to achieve a desired result
- Use what-if analysis to determine the maximum or minimum value of one cell by changing other cells
- Use what-if analysis to forecast best-case and worst-case results
- Use what-if analysis to explore a possible set of outcomes at a glance
Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level.
Offerings
There are no Offerings available for this course.
Automating Excel 2010 Tasks Using Macros (UK)
Overview
This course will introduce you to macros in Excel and show you how to leverage their power to make your work with Excel easier.
Prerequisites: Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality
For an optimal experience please check the minimum computer system requirements.
This online course forms part of the SkillsNet short course suite.
Please note this course is only available to CPA Australia members.
Objectives
- Identify the features of Excel 2010 macros
- Use the Macro Recorder to record and run a macro
- Identify the steps in recording a macro using the macro recorder
- Edit and delete macros
- Run a macro in different ways
- Prepare for recording a macro
- Record and run a macro
- Assign a macro to the developer tab on the Ribbon
- Add a macro the Quick Access Toolbar
Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level.
Offerings
There are no Offerings available for this course.
Organizing Data and Objects in Excel 2010 (UK)
Overview
This course explores organising data in Excel 2010 using the built-in features. It also covers arranging objects for better viewing as well as the use of hyperlinks to organise data.
Prerequisites: Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality
For an optimal experience please check the minimum computer system requirements.
This online course forms part of the SkillsNet short course suite.
Please note this course is only available to CPA Australia members.
Objectives
- Sort data in more than one column or row
- Create a custom filter
- Outline data using the Subtotal, Auto Outline, or Group commands
- Arrange objects on a worksheet page
- Recognise how you can arrange data to fit a specified page layout for printing
- Create a hyperlink
- Modify hyperlinks
- Sort and filter data
- Create an outline so you can group and summarise data
- Arrange objects on a page
- Create a hyperlink from a worksheet to a web page
Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level.
Offerings
There are no Offerings available for this course.
PivotTable Filters, Calculations, and PowerPivot (UK)
Overview
This course introduces PivotTable, filtering, Slicer and other features to give you the tools to summarise large amounts of data efficiently. It also covers how to apply calculations to the data in PivotTables in the form of summary functions and custom calculations.
Prerequisites: Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality
For an optimal experience please check the minimum computer system requirements.
This online course forms part of the SkillsNet short course suite.
Please note this course is only available to CPA Australia members.
Objectives
- Use calculations in PivotTable reports
- Filter data in PivotTable reports
- Create and use slicers
- Identify the functions of elements of the PowerPivot interface
- Identify the features of PowerPivot for Excel add-in
- Change functions in PivotTable reports
- Create your own formula in a PivotTable report
- Enable multiple filters and apply a Report filter
- Use slicers to filter data in a PivotTable report
Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level
Offerings
There are no Offerings available for this course.
Verifying Excel 2010 Data and Formulas (UK)
Overview
This course describes Excel 2010's auditing and formula correction features and shows you how to use data validation to avoid worksheet errors.
Prerequisites: Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality
For an optimal experience please check the minimum computer system requirements.
This online course forms part of the SkillsNet short course suite.
Please note this course is only available to CPA Australia members.
Objectives
- Use Excel's formula auditing tools to evaluate and correct formulas
- Use the Watch Window to inspect, audit, or confirm formula calculations and results
- Use data tools to convert text to columns and remove duplicates
- Add data validation to worksheet cells
- List the different things you can use data validation for
- Use error checking to identify a formula error
- Separate text in one column into two columns
- Restrict data entry in specific cells
Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level.
Offerings
There are no Offerings available for this course.
Customizing Visual Elements in Excel 2010 (UK)
Overview
Excel 2010 provides you with a number of basic and advanced techniques for customising common elements such as charts, themes, cell styles, and graphics. This course describes many of these techniques and shows you how to implement them to their best effect.
Prerequisites: Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality
For an optimal experience please check the minimum computer system requirements.
This online course forms part of the SkillsNet short course suite.
Please note this course is only available to CPA Australia members.
Objectives
- Manually adjust a chart's layout and formatting
- Save and apply a chart template
- Manually format illustrations using the Format object dialog box
- Customise and save Excel themes and styles
- Save an Excel template and apply to a new workbook
- Adjust individual chart elements
- Format Excel illustrations
- Create a new cell style
- Create an Excel theme
Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level
Offerings
There are no Offerings available for this course.
Using Lookup, Reference, Math, and Text Functions in Excel 2010 (UK)
Overview
The Excel 2010 function library includes a number of functions in Lookup & Reference, Math & Trig, and Text categories that enable you to quickly complete tasks and analyse data. This course explores rounding functions, and also provides a number of functions to make working with text easier.
For an optimal experience please check the minimum computer system requirements.
This online course forms part of the SkillsNet short course suite.
Please note this course is only available to CPA Australia members.
Objectives
- Use lookup functions in Excel 2010
- Recognise when to use the lookup functions in Excel 2010
- Use reference functions in Excel 2010
- Use math functions in Excel 2010
- Recognise when to use the rounding functions in Excel 2010
- Use trig functions in Excel 2010
- Use text functions in Excel 2010
- Use advanced functions in Excel 2010
Audience
Individuals who seek proficiency in the use of Microsoft Excel 2010 at a power user level and have knowledge of computing, spreadsheets, and the Microsoft Office and online work environments
Offerings
There are no Offerings available for this course.
Workbook Settings, Conditional Formatting, and Number Formats in Excel 2010 (UK)
Overview
This course explores some of the more advanced ways that you can enhance your workbooks and data using Excel’s powerful customisation features. Explore numerous abilities to modify existing themes and styles to meet business needs, or you can create custom themes and styles to further enhance data presentation. Custom number formats allow you even more control over the presentation and usefulness of your workbooks and conditional formatting gives you the power to apply individual formatting based on custom rules to further enhance data presentation.
For an optimal experience please check the minimum computer system requirements.
This online course forms part of the SkillsNet short course suite.
Please note this course is only available to CPA Australia members.
Objectives
- Customise workbook settings using Excel Options
- Recognise how to alter code strings to create custom number formats
- Create a conditional format based on a new formatting rule
- Manage conditional formatting rules
- Customise workbook settings and the Quick Access Toolbar
Audience
Prerequisites
Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality.
Individuals and business users with basic computer literacy
Offerings
There are no Offerings available for this course.
PivotTables and PivotCharts in Excel 2010 (UK)
Overview
One of the most powerful tools that Excel 2010 provides is a PivotTable that allows you to dynamically reorganise and display your data. PivotTables can summarise huge amounts of data by category without the need to input complex formulas or spend long hours manually reorganising your spreadsheet. This course will introduce you to PivotTables and show you the many benefits they provide.
For an optimal experience please check the minimum computer system requirements.
This online course forms part of the SkillsNet short course suite.
Please note this course is only available to CPA Australia members.
Objectives
- Create a PivotTable report
- Rearranging data in PivotTable reports
- Customise PivotTable reports
- Modify a PivotTable report's design
Audience
Prerequisites
Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality.
Individuals and business users with basic computer literacy
Offerings
There are no Offerings available for this course.