Excel FP&A – system data and automating month-end reporting

Excel FP&A – system data and automating month end reporting

Available

All Locations

Data Analytics

Sep

Mon

Dec

Sat

09:30

16:30BST

Schedule Type Title: Every Day of the Week

Sessions: 463

Session Hours: 3241.00

Description

Apply best practice Excel techniques to extract information from databases and produce monthly management accounts and rolling strategic plans.

Please choose from the dates below to view more details and add to your basket.

Please choose a date below

Overview
Pricing
Programme
Course level
In-house

Date and time	Location
Select a date in the drop-down menu above for details	Select a date in the drop-down menu above for detailsCourse overview

Course overview

Improve your Excel technique to efficiently extract information from databases and produce monthly management accounts and rolling strategic plans.

This course will also cover model structure and construction, data cleansing, data summarisation, management accounts, archiving data, waterfall charts and strategic planning.

Learning outcomes:

A clear understanding of how to use downloaded data from Accounting Systems to create management information.
Capacity to build Data Bridges to consolidate data and transfer results to management reporting tools.
Ability to create dynamic management reports.
Ability to enhance reports with both graphical interpretation and traffic light alerts including a waterfall chart to link budget to actual results.

Who should attend

This is an intermediate course for those who need a deeper understanding of how to consolidate business data from multiple sources to model and analyse financial plans.

Computer Requirements:
You must bring a PC laptop equipped with Excel 2007/2010/2013/2016/2019 to this course. We do not recommend Apple products.
A set of model examples will be used during the course and shared with you via USB. Please contact us in advance if your laptop does not have a USB port.
On line support is available after the course for continued dialogue with the tutor.

Competency requirements:
Delegates should be able to construct an =IF statement in Excel before attending this course.

Course enquiries

Related content

View upcoming CPD dates.

Download the catalogue for our full range of courses.

In response to the ever-changing business landscape ICAEW Academy has discounted their new range of virtual learning, to support all accountants worldwide. See below, for your new discounted price.

Rate	Discount	Was	Now
Non-Member	50% off full course price	£675.00 + VAT	£337.50 + VAT
Faculty/Communities/ICAEW Member	75% off full course price	£675.00 + VAT	£168.75 + VAT

Discounts are automatically applied at the checkout.

Topics	Description
Introduction to the course
Model Structure and Construction	Best practice principles for building a Data Bridge and producing an automated management accounts pack.
Data Summarisation	Techniques to build a Data Bridge that extracts system data and summarises it into categories. Use Workbook links to transfer data to a set of Management Accounts.
Data Cleansing	Excel functions that can be used to extract and combine data items including text, numbers and dates.
Management Accounts	Create a set of month and year to date accounts with variance analysis. Build graphs to present trends and comparisons as well as use Conditional Formatting to show traffic light interpretation of the variances.
Archiving Data	Model structures to retain historic data, evaluate trends to support forecasting and produce seasonalisation profiles.
Waterfall Charts	Build a chart to illustrate the variances between budget and actual results.
Strategic Planning	How to use historic and current data to generate three and five year plans that refresh as new data emerges.
Surgery	Common problems encountered by participants in developing Management Accounts, a sharing of experiences amongst the group.
Course Review and Close

Excel level

This course is Developer level in our Spreadsheet Competency Framework.

Career level

Financial analyst

Trusted adviser

Career level in context

Career journey

Our public course programme is deliberately structured to encourage delegates from different organisations to participate. However, if you have six or more delegates who require development in the same area, we are able to run a more cost-effective and much wider range of courses tailored specifically to your organisation.

These are ideal for organisations seeking hassle-free, flexible and cost-effective training delivered to multiple delegates at your location of choice. Whether we use our existing materials or develop new content for your business, our expertise lies in translating your requirements into a pragmatic, interactive training programme highly relevant to your people and organisation.

To discuss in-house training for your business please email Academy or call +44 (0)20 7920 8813.

Basket

Item(s)	£0.00

Grand Total	£0.00