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

$150Limited
inc GST

Excel Advanced - Use Advanced Functions

<p><p>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