Popular
Training Dates
- Training Course Dates– Durban (Kingsmead) and Cape Town- See below
- Training Course Dates JHB/ PTA
Tips and Tricks
- Copy a cell to the left in Excel
- Correct way to calculate interest in an annual financial model
- Safest way to enter a date in Excel
- Euro 2016 Sweepstakes spreadsheet
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 and provide us with feedback on its usefulness. 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- (Regus, Kingsmead-11 Walnut Rd, Durban, 4001 by ICC),
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
- 10 June 2016
- 12 Aug 2016
- Advanced Excel course– 2 or 3 days
- 9-11 May 2016
- 6-8 June 2016
- Excel Financial Modeling, Budgets and Forecasts– 2 Days
- 12-13 May 2016
- 9-10 June 2016
- Corporate Financial Modeling (Adv Excel + Fin Modeling)– 5 Days
- 9-13 May 2016
- 6-10 June 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
Copying a cell to the left in Excel
How to apply the method you use to copy to the right, to copy cells to the left
How to copy a cell to the left…
Correctly calculating interest charges in an annual financial model
If you calculate interest in an annual financial model, you cannot just take the opening balance and apply interest for a year. Payments during the year will reduce the interest charge. Excel can calculate this for you.
Calculate interest in an annual model …
Safest way to enter a date in Excel
You need to be careful when typing in a date into Excel. Depending on the computer you may need to type 19/04/2016, 2016/04/19, 04/19/2016 etc. for Excel to recognise it as a date. But there is a safer way.
Euro 2016 Sweepstakes spreadsheet
You need to be careful when typing in a date into Excel. Depending on the computer you may need to type 19/04/2016, 2016/04/19, 04/19/2016 etc. for Excel to recognise it as a date. But there is a safer way.
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. How to use the online course …
Online Pivot Table Course
Our Pivot Table course is now available online. Have a look at the topics. Details on the online Pivot course
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. Excel Skills Assessment Questionnaire
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