Better Business Reporting - Better and quicker management reporting using Excel





The interactive transcript could not be loaded.



Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Uploaded on Feb 17, 2010

Web: http://tinyurl.com/rcolley
Blog: http://r001.wordpress.com/

Excel has a variety of useful functions which individually have limited use, but when combined they are enormously powerful.

One of the major problems with monthly reporting, is keeping figures correctly aligned in Board Reports say in Word Format and the accounts say in Excel. Invariably last minute revisions are made to the accounts and not the Word document and also human transposition error creeps in.

In this video showing the reporting model for an imaginary company BAR Fruits Ltd, I show how a monthly reporting model can be made more powerful through a What If table, to look at possible year end outcomes.

About me - I am an experienced, strategic and innovative commercial director - financial director with a dynamic track record of leading, refocusing, and growing businesses.

► My Key Skills

● Creative developer of strategies for market leadership and growth
● Negotiator of successful acquisitions, mergers and disposals
● Securing funding from private equity houses and banks
● Strong IT skills/knowledge and implementation
● Comprehensive business planning, modeling and meaningful financial reporting

Contact Details
E: richard@colley.co.uk
M: +44 7813 025605


When autoplay is enabled, a suggested video will automatically play next.

Up next

to add this to Watch Later

Add to

Loading playlists...