Please note javascript is required for full website functionality.

Blog

A to Z of Excel Functions: The IMSIN Function

14 December 2020

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


Charts and Dashboards: Dynamic Chart Titles

11 December 2020

Welcome back to this week’s Charts and Dashboards blog series. This week, we show you how to create dynamic chart titles.


Power BI Blog: Setting Up Custom ToolTips

10 December 2020

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how to set up a custom ToolTip.


Power Query: I Gather That’s Right

9 December 2020

Welcome to our Power Query blog. This week, I look at how to gather data from multiple rows.


Power Pivot Principles: Nothing to Draw a BLANK About – ISBLANK Zero?

8 December 2020

Welcome back to the Power Pivot Principles blog. This week, we take a look at a common mistake made with zero(e)s.


A to Z of Excel Functions: The IMSECH Function

7 December 2020

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


Charts and Dashboards: Rolling Charts

4 December 2020

Welcome back to this week’s Charts and Dashboards blog series. This week, we consider rolling charts, whatever they may be...


Power BI Blog: Managing Slicers

3 December 2020

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how to manage slicers in a multi-paged report.


Power Query: All Dates Must Change

2 December 2020

Welcome to our Power Query blog. This week, I look at how to dynamically set the Data Type on all my datetime columns to date.


Power Pivot Principles: Problems with 1 Month Ago – DATEADD vs. PREVIOUSMONTH

1 December 2020

Welcome back to the Power Pivot Principles blog. This week, we take a look back at, er, looking back and an associated classic gotcha.


Newsletter