| Date | Location | Price / Members Price | Places | Trainer | Book Online or Enquire |
|---|---|---|---|---|---|
| 17th May 2021 @ 9.30-12.30 | Online | € 65.00 / € 65.00 | 2 available | Systems & Software Training |
This course is not suitable for beginners
ADVANCED – Online Workshop – Duration 2 x Half day workshops 17th & 29th May 9.30-12.30 (both days)
Objective
Many experienced excel users are self-taught. They know how to use most of the main Excel tools, but they don’t know how to use many of them to the best effect, or just aren’t using the power of excel to help them do their work. Taught by someone who has been working with and teaching Excel for 30 years, you will be amazed by how much you will learn.
Topics Include
|
Overview – Tips & Tricks Customise Excel – Quick Access Tool Bar Audit Options- Advanced Options Mixed Absolute Reference Named Areas Default Settings The Outline Feature Advanced Filter Macros Validation Lists Macro Buttons Nested If Statements V Lookups – Nested V Lookups
|
Pivot Tables Pivot Charts Consolidation Scenarios Goal seek Using more Advanced Formulas ( Indirect, Match Etc) Templates The Developer Tab · Index · Nested If Statements · PMT Function
Q&A and Review
|