Updated on: 16-04-2024
Excel - Advanced (half day)
Topics covered
Complex Functions
- VLOOKUP
- XLOOKUP
- SUMIF
- CONCATENATE
- IFERROR
- Formula Auditing
Advanced Formatting
- Conditional Formatting
- Apply the Format Painter
- Split and Freeze columns
Protection
- Protecting Sheets
- Protecting Cells
Pivot Tables
- Creating a Pivot Tables
- Editing a Pivot Table
- Using Pivot Charts
Online training will be delivered via MS Teams. You will receive joining instructions before your selected session
At the end of the session all delegates will:
On successful completion of this course you will be able to:
- Create Complex Functions
- Apply Conditional Formatting
- Use the Format Painter
- Use the Split and Freeze Panes to change the view
- Protect spreadsheets
- Create Pivot Tables and Pivot Charts
About the course
| Course Code | MLCSU-TR0087 |
|---|---|
| Intended Audience | Regular users of Excel or those who have completed the Excel Introduction and Intermediate course |
| Delivery Method | Online |
| Required Experience / Training | Attendees to have completed the Excel Introduction course or have equivalent work based experience Quiet room with access to MS Teams and headset or headphones |
| Duration of Training | 2 - 2.5 hours |
Premium Content
This course requires a paid subscription to access. Please login to see if your organisation has a subscription.