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

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

Welcome to our Power Query blog. This week, I look at the ‘Query Options’ screen and what it can do for me.

Want to create a PivotTable where formatting “sticks” and data may be referenced from a myriad of various sources at the same time?

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