Advanced Excel 2010

Duration: 1 Day

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.

Course Aims and Objectives:
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.


Course Outline Summary

Section One: Working with Data

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

Section Three: Advanced Excel Tasks

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

Section Two: Pivoting Data

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

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