Please note javascript is required for full website functionality.

Blog

Power Query: That Makes (Intelli)sense

14 August 2019

Welcome to our Power Query blog. Today, I look at the Intellisense features available in Power BI’s Power Query (Get Data).


Power Pivot Principles: Dynamic Ranges for Rolling Averages

13 August 2019

Welcome back to our Power Pivot blog. Today, we expand on the rolling average concept first introduced in a previous blog and show you how to include a dynamic selection range to a rolling average measure.


VBA Blogs: Dynamically Highlight the Row

9 August 2019

Welcome back to the VBA blog! This week we are going to expand our learning of how to highlight selected cells in a worksheet from last week.


Power BI Blog: New Filters Pane

8 August 2019

Welcome to this week’s Power BI blog series. This week, we’re going to look at Power BI Desktop’s new Filters pane.


Power Query: Step Back and See

7 August 2019

Welcome to our Power Query blog. Today, I build a function to add a column to a table.


Power Pivot Principles: Introducing the LASTDATE Function

6 August 2019

Welcome back to our Power Pivot blog. Today, we show you how the LASTDATE function work.


A to Z of Excel Functions: The FLOOR.MATH Function

5 August 2019

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


A to Z of Excel Functions: The FLOOR.PRECISE Function

5 August 2019

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


VBA Blogs: Group Specific Rows

2 August 2019

Welcome back to the VBA blog! This week we are going to learn how to group specific rows by using VBA.


Power BI Blog: Excel Summit South 2019

1 August 2019

Hello there! We thought we’d take a break from our regular tips and tricks and thought we’d let you know we’re presenting at the Excel Summit South 2019 in Sydney…


Newsletter