Please note javascript is required for full website functionality.

Blog

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


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.


Power BI Blog: 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.


VBA Blogs: 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.


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.


Power BI Blog: 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 Query: It’s Good to Share (a Query)

17 January 2018

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


Newsletter