In 2018 I started working with CPA Australia on a series of Excel podcasts.
This page brings all the podcasts together. I have done 17 episodes so far.
October 2019 – Link
I covered Excel macros, the what, why and how of macros for accountants.
June 2019 – Link
Two shorter episodes were released in June. They covered Flash Fill (Excel’s super hero feature that has a back story) and Format as Table a must-use feature for tables that isn’t about formatting. These features are also on the Data ribbon.
May 2019 – Link
In this podcast I focus on the Data ribbon and the many features that it contains. Excel is more and more data focused and I discuss the how, why and when to use these features. Future podcasts will highlight specific parts of the Data ribbon in more detail.
February 2019 – Link
This podcast focuses on Power Query, what it is and how and why to use it. Power Query simplifies importing data into Excel form virtually any source.
If you haven’t started using Power Query the podcast might convince you to start. Power Query (aka Get & Transform) is also part of Power BI so everything you learn in Excel can be applied to Power BI.
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