by admin | Nov 16, 2022 | Excel | General
This blog post was inspired by a recent dilemma. My wonderful VA – Zita Lewis – who helps ensure that all my course participants get what they need when they need it and quite frankly has much better attention to detail than I have 🙂 had got a list of...
by admin | Nov 10, 2022 | Excel | General
Power Query (AKA Get and Tranform) is Excel’s amazing data cleansing tool. You can use it to remove unwanted spaces in your data but I have noticed that sometimes it doesn’t remove everything that you would expect. This video shows you a technique you can...
by admin | May 14, 2022 | Excel | General
One issue that can come up in adding up lists with subtotals and hidden rows is that the usual sum() will exclude hidden rows from your calculations. Equally if you have subtotals – you often don’t want those included in your calculations… So...
by admin | May 2, 2022 | Excel | General
I was recently asked in a class by a participant who needed to find a way to identify the top three performers in a group. What she wanted to see was the total of their current top three scores. In order to do that I used the Large() function. Then I used Conditional...
by admin | Apr 14, 2022 | Excel | General
This is going to be a longer post. I’ve broken down the final creation into a number of pieces. In this first part – you can see how I start the dashboard by applying background colour and borders, creating a dropdown list and starting my calculations. You...
by admin | Apr 14, 2022 | Excel | General
You can view Part One , Part Two and Part Three of this series. In this video, we are going to look at how to summarize our year to date (YTD) numbers. We are using the Iferror() and Indirect() functions to pull in the data from the matching sheets. You can download...
