This course is intended for current Microsoft Excel users who wish to extend their knowledge and skills in the more advanced areas of Excel such as goal seeking, linking, macros and PivotTables.

Course Topics

• Nesting Functions
• Advanced Filters
• Validations
• Goal Seeking
• Data Tables
• Scenarios
• Pivot Tables
• Linking Workbooks
• Consolidation
• Excel On The Web
• Summarising Data
• Macro Virus Control
• Recorded Macros
• Recorder Workshop

Prerequisites     Intermediate Excel

Duration              1.5 Days                              9.00a.m. to 4.00p.m. and 9.00a.m. to 12.30p.m.

Important Note:

Click here to download skills assessment just to make sure you are registering at right level.

Email to training@tphumancapital.com.au for review, prior to registering for event.

Or click here for more information about this workshop.

Click here to access Terms and Conditions prior to registering