Financial Modelling for Budgeting and Forecasting in Excel
"Gaining sound and practical insights from advanced techniques of Excel"
13-15 November 2019 | Kuala Lumpur, Malaysia and 18-20 November 2019 | Manila, Philippines
This three day course entitled Financial Modelling for Budgeting and Forecasting in Excel reflects tasks that are among the most important and yet least favourite areas of work of many senior managers, accountants and others. In this course, we will walk you out of the potential minefield you are currently living in by introducing you to Microsoft Excel and the Business Intelligence elements of advanced functions and formulas, Power Query and Power Pivot technologies.
One aspect of life in Excel that many people can relate to is that if someone has learned how to use the VLOOKUP function, they think they are now an advanced Excel user. In this course, you will go way beyond that thought and appreciate that Power Query and Power Pivot can not only take away the need for anyone to learn VLOOKUP and so on but you will come to appreciate that you have even more power than ever.
Your trainer is highly experienced in all aspects of the contents of this course: he has worked as an accountant, consultant and trainer and has written many books on the subject. Many courses in this area talk about fictitious widgets and they use data sets from text books: as a data magnet, your trainer creates and provides real life case studies that will help you to apply what you learn to your own real world situation.
Major Benefits of Attending
By the end of the workshop, delegates will be able to:
ANALYSE financial statements using modelling
CREATE a Budget and make changes to different scenarios
DEVELOP a model for investment decision
APPLY Excel’s Forecast Sheet utility and other FORECAST functions
CREATE a sensitivity analysis model
MANAGE existing financial proposals to deliver the best returns
LEVERAGE Excel’s Power Tools: Power Query and Power Pivot
PRACTISE preprogrammed Excel Macros as they apply to certain situations
By the end of this course you will be able to:
Assess your current level of knowledge and expertise
Use Excel to leverage your data and your current reports as you create leading edge solutions
Get data, build and apply a Query in Excel
Assess the acceptability of a capital investment project including the use of Scenarios
Carry out more advanced analysis of data using advanced Pivot Table features
Use Macros in Excel
Follow a case study approach to data analysis and investigation, including the use of DAX
Participants should have a good, intermediate level, working knowledge of Microsoft Excel. VBA and Macros in conjunction with Excel will also be introduced in this training so a basic knowledge of them will help.
Participants should bring their own Windows based laptops preferably with a full installation of Office 365/Excel 2016, to the workshop.
In addition, we assume that the mainstay topics are already familiar to you. Everyone with an intermediate knowledge of Excel is welcome to attend this course and once you have seen the more advanced elements of our work, you will definitely want more!
One to two weeks before the start of the course, you will be given the joining instructions for the course as well as most of the files we will be working on during the course.
Who Should Attend?
This workshop will be valuable to everyone who is faced with quantitative decision making, financial and non financial reporting, budgeting and planning, model building, statistical and data analysis and more.
CEO/CFO/COO/Finance Directors/Financial Controllers /Heads of Finance
Directors/Heads/Managers of Strategic Planning
Directors/Heads/Managers of Business Development
Project Financiers and Lenders
Accountants and Auditors
Financial and management accountants
Financial project administrators
Project finance professionals
This course will focus on the tools and techniques available in Microsoft Excel which will enable you to develop your own solutions to your own problems.
For more information, investment fees and registration, email us at
What do they say about our recent runs?
"Learning the advanced features of Excel and how to apply it in my line of work." - John Elson Baguipo, Financial Modeller, Boracay Island Water Company
"Course was very comprehensive but the material very much relevant and applicable to corporate career. - Francis Buenaventura, Treasury Specialist, Ayala Corporation
"Very well organised, highly informative, and a chance to get to know more people outside our department." - Rico Escaler, Corporate Strategy & Development Associate, Ayala Corporation
"The instructor had a very good idea of what we would need Excel to do in our work and was able to point out some really helpful and useful techniques for us to apply at work." - Monica Fajardo, Finance Analyst, Ayala Corporation
"There were applications that we've been using for years and only to find out there were simpler commands we can use. The training will be very useful and applicable being a finance person. " - Rizalyn Guico, Finace Manager, Ayala Automotive
"Learned a lot of new concepts and enhanced my efficiency in excel." - John Albert Ong, Business Development Analyst, Ayala Corporation Infrastructure
"Great course, with all the new learnings in Excel, Power Q, Power BI, should improve production time significantly." - John Armand Ong, Finance Manager, Ayala Corporation
"Very helpful and expert instructor!" - Jun Villaluz, Corporate Finance Associate Director, Ayala Corporation
"CTS provides an easy step by step guidance on modeling concepts and the instructor really knows what he's talking about." - Anonymous, Ayala Infrastructure
"Mr. Duncan is very helpful & approachable " - Kate Petilla, Auditor, Ayala Corporation
" Very Good" - Anonymous, Ayala Group Club, Inc.
"Very informative." - Alvin Evangelista, Finance Manager, Manila Water Asia Pacific (VIetnam)
"Learned a lot in this course. Thank you!" - Mayee Pena, Cost Controller, Manila Water
"I learned a lot! MS Excel Level Up" - Jasmine Orpilla, Corporate Finance and Admin Manager, Manila Water
"I am happy I was able to participate and learn in this seminar, looking forward to future trainings. " - Timothy Salak, Business Development Manager Ayala Corporation Infrastructure
"Mr. Williamson is very approachable, tries to understand and provide practical solutions to questions of the attendees." - Mae Christine Go, Internal Audit Manager, Ayala Corporation