เกี่ยวกับพอดแคสต์นี้ 🔗
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.
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.
ผู้จัด:
ความถี่ในการอัพเดต:
monthly
ความยาวเสียงโดยเฉลี่ย:
12 minutes
มีสปอนเซอร์
ภาษาอังกฤษ
ออสเตรเลีย
52 ตอน
ตั้งแต่ 13 มกราคม 2023
episodic
ในพอดแคสต์นี้ 🔗
ตอนล่าสุด 🔗
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 h…
ตอนก่อนหน้านี้ 🔗
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 techn…
Wouldn't it be useful to learn how to build interactive Excel charts that respond automatically to user input using dynamic arrays?
This expert-led episode introduces the core techniques behind flexible charting in Excel, with practical examples.
Key takeaways:
Create charts that automati…
From trial balances to profit and loss statements, reporting sits at the centre of modern finance.
This episode explores how finance professionals can use DAX (Data Analysis Expressions) formulas and Power Pivot to build more powerful accounting reports in Excel.
Learn how to create scalable, m…
Excel macros are far from obsolete. And here's why.
This episode explores why VBAs (Visual Basic for Applications) still play an important role in workflow efficiency for accountants and finance professionals.
Key learnings:
Why macros still matter in modern Excel workflows
How VB…
Most finance professionals have made this mistake at least once.
You open last month's file, update the numbers, hit save, and only then realise you should have saved it as this month's version of the file.
This is where templates can help.
In this episode, explore how Excel templates solve t…
What if you could simplify Excel date calculations with one powerful custom function?
Well, this episode explains how.
You'll learn:
How to handle different date increments including days, weeks and months in one function
Using the SWITCH function to create a lookup table
…
Messy, unstructured data.
It slows reporting, creates errors, and tests everyone's patience. Right?
This episode breaks down how the new Regular Expressions (REGEX) work and how they help you find patterns in unstructured text, from email addresses to dates and hidden white space.
You will le…
You may know The Seven Habits of Highly Effective People as a cornerstone of modern business thinking.
But what happens when those same principles from this book are applied to one of the most widely used tools in finance: Excel?
In this episode, we explore how the seven habits framework can be…
Excel Tips Summer Season Encore presentation from October 2025
In this episode of Excel Tips, we explore the latest Excel updates that can help to boost productivity and simplify workflows for finance and accounting professionals.
Listeners will learn:
How to use TRIMRANGE for flexible range…
ข้อสงวนสิทธิ์: พอดแคสต์และอาร์ตเวิร์คที่ฝังอยู่ในหน้านี้มาจาก CPA Australia ซึ่งเป็นทรัพย์สินของเจ้าของและไม่มีส่วนเกี่ยวข้องหรือรับรองโดย Listen Notes, Inc.
เครื่องมือค้นหาพอดแคสต์
คุณสามารถใช้เว็บไซต์ของเราเพื่อค้นหาพอดแคสต์ของ3,824,495และตอนของ195,764,137ตามบุคคล สถานที่ หรือหัวข้อ
If I have seen further than others, it is by listening to podcasts and standing upon the shoulders of
giants.
‐ Isaac "Llamacorn" Newton
พอดแคสต์มีการอ้างสิทธิ์แล้ว
This podcast page is claimed and managed by
@CPA_Australia
