Please note javascript is required for full website functionality.
MVP

Blog

Blog

VBA Blog: Same Same But Different

2 February 2018

This is the tenth blog in the series about using ListObjects to manipulate Tables within an Excel workbook in VBA. Today we will be reviewing ListColumns and how it applies to ListRows.


A to Z of Excel Functions: The COUPNUM Function

2 February 2018

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


Power BI Tips: Which Power BI should I use?

1 February 2018

If you’re new to the Power BI ecosystem, it can be a bit confusing to understand what all the different parts are, not made easier by the way that Microsoft presents it on the website. Basically though, they can be broken down into two main categories – the...


Power Query: Evaluating Stored Queries

31 January 2018

Previously I looked at a few ways to share queries between workbooks. This week, I take a look at a slightly different approach...


Power Pivot Principles: Importing Data from Excel

30 January 2018

Once data is loaded into Power Pivot it is unable to be changed from the Power Pivot window. To get around this issue, we can load data from Excel...


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?


Newsletter