Advanced Microsoft Excel

Overview

Turn unorganized data into useful information and quickly make spreadsheets your colleagues. The course covers advanced topics like functions, PivotTables, and macros.

Who is Advanced Microsoft Excel aimed at?

Anyone in the organisation who wishes to upgrade their MS Excel skills to an advanced level

Course Length

1 day

Learning Outcomes

On conclusion of the course, participants will understand the following advanced features of MS Excel:

Working with Pivot Tables

• 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
• Using Slicers
• Sharing Slicers Between PivotTables

Analysing Data

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

Working with the Web and External Data

• Inserting a Hyperlink
• Importing Data from an Access Database or Text File
• Importing Data from the Web and Other Sources
• Working with Existing Data Connections