Event Details
*2 HALF DAYS ONLINE EXCEL TRAINING*
Please ensure you have a laptop/computer screen and an additional screen connected as this will assist you greatly in the training.
Objectives
The purpose of this 2 half-days course is to teach delegates some of the more advanced features such as - Using If statements, Financial Functions, Lookups, Named Ranges, Sorting Data and Charting are all covered.
Contents
- Create an IF Function
- Nest AND, OR and IF Functions
- Use the PMT Function
- Use the VLOOKUP Function
- Use the HLOOKUP Function
- Create Named Cells
- Create Named Ranges
- Create drop down lists
- Sort Data
- Create a Custom Sort
- Filter Data
- Advanced Filter
- Subtotal Data
- Create a Column Chart
- Create a Pie Chart
- Modify Chart Options
Date/Time Description:
9:30am-12:30pm
Tuesday 20th August 2024
Wednesday 21st August 2024