€45

Masterclass in Excel - Tips and Tricks

Event Information

Share this event

Date and Time

Location

Location

Online Event

Event description
Masterclass in Excel - Tips and Tricks

About this Event

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 - 7th October

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 - 8th October

Advanced Filter

Macros

Consolidation

Import / Export

Pivot Tables –

Pivot Charts

Reports

Conditional Formatting

Tags
Share with friends

Date and Time

Location

Online Event

Save This Event

Event Saved