Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Pivot Principles: Dynamic Ranges and Periods for Rolling Averages

20 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 period selection range in a rolling average measure.


A to Z of Excel Functions: the FORECAST Function

19 August 2019

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


VBA Blog: Dynamically highlight entire row and column

16 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 Transform - Split Column by Positions

15 August 2019

Welcome back to this week’s Power BI blog series. This week, we are going to look at a new transformation in Power BI: split column by positions.


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.


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

12 August 2019

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


VBA Blog: 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.


Newsletter