Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Query: Grouping to the Max

25 September 2019

Welcome to our Power Query blog. Today, I look at groups and how to interrogate them.


Power Pivot Principles: Introducing the REPLACE Function

24 September 2019

Welcome back to our Power Pivot blog. Today, we look at the REPLACE function.


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

23 September 2019

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


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”.


Newsletter