Who is it for?
This advanced course is aimed at learners who have a good grounding in Excel (any version, but Excel 2007 or 2010 are preferable) either from experience or attending our Intermediate Microsoft Excel training course.
If your job involves manipulating and analysing data in Excel, you will find this course very useful. You will also find it helpful if you spend most of your working day using Excel and would like to fill in gaps in your knowledge.
What is it about?
This advanced Microsoft Excel course focuses on the vast array of functionality and will allow delegates to enhance their skills. It offers a focused approach that looks at manipulating and analysing data. This course goes into detail on how to normalise data and analyse it with Pivot Tables.
It also covers importing data using queries, preparing and analysing data with What If functions and Scenario building. You will also discover how to record and run your own macros.
The course is taught by expert Microsoft Certified Trainers with extensive training experience. You will be provided with a comprehensive manual which covers all the features covered during the course. This doubles up as a reference manual for use after the course.