Better Business Reporting - Better and quicker management reporting using Excel

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

Category:

Howto & Style

Tags:

• Better Business Reporting
• UK Fin Rep
• UK Auto Rep
• sales reporting
• 2 variable data table
• Excel
• Excel Reporting
• Richard Colley
• Excel What if
• Goal Seek
• KPI's
• Management reporting
• Multiple Goal Seek
• What if
• Excel text
• Excel Formulas
• Interactive Text
• commercial director
• experienced financial director
• growing businesses
• innovative director
• refocussing businesses
• strategic director