Podcasts

Excel with your ears

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

This page brings all the podcasts links together. There are currently over 20 separate episodes.

July 2020 – Link

After a short break from recording podcasts I have returned with four separate podcasts covering Excel’s new feature called dynamic arrays. The first three podcasts follow closely the three articles I wrote for the INTHEBLACK magazine. The fourth podcast has ideas on how to apply this new functionality.

January 2020 – Link

I covered the Data Validation feature in a short form podcast.

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

2 thoughts on “Podcasts”

  1. Your podcasts unfold great stuff about excel & Power query.
    But why have you kept your favorite subject VBA / macros untouched yet in your podcast?
    Hope to hear one sooner rather than later.
    Other topics you may cover are: Power Pivot, DAX, Pivot Tables, SUMPRODUCT (again your favourite) (in greater detail – though we got to hear the basics of SUMPRODUCT in your Functions podcast, which was by far the best), Arrays, more on Power query & its code: M language, Conditional Formatting, What-If analysis, etc..

    Reply