|
|
Need help or advice?
We'll call during UK business hours
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ILM Endorsed Courses
Financial Training events in the next 12 months: live dates & pricing here |
Who is this course for?
Anyone looking to learn or extend their knowledge of using Excel to assist with financial decision making in a business context.
Prerequisites
Attendance or equivalent knowledge of Excel Advanced Part 1 and Introduction to Finance for Non-financial managers.
Objectives
This course will show you why Excel is an essential tool for financial modelling, guide you through some key models and also introduce the practice of rolling forecasting. There will also be the opportunity to explore tying up actual models with reporting.Course Syllabus
Excel modelling fundamentals Best practice tips Analysing data for financial models Using Pivot Tables to analyse and prepare raw data Sales and cost budget models Interpolation and extrapolation methods Capital investment models Understanding discounted cashflow and net present value (NPV) | Business valuation models Understanding and using different business valuation methods Rolling forecasts Budgets versus rolling forecasts Dynamic reporting models Building simple reporting models for divisional reporting |
|
|||||||||
| Version | Date | Location | Places available |
Book | Next place rate (£) | List price |
|||
|---|---|---|---|---|---|---|---|---|---|
| Pay by Card |
Pay by Invoice |
||||||||
| Standard | Thu 5 + Fri 6 Dec 2013 | Southwark | 8 |  |
£950 | £950 | £950 | ||
| Standard | Thu 6 + Fri 7 Mar 2014 | Bloomsbury | 8 | |
£950 | £950 | £950 | ||
| Standard | Tue 3 + Wed 4 Jun 2014 | Limehouse | 8 | |
£950 | £950 | £950 | ||
What you get
 |
Training is held in our modern, comfortable, air-conditioned suites Modern-spec IT, fully networked with internet access |
"What do I get on the day?" |
Learning tools |
 Breaks and timingCourses start at 9:30am. |
 In-course handbookContains unit objectives, exercises and space to write notes |
 RefreshmentsAvailable throughout the day:
|
 24 months access to trainersYour questions answered by qualified trainers online. |
 LunchLunch is provided at a local restaurant or pub. Browse the sample menus: |
Training Formats & Services
|
Some reasons why thousands of businesses trust us
|
Some of our clients:
|
