Course Overview

Tunneys offer bespoke 1 or 2 day courses to businesses and groups that have specific learning outcomes or problems to be overcome. This option is intended for teams or groups facing a challenge in their business for which a more focused learning approach would be required. Therefore no existing knowledge or skills would be assumed or required and all learning would be bespoke to the level of the group.

Course Content

This course will be designed for and with the group in advance and can cover but are not limited to the following areas:

• Key Excel formulas, shortcuts and techniques
• Essential data manipulation skills
• Excel chart manipulation skills
• Principals of best practice financial modelling
• Model building, management and review
• Building a cash flow from a set of data
• Discount cash flow and NPV theory and calculations
• Depreciation calculations
• Debt calculations
• Equity Investment calculations
• Valuations
• Option appraisals
• Scenario modelling
• Activity based costing
• Zero based budgeting
• Profitability differentiation
• Power Query
• Power BI
• Integrated financial statements (P&L, Cash Flow and Balance Sheet)

Post course support:

The group may wish to retain a specific level of monthly or annual support whereby Tunneys can be contacted online for ad-hoc questions, advice and problem solving such as writing or correcting a formula, identifying the route of a problem or giving feedback on a piece of modelling work.

‍

* For questions about this course, delivery at your offices or to discuss bulk discounts please contact enquiries@tunneys.co.uk