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 / 365 Advanced course.
This course is aimed at end users who have taken the following QA course or have equivalent knowledge: Microsoft Excel 2016 / 365 Introduction.
This course is suitable for users of Microsoft Excel 2016 or 365 subscription editions. If you're attending at a QA location, the course will be delivered on Microsoft Excel 2016.
Create basic spreadsheets
Select and edit data
Perform basic formatting
Open, close and save files
Create basic formulas - AutoSum
Use Insert Function to create built-in functions
Work with absolute references
Use the AutoFill feature
Calculate with advanced formulas
Audit formulas using the auditing tools
Work with Excel tables
Organise worksheet data so that data can be sorted and filtered