Please note javascript is required for full website functionality.

Blog

Power BI Blog: Power KPI

29 August 2019

Welcome back to this week’s Power BI blog series. This week, we are going to look at the Key Performance Indicator (KPI) visual.


Power Query: Unique Combination

28 August 2019

Welcome to our Power Query blog. Today, I look at a way to create a set of data from multiple tables.


Power Pivot Principles: Highlighting Absent Students

27 August 2019

Welcome back to our Power Pivot blog. Today, we look at how to create a PivotChart that highlights the number of absent students in university classes.


A to Z of Excel Functions: The FORECAST.ETS Function

26 August 2019

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


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


Newsletter