If we have helped you before with some of our tips and tricks, please forward this link to your friends and suggest they subscribe.
If we have never helped you, then tell us some of your Excel problems and we will help!
In this update:
- Training Course Dates– Use up your remaining training budget?
- Summing only the visible cells or cells with no errors
- How to put m2 into an Excel cell (and other formatting)
- How to use our new online courses
- South Africa Tax Calculator for the 2016/ 2017 Year
- Change Excel columns back to letters from numbers, and
- Why does Excel sometimes change to R1C1 format
- Updated Skills Assessment Reports
Summing only the visible cells with a new Excel function
How to sum, average, count and more based on the visible cells, cells with no errors and more using a new Excel function called AGGREGATE Read more
How to put m2 into an Excel cell
How to make the metre squared symbol with the raised 2 appear in an Excel cell. Read more
South African Tax Calculator for 2016/ 2017
As soon as Pravin Gordhan announces the budget on 24 February we will upload the South African Tax Calculator for 2016/ 2017. 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
Change Excel Columns back from R1C1 format (when the columns have numbers instead of letters)
Every now and then you come across a spreadsheet that seems to have changed the columns to be show as numbers instead of letters. Read More about how to fix this, and why it happens.
How to use the online courses
Instructions on how to use the new online Excel training course. We will be launching modules of the live courses over the next few months. Read More
Online Course Available
Below the online courses we currently offer. Use these to top up your CPD points!
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
Upcoming Excel Courses
Excel Fundamentals for beginners–
- 12 Feb 2016 (URGENT LIMITED SPACE)
- 8 Apr 2016
- 10 June 2016
- 12 Aug 2016
- Advanced Excel course– 2 or 3 days
- 15-17 Feb 2016
- 14- 16 Mar 2016
- Excel Financial Modeling, Budgets and Forecasts– 2 Days
- 18-19 Feb 2016
- 17-18 Mar 2016
- Corporate Financial Modeling (Adv Excel + Fin Modeling)– 5 Days
- 15-19 Feb 2016
- 14-18 Mar 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