Podcasts

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

This page brings all the podcasts together. I have done 14 episodes so far.

May 2019Link

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 2019Link

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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.