Excel - Advanced Users v2007/2010

MODULE 1: Grouping & Outlining and Subtotals

Learning outcomes:

Useful Excel functions to summarise a spreadsheet making the data easier to identify and explain.

Topics covered:

• Outlining and Grouping Data
• Using the Subtotals Tool

MODULE 2: What-If Analysis

Learning outcomes:

Tools designed to help with forecasting and finding solutions to complicated problems involving your spreadsheet’s data and formulas.

Topics covered:

• Exploring Scenarios
• Goal Seek and Data Tables
• Using Solver

MODULE 3: PivotTables

Learning outcomes:

Creating Pivot Tables in order to display and summarise large quantities of data effectively.

Topics covered:

• Getting Started with PivotTables
• Displaying Data in a PivotTable
• Formatting a PivotTable
• Using the Classic PivotTable Layout
• Slicers

MODULE 4: Charting Pivoted Data

Learning outcomes:

Introducing Pivot Charts, adding specialist pivot charts to the already excellent Pivot Table feature.

Topics covered:

• Getting Started with PivotCharts
• Using the PivotChart Tools Tabs
• Formatting a PivotChart

MODULE 5: Advanced Excel Tasks

Learning outcomes:

Here we will look at sharing Excel files along with adding hyperlinks and Custom AutoFill Lists.

Topics covered:

• Excel and Hyperlinks
• Using Custom AutoFill Lists
• Sharing Workbooks

MODULE 6: Creating HLOOKUP and VLOOKUP Functions

Learning outcomes:

Exploring the different Lookup functions, ideal add further functionality to a spreadsheet to reference particular data quickly and effectively.

Topics covered:

• Using the VLOOKUP Function
• Using the LOOKUP Function

MODULE 7: Introduction to Macros in Excel

Learning outcomes:

Explore how to create your own Macros and introducing Visual Basic for Applications, the application Macros are created in.

Topics covered:

• Recording and Playing Macros
• Copying and Deleting Macros
• Visual Basic and Macros