Please note javascript is required for full website functionality.

Blog

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 Blogs: 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.


Challenges: 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.


Challenges: 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, you’re playing for bragging rights only!


Newsletter