a

Lorem ipsum dolor sit amet, conse ctetur adip elit, pellentesque turpis.

Image Alt

Building Financial Models with Excel

  /    /  Building Financial Models with Excel

When looking at any financial opportunity the ability to perform accurate and realistic analysis is imperative. In today’s ever-changing business environment the capability to write simple spreadsheets is not enough. You have to be able to incorporate all the “what if” scenarios and stress any proposal to its limits. A well-structured financial model can facilitate and improve the reliability and quality of your decision-making.

At the end of the course delegates will be able to:

  • Understand the different types of financial models and when each should be applied
  • Construct financial models making use of a broad range of Excel methods and techniques
  • Incorporate elements such as risk, sensitivity, optimization and forecasting into financial models
  • Produce meaningful management reports and charts for communication
  • Opening and closing Excel files
  • Excel screen menu and standard toolbar
  • Auto fill
  • Moving around a worksheet
  • Moving around the sheets in a workbook
  • Creating files
  • Deleting files and individual sheets
  • Changing column width and row height
  • Entering simple formulas
  • Entering labels
  • Cell referencing
  • Centering titles and merging cells
  • Simple cell formatting
  • Number formats
  • Changing font sizes and colors
  • Copy, cut and pasting cell contents
  • Inserting graphic objects
  • Custom views
  • Previewing worksheets
  • Printing documents and ranges
Course Overview

When looking at any financial opportunity the ability to perform accurate and realistic analysis is imperative. In today’s ever-changing business environment the capability to write simple spreadsheets is not enough. You have to be able to incorporate all the “what if” scenarios and stress any proposal to its limits. A well-structured financial model can facilitate and improve the reliability and quality of your decision-making.

Course Objective

At the end of the course delegates will be able to:

  • Understand the different types of financial models and when each should be applied
  • Construct financial models making use of a broad range of Excel methods and techniques
  • Incorporate elements such as risk, sensitivity, optimization and forecasting into financial models
  • Produce meaningful management reports and charts for communication
Course Outline
  • Opening and closing Excel files
  • Excel screen menu and standard toolbar
  • Auto fill
  • Moving around a worksheet
  • Moving around the sheets in a workbook
  • Creating files
  • Deleting files and individual sheets
  • Changing column width and row height
  • Entering simple formulas
  • Entering labels
  • Cell referencing
  • Centering titles and merging cells
  • Simple cell formatting
  • Number formats
  • Changing font sizes and colors
  • Copy, cut and pasting cell contents
  • Inserting graphic objects
  • Custom views
  • Previewing worksheets
  • Printing documents and ranges

Call Me Back