€45

Masterclass in Excel - Advanced

Actions and Detail Panel

€45

Event Information

Share this event

Date and time

Location

Location

Online event

Event description
Masterclass in Excel - Advanced

About this event

Trainer: System and Software

This is two half day workshops on 3rd and 10th March 2022 from 10am -1pm

Most Excel users, once they have learnt the core Excel skills, are largely self taught. You can pick a lot of how to’s along the way. But you’ve never been shown how to use Excel the best way, by a professional.

The aim of this course is to achieve two goals. To show delegates how to do most every-day tasks much more productively, PROBABLY saving you hours of boring routine work. Along with this we will cover new topics which will broaden your knowledge of use of Excel.

Session 1

Overview – Tips & Tricks

Customise Excel

Formula – Best Approach

Functions

• Stats

• Date

• Text

Freeze Panes

Formatting

Audit Options

Charting

Sub-Totals

Data Functions

Sub-Totals

IF Statements

VLOOKUP's

Drop-Down Lists

Session 2

Advanced Filter

Macros

Consolidation

Import / Export

Pivot Tables –

Pivot Charts

Reports

Conditional Formatting

Share with friends

Date and time

Location

Online event

Organiser Carlow Kilkenny Training Skillnet

Organiser of Masterclass in Excel - Advanced

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