Please note javascript is required for full website functionality.
MVP

Blog

Blog

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.


Power Query: Linking Up

26 December 2018

Welcome to our Power Query blog. This week, I look at how to view links in a webpage.


A to Z of Excel Functions: the EOMONTH Function

25 December 2018

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


Season's Greetings and Happy New Year

25 December 2018

It’s been a big year at SumProduct HQ in 2018.


A to Z of Excel Functions: the ENCODEURL Function

24 December 2018

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


VBA Blog: Going Through the Visual Basics – Part 17

21 December 2018

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 has a lot to DO this time.


Power BI: Row Level Security

20 December 2018

Welcome to the last Power BI article of the year! This week, we’re going to look at Row Level Security, as a topic that has come up quite a bit in recent enquiries.


Power Query: Update with Caution

19 December 2018

Welcome to our Power Query blog. This week, I look at how to update data in an SQL database.


Power Pivot Principles: Lookups in Power Pivot

18 December 2018

Welcome back to our Power Pivot blog. Today, we discuss how to create lookups in Power Pivot.


Newsletter