Please note javascript is required for full website functionality.
MVP

Blog

Blog

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.


Power Query: Example Grading

4 September 2019

Welcome to our Power Query blog. Today, I use Column From Examples to help me put my data into grade boundaries.


Power Pivot Principles: Introducing the EARLIER Function

3 September 2019

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


Monday Morning Mulling: August 2019 Challenge

2 September 2019

On the final Friday of each month, we set a Power BI or Excel problem for you to puzzle over for the weekend. On the Monday, we publish a solution. If you think there is an alternative answer, feel free to email us. We’ll feel free to ignore you.


Final Friday Fix: August 2019 Challenge

30 August 2019

On the final Friday of each month, we’re going to set an Excel / Power BI challenge for you to puzzle over so that you can get your “Excel / Power BI fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There’s no prizes at this stage,...


Power BI Blog: Power KPI

29 August 2019

Welcome back to this week’s Power BI blog series. This week, we are going to look at the Key Performance Indicator (KPI) visual.


Power Query: Unique Combination

28 August 2019

Welcome to our Power Query blog. Today, I look at a way to create a set of data from multiple tables.


Power Pivot Principles: Highlighting Absent Students

27 August 2019

Welcome back to our Power Pivot blog. Today, we look at how to create a PivotChart that highlights the number of absent students in university classes.


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

26 August 2019

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


Newsletter