Please note javascript is required for full website functionality.

Blog

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).


VBA Blogs: Stop Reticulating Splines! - Part 1

6 July 2018

VBA Blog about improving calculation speeds.


Power BI Blog: Access-ible Data - Part 1

5 July 2018

One of the neat things about Power BI is the large number of connectors to Get & Transform data. We’ve been working with flat files until now but to realise the full potential of Power BI, we’re going to start having to work with REAL data.


Power Query: Getting Something Out of a Date

4 July 2018

Welcome to our Power Query blog. This week, I look at some useful ways to extract data from dates in M.


Newsletter