This practical course is designed to enable you to create advanced spreadsheets for data analysis and forecasting. You will learn how to implement advanced functions and features such as macros and will be familiar with the basics of Visual Basic for Applications (VBA).

The course is designed as a practical course enabling you to receive hands-on experience of all topics covered.   

By the end of the course, you will have an understanding of:

Advanced Functions
IF, Nested IF
Lookups 
Match, Index

Pivot Tables
Creating Pivot Tables
Using Pivot Table Tabs
Changing Summary Field
Grouping Data in a Pivot Table 
Pivot Tables

Forecasting
Goal Seek
Data Tables 
Scenario Manager 
Solver

Macros
Recording & Running Macros
Assigning Macros to Buttons
Macro Virus File Protection

This course is designed for those who are proficient in basic MS Excel features and wish to use MS Excel for more complex and sophisticated tasks.  Participants should have a good working knowledge of MS Excel.

Please note that the cancellation policy for our public training courses is as follows:

NON-ACCREDITED TRAINING

More than 3 weeks prior to the course start date - No cancellation fee payable.

Less than 3 weeks prior to the course start date - 100% of total fees payable or free transfer.

ACCREDITED TRAINING

More than 6 weeks prior to the course start date - No cancellation fee payable.

Less than 6 weeks prior to the course start date - 100% of total fees payable or free transfer.

Substitute delegates will be accepted at any time at no cost.

Full joining instructions for the course will be emailed to you at least five working days prior to the course. In the meantime, if you have any queries please contact a member of our team on 028 9016 0587 or via email kate@aku.training.

Download a copy of our standard Terms and Conditions for course bookings.