Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Query: Abridged Appending

24 January 2018

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.


Power Pivot Principles: Importing Data

23 January 2018

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


A to Z of Excel Functions: the COUPDAYS Function

22 January 2018

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


A to Z of Excel Functions: the COUPDAYBS Function

19 January 2018

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


VBA Blog: ListColumn Swan Song

19 January 2018

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.


Power BI: Excel vs. Power BI – when to use which?

18 January 2018

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.



Power Pivot Principles: Excel Compatibility

16 January 2018

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



VBA Blog: ListColumn

12 January 2018

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.


Newsletter