Tag Archives: KPI’s

Creating a Full Year Forecast What If Table

Excel has a variety of useful functions which individually have limited use, but when combined they are enormously powerful. Here I combine, a two variable data table, with choose, and goal seek, to produce a dynamic What If table Continue reading

Advertisements
Posted in Better Management, Excel Tips and Tricks, News | Tagged , , , , , , , , , , | Leave a comment

Adding Interactive Text to Excel Reports

How to make extensive use of interactive text within Excel, which both eliminates the chance of error, and shows the correct figures for each month chosen. Continue reading

Posted in Excel Tips and Tricks, News | Tagged , , , , , | Leave a comment

Better and quicker management reporting

Business Analytics and Reporting Continue reading

Posted in Better Management, News | Tagged , , , | Leave a comment