Please note javascript is required for full website functionality.

Blog

A to Z of Excel Functions: The BYROW Function

11 August 2021

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the BYROW function.


Power Query: Rental Wrangles Receipts - Part 1

11 August 2021

Welcome to our Power Query blog. This week, I look at an example where I need to transform my data before I can apply a function.


A to Z of Excel Functions: The BYCOL Function

10 August 2021

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the BYCOL function.


Power Pivot Principles: The A to Z of DAX Functions – ALLEXCEPT

10 August 2021

In our long-established Power Pivot Principles articles, we are starting a new series on the A to Z of Data Analysis eXpression (DAX) functions. This week we look at ALLEXCEPT…


A to Z of Excel Functions: The ISREF Function

9 August 2021

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the ISREF function.


Charts and Dashboards: Problem Solving with Pareto Charts

6 August 2021

Welcome back to our Charts and Dashboards blog series. This week, I look at a Pareto chart.


Power BI Blog: Access-ible Returns Part 2

5 August 2021

Welcome back to this week’s edition of the Power BI blog series. This week, we continue our Access-ible series of Blogs.


Power Query: Refined Rental Wrangles

4 August 2021

Welcome to our Power Query blog. This week, I look at creating a function to get data from a table.


Power Pivot Principles: The A to Z of DAX Functions – ALL

3 August 2021

In our long-established Power Pivot Principles articles, we are starting a new series on the A to Z of Data Analysis eXpression (DAX) functions. This week this function is ALL we can talk about!


Monday Morning Mulling: July 2021 Challenge

2 August 2021

On the final Friday of each month, we set an Excel / Power Pivot / Power Query / Power BI problem for you to puzzle over for the weekend. On the Monday, we publish a solution. If you think there is an alternative answer, feel free to email us. We’ll feel free to ignore you.


Newsletter