Please note javascript is required for full website functionality.

Blog

Challenges: Final Friday Fix: February 2019 Challenge

22 February 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 Blog: Key Influencers Top Segments

21 February 2019

Welcome back to the Power BI blog. This time, we’re going to be talking about the other part of the Key Influencers visual: the Top Segments.


Power Query: File Away

20 February 2019

Welcome to our Power Query blog. This week I look at some of the M functionality for dealing with files.


Power Pivot Principles: Introducing the SUMX function

19 February 2019

Welcome back to our Power Pivot blog. Today, we discuss the SUMX function.


A to Z of Excel Functions: The EXPON.DIST Function

18 February 2019

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


VBA Blogs: Selecting Case By Case

15 February 2019

This month, we’re talking about the Select Case statement in VBA. We had a question from a client that we thought we’d take the opportunity to answer here.


Power BI Blog: Key Influencers

14 February 2019

This week in Power BI, we’re going to look at a brand new feature that’s just been released, called “Key Influencers”.


Power Query: Zoned Out

13 February 2019

Welcome to our Power Query blog. Last week’s blog looked at solving a particular problem by using DateTime.AddZone(). This week, I look at some of the M functionality for dealing with time zones.


Power Pivot Principles: Revisiting the SUM function

12 February 2019

Welcome back to our Power Pivot blog. Today, we discuss the SUM function.


A to Z of Excel Functions: The EXP Function

11 February 2019

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


Newsletter