Please note javascript is required for full website functionality.
MVP

Blog

Blog

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.


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


Power Query: Absolutely Fabulous

1 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: MAXX with Filter Criteria

30 April 2019

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


Newsletter