Microsoft Excel is an integral part of the business landscape and it is a critical tool in departments including accounting, finance, strategy and operations. With Corality’s Excel Diploma course, you will learn how to produce robust and transparent analyses that drive corporate reporting and decision processes by unlocking the complete functionality of Excel.
This highly interactive Excel training course is designed to help you to progress quickly from simply working with Excel spreadsheets to fully mastering the foundation principles of robust Excel development and focused analysis. With illustrated real-life examples, Excel Diploma will give you practical skills that you can use for complex analysis every day.
Upon completion of the course you will not only have accelerated your modelling skills and learnt to decrease risk in your use of Excel and financial models, but you will also be able to confidently repair broken models.
The Excel Diploma course will enable you to
Lift the quality of your Excel spreadsheets to enterprise level quality with techniques and structure from advanced financial modelling
Master the separation of data, logic and outputs
Develop transparent Excel spreadsheets that can be easily understood and modified by other users
Understand key Excel functions such as LOOKUP, MATCH, OFFSET, and INDEX
Learn how to use VBA and macros
Learn essential Excel functionality, from Excel shortcuts and special commands to pivot and data tables
Avoid errors with systematic ‘checks’ and audit techniques (i.e., don’t rely on VLOOKUP)
Do you want to advance your Excel knowledge?
This course is designed for those wishing to advance their knowledge of the Excel environment, key Excel functionality, data manipulation and analysis.
No prerequisite knowledge required
There are no prerequisites for this course.
Need more? Learn about valuations or project finance
You may be interested in our project finance modelling course, or the project finance theory course.
Interested in an Excel or financial modelling course for your company?
Contact us for an in-house course delivery options
Best practice financial modelling courses
To see a full list of Corality’s training courses go the full list of financial modelling training courses.
Our course schedule shows you a list of all the upcoming courses in your region.
Financial modelling tutorials – a free resource library
Visit the SMART Campus for free financial modelling tutorials. This extensive library is full of analytical insights that will help you to reduce risk in your models.