Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Query: Skipping Lists

9 January 2019

Welcome to our Power Query blog. This week I look at M functions List.Skip() and List.Alternate().


Power Pivot Principles: When the CALCULATE Function Misbehaves.

8 January 2019

Welcome back to our Power Pivot blog. Today, we discuss how to stop the CALCULATE function from overwriting row filters.


A to Z of Excel Functions: the ERFC.PRECISE Function

7 January 2019

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


VBA Blog: Going Through the Visual Basics – Part 18

4 January 2019

We thought we’d run an elementary series going through the rudiments of Visual Basic for Applications (VBA) as a springboard for newer users. This blog marks the Event-ful end of this series…


A to Z of Excel Functions: the ERFC Function

3 January 2019

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


Power Query: Seeing JSON

2 January 2019

Welcome to our Power Query blog. This week, I look at how to view a complex JSON record.


A to Z of Excel Functions: the ERF.PRECISE Function

1 January 2019

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


Monday Morning Mulling: December 2018 Challenge

31 December 2018

It’s the last day of 2018! A perfect time to take a look at the answer to a question that seems quite easy, but is difficult to do elegantly.


Final Friday Fix: December 2018 Challenge

28 December 2018

Welcome to the December Final Friday Fix! It clearly appears that we’ve been doing more training and less consulting work as the year comes to a close, as our challenge problem has again been inspired from a question on Reddit.


A to Z of Excel Functions: the ERF Function

27 December 2018

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


Newsletter