Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Query: Joining Grades

15 August 2018

Welcome to our Power Query blog. This week, I look at last week’s problem again, but this time I translate numbers to letters in multiple columns by joining tables.


Power Pivot Principles: Disconnected Tables and Exchange Rates

14 August 2018

Welcome back to our Power Pivot blog. Today, we discuss why disconnected tables may be useful in Power Pivot.


A to Z of Excel Functions: the DISC Function

13 August 2018

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


VBA Blog: Going Through the Visual Basics – Part 2

10 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 second part looks at how to record a macro.


Power BI: Quality of Life Improvements

9 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: Upgrading Grades

8 August 2018

Welcome to our Power Query blog. This week, I look at an example where I need to translate numbers to letters in multiple columns using the M function List.ReplaceMatchingItems().


Power Pivot Principles: Calculating with Other Tables

7 August 2018

Welcome back to our Power Pivot blog. Today, we discuss how the CALCULATE function can benefit from connected tables.


A to Z of Excel Functions: the DGET Function

6 August 2018

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


VBA Blog: Going Through the Visual Basics – Part 1

3 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 first part starts with the most basic of Visual Basics


Power BI: Upgraded Quick Insights

2 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