Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Pivot Principles: Introducing the SWITCH Function

21 May 2019

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


A to Z of Excel Functions: the FIELDVALUE Function

20 May 2019

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


A to Z of Excel Functions: the FDIST Function

17 May 2019

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


Power BI: New Web Table from Inference

16 May 2019

Welcome back to this week’s Power BI blog series! This week, we’re going to look at the new Preview Feature ‘New web table from inference’


Power Query: Fascinating Filters

15 May 2019

Welcome to our Power Query blog. Today, I am going to look at how Power Query turns a tricky transformation into a simple task.


Power Pivot Principles: Introducing the MEDIANX Function

14 May 2019

Welcome back to our Power Pivot blog. Today, we look at the MEDIANX function.


A to Z of Excel Functions: the FALSE Function

13 May 2019

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


VBA Blog: Referring to Sheets

10 May 2019

Welcome back to the VBA blog! Last week, we looked at how referencing sheets can be fraught with peril in the event that sheet names change, and we showed how you can use the VBA sheet name to avoid that issue.


Power BI Blog: Waterfall Charts

9 May 2019

Welcome back to this week’s Power BI blog series! This week, we’re going to look at how to create Waterfall charts.


Power Query: Divide and Conquer

8 May 2019

Welcome to our Power Query blog. Today, I am going to look at a method to extract multiple columns from a single column of mixed data.


Newsletter