by admin | Jun 2, 2014 | Case Studies - How To
I was recently teaching a class on Powerpivot and the subject came up of how to use Excel to construct an aging analysis. The person had already created some serious serious formulas to do what he needed to do so no point in re-inventing the wheel. His big interest...
by admin | May 12, 2014 | Case Studies - How To
Recently I was asked to help a manager score a series of tenders. The scenario was as follows: He had 10 questions for each tender application. Some questions were deemed essential. Others less so. He had 15 applications He needed to find some way to be able to...
by admin | Feb 10, 2014 | Case Studies - How To
I recently got asked to help with setting up a formula that would autofill standard entries for particular species. The idea would be that the user would enter a species name and then the other details would fill in as normal. While the example I’ve given here...
by admin | Nov 18, 2013 | Case Studies - How To
In the first of these blog posts I showed you how to set up your data entry sheet to make it pivot table friendly. Now in this blog post we are going to use pivot tables to show the following… Analysis of each property’s performance (using total income)...
by admin | Nov 11, 2013 | Case Studies - How To
Recently I got asked for help by a colleague. She had helped a friend set up a spreadsheet to track his income and expenditure on his properties. Of course he had started off with one and that was easy to track but he had been very successful and was now up to...
by admin | Oct 24, 2013 | Case Studies - How To
I recently came across an interesting problem. A student in one of my classes asked me to help her set up some If functions which I did and which worked fine. It was a function to say that if a cell was blank, then the answer was to show today minus the days in F2,...
