14
APR

Master Class Excel Tips & Tricks – 17th & 18th May

 

Date: 17th & 18th May

Time: 09:30 -12:30 (Both dates)

Location: Online

Member Price: €65.00

Non Member Price: €65.00

Book Online: Wexford Chamber Skillnet

 

 

Online Workshop – Duration 2 x Half day workshops

 

Course Content:

 

    Session 1:                                                                                                                Session 2:                      

Overview – Tips & Tricks                                                                 Advanced Filter

Customise Excel                                                                              Macros

Formula – Best Approach                                                              Consolidation

Functions                                                                                           Import /  Export

-Stats                                                                                                 Pivot Tables

-Date                                                                                                  Pivot Charts

-Text                                                                                                   Reports

Freeze Panes                                                                                    Conditional Formatting

Formatting

Audit Options

Charting

Sub-Totals

Data Functions

Sub-Totals

IF Statements

VLOOKUP’s

Drop-Down Lists

 

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.