- This event has passed.
Training – MS EXCEL – INTERMEDIATE
9th September 2020 @ 8:30 am - 4:30 pm
$1350 – $1600TRAINER: Mark Tyrer – Summit Solutions
Date: 9 September 2020
Time: 08:30 – 16:30
Venue: PMCB Offices – Shop 6A, Lifestyle Centre, Liberty Midlands Mall
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 lifetime access to the equivalent course on our Online Training Platform. A summary of Key Board Shortcuts and Formula.
WHO SHOULD ATTEND?
You should have basic knowledge of MS Excel.
This course will grow your knowledge of Excel and help you learn new and better ways of using it.
PLEASE NOTE
Attendees are required to bring a laptop that runs at least MS Excel version 2013 to the training.
Strict Covid-19 protocols will be adhered to. To comply with social distancing requirements there will be a limited number of attendees on this course.
Attendees will receive a certificate of attendance.
