Please note javascript is required for full website functionality.

Blog

A to Z of Excel Functions: The DELTA Function

20 July 2018

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


Power BI Blog: SumProduct in Seattle!

19 July 2018

We’re taking a break from our regular Power BI blog series to let you know that our Sydney Director, Tim Heng, is heading this weekend to Seattle!


Power Query: Currently Dating?

18 July 2018

Welcome to our Power Query blog. This week, I look at some useful logical M functions to determine whether a date is in a particular period.


Power Pivot Principles: Multiple Table Management

17 July 2018

Welcome back to our Power Pivot blog. Today, we discuss managing multiple tables.


A to Z of Excel Functions: The DEGREES Function

16 July 2018

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


VBA Blogs: Stop Reticulating Splines - Part 2

13 July 2018

More VBA optimisation tricks so you can stop reticulating splines.


Power BI Blog: Access-ible Data - Part 2

12 July 2018

Utilising Get Data from an MS Access database in Power BI.


Power Query: End of Dates

11 July 2018

Welcome to our Power Query blog. This week, I look at some ways to determine the end (and the start) of a particular date period in M.


Power Pivot Principles: Filters

10 July 2018

Welcome back to our Power Pivot blog. Today, we discuss how to use filters in Power Pivot.


A to Z of Excel Functions: The DECIMAL Function

9 July 2018

This function converts a text representation of a number in a given base into a decimal number (base 10).


Newsletter