Creating a KPI Dashboard – Part Two – Calculating calendar and work days. Identifying who has met/not met the KPI
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 entries that are inside and […]
Doing a dashboard in 20 minutes….Jamie Oliver style
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 observed about Jamie Oliver’s 30 minutes […]
A Variation on the Index function – special Area edition
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 your day (OK, maybe not BRIGHTEN…) […]
Using index/match/match to locate a value in a grid
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 generally don’t eat it on its own – it’s […]
Some lesser known charts in Excel – Treemap and Funnel
Excel has really upped its games around charts in the last couple of editions but there are some charts that are not so well known. In this blog post I am going to introduce you to two of them: The Tree Map and the funnel. You can use this file to practise on and here […]
The Power of Powerpivot | Excel’s new free plug-in to help you work with large amounts of data
Well, this week I’m going to write specifically about Powerpivot. Powerpivot is the new free add-in you can download free for Excel 2010 and later. However Powerpivot has a diva side – it’s been known to flounce off in a huff and only return when you coax it with a Repair via the Control Panel […]