Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Query: Portable Document Format

18 September 2019

Welcome to our Power Query blog. Today, I head off to Power Query in Power BI to look at extracting data from PDF files.


Power Pivot Principles: Calculating Cumulative Totals with Variables

17 September 2019

Welcome back to our Power Pivot blog. Today, we look at an alternative method of calculating cumulative sums without using the EARLIER function.


A to Z of Excel Functions: the FORECAST.ETS.SEASONALITY Function

16 September 2019

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


VBA Blog: Deleting Specific Rows

13 September 2019

Welcome back to the VBA blog. This week, we are going to learn how to use VBA to delete specific rows.


Power BI Blog: Sankey Chart

12 September 2019

Welcome back to this week’s Power BI blog series. This week, we are going to create a “flow”.


Power Query: Rows of Columns

11 September 2019

Welcome to our Power Query blog. Today, I split a column into rows.


Power Pivot Principles: Cumulative Totals with the EARLIER Function

10 September 2019

Welcome back to our Power Pivot blog. Today, we look at another application of the EARLIER function.


A to Z of Excel Functions: the FORECAST.ETS.CONFINT Function

9 September 2019

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


VBA Blog: Multiple Criteria Filter

6 September 2019

Welcome back to the VBA blog. This week, we are going to learn how to use VBA to filter a data table based upon multiple criteria.


Power BI Blog: Copy vs. Export Data from Power BI Desktop

5 September 2019

Welcome back to this week’s Power BI blog series. This week, we are going to look at a few ways to export data from Power BI.


Newsletter