Demo Mode
ICAEW
  • Login
  • Event listing
  • Checkout
  • How to Book
  • Contact us
0
Basket

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

Available
All Locations
Data Analytics
Sep
25
Mon
-
Dec
31
Sat
09:30
-
PM
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 

  • +44 (0) 1908 248 159
  • academy@icaew.com

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

Contact us

  • Helplines and support
  • How to make a complaint
  • International offices
  • UK offices

Events

  • All events
  • Continuing professional development (CPD) courses

Information services

  • Library
  • Guide to services
  • Company research
  • Historical resources
  • Library collection
  • Library search

Legal

  • ICAEW policies
  • Cookies
  • Privacy policy
  • Reproducing ICAEW content
  • Copyright notice and disclaimer
  • Data protection policy
  • ICAEW website links policy
  • +44 (0)1908 248 250
  • contactus@icaew.com
  • icaew_uk
© ICAEW 2017

This screen shows you the details for the selected product.

Click the "Add to Cart" button to add this product to your shopping cart. You can enter a quantity larger then 1 to add multiples of this product to your shopping cart.

If the product is full you will see a "Wait List" button. Click this button if you would like to be notified if/when capacity is added. If capacity is increased we will email you.  Upon receipt of the increased capacity notification, registration will be on a first-come, first-served basis.

If the product is not ready for purchase you will see a "Notify Me" button. You can click this button if you would like to be notified when this product is ready for purchase.

Some products can only be purchased through our partner. In this case you will see an "External Register" button. Click this button to purchase through our partner's website.

Powered by Configio Sandbox 1825 N Hutchinson Rd, Suite 300, Spokane Valley, WA 99206