Please note javascript is required for full website functionality.

Blog

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.


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 EOMONTH Function

25 December 2018

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


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


A to Z of Excel Functions: The EFFECT Function

17 December 2018

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


Newsletter