Training Programmes

IT

Masterclass in Excel – Advanced

Date:  21st  and 22nd March 2023

Tutor: System and Software

Venue: Online

Time: 9.30-12.30

Investment: €45 per person

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

This is a two half day course from 9.30am -12.30 pm on 21st and 22nd of March 2023. The course will be delivered online.

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

 

Latest News