In 2018 I started working with CPA Australia on a series of Excel podcasts.

This page brings them all together. There are 12 so far.

November 2018Link

In this podcast I cover the functions Accountants need to master to get the most out of Excel.

I cover summing, logic, look ups, date, text and sundry functions.

This link is to an article I wrote that lists the functions and also the articles I have written on those functions.

October 2018 – a series of 4 short tips – Link

  • The F4 function key
  • The F5 function key
  • Using Find in Excel – tips and traps
  • Gridlines

June 2018 – Excels’ new features and functions by version Excel 2007 to Excel 2016 – Link

April/May/June 2018 – a series of five short form podcasts – Link

  • Double clicking
  • Right clicking
  • Ctrl key dragging
  • Using Windows within Excel
  • Cell comments

February 2018 – lots of keyboard shortcuts – Link


Please note: I reserve the right to delete comments that are offensive or off-topic.