Please note javascript is required for full website functionality.
MVP

Blog

Blog

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.


Power Query: Trying to Extract Errors

5 December 2018

Welcome to our Power Query blog. This week, I look at how to view the errors for each row.


Power Pivot Principles: Concatenating Filters

4 December 2018

Welcome back to our Power Pivot blog. Today, we look at using concatenation with the FILTER function to combine filter criteria.


Monday Morning Mulling: November 2018 Challenge

3 December 2018

Last week, we posed a challenging question – given a large table of data, how can we create a set of data validated cells that would automatically update when you select a particular item in the previous cell?


Final Friday Fix: November 2018 Challenge

30 November 2018

Welcome back to the Final Friday Fix! This month, we are going to draw inspiration from the Excel team’s Ask Me Anything session earlier this month and look to Reddit to find a challenging question. (No cheating by going there to look for the answer!)


Power BI: Power BI Gateway

29 November 2018

Welcome back to our Power BI blog series! This week, we’re going to finish the process of automatically refreshing data, using the Power BI Gateway.


Newsletter