The goal of this course is to provide you with the knowledge required to use more advanced formulas and work with various tools to analyse data in spreadsheets, such as sorting, filtering, conditional formatting and auditing. You will also organise table data and present data as charts. You will discover how Excel spreadsheets are constructed and be given a clear path on how to create templates. The course emphasises hands-on experience, with a series of self-guided exercises integrated into the training.
This course is aimed at end users who have introductory knowledge and experience of using Microsoft Excel 2016 for Mac.
Module 1 - Calculating with Advanced Formulas
Module 2 - Auditing a Worksheet
Module 3 - Mastering Excel Tables
Module 4 - Organising Worksheet Data
Module 5 - Charts
Module 6 - Working with Templates
Module 7 - Analysing Selected Data
Module 8 - Applying Conditional Formatting
Module 9 - An Introduction to PivotTables
If time permits:-
Module 10 - Appendix: Inserting Illustrations
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.