Who is it for?
This course is suitable for people who have good knowledge and understanding of Excel or have attended the Excel Intermediate course and would like to learn about automation and other advanced features.
Description
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 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.
Course content
-
Auditing tools
-
Validation of data
-
Consolidation and linking of spreadsheets
-
What If: Goal seeking and Data Tables
-
Lookup Formulae
-
Array formulae
-
Macros
-
Protecting Worksheets
-
Hiding worksheets
-
Creating and using templates
Course duration
1 day, normally between 9:30 and 4:30