Financial Analysis Fast Track

Fitch Learning
5.0
1 review
  • It has been the best training I have attended so far. Definitely, it will be useful for my day-to-day job.
    ← | →

Training

In New York (USA) and London

Save 31%
£ 1,195 + VAT

*Indicative price

Original amount in GBP:

£ 1,195 £ 1,750

The best Financial Analysis courses

See all

See all

Description

  • Type

    Training

  • Level

    Intermediate

The aim of this course is to give delegates the skills to work quickly and accurately within spreadsheets. By the end of the course those attending will be comfortable at navigating Excel using the keyboard; will understand the best practice approach to efficiently setting up a workbook; and will have considerably enhanced their skills regarding referencing, formatting, auditing and using key logical formulae. They will also have built a (tutor led) model suitable for forecasting business financials, with significant functionality and flexibility.

By the end of the course, participants will have the tools and techniques to be able to:
Build spreadsheets more quickly
Perform calculations more efficiently
Create re-usable Format
Set up a 'ready to print' spreadsheet
Add flexibility to models using Logical statement and Switches

Facilities

Location

Start date

London
See map

Start date

On request
New York (USA)
See map

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

5.0
  • It has been the best training I have attended so far. Definitely, it will be useful for my day-to-day job.
    ← | →
100%
3.3
good

Course rating

Recommended

Centre rating

OPHIE FALL

5.0
20/12/2017
What I would highlight: It has been the best training I have attended so far. Definitely, it will be useful for my day-to-day job.
What could be improved: .
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

Subjects

  • Excel Formula
  • Excel

Teachers and trainers (1)

TBC TBC

TBC TBC

TBC

Course programme

Flexible formulas
  • Relative vs. Absolute referencing
  • Efficient use of $ and Names leads to greater accuracy in formulae construction
  • Grid exercise - the exercise will involve creating formulae using mixed references
Formatting conventions
  • Inputs vs. formulae
  • Customising numbers (percentages, multiples, dates, thousands, millions, etc)
  • Styles - the quick way to format and create formats that can be used again and again and again
  • Conditional formatting - uses and dangers
  • Text strings (dynamic text) - an efficient way
Model set-up and build
  • The good and bad practice modelling guidelines
  • Understanding the structure of a model - inputs, workings, outputs
  • Using group edit tools to quickly set up a robust, consistent and printable financial model
  • Model set-up exercise - using the guidelines above
  • Integrated financial model building - an integrated financial model will be developed over the 2 days
Model auditing tools
  • F2, F5, F9, Control-[
  • Tools - Auditing toolbar

Additional information

At Fitch Learning we consistently receive excellent customer feedback - 94% of our participants recommend a colleague attend the same course. With 25 years’ experience, our interactive training methods are tried and tested. Our workshops are small – with no more than 16 people – to ensure your learning experience is as interactive and personal as possible. They are taught through up-to-date , region-specific case studies and exercises so you can apply the analytic skills you learn as soon as you are back at your desk. If you register a place 8 weeks or more in advance of the course, you can save 10%.

See related categories

Financial Analysis Fast Track

£ 1,195 + VAT

*Indicative price

Original amount in GBP:

£ 1,195 £ 1,750

The best Financial Analysis courses

See all

See all