About this module
This course is ideal for delegates wishing to gain knowledge of some of the advanced features and formulae within Microsoft Excel. Delegates attending should be already at a competent level of Excel and have good experience with the software. Ideally delegates would have already completed the Excel Intermediate course.
Delegates will cover the following topics:
> Auditing
> Look up tables
> Macros and Assigning Code to Buttons
> IF Revisited
> AND Function
> Text Functions
> Goal Seeking
> Scenarios
> Consolidation of Data
> Working with Fractions
> Sub Totals
> Pivot Tables
Please note: A minimum of 4 delegates are required to run this course. If this is not met then this course may be rescheduled.
