February 18, 2021
Sort-By Columns in Power BI
Normal sorting behaviour is to sort based on a numeric value, either higher to lower or lower to higher. But
Read More
February 11, 2021
Excel Pyramid Charts
Excel pyramid charts are easy to build using bar charts or Conditional Formatting, but there are a few rules you
Read More
February 4, 2021
Personal Stock Portfolio Dashboard
Keeping track of your share trading is easy with this personal stock portfolio dashboard. It uses the latest Excel tools*
Read More
January 28, 2021
Custom Formatting Strings in Power BI
You may be familiar with Custom Format Strings in Excel, if you are not then check this Excel Custom Number
Read More
January 21, 2021
Highlighting Periods in Excel Charts
Shading or highlighting periods in Excel charts can help users more quickly interpret them and identify patterns. In the chart
Read More
January 14, 2021
Table Statistics from Table.Profile in Power Query
It's often useful to know some quick statistics about our data. Things like the minimum or maximum values, or the
Read More
December 16, 2020
Changing Data Source Location in Power Query
Here's the scenario - you've created a query in Power Query that loads data from a source, either a file
Read More
December 10, 2020
Stacked Bar Excel Waffle Charts
Last week we looked at building Excel waffle charts using Conditional Formatting. This week we’re looking at building Stacked Bar
Read More
December 3, 2020
Excel Waffle Charts with Conditional Formatting
Excel Waffle Charts are a popular way to visually display parts to a whole. You can think of them as
Read More
November 24, 2020
Dense Ranking in Power Query
There are several ways to rank things, dense ranking is when items that compare equally receive the same ranking number,
Read More
November 19, 2020
Force Excel Slicers to Single Select
There’s no built-in way we can force Excel Slicers to single select, but we can use some crafty tricks to
Read More
November 10, 2020
Excel Dashboards vs Power BI Dashboards
One of the most common questions I get is: Should I be using Power BI to build dashboards instead of
Read More
November 3, 2020
How to Build Power BI Dashboards
Demand for data visualisation skills is showing no signs of slowing. There are many BI tools available, and this can
Read More
October 29, 2020
Create a List of Matching Words When Searching Text in Power Query
My previous post searched for text in columns and returned a true/false result if a match was found. This post
Read More
October 22, 2020
Searching for Text Strings in Power Query
Let's say we have a column of text and we want to search it to see if each row contains
Read More
October 15, 2020
Introduction to Power Query
What’s the big deal about Power Query? Talk to those who have used it and they’ll tell you how amazing
Read More
October 7, 2020
Grouped Running Totals in Power Query
In a previous post I looked at creating running totals in Power Query, here I'll be creating grouped running totals.
Read More
October 1, 2020
Power Query Custom Data Types
You may already be familiar with Excel Data Types for geography and stocks, but with Power Query Custom Data types
Read More
September 24, 2020
Quickly Create Running Totals in Power Query
A running total (or cumulative sum) is when you add the previous value to the next, basically you're summing values
Read More
September 17, 2020
Excel Custom Number Format Conditions
Custom number format conditions allow you to specify a different format based on the size of a number. In this
Read More
September 3, 2020
Power Query Custom Functions
If you're familiar with using Excel functions (and of course you should be) then you'll know that a function typically
Read More
August 27, 2020
Import Data from a Picture to Excel Mobile
A new feature in the Excel mobile app (iPhone and Android) is the ability to take a photo of your
Read More
August 20, 2020
Display All Matches from Search in Userform ListBox
I've previously described how to use a form to search for a distinct value, like a unique ID. This time
Read More
August 13, 2020
Import Data from a PDF to Excel
Office 365/Microsoft 365 users can now import data from a PDF to Excel using Power Query*. It’s super handy for
Read More
August 11, 2020
Plan v Actual Excel Dashboard
Reporting on plan v actual variances can be a very dry topic and often the audience for these reports are
Read More
August 6, 2020
Connecting to an OAuth API Like PayPal With Power Query
My previous post on using Power Query to access API's looked at API's that required either basic or no authorization.
Read More
July 30, 2020
Excel PivotTable Profit and Loss
Creating an Excel PivotTable Profit and Loss statement is surprisingly easy. And because it’s a PivotTable you can team it
Read More
July 23, 2020
Getting Started with API’s in Power Query
An Application Programming Interface (API) allows a program to retrieve data from a system. A 'program' could be something written
Read More
July 16, 2020
Dynamically List Excel Sheet Names
Navigating workbooks with lots of sheets can be tedious. In this tutorial I’m going to show you how to dynamically
Read More
July 9, 2020
Label Specific Excel Chart Axis Dates
When you have data that spans a long period of time that you want to plot in a chart, the
Read More