Please note javascript is required for full website functionality.
MVP

Blog

Blog

VBA Blog: Dynamic Validation List

20 September 2019

Welcome back to the VBA blog. This week, we are going to learn how to use VBA to setup a dynamic validation list.


Power BI Blog: Colour Formatting Tips

19 September 2019

Welcome back to this week’s Power BI blog series. Over the next three weeks, we are going to look at some tips on colour (color?) formatting in Power BI.


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.


Newsletter