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.

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

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

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

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

This Friday, let us return to charts. Today’s challenge is this: Left aligning text on the vertical axis of a bar chart...

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