In this course, you will extend your knowledge into some of the more specialised and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets such as PivotTables, and importing and cleaning data.
The course emphasises hands-on experience, with a series of self-guided exercises integrated into the training.
This course is aimed at existing Excel users who need to further their knowledge and seek to gain an industry recognised certification, following the course. Delegates are assumed to have experience of •the following:
Module 1: Getting Started with Excel
Module 2: Formatting an Excel worksheet
Module 3: Working with Data Lists
Module 4: Printing workbooks
Module 5: Collaborating with Colleagues
Module 6: Creating Calculations with Formulas and Functions
Module 7: Advanced Excel Functions
Module 8: Mastering Excel Tables
Module 9: Summarise Data Visually
Module 10: Importing Data
Join our public courses in our Germany facilities. Private class trainings will be organized at the location of your preference, according to your schedule.