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

What to bring:

  • Pen
  • Paper

Other Information:

  • To ensure resources are ready for you at the start of your course, we ask you ideally enrol at least one week before the course commences.
  • All courses need a minimum number of students to run ("we try our hardest to get those") . If your course does not have enough students it will be cancelled before the commencement and you will be informed.

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