Microsoft Excel Advanced

This one day course has been designed for those users who wish to discover the advanced features of excel. By the end of the course, you will be confident in using some of Excel’s more advanced features. You will be able to do more complex “what if” scenarios and use conditional formula and pivot tables to manipulate information.

This course covers the following topics:

Working with PivotTables

• Creating a PivotTable
• Specifying PivotTable Data
• Changing a PivotTable’s Calculation
• Filtering and Sorting a PivotTable
• Working with PivotTable Layout
• Grouping PivotTable Items
• Updating a PivotTable
• Formatting a PivotTable
• Creating a PivotChart

Analyzing and Organizing Data

• · Creating Scenarios
• Creating a Scenario Report
• Working with Data Tables
• Using Goal Seek
• Using Data Validation
• Using Text to Columns
• Removing Duplicates
• Grouping and Outlining Data
• Using Subtotals
• Consolidating Data by Position or Category
• Consolidating Data Using Formulas

Auditing your Work

• Displaying and Tracing Formulas
• Understanding Formula Errors

Working with Macros

• Recording a Macro
• Playing and Deleting a Macro
• Adding a Macro to the Quick Access Toolbar
• Editing a Macro’s Visual Basic Code

Time Saving Features

• Customizing the Quick Access Toolbar
• Using and Customizing AutoCorrect
• Creating Custom Views
• Changing Excel’s Default Options
• Recovering Your Documents
• Creating a Custom AutoFill List
• Creating a Custom Number Format