by admin | Apr 14, 2022 | Excel | General
You can view part one of this tutorial here and part two here. In this tutorial what I want to look at is how to set up formulas to show our monthly stats. We already have our sheets set up and we’ve got a table set up on each one. Next step is to (a) use group...
by admin | Apr 11, 2022 | Excel | General
This is the second of my series in creating a KPI dashboard. You can check out the first blog post here. You can download the completed file for this session here in which I show you how to calculate calendar days, working days and use the IF function to identify...
by admin | Mar 26, 2022 | Excel | General
In March 2022 – as part of my Excel snacks sessions – I set myself the challenge of doing a dashboard in 20 minutes. The first thing to say is that I copied the example of TV chefs everywhere by having my ingredients ready. As one class participant once...
by admin | Mar 25, 2022 | Excel | General
I was recently asked in a class about the second version of the Index function available from the Formulas | Function menu. To be honest I’d never come across it before. Needless to say I was intrigued and here we are – a blog post about it to brighten...
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 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...
