Please note javascript is required for full website functionality.
MVP

Blog

Blog

A to Z of Excel Functions: the DBCS Function

7 May 2018

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



Power BI Tips: Just Speculate Over Numbers - Part 1

3 May 2018

Power BI exercise focusing on JSON files using the NY Powerball data.


Power Query: Thanks for the Memory

2 May 2018

This week, I look at what to do if you are short of memory.


Power Pivot Principles: Measure Creation in Practice

1 May 2018

Today we discuss proper practices we should adopt when creating measures.


Monday Morning Mulling: April 2018 Challenge

30 April 2018

On the final Friday of each month, we set an 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.


A to Z of Excel Functions: the DB Function

30 April 2018

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


Final Friday Fix: April 2018 Challenge

27 April 2018

On the final Friday of each month, we’re going to set Excel for you to puzzle over so that you can get your “Excel 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...


Power BI Tips: Xenagogue to Markup Lists - Part 3

26 April 2018

Using a multi-row card visualisation to display the USD exchange rate from the RBA RSS feed


Power Query: Hot Cross Joins

25 April 2018

This week I look at cross joins.


Newsletter