• The auditing tools
• Validation of data
• Consolidation and linking of Excel spreadsheets
• Data tables and lookup tables
• Goal seeking from formulae and charts
• Solving from a complex formula
• Using scenarios
• Array formulae
• Macros
• Security
• Hiding workbooks and worksheets
• Creating and using templates

Who is it for? This course is suitable for people who have good knowledge and understanding of MS Excel or have attended the MS Excel Intermediate course and would like to learn about automation and other advanced features.

Excel spreadsheets can become very complex with one formula calculating from the results of several others. This course covers the tools to trace problems with complex formulae and methods for consolidating several Excel worksheets.

You will also learn about the analytical tools in Excel and how to use them for goal seeking. You will learn about macros, how to create templates for commonly used worksheets and how to protect data using security features.