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.
Module 1: Creating macros
Module 2: Collaborating with others
Module 3: PivotTables
Module 4: Array formulas
Module 5: Further lookup and reference functions
Module 6: Analysing data
Module 7: Data validation
Module 8: Importing data
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.
DANONE
We really loved the trainer. I had hesitations on online trainings, but it really went well. I'd love to attend another online training with Bilginc