Mastering Financial Modelling In Excel Duration: 1 Day

Course Overview

Objectives: Tutor led hands on training day covering Excel Formulae. In this course we concentrate on Excel Formulae from a basic level through to advanced – the exercises used through this training are designed to help the candidate master financial modelling whist showing shortcuts and tips to assist with effective use of this spreadsheet software. Who should attend? This course is beneficial for candidates who need a good understanding of formulas and functions.

Course content:

Formulas and Functions

• Defining Relative, Mixed and Absolute References
• Database functions
• VLOOK UP
• HLOOKUP
• Sum, SumIF, CountIF, IF, NestedIF
• PROPER
• Case, TEXT and STRING formulae
• DATE
• COUNT, AVERAGE and RANDOM

Pivot Tables

• Creating PivotTables, Creating Pivot Charts

What If Analyses

• Dynamic Tables
• Create, Modify, Format

Subtotals

• Using group and outline

Named Ranges

• Creating & using Named Ranges
• Using, Pasting, Deleting, Creating

Working with and around workbooks and worksheets