- This event has passed.
MS Excel 2016 – Intermediate
10th September 2019 @ 8:30 am - 4:00 pm
$1350 – $1600MS EXCEL 2016 – INTERMEDIATE
TRAINER: Mark Tyrer – Summit Solutions
Date 10 September 2019
Time 08:30 – 16:00
Venue Chamber House, Royal Showgrounds
COST (includes vat and lunch)
Members R1 350 p/p, R1 315 p/p for 3/more, R1 250 p/p for 5/more
Non-members R1 600 p/p, R1 550 p/p for 3/more, R1 500 p/p for 5/more
OVERVIEW
This course covers:
Managing Data Types, Data Manipulation, Advanced Copy and Paste, Cell Referencing, Graphs, Conditional Formatting, Filtering and Sorting, Find and Replace, Printing, Ranges and Tables, VLOOKUP, View Optimization, Formulas and Functions (including IF statements), and an Introduction to Pivot Tables.
Your take home material includes:
A USB flash stick preloaded with all Excel Worksheets used, plus a comprehensive Video File Library
that explains in detail all the Skills Covered. A summary of Key Board Shortcuts and Formula.
WHO SHOULD ATTEND?
You should have basic knowledge of MS Excel 2016.
This course will grow your knowledge of Excel and help you learn new and better ways of using it.
Attendees that have a laptop that runs at least MS Excel version 2013 should please bring their laptop to the training.
If you do not have access to this version of MS Excel or a laptop, please let us know so we can provide you with a laptop.
Attendees will receive a certificate of attendance.
