Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Query: Example Grading

4 September 2019

Welcome to our Power Query blog. Today, I use Column From Examples to help me put my data into grade boundaries.


Power Pivot Principles: Introducing the EARLIER Function

3 September 2019

Welcome back to our Power Pivot blog. Today, we look at the EARLIER function.


Monday Morning Mulling: August 2019 Challenge

2 September 2019

On the final Friday of each month, we set a Power BI or Excel 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.


Final Friday Fix: August 2019 Challenge

30 August 2019

On the final Friday of each month, we’re going to set an Excel / Power BI challenge for you to puzzle over so that you can get your “Excel / Power BI fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There’s no prizes at this stage,...


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 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.


Newsletter