Please note javascript is required for full website functionality.
MVP

Blog

Blog

Final Friday Fix: January 2019 Challenge

25 January 2019

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


Power BI: Microsoft Teams

24 January 2019

This week, we’re going to divert a little bit away from Power BI directly, and talk about how it can integrate into Microsoft Teams. This is the central part of what Tim’s presentation in Singapore last week was all about. We’ll spread this over the next few...


Power Query: Select a Number

23 January 2019

Welcome to our Power Query blog. This week, I look at extracting a number from a mixed column.


Power Pivot Principles: Variables in DAX

22 January 2019

Welcome back to our Power Pivot blog. Today, we discuss how to use variables in DAX.


A to Z of Excel Functions: the EVEN Function

21 January 2019

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


A to Z of Excel Functions: the EUROCONVERT Function

18 January 2019

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


Power BI: Microsoft Ignite | The Tour Singapore

17 January 2019

This week, there are no new tips and tricks, but that’s because we’re presenting at Microsoft Ignite – The Tour over in Singapore!


Power Query: A Join I Made Earlier

16 January 2019

Welcome to our Power Query blog. This week, I look at a neat way of linking tables with similar key data.


Power Pivot Principles: KEEPFILTERS to the Rescue

15 January 2019

Welcome back to our Power Pivot blog. Today, we discuss an alternate way to keep the CALCULATE function from misbehaving.


The ERROR.TYPE Function

14 January 2019

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


Newsletter