07/01/2021
Advanced Excel Training
Start at 10am -3pm
-Classroom based training with laptops
-Only 5 Learners per class every day for individual attention
-Feedback Exercise at end of session to test competency
-Constant after class support on Whatsapp & Email
-Printed Notes for easy reference
Outcomes for the day
1. Using Vlookup the easy way
2. Excel IF Function-Simple to Advanced
3. Working with Excel Text Functions
4. 3D Formulas & Linking cells
5. Working with Conditional Formatting
6.Naming cells & Ranges
7.How to use the Goal Seek function
8.Introduction to Macro’s
Contact me to book your seat today:-
084 517 1576
[email protected]
07/01/2021
Intermediate Excel Training
Start at 10am -3pm
-Classroom based training with laptops
-Only 5 Learners per class every day for individual attention
-Feedback Exercise at end of session to test competency
-Constant after class support on Whatsapp & Email
-Printed Notes for easy reference
Outcomes for the day
1.Working with tables
2.Database Functions-DSUM & DMAX
3. Creating interactive charts & tables from scratch
4. What is a Pivot table?
5. Data Analysis
6. Working with Sparklines
7. How to add a Slicer tool into a Pivot Report
8. Introduction to Pivot Charts
Contact me to book your seat today:-
084 517 1576
[email protected]
07/01/2021
Basic Excel Training
Introduction to Excel-R500
Start at 10am -3pm
-Classroom based training with laptops
-Only 5 Learners per class every day for individual attention
-Feedback Exercise at end of session to test competency
-Constant after class support on Whatsapp & Email
-Printed Notes for easy reference
Outcomes for the day
1.Excel User Interface
2.Formatting & Editing Cells
3.What is a cell location?
4. Introduction to Formulae
5. Autofill Feature
6.Functions (SUM,MIN,MAX,AVERAGE)
7.Working with sheets
8.Flashfill feature
9.Conditional formatting
10.Tips & Tricks in Excel
Contact me to book your seat today:-
084 517 1576
[email protected]
