Excel Advanced Course, 1-to-1, London, Live Online

Excel Advanced Course, 1-to-1, London, Live Online

Actions and Detail Panel


Excel Advanced is for Excel Experts: you daily work revolves around spreadsheets and Excel databases. Online. Practical. Instructor-led.

About this event


Excel Advanced is for Excel Experts - you work daily with Excel and your work revolves around spreadsheets and Excel databases. This course is offered one-to-one, because we understand that individuals have varying skill levels and varying applications. Read more



  • Editing Standard Formatting Rules 
  • Input Validate rules 
  • Using Formulas in Conditional Formatting 
  • Group and Outline 
  • Filter and Sorting 

Data Insights with Pivot Tables

File and sheet Linking

  • Referring to multiple sheets and external files within formulae and functions 
  • Working with multiple sheets
  • Linking external files

Excel Tables and Advanced Filter 

  • Working with Excel tables 
  • Selectively Copy specific datasets, selective rows and columns from sheets, workbooks or external data 
  • Automate this process and integrate with data importing

Consolidate Goal seek, consolidate and scenarios Using Form Templates 

  • Creating Templates 

Advanced Excel Lookup Functions 

  • VLookup Function 
  • Hlookup Function 
  • Using the Index Function,
  • Using the Match Function,
  • Index and Match Together 
  • Using the Indirect Function 

Excel Advanced Functions 

  • Using Error, Logical, Array, Rounding Functions 

Excel Macros 

  • Creating, amending and deleting macros 
  • Relative and Absolute recording of cell references
  • Running macros 
  • Creating Macro menus, toolbars and shortcuts to execute macros by the click of a button


  • Excel Course Certificate on completion
  • Excel Course notes 
  • Practical Excel Class exercises, Excel Course Homework / Excel Course Revision work 
  • To assist after the course, 1 free session for questions online

Share with friends