Please note javascript is required for full website functionality.
MVP

Blog

Blog

VBA Blog: Dynamically Highlight the Entire Row and Column by Using VBA Script

23 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’s article.


Power BI Blog: Real-time Forms to Dashboard

22 August 2019

Welcome back to this week’s Power BI blog series. This week, we are going to create an example of a real-time dashboard.


Power Query: Name or Number

21 August 2019

Welcome to our Power Query blog. Today, I look at an example where renaming a column is performed by column position.


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.


Newsletter