Excel 2010 Advanced

Date Location Price / Members Price Places Trainer Book Online or Enquire


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



Section One: Working with Data

  • Outlining and Grouping Data
  • Exploring Scenarios 
  • Using Goal Seek
  • Using Solver
  • Using Hyperlinks

Section Two: Pivoting Data

  • Getting Started with PivotTables
  • Working with PivotTable Data
  • Formatting a PivotTable
  • Using Classic PivotTable Layout
  • Creating and Formatting a PivotChart 
  • Using Slicers
  • Advanced PivotTable and PivotChart Tasks
  • Using PowerPivot

Section Three: Advanced Excel Tasks

  • Using Advanced Functions (PMT & FV Functions, IF AND or Functions and IFERROR Functions)
  • Using VLOOKUP Function
  • Using Array Formulas
  • Using Custom AutoFill Lists
  • Linkin, Consolidating and Combining Data


Section 4: Macros

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

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


  • It is also recommended that proposed delegates have attended a Microsoft Excel 2010 Introduction and Excel Intermediate course 
  • Those who have obtained comparable knowledge from workplace and work Excel on a daily basis.