| Date | Location | Price / Members Price | Places | Trainer | Book Online or Enquire |
|---|---|---|---|---|---|
| 14th April 2021 @ 9.30-12.30 | Online | € 50.00 / € 50.00 | 4 available |
This course is not suitable for beginners
Online Workshop – Duration 2 x Half day workshops 14th & 15th 9.30-12.30 (both days)
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
|