Microsoft Excel 2010 Power User value pack (45505274) - Online

This course explores the processing of formatting cells and text, using tools such as the format painter and changing the way text is presented in order for it to be more visually appealing. This course also explains the various options for formatting numbers in 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.

• Apply basic text formatting
• Apply and copy cell formatting
• Recognise how alignment commands change the position of text

Individuals and business users with basic computer literacy

By using Excel, you can create attractive and well-organised representations of worksheet and workbook data, making your data easy to read. This course demonstrates how to effectively use and customise charts in Excel 2010; it explores available chart types and the best use of each type; and shows how to change the different elements of a chart to provide an effective visualisation of your data.

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.

• Recognise when to use different Excel charts
• Insert a chart
• Identify the elements of an Excel chart
• Update an existing Excel chart's style, layout, or location
• Change the data range on which a chart is based

Individuals and business users with basic computer literacy

Excel 2010 provides a large variety of statistical functions that allow you to perform data analysis on worksheet data.

This course discusses various statistical functions, including those designed to work with averages, determine the median, pinpoint rank, percentages, and sample populations. In addition, this course explores the available cube functions, and the methods for working with arrays.

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.

• Use statistical functions in Excel 2010
• Use conditional functions in Excel 2010
• Use array formulas in Excel 2010
• Use advanced Excel functions
• Add and edit ActiveX Controls in an Excel worksheet

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

This course will show you how to move around the Excel interface using the various keys on the keyboard, such as the Home and End keys, and Ribbon commands. The course also covers the ways in which you can view and arrange workbooks and worksheets to be the most useful and shows you how you can access Excel's many Help features.

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.

• Recognise how to navigate around Excel in a given scenario
• Discuss Excel commands
• Alter your view of the worksheet

Individuals and business users with basic computer literacy

Excel 2010 provides easy to use and access tools that allow you to review, proof, and protect the workbooks you create and share. The tools for performing these tasks are grouped conveniently on the Ribbon and include the Spelling, Research, and Thesaurus tools; a Translate tool; tools to insert, edit, and review Comments in a worksheet; and tools for tracking changes and protecting workbooks. The various tasks you can perform with these features are covered in this course, along with how and when you would use these tools.

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.

• Use Excel's proofing tools
• Use the Excel comments feature
• Use track changes in Excel 2010
• Apply worksheet and workbook protection

Individuals and business users with basic computer literacy

This course describes Excel features such as how to save, print, and share workbooks and worksheets. These features allow you to easily collaborate with others. Explore how to use these features to increase your efficiency and productivity.

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.

• Save a workbook in a different format
• Change the default save options in Excel 2010
• Share and send a workbook
• Use the Page Setup settings to prepare a worksheet for printing

Individuals and business users with basic computer literacy

This course explores the basics of Excel 2010, including opening the application, creating new spreadsheets, entering data and, AutoFill features. It also provides an introduction to the many tools that will help you create and use your spreadsheets productively.

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.

• Identify the features of spreadsheets
• Recognise the functions of key Excel 2010 interface elements
• Create a new workbook
• Enter data in a given scenario
• Open a workbook based on an existing template

Individuals and business users with basic computer literacy

Excel 2010 provides tools that enable you to efficiently present your data and that can also make your data easier to understand. This course analyses features such as tables, styles, conditional formatting and sparklines and how to access and use them efficiently.

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.

• Apply conditional formatting rules
• Use sparklines to show data trends
• Format sparklines
• Sort and filter table data
• Use conditional formats to highlight data

Individuals and business users with basic computer literacy

This course introduces you to the changes made to functions in Excel 2010, including improved function accuracy and consistency. Be taken through the useful features of Excel's status bar that automatically displays basic calculations as well as the Function Library, which groups useful functions. The most common use of functions, calculating basic financial, logical, date and time data is also covered.

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.

• Identify the characteristics of functions in Excel
• Perform basic calculations using Excel's most commonly used functions
• Use financial functions
• Use date and time functions
• Use logical functions to help perform calculations on worksheet data

Individuals and business users with basic computer literacy

Excel 2010 provides you with the tools that allow you to perform calculations on your workbook data. Being able to use formulas to do complicated calculations not only simplifies your work but also helps to reduce the number of errors that can arise in such complex tasks. This course introduces the concepts and terminology associated with formulas, and demonstrates how to create and edit them, copy and paste them, and how to check for errors that can arise.

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.

• Identify elements of a formula
• Recognise how Excel calculates precedence in a formula
• Create and insert formulas
• Use names in formulas
• Correct common error values
• Define a name reference and use it in a formula
• Copy and paste a formula between cells

Individuals and business users with basic computer literacy