Using Microsoft Excel to solve business problems

Course Overview

This course will increase your ability to use Excel in dealing with complex financial problems, to run sensitivity analysis on the results and to present your findings in a highly effective way.

These hands-on courses will be run in our computer suites to give delegates the chance to try the techniques for themselves. Numbers will be limited to 12 for better tutor interaction.

Audience

• Those involved in making business cases, numerical forecasts and financial decisions for their companies; or
• Those seeking an introduction to financial modelling

Course Outline

Approaching the business problem

• planning and documentation
• core concepts and principles

Presenting the business problem

• outputs
• inputs
• calculations

Amending the data

• inflation
• growth forecasts
• financing solutions

Understanding the solution and 'what if' analysis

• Presenting the solution using data tables and charts

Using Microsoft Excel to solve business problems / cm65360