Excel for Financial Management & Modelling - Full Course | Kaplan Financial
Skip to main content

Excel for Financial Management & Modelling

My Basket | 0 items
Go Search
Training and Qualifications > Financial Markets > Excel for Financial Management & Modelling > Pages > full-course-content.aspx  

Kaplan Financial - Home > Training and Qualifications > Financial Markets > Excel for Financial Management & Modelling > Full Course Content

Excel for Financial Management & Modelling Course Content

Introduction to Excel Functionality

Pre-requisite: this course has no formal pre-requisite, but a basic knowledge of Excel is required.

Suitable for: anyone who uses Excel on a regular basis

  • Shortcut keys
  • Data entry simplified
  • Entering numbers with a fixed decimal point
  • Autofill: Filling cells with a series of data
  • The use of relative, absolute, and mixed references in formulae (use of $) Basic Functions
  • SUM() AVERAGE(), MIN(), MAX(), COUNT(), ROUND(), IF()
  • Formatting issues
  • Custom number formats
  • Quickly copying formats
  • Format Painter
  • Basic conditional formatting
  • Hiding cells and cell contents
  • Concatenating text and values
  • Comments: Creating/Editing/Printing
  • Manipulating Dates and Times
  • Names: creation and uses
  • Data validation
  • Basic charting including setting up dynamic chart titles
  • Recalculation options
  • Protecting cells and worksheets
Apply today

Excel Features for Financial Management

Pre-requisites: to have attended Introduction to Excel Functionality or have equivalent knowledge

Suitable for: those involved in data manipulation

Conditional functions

  • Nested IF() statements, COUNTA(), COUNTIF(), SUMIF()
  • SUMPRODUCT()
    • This is a much more powerful function than might be suspected from reading the Excel help screens and allows for highly sophisticated conditional calculations

Lookup functions

  • Basic lookup techniques
    • VLOOKUP(), HLOOKUP()
    • Trapping errors via ISERROR()/IFERROR()
  • Non-exact lookups into bands of values
  • The use of MATCH() and INDEX()
  • Data tables based on lookups
  • Dynamic charts (content of chart selected from list by end-user)

Managing lists and tables

  • Sorting
  • Filtering
  • Grouping & Subtotals
  • Forms
  • Introduction to PivotTables & PivotCharts

Manipulating text

  • Functions
    • LEN(), LEFT(), RIGHT(), MID(), FIND(), SEARCH()
  • Examples of splitting/combining text strings
    • using the above functions
    • using "text to columns"
Apply today

Introduction to Financial Modelling with Excel

Pre-requisites: to have attended Introduction to Excel Functionality or have equivalent knowledge

Suitable for: anyone involved in the process of financial projection

A case-study driven examination of the principles and practice of financial modelling, focusing on a project finance-style scenario, including the construction of an integrated set of simplified financial statements and subsequent investment appraisal and sensitivity analysis. Specific topics covered include:

  • Good practice in model design
  • Names as an aid to model clarity
  • Circular references and iteration – uses and drawbacks
  • Financial functions: NPV(), IRR()

What if? Analysis:

  • Goal seek
  • Solver
  • Use of data tables
  • Scenarios
  • Understanding an existing model – Auditing techniques
Apply today

Bond Analysis and the Basics of Equity Valuation

Prerequisite: familiarity with the techniques covered on the "Introduction to Excel functionality" course.

Bond analysis

  • Valuation
  • Bond yields
  • Duration
  • Reinvestment risk and price risk
    • The principle of immunisation
  • Excel features to be used include data validation, data tables, charts, IF(), NPV(), IRR(), OFFSET(), TVM functions [PV(), FV(), etc]

Equity valuation

  • A variety of valuation approaches will be examined
    • Dividends, Free Cash Flow, Residual income, EVA, Claims valuation
Apply today

Options Analysis and Regression Analysis

Prerequisite: familiarity with the techniques covered on the "Introduction to Excel functionality" course.

Options analysis

  • The terminology of options
  • Moneyness & payoffs (intrinsic value)
  • Profits and losses
  • Valuation via the Black-Scholes model and put-call parity
  • Excel features to be used include IF(), data validation, Data tables, charts, goal seek and solver

2-variable Regression Analysis

  • Scatter plots and trend lines
  • Excel functions
    • INTERCEPT(), SLOPE(), COVAR(), CORREL(), RSQ(), STDEVP(), STDEV(), FORECAST()
  • The regression add-in
  • ANOVA tables

Multiple regression

  • Excel functions
    • LINEST(), TREND()
Apply today

* T&Cs of discount: Discount will be applied in the basket and the courses must be booked together for the discount to apply. This offer is not applicable with any other offers. Cancellation terms and conditions apply and your discount will be altered in the event of any cancellations.

Items: 0Total: £0.00

  0203 281 7457

  Email Us


Full Course Content