Masterclass in Excel - Advanced

Trainer: System and Software

This is two half day workshops on 21st and 22nd March 2023 from 9.30am -12.30pm

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

Host or Publisher Carlow Kilkenny Training Skillnet