Author Archives: r001

How to choose different months in an Excel report

I was asked how you add a slider to a report to choose the data shown for different months. This involves two excel devices: 1. A slider from Forms Control and 2. VLOOKUP function Forms Control You may need to … Continue reading

Posted in Excel Tips and Tricks | Leave a comment

Top 20 business and UK travel websites

I am often asked what’s the cheapest way to travel, hold a one to one video conference, or what’s the most useful software on your Macbook? Having done this several times recently here is my personal list of the latest top 20. Continue reading

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

Product Portfolio Management

When reviewing a product portfolio always start from the perspective of why might customers start buying from you. Typically, a decision to change supplier is driven by one of three reasons; a) their previous supplier let them down or is … Continue reading

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

Mind Mapping

Mind Mapping software is a great tool for a busy executive, and it’s an essential tool in any growing business. Continue reading

Posted in Better Management, News | Tagged , , , , , , , | 1 Comment

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

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