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 2019 Advanced course.
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