98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsExcel Financial Modelling Training Course
Excel 365
Face to face / Online closed & onsite training. Restaurant lunch included at STL venues.
- 2 days Instructor-led workshop
Further to this syllabus, many delegates went on to take the Effective Budgeting and Beyond course.
Syllabus
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.
Benefits
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.You may also be interested in our finance for non financial manager or VBA courses.
Course Syllabus
Fundamentals of financial modelling
Applications for financial models
Vital differences between financial models and spreadsheets
Best practice in developing and building financial models
Getting the best results with Excel
Financial models and techniques for forecasting
Using Excel's data analysis toolkit
Avoiding common forecasting problems
Using moving averages to isolate trends in time series data
Using linear regression to isolate trends in time series data
Using exponential smoothing to forecast sales demand
Building a financial model to make sales forecast
Using Excel Solver to minimise forecast error
Using Excel correlation tools to identify links between variables
Building a financial model to forecast costs
Understanding the drivers of business cash flow
Building a financial model to forecast cash flow
Financial models for capital investment decision-making
Principles of capital budgeting
Common approaches to capital investment decision-making
Understanding the time value of money
Principles of discounted cash flow (DCF)
Understanding and using Excel DCF functions
Building a financial model for capital investment decision-making
Financial models for forecasting and improving business performance
The elements, structure and dynamics of financial statements
Understanding the shareholder value concept
Measuring profitability with Return on Net Assets (RONA)
Managing the key drivers of RONA
Understanding and managing business risk
Building a financial model to forecast financial statements
Using rolling forecasts in adaptive management processes
Building a financial model to make rolling forecasts
Financial models for business valuation
The need for and approaches to business valuation
Understanding the shareholder value added (SVA) method
Building a financial model for business valuation
What you get
"What do I get on the day?"
Arguably, the most experienced and highest motivated trainers.
Face-to-face training
Training is held in our modern, comfortable, air-conditioned suites.
Lunch, breaks and timing
A hot lunch is provided at local restaurants near our venues:
- Bloomsbury
- Limehouse
Courses start at 9:30am.
Please aim to be with us for 9:15am.
Browse the sample menus and view joining information (how to get to our venues).
Refreshments
Available throughout the day:
- Hot beverages
- Clean, filtered water
- Biscuits
Online training
Regular breaks throughout the day.
Learning tools
In-course handbook
Contains unit objectives, exercises and space to write notes
24 months access to trainers
Your questions answered on our support forum.
Training formats & Services
Training Formats & Services
Training formats available
|
Testimonials
NBCUniversal
Hanna Alem,
Financial Analyst
Very good training a
Excel Financial Modelling
Incommunities
Barrie Topham,
Senior Finance Officer
A lot was covered in the two days and at times it was a bit stressful trying to keep up with topics that I had never covered before. I enjoyed the course and Paul's delivery and knowledge. Hopefully I will be able to use the course to improve consistency and efficiency within my work role.
Excel Financial Modelling
Incommunities
Greg R,
Ace Resources
Paul has been great, we have different skill levels and use excel in different ways but he has been able to account for these variations in his pack and stimulating presentation.
Excel Financial Modelling
Training manual sample
Below are some extracts from our Excel Financial Modelling manual.
Unit 3: Extract Data
In this unit you will learn how to:
Extract data from excel table
Extract data from excel external workbooks
Extract data from databases
Extract data from excel table
To extract data from Excel the data most be stored in an Excel Table.
What is a Table?
In Excel, a table is a specially designated range of numbers. This special range of numbers has added functionality that other cell ranges do not have. You can have more than one table in a workbook or worksheet if you want, and tables can be as large or small as the amount of data you want to work with.
Normally a table is made from adjacent columns of data, with a unique label or heading for each column. Each row in the table should have entries organised according to the column headings. You should keep your table data adjacent in a block to take advantage of all of Excel’s table features. Some Excel features, like filters and PivotTables, will not work correctly if the data is not blocked together in adjacent columns as a table.
One of the key advantages with working with a Table is that the table range will automatically increase as more rows are added. If you have used an Excel Table as the basis for a PivotTable, when the PivotTable is refreshed it will grow to accommodate these new rows. These new rows can either be typed manually or pasted on to the bottom of the table.
Creating Tables
To create a table from an existing range:
Pre-select a range of data in adjacent columns or click any cell within the required data range.
On the Home Ribbon, Style group, click on the Format as Table button.
This will display a menu of table formatting options. If you click on one of the table menu options, the selected range will be formatted as a table based on the style of your choice.
When you choose a table format, you will see a Format as Table dialogue box appear.
If there are column headings in the first row of the range you selected for your table, check the box that says, “My table has headers.”
Make sure the cell range shown is the range that you want for your table;
Click the OK button to create your table.
To extract data from Excel table, click inside the table and click From Table/Range
This will open the query editor where the data will be displayed.
Extract data from excel external workbooks.
Click Get Data -> From File -> From Workbook
Select the file and click Open.
Select the worksheet(s) and click Load
Extract data from databases
Source data stored in database can easily be extracted by Power Query. Click From Database and selected the database. If your database is not listed, you can click From Other Sources and ODBC (Open DataBase Connectivity) and connect to the database.
Select the tables or queries in the database you want to extract to Excel. The data can now be loaded to the destination workbook, or loaded as connection only, or if you want to edit the query, you can click Transform.
Extract data from web
Click From Web, enter the URL and click OK. The Navigator will display the data and again the data can now be loaded to the destination workbook, or loaded as connection only, or if you want to edit the query, you can click Transform.
Unit 4: Transform Columns & Add Columns
In this unit you will learn how to:
Use Group By to group source data
Calculate columns
Use text functions in columns
Replace errors or values in columns
Unpivot data
Use Group By to group source data
The Group By option can be used to get subtotals from source data and can be very useful if you have many to many relationships between multiple source tables. Any number of columns can be grouped, and any number of aggregations can be applied to the query.
Calculate columns
We can make any number of calculated columns in Power Query. This can be useful to automate all steps. In this example we have quarterly profit from clients and want a calculated column to display annually income.
Click Custom Column on the Add Column tab. Give the column a name and type the calculation in the Custom column formula box. On the Available columns list all for the calculated column available columns are listed. Just double click on the column name in the Available columns list when you need to reference the column in the calculation. Here it is just a simple sum.