Please note javascript is required for full website functionality.
MVP

Blog

Blog

Monday Morning Mulling: April 2019 Challenge

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


Final Friday Fix: April 2019 Challenge

26 April 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: Key Influencers - Continuous Variables

25 April 2019

Welcome back to the Power BI blog series! This week, we’re going to talk about some new updates to the Key Influencers visualisation.


Power Query: Exceptional Cases

24 April 2019

Welcome to our Power Query blog. Today, I am going to look at how to protect specific data when transforming text case.


Power Pivot Principles: MAXX

23 April 2019

Welcome back to our Power Pivot blog. Today, we discuss how to use the MAXX function.


A to Z of Excel Functions: the FACT Function

22 April 2019

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


VBA Blog: Common Traps 3

19 April 2019

Welcome to this week’s VBA blog! In line with previous months, we’re going to keep this month’s blogs on a theme, and this month’s theme is all about common errors and issues that people run into.


Power BI: Data Profiling Generally Available

18 April 2019

Welcome back to the Power BI blog series! This week, we’re going to look at a tool that we’ve covered before, but is now generally available and has some neat improvements.


Power Query - Files for Today

17 April 2019

Welcome to our Power Query blog. Today, I am going to select files using the date embedded in the file name.


Power Pivot Principles: Conditional Custom Columns with Four Categories

16 April 2019

Welcome back to our Power Pivot blog. Today, we discuss how to create conditional custom columns using the AND ‘&&’ and OR ‘||’ operators together.


Newsletter