"A Training Solution Provider delivering Learning Skills to keep forever"

Call the JCS training team free now 0800 5425 150 Or mail Email | training@jcstraining.com
  • Microsoft/Excel Mastering Financial Modelling

Excel Mastering Financial Modelling

Course Delivery:JCS training NN3 6QB and associate locations nationwide
 Duration: 1 day
 
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 suitable for candidates who have not attended a formal training course. 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 PivotCharts
 
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 around workbooks and worksheets

Course Objectives

Excel Mastering Financial Modelling 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.