Category Archives: Excel Tips and Tricks

Tips and Tricks using Excel

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

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