Training Programmes

IT

Masterclass in Excel – Intermediate

Date:  21st  and 22nd February 2023

Tutor: System and Software

Venue: Online

Time: 9.30-12.30

Investment: €45 per person

Book Here: https://bit.ly/3Tqa8Cj

This is a two half day course from 9.30am -12.30 pm on 21st and 22nd of Feb 2023. 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

 

Latest News