Description
Course Aim:
By the end of the course you will be confident in using the features of Excel that you will need to be effective in your role.
What you will learn
Session One: Formulas & Basics Refresher
Creating basic formulas
Copy formulas with Relative and Absolute cell references
Create basic summary functions
Sort and Filter a list
Session Two: Range Names and Functions
Create Range Names for navigation and use with formulas
Use VLOOKUP / XLOOKUP functions to return required data from another source
Use the IF function to apply simple logic
Develop conditional summary functions - COUNTIFS, SUMIFS,
Session Three: Pivot Tables
Create a basic Pivot Table
Modify Pivot Tables by adding and removing fields
Refresh Pivot Tables
Insert a Slicer to filter Pivot Tables
If There’s Time: Error Handling
Formula Auditing; Trace Precedents, Formula Evaluator, IFERROR, IFNA
020 7375 7300
Email