Excel 2007/2010 Advanced

Course details

This course covers aspects of Excel beyond building basic workbooks. It deals with workbook automation, productivity features, data analysis tools and automating workbook operations using macros

Content

Section One: Working with Data

• Outlining and Grouping Data
• Exploring Scenarios
• Using Data Analysis Tools
• Using Solver
• Using Hyperlinks 

Section Two: Pivoting Data

• Getting Started with PivotTables
• Working with PivotTable Data
• Formatting a PivotTable
• Advanced PivotTable Tasks
• Using the PivotChart Tools Tabs

Section Three: Advanced Excel Tasks

• Using Advanced Functions
• Using the VLOOKUP Function
• Using Custom AutoFill Lists
• Linking, Consolidating, and Combining Data

Section Four: Macros

• Recording a Macro
• Assigning a Macro to the QAT
• Viewing a Macro
• Deleting a Macro

Prerequisites

It is also recommended that proposed delegates have attended a Microsoft Excel 2010 Introduction and Excel 2010 Intermediate course

Those who have obtained comparable knowledge from the workplace and word with Excel on a daily basis.

Who should attend?

This course is designed for Microsoft Excel users who have a good knowledge and understanding of Excel but are not yet at expert level.

It will suit users who wish to extend their knowledge and skills.