Please note javascript is required for full website functionality.

Blog

Power Query: Cell Referencing

7 February 2018

Welcome to our Power Query blog. This week, I take a look at how to reference a cell in an Excel workbook from Power Query.


Power Pivot Principles: Filtered Imports

6 February 2018

Today we look at filtering the data a little before importing it form Excel.


A to Z of Excel Functions: The COUPPCD Function

5 February 2018

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


VBA Blogs: Same Same But Different

2 February 2018

This is the tenth blog in the series about using ListObjects to manipulate Tables within an Excel workbook in VBA. Today we will be reviewing ListColumns and how it applies to ListRows.


A to Z of Excel Functions: The COUPNUM Function

2 February 2018

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


Power BI Blog: Which Power BI should I use?

1 February 2018

If you’re new to the Power BI ecosystem, it can be a bit confusing to understand what all the different parts are, not made easier by the way that Microsoft presents it on the website. Basically though, they can be broken down into two main categories – the software component and the payment component.


Power Query: Evaluating Stored Queries

31 January 2018

Previously I looked at a few ways to share queries between workbooks. This week, I take a look at a slightly different approach...


Power Pivot Principles: Importing Data from Excel

30 January 2018

Once data is loaded into Power Pivot it is unable to be changed from the Power Pivot window. To get around this issue, we can load data from Excel...


Monday Morning Mulling: January 2018

29 January 2018

Solution to Final Friday Fix for January 2018. Detailing how to left align the text of bar charts.


A to Z of Excel Functions: The COUPNCD Function

29 January 2018

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


Newsletter