Fall in Like with Excel - one cell at a time

Here you can read my blogs and video tutorials covering all aspects of using Excel. If you are looking for a specific topic, use the search bar below to find the relevant blog post.

Tracking Training Records in Excel

Getting totals for training fund applications

14 February 2024
I was recently working with a woman in a large organization around tracking training funding applications and she needed to be able to do
Continue reading

Colour code your training dates

7 June 2021
This blog post shows you how to colour code your training records. It helps you identify who is current, who is due for renewal
Continue reading

How to create a training roster in Excel .

27 September 2023
A while back I had a message from a colleague. She had got a training contract but she wanted to track it on Excel.
Continue reading

Pivot Tables

How to colour code your pivot table with Conditional Formatting

12 February 2024
In this tutorial I want to show you how to apply Conditional Formatting to your pivot table. It is a quick and easy way
Continue reading

06 – Pivot Tables – How to show % breakdown with Show Values As

7 February 2024
Another one in the pivot table series. In this one I show you how to use the Show Values As feature to show %
Continue reading

05 – Pivot table – Grouping my data by dates and in bins (grouping in quantities)

7 February 2024
In this tutorial what I want to show you how to group your dates together. Excel usually does this automatically in later versions. It
Continue reading

Case Studies - How to

How to create a data model in PowerBI with multiple tables from a single Excel file

9 October 2023
One of the issues I have noticed coming up with learners after PowerBI training is that when they go back to their desks, they
Continue reading

Learn how to go about creating a dashboard to show Top Ten Sales and Bottom Ten Sales by Country in 7 steps

10 August 2023
In this blog post I walk you through creating a dashboard to show the Top Ten and Bottom Ten sales from a set of
Continue reading

Getting totals for training fund applications

14 February 2024
I was recently working with a woman in a large organization around tracking training funding applications and she needed to be able to do
Continue reading

Excel Path - Step by Step

How to link files and change the file

3 August 2023
How to link external files into an Excel file and then change if required A common requirement is to pull data from one Excel
Continue reading

02 – Recommended Pivot Tables and Analyze data – Let Excel help you get started

7 February 2024
One of the most common questions I get asked in class about pivot tables is “Well, how do I know what goes where?” .
Continue reading

Some lesser known charts in Excel – Treemap and Funnel

22 February 2022
Excel has really upped its games around charts in the last couple of editions but there are some charts that are not so well
Continue reading

Excel - General

How to do an Xlookup in Excel

20 May 2024
If you have Office 365 and you need to use the Vlookup() function, you should really consider using the Xlookup function, which I like
Continue reading

How to check for duplicates across worksheets – using Power Query Append

2 March 2023
This blog post was inspired by a recent dilemma. My wonderful VA – Zita Lewis – who helps ensure that all my course participants
Continue reading

How to use removed unwanted spaces with Power Query – AKA Trim

2 March 2023
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
Continue reading

Random

10 – 10 tips to help you work faster in Excel

27 September 2023
Table it! If you have large data sets, convert them to a table. This means that if you scroll down to the bottom, the
Continue reading

5 ideas to help with your Excel learning plan – “September is the new January”

15 August 2017
September can be described as the new January and it’s often a time when people decide to start something new or get stuck into
Continue reading

Guest Post: “The Facebook of Business: Why Excel Isn’t Going Away Anytime Soon.” by George Mount

30 June 2016
The Facebook of Business: Why Excel Isn’t Going Away Anytime Soon. George J. Mount blogs about Microsoft Excel, business analytics, and other tips for
Continue reading

Personal

Reflecting on 2022 – Failures & Disappointments, what went well and lessons learned.

2 March 2023
Failures and disappointments.. I have tried for the last couple of years to really lose weight – I have failed dismally. After two years
Continue reading

What I learned from the 2022 Tour de France

2 March 2023
For the last couple of years I have gone into Low Power Mode for the Tour de France – which is three weeks in
Continue reading

Naomi Osaka and why her experience has so much resonance

14 June 2021
You have probably heard about Naomi Osaka’s  withdrawal from the French Open based on her refusal to do press conferences. I think it’s an
Continue reading

Tracking Training Records in Excel

Getting totals for training fund applications

14 February 2024
I was recently working with a woman in a large organization around tracking training funding applications and she needed to be able to do
Continue reading

Colour code your training dates

7 June 2021
This blog post shows you how to colour code your training records. It helps you identify who is current, who is due for renewal
Continue reading

How to create a training roster in Excel .

27 September 2023
A while back I had a message from a colleague. She had got a training contract but she wanted to track it on Excel.
Continue reading

Excel Path – Step by Step

How to link files and change the file

3 August 2023
How to link external files into an Excel file and then change if required A common requirement is to pull data from one Excel
Continue reading

02 – Recommended Pivot Tables and Analyze data – Let Excel help you get started

7 February 2024
One of the most common questions I get asked in class about pivot tables is “Well, how do I know what goes where?” .
Continue reading

Some lesser known charts in Excel – Treemap and Funnel

22 February 2022
Excel has really upped its games around charts in the last couple of editions but there are some charts that are not so well
Continue reading

Case Studies - How to

How to create a data model in PowerBI with multiple tables from a single Excel file

9 October 2023
One of the issues I have noticed coming up with learners after PowerBI training is that when they go back to their desks, they
Continue reading

Learn how to go about creating a dashboard to show Top Ten Sales and Bottom Ten Sales by Country in 7 steps

10 August 2023
In this blog post I walk you through creating a dashboard to show the Top Ten and Bottom Ten sales from a set of
Continue reading

Getting totals for training fund applications

14 February 2024
I was recently working with a woman in a large organization around tracking training funding applications and she needed to be able to do
Continue reading

Excel - General

How to do an Xlookup in Excel

20 May 2024
If you have Office 365 and you need to use the Vlookup() function, you should really consider using the Xlookup function, which I like
Continue reading

How to check for duplicates across worksheets – using Power Query Append

2 March 2023
This blog post was inspired by a recent dilemma. My wonderful VA – Zita Lewis – who helps ensure that all my course participants
Continue reading

How to use removed unwanted spaces with Power Query – AKA Trim

2 March 2023
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
Continue reading

Pivot Tables

How to colour code your pivot table with Conditional Formatting

12 February 2024
In this tutorial I want to show you how to apply Conditional Formatting to your pivot table. It is a quick and easy way
Continue reading

06 – Pivot Tables – How to show % breakdown with Show Values As

7 February 2024
Another one in the pivot table series. In this one I show you how to use the Show Values As feature to show %
Continue reading

05 – Pivot table – Grouping my data by dates and in bins (grouping in quantities)

7 February 2024
In this tutorial what I want to show you how to group your dates together. Excel usually does this automatically in later versions. It
Continue reading

Personal

Reflecting on 2022 – Failures & Disappointments, what went well and lessons learned.

2 March 2023
Failures and disappointments.. I have tried for the last couple of years to really lose weight – I have failed dismally. After two years
Continue reading

What I learned from the 2022 Tour de France

2 March 2023
For the last couple of years I have gone into Low Power Mode for the Tour de France – which is three weeks in
Continue reading

Naomi Osaka and why her experience has so much resonance

14 June 2021
You have probably heard about Naomi Osaka’s  withdrawal from the French Open based on her refusal to do press conferences. I think it’s an
Continue reading

Random

10 – 10 tips to help you work faster in Excel

27 September 2023
Table it! If you have large data sets, convert them to a table. This means that if you scroll down to the bottom, the
Continue reading

5 ideas to help with your Excel learning plan – “September is the new January”

15 August 2017
September can be described as the new January and it’s often a time when people decide to start something new or get stuck into
Continue reading

Guest Post: “The Facebook of Business: Why Excel Isn’t Going Away Anytime Soon.” by George Mount

30 June 2016
The Facebook of Business: Why Excel Isn’t Going Away Anytime Soon. George J. Mount blogs about Microsoft Excel, business analytics, and other tips for
Continue reading