Excel Tips

By CPA Australia

Listen to a podcast, please open Podcast Republic app. Available on Google Play Store and Apple App Store.

Image by CPA Australia

Category: Education

Open in Apple Podcasts


Open RSS feed


Open Website


Rate for this podcast

Subscribers: 7
Reviews: 0
Episodes: 48

Description

Excel Tips is a podcast for accounting, business and finance professionals who are looking to sharpen their spreadsheet skills and learn new hacks and tricks from Neale Blackwood CPA, a Microsoft Excel expert. Excel Tips helps spreadsheet users discover Excel's hidden features and shortcuts and understand how best to apply the newest features and functionality. The podcast is a companion to regular articles in INTHEBLACK, CPA Australia's award-winning business magazine. Every podcast episode includes links to the accompanying Excel Tips digital magazine article. Neale Blackwood CPA has more than 20 years of experience as a Microsoft Excel educator. He is the author of more than 200 INTHEBLACK articles as well as a book, Advanced Excel Reporting for Management Accountants. Subscribe today to stay up-to-date with the latest episodes. Excel Tips is presented by CPA Australia, one of the world's largest accounting bodies, with core services that include education, training, technical support and advocacy. CPA Australia publishes four podcasts: With Interest, INTHEBLACK, INTHEBLACK Out Loud and Excel Tips. To find out more about our podcasts, visit https://www.cpaaustralia.com.au/tools-and-resources/podcasts - or search for the shows in your podcast service. To contact the podcast team email us at podcasts@cpaaustralia.com.au.

Episode Date
Why Excel macros still matter in 2026
Jun 01, 2026
Template tips to boost workflows
May 01, 2026
Increment dates easily in Excel
Apr 01, 2026
Master your messy data
Mar 02, 2026
Build Better Excel Models
Feb 02, 2026
Smarter, faster, easier: Here's what's new in Excel
Jan 01, 2026
Unlock 7 underused Excel features you still need today
Dec 01, 2025
How to simplify complex calculations with custom functions
Nov 03, 2025
Smarter, faster, easier: Here's what's new in Excel
Oct 01, 2025
Unleash the power of Python in Excel
Sep 01, 2025
Python in Excel: Practical applications
Aug 01, 2025
Getting started with Python in Excel
Jul 01, 2025
Excel's GROUPBY and PIVOTBY explained
Jun 02, 2025
Better share price reports with Excel's new tool
May 01, 2025
Elevate your Pareto analysis skills with Excel
Mar 31, 2025
Unlock the power of Microsoft Forms in Excel
Mar 03, 2025
New tool explained: boost your efficiency with checkboxes
Feb 02, 2025
Improve your PDF data handling with Power Query
Jan 02, 2025
Handy hack to create timeline charts
Dec 01, 2024
Master calendar creation in Excel
Oct 31, 2024
How to add a user interaction into Power Query
Sep 30, 2024
Learn a smart way to hide blank or zero rows
Aug 31, 2024
The power of heat maps for sales and costs data
Aug 01, 2024
3 powerful macros to streamline your workflow
Jun 30, 2024
Level up your custom functions skills
Jun 03, 2024
How to create a dashboard using Excel's dynamic arrays
May 01, 2024
How to automate report building in Excel (part 2)
Apr 02, 2024
How to automate report building in Excel
Feb 29, 2024
Master the latest Excel changes: your ultimate guide
Feb 01, 2024
How to master using different Excel techniques together
Jan 04, 2024
Top Excel tips for your first 100 days in a new job
Dec 01, 2023
How to create improved data visualisations in Excel
Nov 01, 2023
Master 10 new and revamped Excel features
Oct 03, 2023
Boost your skills with tips for Excel function updates
Sep 01, 2023
Unlock 14 expert tips for Excel formulas
Aug 01, 2023
Why Excel can be a university student's secret weapon
Jul 02, 2023
22 Excel shortcuts to supercharge your efficiency
Jun 01, 2023
Excel and ChatGPT
May 04, 2023
Learn Excel's built-in artificial intelligence feature
Apr 06, 2023
How to use custom functions without macros
Mar 23, 2023
How to do dynamic arrays (subscription version)
Mar 16, 2023
How to create vertical lines in line charts
Mar 09, 2023
Excel tips: how to use the new data types feature
Mar 02, 2023
Excel tips: how to work with dates and days
Feb 20, 2023
Excel tips: how to use Goal Seek
Feb 13, 2023
Excel tips: how to improve your formatting
Feb 06, 2023
Excel Tips: New text functions for Excel
Jan 31, 2023
EXCEL TIPS, coming soon.
Jan 13, 2023