Please note javascript is required for full website functionality.

Blog

A to Z of Excel Functions: The IFS Function

8 June 2020

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


Charts and Dashboards: Highlighting Data

5 June 2020

Welcome back to this week’s Charts and Dashboards blog series. This week, let’s talk about how we can highlight one or more data points in a chart.


Power BI Blog: Custom Visualizations; Funnel/Pyramid Chart Formatting

4 June 2020

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau takes a look at formatting a custom visualisation, namely the Funnel Chart by xViz


Power Query: Previous Value

3 June 2020

Welcome to our Power Query blog. Today, I am looking at two ways to reference a previous value in a column.


Power Pivot Principles: Power Pivot Principle: Introducing the RELATEDTABLE function

2 June 2020

Welcome back to the Power Pivot Principles blog. This week, we consider the RELATEDTABLE function in DAX.


Challenges: Monday Morning Mulling: May 2020 Challenge

1 June 2020

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 IFNA Function

1 June 2020

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


Challenges: Final Friday Fix: May 2020 Challenge

29 May 2020

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 fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There are no prizes at this stage: you’re playing for bragging rights only!


Power BI Blog: Custom Visualizations – Funnel/Pyramid Chart

28 May 2020

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau takes a look at new custom visualisation, the Funnel Chart by xViz.


Power Query: More Room for a View

27 May 2020

Welcome to our Power Query blog. This week, I continue my look at some new additions to the View tab, which are still not available on all versions of Power Query. Today, I look at ‘Column Profile’ and ‘Column Quality’.


Newsletter