
Date: 14th & 15th April
Time: 09:30 -12:30 (Both dates)
Location: Online
Member Price: €50.00
Non Member Price: €50.00
Places Available: 4 available
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.