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.

This is a common question that we’re asked. If we already have Excel for reporting, and it’s currently getting the job done, why should we use Power BI? Or if we want to use Power BI, what processes should we switch over?

Welcome to our Power Query blog. This week, I take a look at a way to create and append new queries by starting with the Query Editor.

Let's go through some of the different methods to import data...

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