Operational Modelling Course

The Operational Modelling Course is designed to provide participants with a comprehensive understanding of operational spreadsheet modelling, including Revenue, Cost of Goods Sold, Operating Expenditure, Capital Expenditure, Unit Prices/Costs, Volumes and Inflation. A mix of theoretical and practical exercises will ensure participants walk away with a thorough understanding of operational modelling concepts and have the ability to perform detailed and efficient operational analysis within Microsoft Excel.

The Operational Modelling Course addresses the following areas:

  • operational Analysis - overview and fundamental concepts;
  • a modular approach to operational modelling;
  • Volumes;
  • Inflation;
  • Unit Prices;
  • Unit Costs;
  • Revenue;
  • Costs of Goods Sold;
  • Operating Expenditure;
  • Capital Expenditure;
  • The impact of operational modelling on financial statements;
  • Operational modelling precedents and dependants; and
  • using bpmModules to quickly and efficiently develop operational spreadsheet models.

Contact BPM to book this course.Book this training course.

Course Information

Intended Audience
Beginner to intermediate Excel users

Course Type
Practical

Complexity
Basic

Pre-Requisites
None

Duration
4 hours

Price
View prices

Course Materials
Presentation materials; annotated "Operational Modelling" reference guide; example models; self training exercises.