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 | Apr 2, 2022 | Case Studies - How To
I was recently working with a woman who needed to track monthly stats for appointments and attendance but also was tasked with the job of creating a dashboard to show the following: In this four part case study, I am going to walk you through the process from original...
by admin | Mar 28, 2022 | Case Studies - How To
In this video I explore how to use Xlookup() with the table facility to copy an entry across. You can download the completed file here. You can view the video here.
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...
