Microsoft Excel Financial Modelling Training course Outline

Audience: Thiscourse is aimed for those needing the fundamental Excel skills required to create robust and professional financial models. A forecast integrated set of financial statements is created from first principles based on published historic data.

Course Duration: 1 day

Course Availability: Monday – Saturday

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and office migrations.

Course Location: This Microsoft Excel Financial Modelling training course can be delivered either at our London training venue or at your offices. 

Tailored Course Content: Course content can be customised to meet your specific requirements, with scheduled dates to suit you.

At Course Completion

After completing this course, students will be able to:

  • Understand essential financial mathematics
  • Use essential Excel Functions
  • Store key constants and references in Names
  • Produce consistent formatting using Styles
  • Use Conditional Formatting
  • Audit worksheet formulas 
  • Include Data Validation for data entry
  • Protect the model
  • Plan the model
  • Create basic Financial Statements
  • Set up a financial model

Course Outline

Module 1: Excel Formulas

  • Essential financial mathematics
  • Absolute and external references

Module 2: Excel Functions

  • Decision-making functions: IF, AND, OR, NOT, CHOOSE
  • Lookup functions: VLOOKUP, HLOOKUP, MATCH, INDEX, OFFSET, INDIRECT
  • Aggregation functions: SUMIFS, COUNTIFS
  • Information functions: ISERR, ISERROR, ISNA

Module 3: Names

  • Naming Ranges and Constants
  • Using Names in Formulas

Module 4: Formatting using Styles

  • Using Normal style for consistency
  • Creating a new style
  • Applying styles to specific areas

Module 5: Conditional Formatting

  • Changing the appearance of a cell based on its value
  • Applying Conditional Formatting with a formula
 

Module 6: Auditing Worksheets

  • Viewing Formulas
  • Viewing Precedents and Dependents
  • Formula evaluation

Module 7: Data Validation

  • Setting rules for data entry
  • Creating drop down lists

Module 8: Document Protection

  • Protecting ranges and worksheets
  • Protecting workbooks

Module 9: Model planning

  • Financial modelling best practice
  • Identifying inputs and outputs

Module 10: Creating Basic Financial Statements

  • Income Statement
  • Balance Sheet
  • Cash Flow Statement

Module 11: Setting up the Model

  • Integrating the financial statements
  • Balancing the balance sheet
  • Forecasting the numbers and populating the financial statements
  • Model audit and review
, Microsoft Excel Financial Modelling Training course
, Microsoft Excel Financial Modelling Training course