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

This is the eleventh blog in the series about using ListObjects to manipulate Tables within an Excel workbook in VBA. Today we will be looking at all the commonalities between ListColumns and ListRows on the Item level.

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

Let’s start using Power BI. Power BI is a data visualisation tool so the first and foremost thing that needs to be done is to get some data into Power BI.

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.

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

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

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.

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

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.