Microsoft Excel Intermediate 2010

Description

This practical course allows the delegate to appreciate the full potential of Microsoft Excel 2010. Participants will be encouraged to discuss their individual requirements relevant to their working environment.

What you will learn

By the end of the course the delegate should be able to:

 Use a Variety of Worksheet Views in Microsoft Excel
 Apply a Range of Advanced Formatting Techniques to Worksheet Cells
 Apply a Range of Advanced Editing Techniques to Worksheet Cells
 Create and Apply Formulas and Functions
 Create, Edit and Delete Cell Comments
 Create and Use Defined Names in a Workbook
 Link Workbooks Within Excel
 Use a Range of Elements and Features to Set Chart Parameters
 Select and Change the Format of Charts
 Protect Data in Worksheets and Workbooks
 Create, Edit and Delete Templates
 Print Using Advanced Techniques
 Create Custom Forms and Lists
 Filter Lists Using Auto, Custom and Advanced Filter Options
 Sort Using Multiple Column and Custom Sort Options
 Create, Construct and Operate a PivotChart
 Create and Work With Goal Seek, Solver and Scenarios