Excel Business Modelling for Telecoms
- Duration: 2 days
- Level: Level 2
Excel Business Modelling for Telecoms
Who Should Attend
This class assumes some familiarity with the basic functions and features of Excel, such as constructing simple formulae and is suited for anybody within the telecoms sector that could leverage the use of business models as part of their job role.
Course Outline
Divided into 8 sections, the topics covered will include:
Section 1: Best Practice Excel Business Modelling (1.5 hours)
This initial section explains the key principles of the Coleago MAPPED Modelling Methodology, conveying the principles of best practice business modelling in order to make business models more efficient and effective. Essentially, the section will provide a structure and framework for those attending who are self taught in Excel, allowing the attendee to create models that are easier to follow, use and create, yet at the same time providing greater analytical power.
Section 2: Model Structure Layout and Design (1.5 hours)
This section describes the varying methods for model layout, showing how spreadsheets can be designed to be effective and powerful, with the ultimate goal of making a spreadsheet capable of answering key business questions. Included in this section will be a guide on how to make models on a modular basis, as well as providing content on enabling “what if” analysis. In addition, the techniques of graph manipulation and report design will be highlighted, passing on essential tips and tricks.
Section 3: Excel Features for Power Modelling (1.5 hours)
This section describes useful features for power modelling in Excel, uncovering the little known tools that are readily available which make a major difference to the speed and accuracy with which you can develop a model. The section will include techniques that will accelerate the development of a model and also design workings for maximum efficiency.
Section 4: Useful Functions in Excel (1.5 hours)
Excel contains a number of functions that can allow the user to become a more effective and powerful modeller. This section seeks to examine these key worksheet functions in sufficient detail to provide the attendee with the confidence to tackle more sophisticated modelling challenges. Included in this section will be a description of the “switching point” technique, which increases the power of spreadsheets.
Section 5: Building a Model (1.5 hours)
Using a business problem as a scenario, this practical session is designed to allow the attendee to implement some of the skills developed in the preceding sections.
This section, like the preceding sections, is designed to provide the attendee with a suite of techniques and a useful library of spreadsheets which can be used back at their place of work.
Section 6: Turning a Model Into an Application (1.5 hours)
The ability to incorporate useful macros into a spreadsheet, such as check boxes, buttons, scroll bars etc is a desirable skill. This section is designed to show how these features are implemented, in addition to providing guidance on how to record, edit and even write simple Visual Basic macros.
Section 7: Testing and Debugging (1.5 hours)
Testing and Debugging is a critical stage in the development of any model. As such, this section will examine the use of the Audit Toolbar when auditing a model, as well as describing simple techniques that can automate and accelerate the bug checking process.
In addition, error trapping techniques will be highlighted, showing how to capture potential issues and deal with circular references.
Section 8: Getting the Most from a Model (1.5 hours)
This concluding section will introduce additional tools that are included with Excel. Accordingly, facilities such as Goal Seek, Scenario Manager and Solver will be highlighted. Topics covered in this section include: constructing a scenario manager, creating workings for sensitivity analysis and using Visual Basic to automate key processes.