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
In this course you will learn how to:
- operate the ribbon,
- customize the quick-access toolbar,
- format and set up personalized spreadsheets by using colours, spacing and lines,
- do calculations
- set up formulas for calculations and
- also produce graphs at the push of a few buttons.
The most common task Excel is used for is to ‘clean’ information received from other systems to be usable in the business.
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."