Web: [ Ссылка ]
Blog: [ Ссылка ]
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
