Master Class Excel Tips & Tricks – February 2021

Date Location Price / Members Price Places Trainer Book Online or Enquire
16th February 2021 @ 9.30-4.30 Online € 50.00 / € 50.00 10 available

Online Workshop – Duration 2 x Half day workshops

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