Date and time
Select a date in the drop-down menu above for details
Select a date in the drop-down menu above for detailsCourse 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.
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.
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.
Discounts are automatically applied at the checkout.
Model Structure and Construction
Best practice principles for building a Data Bridge and producing an automated management accounts pack.
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.
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.