Season's Savings | ₹5/mo for 3 months

₹199/month after first 3 months. Renews automatically. Terms apply.
Excel Tips cover art

Excel Tips

Excel Tips

Written by: CPA Australia
Listen for free

About this listen
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 FCPA, 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 FCPA has more than 25 years of experience as a Microsoft Excel educator. He is the author of more than 250 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.© CPA Australia Economics
Episodes
  • Is Copilot a reliable tool for Excel?
    Nov 2 2026
    AI is reshaping business workflows, including how we use Excel. Copilot — Microsoft's AI-powered assistant — can help finance professionals work more efficiently in Excel, from generating spreadsheets and explaining unfamiliar workbooks to writing VBA code. However, like any AI tool, human oversight is vital. Find out where Copilot can save you time and how to use AI more reliably in Excel. In this episode, discover how to: Find Copilot in Excel and place it in the home ribbon Use Copilot's edit, planning and chat modes in Excel Apply personalisation rules and workbook-specific instructions Ask Copilot to explain formulas, analyse workbooks and identify data outliers Check AI-generated formulas and validate spreadsheet outputs Understand Copilot's limitations based on outputs and probabilities Tune in now. Host: Neale Blackwood CPA. He has more than 20 years of experience as a Microsoft Excel educator and is the author of more than 200 INTHEBLACK articles as well as a book, Advanced Excel Reporting for Management Accountants. There is a useful companion video to go with this episode of Excel Tips. And you can read more of Neale's Excel articles on INTHEBLACK. You can find a CPA at our custom portal on the CPA Australia website. Loving this content? Would you like to listen to more Excel Tips and other CPA Australia podcasts like INTHEBLACK and With Interest? Head to CPA Australia's YouTube channel. CPA Australia publishes four podcasts, providing commentary and thought leadership across business, finance, and accounting: With Interest INTHEBLACK Excel Tips INTHEBLACK Out Loud Search for them in your podcast platform. You can email the podcast team at podcasts@cpaaustralia.com.au
    Show More Show Less
    12 mins
  • How to use Python in Excel for sentiment analysis
    Oct 1 2026
    Excel's core strength is working with numbers. And we love how it makes our data work more efficiently. However, what happens when the data is words? Python in Excel closes that gap, allowing you to analyse short-form feedback such as customer surveys, employee comments, training feedback and help desk responses. This episode explains how sentiment analysis works and how to combine Python with Excel formulas to create a practical feedback analysis workflow. You will learn: How sentiment analysis can help analyse large volumes of written feedback How Python in Excel gives Excel capabilities it does not have natively How VADER scores negative, neutral, positive and overall sentiment How to turn raw sentiment scores into useful descriptions with XLOOKUP How spill ranges, LET, DROP, HSTACK and VSTACK extend the analysis Where sentiment analysis can struggle, including sarcasm, irony and jargon Why human judgement is still needed to interpret and act on feedback Tune in now. Host: Neale Blackwood CPA. He has more than 20 years of experience as a Microsoft Excel educator and is the author of more than 200 INTHEBLACK articles as well as a book, Advanced Excel Reporting for Management Accountants. There is a useful companion video to go with this episode of Excel Tips. And you can read more of Neale's Excel articles on INTHEBLACK. You can find a CPA at our custom portal on the CPA Australia website. Loving this content? Would you like to listen to more Excel Tips and other CPA Australia podcasts like INTHEBLACK and With Interest? Head to CPA Australia's YouTube channel. CPA Australia publishes four podcasts, providing commentary and thought leadership across business, finance, and accounting: With Interest INTHEBLACK Excel Tips INTHEBLACK Out Loud Search for them in your podcast platform. You can email the podcast team at podcasts@cpaaustralia.com.au
    Show More Show Less
    8 mins
  • Create interactive Excel charts (part 2)
    Sep 1 2026

    Can you make Excel reporting more interactive? Yes, you can.

    And it's all to do with dynamic arrays.

    In the second of this two-part series, discover how to create dynamic Excel charts this time using financial year calculations and checkboxes.

    This is useful for finance pros because the techniques allow users more control.

    You will learn:

    • How to convert calendar year calculations into financial years
    • How to use checkboxes to control ascending or descending chart order
    • How checkboxes can figure out which metrics appear on a chart
    • How PIVOTBY creates two-dimensional reports for chart data
    • How FILTER, HSTACK and VSTACK can combine chart components
    • How formatted tables allow charts to update when new monthly data is added
    • How to build safeguards for accidentally deleted checkboxes

    Tune in now.

    Host: Neale Blackwood CPA. He has more than 20 years of experience as a Microsoft Excel educator and is the author of more than 200 INTHEBLACK articles as well as a book, Advanced Excel Reporting for Management Accountants.

    There is a useful companion video to go with this episode of Excel Tips.

    And you can read more of Neale's Excel articles on INTHEBLACK.

    You can find a CPA at our custom portal on the CPA Australia website.

    Loving this content?

    Would you like to listen to more Excel Tips and other CPA Australia podcasts like INTHEBLACK and With Interest? Head to CPA Australia's YouTube channel.

    CPA Australia publishes four podcasts, providing commentary and thought leadership across business, finance and accounting:

    With Interest

    INTHEBLACK

    Excel Tips

    INTHEBLACK Out Loud

    Search for them in your podcast platform.

    You can email the podcast team at podcasts@cpaaustralia.com.au

    Show More Show Less
    9 mins
adbl_web_anon_alc_button_suppression_t1
No reviews yet