by admin | Jun 18, 2018 | Excel | Advanced Lessons, Excel | Case Studies, Excel | General
Note: Since I wrote this I attended the Excel MVP Conference in Amsterdam – and the techniques I learned there made me realise I could have done this more effectively.. You can view Part one here (Steps one to three) Just a reminder about what deferred income...
by admin | Jun 18, 2018 | Excel | Advanced Lessons, Excel | Case Studies, Excel | General
Note: Since I wrote this I attended the Excel MVP Conference in Amsterdam – and the techniques I learned there made me realise I could have done this more effectively, but that will be for another post…:-) There are seven steps in this so I have published...
by admin | Jul 4, 2017 | Excel | Case Studies, Excel | Excel for Small business, Excel | General
A common issue for many organisations is tracking time-in-lieu i.e. someone has a certain number of days/hours holidays(vacations) allocated but they can increase that by doing overtime and then taking time off – “in-lieu”. While some organisations...
by admin | Sep 23, 2014 | Excel | Case Studies, Excel | Excel for Small business, Excel | General
Recently I went in to do some training with a new manager who had been tearing his hair out with his Excel sheet. The spreadsheet had already been set up for him and the previous incumbent had done some interesting array formula variations using If and Sum – and...
by admin | Sep 9, 2014 | Excel Functions | Useful, Excel | Case Studies
Got presented with an interesting dilemma recently. If you (or your children or any children you know) compete in anything there is usually an age cut off point. For example my son competes in music competitions and the cut off date for each year is 1st January i.e....
by admin | Jun 2, 2014 | Excel Pivot tables | Introduction, Excel | Case Studies, Excel | Useful tricks
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...
