by admin | Mar 15, 2021 | Case Studies - How To
In this blog post I want to walk you through the creation of a dashboard in Excel. We will be using Slicers, dropdown lists, pivot tables and the lesser known function – GetPivotData. Oh and we might throw in a chart or two and traffic lights for extra...
by admin | Mar 8, 2021 | Excel Path - Step by Step
Ah, yes that joyful scenario. You have a list – a great big juicy list and you want to scroll down that list but oh no my headings have disappeared…WHAT DO I DOOOOO? Well I *have* heard of people who have sellotaped the headings onto their...
by admin | Mar 1, 2021 | Case Studies - How To
Like many of my blog posts this came from a request from an attendee at one of my classes. She wanted to get a better understanding of how to clean up unwanted spaces in Excel – that’s the Trim() function. She also wanted to learn how to combine multiple...
by admin | Feb 22, 2021 | Excel Path - Step by Step
The secret – usually forgotten sauce to creating charts in Excel is to make sure your data is properly organised – no blank rows, no blank columns and you need to go all – what I call – Judge Judy on it – “The data, all the data and...
by admin | Feb 15, 2021 | Case Studies - How To
One of my main sources for these blog posts are questions I get from my subscribers and class participants. Recently I had one of my participants ask for help. He had applied conditional formatting to numbers – the idea would be that if the number was greater...
