Please note javascript is required for full website functionality.
MVP

Blog

Blog

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: 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’.


Power Query: Today’s Calendar

22 May 2019

 

Welcome to our Power Query blog. Today, I am going to look at how to use the calendar table to filter on the current day.


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.


Newsletter