NEW: We have developed a new questionnaire to answer the question of Which Excel Course YOU should do, based on what YOU do with Excel. See more below.
In this update:
NEW EXCEL SKILLS ASSESSMENT
Excel Training Dates
- Training Course Dates– DBN and CT- See below
- Training Course Dates JHB/ PTA
Excel Tips and Tricks
- Create Scenarios out of your existing spreadsheets
- Ignore zeros when using average
- Copy Data Validation to other cells without affecting the contents
- Import PDF to Excel, even scanned versions
How to use our new online courses
Which Excel Course Should YOU Do
One of the biggest difficulties with Excel courses is which one is correct for you, specifically based on the type of work you do in Excel.
You can already assess what your skill level is on this site, but what are the most important things to learn to help YOU in YOUR job (as there are so many things you can learn in Excel).
This questionnaire asks you to rate how often you have to perform 20 typical Excel tasks (should take less than 15 minutes to complete) and then tells you which live and online courses you should do.
As it is still in Beta, please give it time to open up. Read more
Training Courses in Durban and Cape Town
We have booked the following dates for a 3 day Advanced Excel course in Durban and Cape Town.
- Durban- 16th-18th May 2016,
- Cape Town- 13th-15th June 2016
Please contact us if you are interested. Request Info
Upcoming Excel Courses- JHB
- Excel Fundamentals for beginners– 1 day
- 8 Apr 2016
- 10 June 2016
- 12 Aug 2016
- Advanced Excel course– 2 or 3 days
- 11-13 April 2016
- 9-11 May 2016
- Excel Financial Modeling, Budgets and Forecasts– 2 Days
- 17-18 Mar 2016
- 14-15 Apr 2016
- 12-13 May 2016
- Corporate Financial Modeling (Adv Excel + Fin Modeling)– 5 Days
- 11- 15 April 2016
- 9-13 May 2016
- In House courses
- Whenever it is convenient for you.
- Over suitable time periods (e.g. half days)
- Customised to suit your requirements based on what YOU do with Excel
- Reply to this email for more details
Email us if you need more details or visit the calendar page
(Easily) create scenarios out of your existing files
You’ve built a spreadsheet that helps you make a decision but now you need to run a few what if scenarios through it. Do you need to rebuild the whole thing? A quick, easy way to create a scenario. Read More
Ignore zeros when calculating an average
If you calculate averages you may want to change the way Excel treats zeros. You can specify whether Excel should include or ignore the zeros. Read More
Copy drop down lists to other cells without changing the contents
If you use drop down lists or other data validation tools, you may find that you want to copy the drop down to another cell, but you don’t want it to overwrite the contents of the cell. Read More
Import Scanned PDF into Excel
Do you need to get PDF’s into Excel, sometimes ones that are scanned and a bit skew? Read more
How to use the online courses
Instructions on how to use the new online Excel training course. We will be launching more modules of the live courses over the next few months. Read More
Online Course Available
Below the online courses we currently offer with the South African costs. To get an invoice in Rands please email us with what you want and we will send the invoice (only available for South African residents- foreigners need to use the credit card system unless you can pay via SWIFT)
Course | ZAR (incl VAT) |
Pivot Tables Course– NEW | R700 |
Auditing a Spreadsheet NEW | R0 |
Excel Fundamentals | R0 |
VLOOKUP | R160 |
Cleaning up Data using Excel | R700 |
PowerPivot | R700 |
WhatIf Analysis | R160 |
Online Pivot Table Course
Our Pivot Table course is now available online. Have a look at the topics. Read more
Updated Excel Skills Assessment Reports
We have updated the reports we provide for your skills assessments. You can now not only see the overall score, but also your score per area and compare them to typical scores. If you already have a skills score (if you have a number next to your name above) then simply reply and we will send you the updated report.
If you don’t have a skills score, now is the time to find out what you don’t know and do something about it. Read More
Keep up to date
If you want to get these tips and tricks as soon as they come out link to us via social media.
Please follow us on Facebook, Twitter , Google + or LinkedIn