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