by admin | Mar 25, 2022 | Excel | General
You may be familiar with index/match but there’s another variation that I like to call index/match/match (like New York – so good they named it twice). This is about how to use a Match function (which I describe as being a bit like salt – you...
by admin | Mar 16, 2022 | Case Studies - How To
In this tutorial I want to show you how to use vlookup along with iferror() and conditional formatting to quickly identify what is in one list – but not in the other.. Here is the completed file and you can view the video here
by admin | Mar 11, 2022 | Case Studies - How To
This blog post came courtesy of a course participant. She was spending a lot of her (all too precious) time on calculating dates for follow ups? As it happens, Excel has a function for that….called Workday() You can download the completed file here and view the...
by admin | Mar 7, 2022 | Excel | General
One of the most common questions I get asked in class about pivot tables is “Well, how do I know what goes where?” . In previous versions of Excel I would have recommended the following.. Go to the ever-wonderful Google and type in “How to plan a...
by admin | Feb 28, 2022 | Case Studies - How To
I had a participant in my class who regularly brings groups on excursions and she thought it would be lovely – as indeed it would – to have a way to identify who has a birthday in the time period of the course. I began with a list of fake names and dates...
