By using our website you agree to our use of cookies.

Excel Business Modelling for Telecoms Professionals

3 Day Course
Code PWL133

This course has been retired. Please view currently available Telecoms Commercial Awareness.

Modules

Hide all

Model structure and layout (6 topics)

  • Creating a scenario and sensitivity manager
  • Identifying best practice model structure and input and output sheet design
  • Using Excel's templates and styles features
  • Creating user inputs with data validation
  • Working with graphs
  • Working with multiple workbooks and linking and consolidating files

Excel's cool functions and features (5 topics)

  • Discovering new ways to enter and manipulate data
  • Learning to use the I-transformation for graphs
  • Learning useful functions including IF and nested IFs, AND, OR, CHOOSE, OFFSET, LOOKUP, SUMPRODUCT, SUMIF, MATCH, INDEX
  • Working with Array functions
  • Creating Pivot tables

Testing and debugging (4 topics)

  • Developing a testing and debugging strategy
  • Using the auditing toolbar
  • Using GOTO SPECIAL to debug models
  • Using FIND to locate hidden errors

Introduction to macros (6 topics)

  • Using the record function to create simple macros
  • Working with the Visual Basic editor to edit recorded macros
  • Creating buttons to activate macros
  • Creating your own personal toolbar
  • Building a navigation menu for your model
  • Automate the printing of your model

List boxes, buttons and scroll bars (5 topics)

  • Learning how to turn a spreadsheet into an application
  • Learning how to use scroll bars and spinners
  • Making use of check boxes and radio buttons
  • Learning how to use lists
  • Generating messages and alerts

Simple programming using Visual Basic (6 topics)

  • Understanding the elements of a Visual Basic macro
  • Learning how to extract and enter data into a spreadsheet using VB
  • Performing operations using Visual Basic
  • Understanding loops and subroutines
  • Creating macros that run automatically when you open the model
  • Creating splash screens

Getting the most from your model (4 topics)

  • Learning how to use GOAL SEEK and SOLVER
  • Learning how to use Excel's own SCENARIO MANAGER
  • Performing What If and Sensitivity analysis
  • Automating the use of GOAL SEEK and running sensitivities with Visual Basic macros

Overview of the financial statements and investment appraisal (5 topics)

  • A theoretical session
  • Examining the different types of financial model
  • Reviewing the layout, contents and significance of the financial statements
  • Understanding the inter-dependencies within the financials
  • Reviewing the theory of investment appraisal techniques such as Discounted Cash Flow and the Internal Rate of Return

Customers and revenues (6 topics)

  • Reviewing different approaches to forecasting customers and revenues
  • Comparing top down versus bottom up models
  • Contrasting real versus nominal forecasts
  • Examining time series and simple regression techniques
  • Modelling the dynamics of the customer base
  • Creating a simple revenue model

Advanced revenue modelling (5 topics)

  • Developing multiple regression techniques
  • Modelling product life cycle curves
  • Modelling elasticity effects
  • Creating a debtors account and modelling working capital
  • Approaches to modelling bad debt

Operating costs and capital expenditure (4 topics)

  • Understanding the different approaches available for modelling costs and capital expenditure
  • Making cost and capex forecasts endogenous to the model
  • Discovering techniques for modelling depreciation and amortisation
  • Modelling stock and creditors

Building the financial statements (4 topics)

  • Establishing the layout of the financial statements within the model
  • Linking revenue and cost workings into the Profit and Loss
  • Modelling working capital and creating the Cash Flow Statement
  • Linking workings into the Balance Sheet

Interest, taxation and dividends (3 topics)

  • Examining the challenges of modelling interest charges and avoiding circular references
  • Computing taxation charges for the Profit and Loss and for valuation workings
  • Modelling dividends and shareholder funds

Completing the financial statements (4 topics)

  • Establishing the links between the financial statements
  • Modelling financing structures
  • Modelling analytical ratios
  • Testing the workings of the financial statements in the model

Investment appraisal (6 topics)

  • Creating a project appraisal module
  • Using Excel's NPV, IRR functions
  • Creating your own valuation models
  • Modelling terminal values and normalising final year cash flows
  • Techniques for calculating Pay Back
  • Using the model for Break-Even analysis and sensitivity analysis

Principles of best practice business modelling (4 topics)

  • Using scenario planning to identify model inputs and outputs
  • Learning the three golden rules of business modelling
  • Developing modular models
  • Using range names

Prerequisites

The course assumes some basic familiarity with Excel and the ability to move around different sheets within Excel as well as being able to construct simple formula.

Telecoms Commercial Awareness

What Our Customers Say

“The training was delivered with a high level of expertise and excellence. Instructor was highly knowledgeable.”

— Technical Trainer, Aviat Networks

“Overall the course was really good, the trainer really understood the material and was very approachable.”

— Customer Training Manager, Aviat Networks

“Excellent course, informative and well-paced.”

— CSE, Cisco

“Course was very well outlined. Topics were great and bridged many gaps.”

— System Engineer, Cable & Wireless

“An excellent intro to video encoding & MPEG transport streams - I would definitely recommend it.”

— Broadcast Engineer, Cisco

“Definitely an excellent intro. Left me interested in learning more.”

— Broadcast Engineer, Eircom

“Excellent training course with real examples and practical classroom demonstrations.”

— Transport Designer, Orange

“Instructor knowledge and experience was excellent.”

— Solutions Engineer, Akamai

“Excellent course, very clear and well organised. Course content delivery was very good.”

— Assistant Engineer, Dhiraagu

“Very informative and appropriate.”

— Network Support Technician, BT

Course PDF

Print

Sections