Please note javascript is required for full website functionality.
MVP

Blog

Blog

Final Friday Fix: July 2019 Challenge

26 July 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: Floor Plan

25 July 2019

Welcome back to this week’s Power BI blog series. This week, we are as far removed from financial modelling as we’ll ever be: we’re going to create a floor plan.


Power Query: Combining Forces

24 July 2019

Welcome to our Power Query blog. Today, I look at a way to reduce overheads when combining numerous files.


Power Pivot Principles: Dynamic Ranking based on Selection Filters

23 July 2019

Welcome back to our Power Pivot blog. Today, we show you how to create a dynamic ranking measure that changes based on selection filters.


A to Z of Excel Functions: the FLOOR Function

22 July 2019

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


Power BI Blog: Mekko Chart (cont'd)

18 July 2019

Welcome back to this week’s Power BI blog series. This week, we continue with Mekko Chart.


Power Query: Inquiring Minds

17 July 2019

Welcome to our Power Query blog. In a plot twist, today’s blog is about how Excel can make Power Query data easier to handle.


Power Pivot Principles: Introducing the RANKX Function

16 July 2019

Welcome back to our Power Pivot blog. Today, we show you how use set up slicers to dynamically segregate text data based on text inputs.


A to Z of Excel Functions: the FIXED Function

15 July 2019

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


A to Z of Excel Functions: the FISHERINV Function

12 July 2019

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


Newsletter