Please note javascript is required for full website functionality.

Blog

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


Power Pivot Principles: Introducing the MEDIAN Function

7 May 2019

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


A to Z of Excel Functions: The FACTDOUBLE Function

6 May 2019

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


VBA Blogs: Common Traps 4

3 May 2019

Welcome back to the VBA blog series! We’re going to continue with last month’s blog theme, focusing on common errors and issues that people run into.


Power BI Blog: Get Data from Exchange

2 May 2019

Welcome back to this week’s Power BI blog series! This week, we’re going to look at how to get data from Microsoft Exchange.


Newsletter