Please note javascript is required for full website functionality.
MVP

Blog

Blog

A to Z of Excel Functions: the COUPNCD Function

29 January 2018

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


Monday Morning Mulling: January 2018

29 January 2018

Solution to Final Friday Fix for January 2018. Detailing how to left align the text of bar charts.


A to Z of Excel Functions: the COUPDAYSNC Function

26 January 2018

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


Final Friday Fix: January 2018

26 January 2018

This Friday, let us return to charts. Today’s challenge is this: Left aligning text on the vertical axis of a bar chart...


Power BI: When should we use Power BI and when should we use Excel?

25 January 2018

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?


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.


Newsletter