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.

This is the ninth blog in the series about using ListObjects to manipulate Tables within an Excel workbook in VBA. Today we will be featuring ListColumns.

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

Welcome back to our new Power BI blog series! We’re going to look this week at the similarities and differences between the tools in Power BI and the equivalent in Excel.

Welcome to our Power Query blog. This week, I take a look at exporting queries to other workbooks in Power Query or Get and Transform.Regular readers will know that this blog is now constructed in Excel 2016 and therefore uses ‘Get and Transform’. In most cases, it’s...

Unfortunately, Power Pivot doesn’t work in all versions of Excel. We discuss Power Pivot’s compatibility with different versions of Excel...

Welcome back to our regular A to Z of Excel Functions blog.  Today we look at the COUNTIFS function. The COUNTIFS functionThis function applies one or more criteria to cells across multiple ranges and counts the number of times all criteria are met.  This...