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.
Please note this course contains a taster session on PivotTables. Detailed training on this subject is covered in our Microsoft Excel 2016 Advanced course.
This course is aimed at end users who have taken the following QA course or have equivalent knowledge: Microsoft Excel 2016 Introduction.
Unsure which Excel course level will be better for you? Click here to take our free online assessment and find out!