Who is it for?
This Advanced Microsoft Excel 2013 course is aimed at learners who have a good grounding in Excel (any version, but Excel 2013 is preferable) either from experience or attending our Intermediate Microsoft Excel training course.
If your job involves manipulating and analysing data in Excel, this course is for you. You’ll 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 course shows you how to use the vast array of advanced functionality in Microsoft Excel 2013, developing your skills to work more efficiently and effectively. It focuses particularly on 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.