Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Query: Erasing Errors

26 September 2018

Welcome to our Power Query blog. This week, I look at how to deal with imported errors.


Power Pivot Principles: How to Refresh Data in Power Pivot

25 September 2018

Welcome back to our Power Pivot blog. Today, we go over how to refresh data in Power Pivot.


A to Z of Excel Functions: the DOLLARFR Function

24 September 2018

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


VBA Blog: Going Through the Visual Basics – Part 7

21 September 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 looks at declaring variables.


Power BI: Q&A Row Level Security

20 September 2018

As we promised in our recent newsletter, we’ll be spending the next couple of months talking about some of the new Power BI features that are being rolled out.


Power Query: 10 Top Tips

19 September 2018

Welcome to our Power Query blog. This week, I take a look at some tips to help get the best out of Power Query.


Power Pivot Principles: Introducing the TOTALYTD Function

18 September 2018

Welcome back to our Power Pivot blog. Today, we introduce another time intelligence function.


A to Z of Excel Functions: the DOLLARDE Function

17 September 2018

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


VBA Blog: Going Through the Visual Basics – Part 6

14 September 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 looks at running a macro.


Power BI: Q&A Power BI Desktop

13 September 2018

As we promised in our recent newsletter, we’ll be spending the next couple of months talking about some of the new Power BI features that are being rolled out.


Newsletter