INTERMEDIATE – Online Workshop
Duration and Schedule:
2 x Half day workshops 10th and 11th October, 9.30am – 12.30pm (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.
Content:
- Overview – Tips & Tricks
- Customise Excel
- Formula – Best Approach
- Functions
- Stats
- Date
- Text
- Freeze Panes
- Formatting
- Audit Options
- Sub-Totals – Paste Options
- IF Statements
- VLOOKUP’s
- Pivot Tables
- Pivot Charts
- Reports
- Conditional Formatting