Advanced Excel

Familiarise yourself with the advanced concepts of Excel and learn how to use Excel for high-powered spreadsheet modelling. Prior attendance on the Intermediate Excel course or an in-depth knowledge of Excel is required.

WHAT WILL I GET OUT OF IT?
• knowledge of the more powerful features of Excel
• ability to create more efficient spreadsheets including automating and customising workbooks.

KEY FEATURES
• custom formatting
• importing and exporting data
• templates and add-ins
• working with multiple workbooks
• look-up and reference functions
• working with named ranges
• working with toolbars
• using macros.

This course is held by PASS Training Ltd and endorsed by the ACCA.

NB This course uses Microsoft software versions 2000-2003. Please ask about training in version 2007.