Please note javascript is required for full website functionality.
MVP

Blog

Blog

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.


VBA Blog: Going Through the Visual Basics – Part 16

14 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 going FOR it.


Power BI: New Course Development

13 December 2018

Welcome to this week's Power BI blog! This week is less about showing you tips and tricks, but asking you what tips and tricks you'd like to see!


Power Query: Skip to the Good Part

12 December 2018

Welcome to our Power Query blog. This week, I look at how to remove a random number of rows before useful data.


Power Pivot Principles: How to Combine Three or More Filter Criteria into One CALCULATE Measure

11 December 2018

Welcome back to our Power Pivot blog. Today, we dive a little deeper into the IN function.


A to Z of Excel Functions: the EDATE Function

10 December 2018

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


VBA Blog: Going Through the Visual Basics – Part 15

7 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 takes a WHILE to get going...


Power BI: Get Data from PDFs

6 December 2018

Welcome to this week’s Power BI blog. Today, we’re going to look at the new preview feature, Get Data from PDFs.


Newsletter