An online Excel charting/ graphing course covering how to understand charts and how to get them to do what you want.
Some free tips and tricks on using Excel in the business world
This course is for anyone who needs to learn Advanced Excel. It follows on from our Intermediate Excel course.
This course is for anyone who works in the Human Resources and Payroll departments. The focus of the course is all the typical issues faced in these departments. The areas covered would also benefit anyone working with people data e.g. Learning and Development/ Training departments.
In this course you will learn a combination of tools and functions that an Intermediate Excel user should be aware of. This is more than just an Excel 2 course, as it covers the practical uses of Excel at this level.
Online course covering the latest data cleanup tool offered free within Excel. Learn how to automate all your data cleanup tasks so that it is as simple as:
- Go have some coffee
- Come back and it is done!
This course will cover how to use Excel to create meaningful dashboards and management reports.
It is assumed you know the basics about Pivot Tables and Charting.
The course will focus on areas that apply to dashboards and will include practical aspects of Pivot Tables, Charting, Conditional Formatting and Sparklines along with other critical dashboard tips and tricks.
A mini course that focuses on the time value of money calculations in all its forms in Excel.
Included is debt calculations and how to
- allow for pre payments, ad hoc withdrawals and changes in interest rate.
- How NPV and IRR work in Excel and
- the relationship between the two and the debt calculations
This is an extract out of the Online Financial Modelling, Budgeting and Forecasting Course . If you want a comprehensive overview we recommend you do the full course
We aim to provide the ultimate, one stop shop for all Excel users requirements, within South Africa and worldwide.
"Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude."