Dublin
01 524 1338
Cork
021 242 9691

Excel Financial Modelling Course

Got a Question? Ask anything, we'll reply instantly. Ask now

How can we help?

Thanks for getting in touch.

All of our team are currently busy with customers, so please leave your email address and we will get back to you within 10 minutes.

We promise :)

All courses

Onsite Training?

We can come to you - wherever you are with work- shops and training sessions tailored to your specific needs.

Find out more

Trusted by ...

A case-study led examination of the principles and practice of financial modelling. The course focuses on a project finance-style scenario. It includes the construction of an integrated set of simplified financial statements and subsequent investment appraisal. The course also considers sensitivity analysis. This course is aimed at both intermediate and experienced staff – it is expected that all participants will have a good grasp of Excel prior to attending this course.

Whilst this introductory course is considered suitable for intermediate users of Excel, all our courses will also suit more seasoned modellers who may be looking to refresh their modelling skills or gain some new insights on model building approaches.

Get Answers to Your Questions in the Excel Financial Modelling Brochure. The brochure contains: Course Format; Trainer Profiles; Previous Clients; Course Syllabus; Full 2018 Timetable & Course Fee.

Get the Excel Financial Modelling Brochure & 2018 Timetable

What's Inside the Brochure?
  • Full course outline
  • Career opportunities and trends
  • Fee and 2018 Timetable
Download Now

By the end of this course you will be able to:

  • Design and construct useful and robust financial modelling applications
  • Learn financial forecasting
  • Use several of the support tools and techniques in spreadsheet programs
  • Utilise sensitivity and scenario analysis

What will you learn on this course?


  • Introduction to Modelling

    Using Excel as a spreadsheet; Effective construction of a model; Objective and structure; Initial preparation

  • The Fundamentals of Model Building

    Use of shortcuts; Workbook set up; Formatting data professionally; Style basics Inputting base data; Setting up date flexibility throughout the model using EDATE, EOMONTH and other date functions; Breakdown and grouping of accounting elements; Determine drivers of the model; Assumptions for projections; Effective use of short-keys and functions; Applicable financial and logical functions; Data transfer and links; Professional use of Excel –protection, range names, data validation Maximum use of Excel applications; Flexible and user-friendly models; Sensitivities; Model diagnostics

  • Auditing

    Using existing models; How to become comfortable with ‘new’ models; Auditing models

  • Evaluating the Day

    Formatting; Professional showcase; Use of graphs; Using switches

How does it Work?

Onsite Training is when we come to you to provide training on your premises or at a location of your choice. Not only will we run the course at a time and venue that suits you, we will also develop a unique programme particular to the developmental, cultural and business requirements of your company.

What's Involved?


Step 1 | After initial discussions, you meet with our training specialist. Here you both work together to design and sculpt a more comprehensive programme outline.

Step 2 | From this outline, a course is designed which addresses your exact needs. Sometimes this involves a completely new course designed from scratch, this depends on your needs.

Step 3 | Once you're happy with everything, the trainer will deliver the course at a venue of your choice on a date that suits.

Step 4 | Once complete, feedback will be gathered from delegates to ascertain the ‘true’ impact. And finally a report will be compiled for you outlining outcomes alongside your stated objectives.

Get a tailored training quote for your How to Read Financial Statements Training today Click Here

Excel for Finance Teams

Excel for Finance Teams

Accountants and Finance team members generally use a great deal of Excel on a daily basis. The course is designed to include new tools and techniques using Excel 2013. We’ll explore useful formulas, s...

Excel for Finance Teams
Finance for Managers & Directors

Finance for Managers & Directors

As a director, whether executive or non-executive, you have responsibilities beyond the norm. Your financial role extends beyond management to financial strategy, corporate governance, group structure...

Finance for Managers & Directors
Finance Training for Sales

Finance Training for Sales

If you are in Sales, Marketing or Sales Support, you already appreciate that without sales there is no business but do you understand if the sales are profitable, break even or actually at a loss? Whe...

Finance Training for Sales
Finance Fundamentals

Finance Fundamentals

Financial skills and knowledge are vital for all managers in all organisations. A more challenging business and economic climate and an increase in financial delegation are making this even more so. M...

Finance Fundamentals
Credit Control

Credit Control

This course has been designed to balance good customer service with good credit control. The course focuses on good communications and negotiation skills while dealing with the common problem of overd...

Credit Control
Data Protection for Finance Teams

Data Protection for Finance Teams

This one-day introductory-level programme is designed for finance teams who handle information about clients or the general public – and who need a basic understanding of data protection rights and re...

Data Protection for Finance Teams
How to Read Financial Statements

How to Read Financial Statements

To many nonfinancial managers, the world of financial terminology and statements is often unclear ... confusing ... even downright frustrating. But, the truth is, buried within those numbers are often...

How to Read Financial Statements
Presenting Financial Information

Presenting Financial Information

Too many financial presentations are filled with spreadsheets and complex graphs from Excel. This confuses executives, which leads to delayed decisions and lost opportunities. This focused, one-day wo...

Presenting Financial Information
Location Date Max Attendee Registered
(so far)
Booking
Dublin | Training Centre 21 April 2018 14 14 Fully Booked
Dublin | Training Centre 21 June 2018 14 12 Book Now

Get the Full Course Brochure & 2018 Timetable Instantly

Get Your Brochure Now

Get the Non Finance Brochure Instantly

What's Inside the Brochure?
  • Full course outline
  • Career opportunities and trends
  • Fee's and 2018 Timetable

Download

Scrummaster Onsite Training Guide

  • Full details of the course

  • Case studies companies we've worked with

  • Our onsite trainer profiles

Download Now

Download the 2014 Finance for Non Finance Course schedule instantly

  • Nationwide locations and venues for 2014

  • Areas include | Dublin, Cork, Galway, Limerick, Meath and many other counties

  • Onsite training is also an option

Download Now

Ask Anything? Get an Answer Instantly!




Get Answers

on the Course Today and Our Team will Call You to Confirm Your Place

How to Read Financial Statements

How can we help?

Thanks for getting in touch.

All of our team are currently busy with customers, so please leave your email address and we will get back to you within 10 minutes.

We promise :)