Excel Advanced - Use Advanced Functions

Take your excel skills to the next level and increase your efficiency and productivity at work. Gain confidence as you expand your knowledge of this software in a small and personalised class. A course for the competent excel user who would like to take their skills to the advanced level.

Microsoft Office 2010 is used. Your excel version must be no older than 2007.

In this course you will learn:

  • An overview of relative referencing and absolute referencing
  • How to write VLOOKUP formulas and IF statements
  • How to protect data
  • How to use the subtotal function
  • How to create pivot tables and pivot charts
  • How to use the solver function
  • How to record macros and work with recorded macros

This course has no current classes. Please the waiting list.