by admin | Feb 1, 2021 | Excel | Case Studies
In this blog post I walk you through a number of different ways to tackle a question. I had a user who had to identify the correct rate for something based on country of origin and product type. You can download the completed file here. Watch the video here to see how...
by admin | Jan 25, 2021 | Excel | Case Studies
Recently in a class I had someone who had to track attendance over a number of days training via a bunch of Zoom Emails. This link shows you how you would extract a list of attendee email addresses from your Zoom list. The key is really to get your data in good shape....
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...