You are here: Find Courses/Training /
Excel Business Modelling, Coleago Consulting Ltd
Excel Business Modelling
|
Summary
|
|
|||||||||
Excel Business Modelling
Early modules focus on best practice and participants will learn the "golden rules" of best practice model structure and design as well as exploring many, often underutilised, features and functions of Excel which make developing models faster and the resulting models more powerful. Participants will also learn how to use simple macros and Visual Basic to turn their spreadsheets into impressive applications.
Other sessions focus on different elements of the financial statements including sessions on revenue forecasting techniques such as the use of s-shaped and diffusion curves as well as all other elements of the financial statements such as costs, capital expenditure as well as valuation techniques as well as tools for assessing the risks of a project.
The course is highly practical and participant numbers are strictly limited to ensure high levels of personal attention. Participants will leave with a library of model components developed during the course which they can use immediately in their own models.
If you want to find out more about Excel Business Modelling, you can make an information request below and the school will contact you with further information.
Suitability and application
- Non-accounting managers required to work with Excel
- Analysts and financial managers
- Strategic and business planners
- Cost centre managers and budget holders
- Engineers, IT and technical managers
- Bankers, accountants, VCs and other finance professionals ยจ
- Economists
- Corporate advisers and consultants
Pre-course analysis and reading
Course Structure and Content
- Scenario planning
- Principles of best practice business modelling
- Model structure and layout
- Excel's cool functions and features
- Testing and debugging
- Introductions to macros
- List boxes, buttons and scroll bars
- Simple programming using Visual Basic
- Getting the most from your model
- Overview of the financial statements and investment appraisal
- Customers and revenues
- Advanced modelling
- Operating costs and capital expenditure
- Building the financial statements
- Interest, taxation, and dividends
- Completing the financial statements
- Investment appraisal
Outcome / Qualification etc.
- Discover the principles of best practice business modelling
- Appreciate how to use macros to make modelling easier and quicker
- Learn how to plan, structure and construct models for use within the communications sector
- Review Excel's functions and features and how to use them
- Develop modular business models to ensure greater efficiency
- Learn how to use Visual Basic to turn simple spreadsheets into impressive applications
- Develop techniques for efficiently testing and debugging models
- Learn how to use your model to make better management decisions
- Gain advice from modelling professionals on how to develop your own models
Expenses
Coleago Consulting Ltd
The specialist telecoms, media and technology training company
Coleago Consulting provide advice, support and training to companies, investors and regulators in the communications sector. Our team comprises only highly experienced, industry experts, many with more than 25 years experience.
Coleago has established itself as a leading provider of strategic, regulatory, technical and business modeling training within the telecoms sector.
Our trainers are first and foremost sector industry professionals and so we have the credibility and understanding to deliver relevant and practical training which provides real business benefits. We deliver our training through traditional instructor led tutorials as well as our War Game, a business simulation exercise which develops strategic and commercial skills as well as providing a platform for management development.
Show all courses with
Coleago Consulting Ltd
Request information - obligation free
Contact information for Coleago Consulting Ltd
Phone no: +44 7973 315 434 
More Information
Request Information
To request information from Excel Business Modelling, please fill out the following details:
Reviews
Need help finding the right course?
