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.

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

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

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

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

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

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.

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.

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

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