This is a two half day course from 9.30am -12.30 pm on 18th and 25th Feb  2024. The course will be delivered online.

Objectives

The purpose of this 2 half day is course is the teach delegates some of the more features advanced of Excel 2010.Using If statements, Financial Functions, Lookups, Named Ranges, Sorting Data and Charting are all covered . Extensive hands-on training is provided throughout.

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