Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Query: Words are Key

29 August 2018

Welcome to our Power Query blog. Last week’s blog looked at how to use list functionality to translate numerical grades into their letter equivalents. This week, I use another List() function to look for multiple keywords in columns of data.


Power Pivot Principles: Calendar Table

28 August 2018

Welcome back to our Power Pivot blog. Today, we discuss the steps we should take when creating a Calendar Table.


A to Z of Excel Functions: the DMIN Function

27 August 2018

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


VBA Blog: Going Through the Visual Basics – Part 4

24 August 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 the basic principles of VBA.


Power BI: Conditional Formatting Improvements

23 August 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: Upgrades

22 August 2018

Welcome to our Power Query blog. This week, I take a final look at an example where I need to translate numbers to letters in multiple columns, this time using the M function List.ReplaceMatchingItems() and matching those items using values from another table.


Power Pivot Principles: Filters Revisited

21 August 2018

Welcome back to our Power Pivot blog. Today, we discuss another way to use Filters in Power Pivot.


A to Z of Excel Functions: the DMAX Function

20 August 2018

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


VBA Blog: Going Through the Visual Basics – Part 3

17 August 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 actually recording a macro.


Power BI: Quality of Life Improvements 2

16 August 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