Please note javascript is required for full website functionality.

Blog

Power Query: Fuzzy Matching

5 June 2019

Welcome to our Power Query blog. Today, I am going heading off into Power BI for a feature I’d like to see more of in Excel Power Query.


Power Pivot Principles: Introducing the CONCATENATE Function

4 June 2019

Welcome back to our Power Pivot blog. Today, we introduce the CONCATENATE function.


Challenges: Monday Morning Mulling: May 2019 Challenge

3 June 2019

On the final Friday of each month, we set an 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.


Challenges: Final Friday Fix: May 2019 Challenge

31 May 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 bragging rights only!


Power BI Blog: Performance Analyzer

30 May 2019

Welcome back to this week’s Power BI blog series! This week, we’re going to look at a new feature called Performance Analyzer.


Power Query: Check Today’s Calendar

29 May 2019

Welcome to our Power Query blog. Today, I am going to look at an example which uses a calendar table to filter on today’s date.


Power Pivot Principles: Introducing the NOT Function

28 May 2019

Welcome back to our Power Pivot blog. Today, we introduce the NOT function.


A to Z of Excel Functions: The FILTERXML Function

27 May 2019

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


A to Z of Excel Functions: The FILTER Function

24 May 2019

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


Power BI Blog: Restaurant Selector

23 May 2019

Welcome back to this week’s Power BI blog series! This week, we’re going to look at cleaning up the data we brought in last week from ‘New web table from inference’.


Newsletter