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 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

Community

Discover and connect with other attendees.

MB