Business Plan Modelling Using Excel

Summary

This course shows how building the plan model is the first step in transforming ideas into tangible reality.  Attendees will gain insight on how to adjust model variables and source data sets using dashboard interfaces (radio buttons, drop down lists, command buttons etc.)  this course will demonstrate how a well-organised plan appears if the concepts make sound business sense.

Venue details:  
Belfast, 8-10 Amelia Street, Belfast
Start date & time:  
05 December 2019 09:30
End date & time:  
05 December 2019 16:30
Price: €270.53  (€257.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
10.00
CPD hours:  
7.00
Speaker details
First nameLast name
Mullan Training

Description

Product type:  
CPD course
Category:  
Information technology

Who should attend?

This course is designed for Accountants who have had limited involvement in business planning on Excel and require more competence in business planning techniques.

This course is not suitable for inexperienced Excel users. Delegates will be expected to be familiar with the following in Excel:

  • Linking Spreadsheets
  • IF Function & Nested IF Statements
  • And & Or Functions
  • Lookup Functions (Horizontal And Vertical Lookup)
  • Subtotals
  • Conditional Formatting  

Course overview

  • Building the detailed working sheet and importing workings from subsidiary schedules
  • Dealing with capital expenditure and funding
  • Developing Profit & Loss, Balance Sheets and Cash Flows and manipulating these with minimum level inputs
  • Sensitivity analyses, goal seeking and scenario setting
  • Preparing formulae to relate accounting concepts in spreadsheets
  • Building checks and balances to ensure model integrity throughout workbooks

Key learning outcomes

  • Maximise flexibility and business model dynamics while incorporating future needs
  • Compete for support and resources with the aid of a convincing plan either internally or for their clients
  • Communicate business and data insights with dashboards