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 2018 – Link
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
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