Please note javascript is required for full website functionality.

Blog

Final Friday Fix: July 2018 Challenge

27 July 2018

On the final Friday of each month, we’re going to set an Excel 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’s no prizes at this stage, you’re playing for bragging rights only!


Power BI Blog: Access-ible Data - Part 3

26 July 2018

Introduction to viewing relationships in a database with Power BI.


Power Query: Technically Dating

25 July 2018

Welcome to our Power Query blog. This week, I look at some useful logical M functions to convert data into dates or vice versa.


Power Pivot Principles: Introducing Slicers

24 July 2018

Welcome back to our Power Pivot blog. Today, we consider slicers in PivotTables created using Power Pivot.


A to Z of Excel Functions: The DEVSQ Function

23 July 2018

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


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.


Newsletter