€45

Masterclass in Excel - Intermediate Level

Actions and Detail Panel

€45

Event Information

Share this event

Date and time

Location

Location

Online event

Event description
Masterclass in Excel - Intermediate Level

About this event

This is a two half day course from 10am -1 pm on 10th and 17th February 2022. 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

Share with friends

Date and time

Location

Online event

Organiser Carlow Kilkenny Training Skillnet

Organiser of Masterclass in Excel - Intermediate Level

The Carlow Kilkenny Skillnet was established in January 1999 by a number of Senior Managers in organisations in the Carlow Kilkenny area. Initial discussions showed that the organisations shared common training problems, namely,

  • Access to information on courses / training, and new technologies available for training purposes
  • Sourcing training programmes
  • Finding courses that were relevant to the specific needs of each organisation
  • The location of available courses

By working together, these organisations have developed new, low cost, customised, and locally based solutions for their management and staff.

Save This Event

Event Saved