A reminder that we will be offering an Excel "tips & tricks" training workshop via Zoom. We will answer any questions you may have at the end of the training. Be sure to book you place.
Date: Wednesday, 18 August Time: 9:00am - 12:30pm Cost: R800 ex VAT per person Platform: Zoom
Microsoft Excel "Tips & Tricks" Workshop - Wed, 18 Aug (9:00am - 12:30pm)
Every day formulas
Advanced formulas including lookups
Pivot tables
Spark lines
Basic macros
Charts
The camera tool
Referencing external data
Data views including freeze frame, split screen, display options, page setup
Removing duplicate values
Conditional formatting
Document security including document protection and removing personal info
Quick access toolbar
Creating your own tab
64bit vs 32 bit Excel
Creating a dashboard
Formatting data
Tables
Tips on printing - setting printable areas, watermarks, etc.
