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

Introduction​

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

Objectives

 

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

Prerequisites

 

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

  • Financial Analysts

  • Directors/Heads/Managers of Strategic Planning

  • Directors/Heads/Managers of Business Development

  • Financial/Equity/Treasury Analysts

  • Project Managers

  • Project Financiers and Lenders

  • Accountants and Auditors

  • Financial controllers

  • Risk managers

  • Credit managers

  • Financial and management accountants

  • Financial project administrators

  • Project finance professionals

  • Financial planners

 

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 enquiries@ctsolutionsglobal.com

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