Please note javascript is required for full website functionality.
MVP

Blog

Blog

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.


Power BI: Introduction to Power BI

11 January 2018

Welcome to the very first post in our new Power BI blog series! Power BI is a tool produced by Microsoft that is designed to assist people with creating business intelligence solutions


Power Query: Querying Query Options

10 January 2018

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


Newsletter