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. Delegates are assumed to have experience of the following:
Module 1: Importing Data
Module 2: Collaborating with others
Module 3: PivotTables
Module 4: Dynamic Array Formulas
Module 5: The Auditing tools
Module 6: Creating macros
Join our public courses in our Hong Kong facilities. Private class trainings will be organized at the location of your preference, according to your schedule.