How often does this podcast release new episodes?

This podcast updates bi-weekly.

Where can I listen to this podcast?

This podcast is available on 10 platforms including Apple Podcasts, Spotify, and more. You can also use the RSS feed directly.

Does this podcast accept guests?

No, this podcast does not typically feature guests.

Excel Tips

Claim This Podcast

by CPA Australia

4.6(7 reviews)

50 episodes

Updated Bi-weekly

Accepts GuestsHas SponsorsLocation 🇦🇺

Podcast Authority

Beta

FairBased on show quality, social media presence, reviews, charts, and more

Quality27

Social0

YouTube93

Engagement77

Learn more

Podcast Overview

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.

Language

🇺🇲

Publishing Since

1/13/2023

Visit Website View on Apple Podcasts RSS Feed

🇺🇸 Charts #3

Outreach generated

Apple 142

Spotify 827

Instant mention tracking

Perfect fit!

Unlock The Full Podcast Authority Score Report

See how your podcast performs across key metrics

Podcast Authority

Beta

FairBased on show quality, social media presence, reviews, charts, and more

Quality27

Social0

YouTube93

Engagement77

Learn more

Excellent Areas

Good Performance

Growth Opportunities

excellent

Episode Length

10 minutes

Performing excellently!

good

Show Experience

40 episodes over 2.6 years

Recommendations available

Unlock the full report to see detailed tips

needs improvement

Publishing Consistency

Every 24 days

Recommendations available

Unlock the full report to see detailed tips

+16 More Metrics

Unlock comprehensive insights including:

• YouTube presence analysis
• Social media reach metrics
• RSS compliance scoring
• Podcast 2.0 features
• Technical standards

What's Included in Your Full Report

Detailed Analytics

Complete breakdown of all 19 authority metrics
Personalized recommendations for each metric
Industry benchmarks and comparisons
Technical RSS feed analysis and compliance scoring

Growth Strategies

Step-by-step action plans for improvement
Quick wins to boost your score immediately
Pro tips from successful podcasters

Get your free podcast insights report

See how your show performs across every key metric

Instant delivery

No spam

Attract Better Guests

High authority scores make your podcast more attractive to industry leaders and influencers who want to appear on credible shows.

Secure Sponsorships

Sponsors look for podcasts with proven authority and engagement. Your score demonstrates your podcast's value to potential partners.

Grow Your Audience

Understanding your strengths and weaknesses helps you make data-driven decisions to expand your listener base effectively.

1 verified contact email on file for Excel Tips

Pitch yourself as a guest, propose sponsorships, or reach out directly to the host.

See contact details

Recent Episodes

August 3, 2026

Create interactive Excel charts

<div class="SCXW109991172 BCX0"> <div class="OutlineElement Ltr SCXW109991172 BCX0"> <p class="Paragraph SCXW109991172 BCX0"><span class= "TextRun SCXW109991172 BCX0" lang="EN-AU" xml:lang="EN-AU" data-contrast="auto"><span class= "NormalTextRun SCXW109991172 BCX0">Wouldn't</span><span class= "NormalTextRun SCXW109991172 BCX0"> it be useful to learn how to build interactive Excel charts that respond automatically to user input using dynamic arrays?</span></span><span class= "EOP Selected SCXW109991172 BCX0" data-ccp-props= "{"134233117":false,"134233118":false,"201341983":0,"335559738":240,"335559739":240,"335559740":240}"> </span></p> </div> <div class="OutlineElement Ltr SCXW109991172 BCX0"> <p class="Paragraph SCXW109991172 BCX0"><span class= "TextRun SCXW109991172 BCX0" lang="EN-AU" xml:lang="EN-AU" data-contrast="auto"><span class= "NormalTextRun SCXW109991172 BCX0">This expert-led episode introduces the core techniques behind flexible charting in Excel, with practical examples</span><span class= "NormalTextRun SCXW109991172 BCX0">.</span></span><span class= "EOP Selected SCXW109991172 BCX0" data-ccp-props= "{"134233117":false,"134233118":false,"201341983":0,"335559738":240,"335559739":240,"335559740":240}"> </span></p> </div> <div class="OutlineElement Ltr SCXW109991172 BCX0"> <p class="Paragraph SCXW109991172 BCX0"><span class= "NormalTextRun SCXW109991172 BCX0">Key takeaways:</span><span class="EOP Selected SCXW109991172 BCX0" data-ccp-props= "{"134233117":false,"134233118":false,"201341983":0,"335559738":240,"335559739":240,"335559740":240}"> </span></p> </div> <div class="ListContainerWrapper SCXW109991172 BCX0"> <ul class="BulletListStyle1 SCXW109991172 BCX0" role="list"> <li class="OutlineElement Ltr SCXW109991172 BCX0" role="listitem" aria-setsize="-1" data-leveltext="" data-font="Symbol" data-listid="13" data-list-defn-props= "{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1"> <p class="Paragraph SCXW109991172 BCX0"><span class= "NormalTextRun SCXW109991172 BCX0">Create charts that automatically adjust the number of months displayed </span></p> </li> </ul> </div> <div class="ListContainerWrapper SCXW109991172 BCX0"> <ul class="BulletListStyle1 SCXW109991172 BCX0" role="list"> <li class="OutlineElement Ltr SCXW109991172 BCX0" role="listitem" aria-setsize="-1" data-leveltext="" data-font="Symbol" data-listid="13" data-list-defn-props= "{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="2" data-aria-level="1"> <p class="Paragraph SCXW109991172 BCX0"><span class= "NormalTextRun SCXW109991172 BCX0">Use SEQUENCE to build flexible dynamic array calculations </span></p> </li> </ul> </div> <div class="ListContainerWrapper SCXW109991172 BCX0"> <ul class="BulletListStyle1 SCXW109991172 BCX0" role="list"> <li class="OutlineElement Ltr SCXW109991172 BCX0" role="listitem" aria-setsize="-1" data-leveltext="" data-font="Symbol" data-listid="13" data-list-defn-props= "{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="3" data-aria-level="1"> <p class="Paragraph SCXW109991172 BCX0"><span class= "NormalTextRun SCXW109991172 BCX0">Combine data for charts with the HSTACK function </span></p> </li> </ul> </div> <div class="ListContainerWrapper SCXW109991172 BCX0"> <ul class="BulletListStyle1 SCXW109991172 BCX0" role="list"> <li class="OutlineElement Ltr SCXW109991172 BCX0" role="listitem" aria-setsize="-1" data-leveltext="" data-font="Symbol" data-listid="13" data-list-defn-props= "{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="4" data-aria-level="1"> <p class="Paragraph SCXW109991172 BCX0"><span class= "NormalTextRun SCXW109991172 BCX0">Find the latest reporting period using MAX and EOMONTH </span></p> </li> </ul> </div> <div class="ListContainerWrapper SCXW109991172 BCX0"> <ul class="BulletListStyle1 SCXW109991172 BCX0" role="list"> <li class="OutlineElement Ltr SCXW109991172 BCX0" role="listitem" aria-setsize="-1" data-leveltext="" data-font="Symbol" data-listid="13" data-list-defn-props= "{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="5" data-aria-level="1"> <p class="Paragraph SCXW109991172 BCX0"><span class= "NormalTextRun SCXW109991172 BCX0">Extract and summarise data with INDEX, MATCH and GROUPBY </span></p> </li> </ul> </div> <div class="ListContainerWrapper SCXW109991172 BCX0"> <ul class="BulletListStyle1 SCXW109991172 BCX0" role="list"> <li class="OutlineElement Ltr SCXW109991172 BCX0" role="listitem" aria-setsize="-1" data-leveltext="" data-font="Symbol" data-listid="13" data-list-defn-props= "{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="6" data-aria-level="1"> <p class="Paragraph SCXW109991172 BCX0"><span class= "NormalTextRun SCXW109991172 BCX0">Fix a common dynamic array date bug using a simple formula adjustment </span></p> </li> </ul> </div> </div> <div class="SCXW109991172 BCX0"> <div class="ListContainerWrapper SCXW109991172 BCX0"> <ul class="BulletListStyle1 SCXW109991172 BCX0" role="list"> <li class="OutlineElement Ltr SCXW109991172 BCX0" role="listitem" aria-setsize="-1" data-leveltext="" data-font="Symbol" data-listid="13" data-list-defn-props= "{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="7" data-aria-level="1"> <p class="Paragraph SCXW109991172 BCX0"><span class= "NormalTextRun SCXW109991172 BCX0">Learn why helper cells make complex formulas easier to understand </span></p> </li> </ul> </div> <div class="OutlineElement Ltr SCXW109991172 BCX0"> <p class="Paragraph SCXW109991172 BCX0"><span class= "TextRun SCXW109991172 BCX0" lang="EN-AU" xml:lang="EN-AU" data-contrast="auto"><span class= "NormalTextRun SCXW109991172 BCX0">This is the first episode in a two-part series on interactive Excel charts, with the next instalment in S</span><span class= "NormalTextRun SCXW109991172 BCX0">eptember</span><span class= "NormalTextRun SCXW109991172 BCX0"> covering more advanced reporting techniques, including </span><span class= "NormalTextRun SCXW109991172 BCX0">financial year</span><span class="NormalTextRun SCXW109991172 BCX0"> reporting.</span></span><span class="EOP Selected SCXW109991172 BCX0" data-ccp-props= "{"134233117":false,"134233118":false,"201341983":0,"335559738":240,"335559739":240,"335559740":240}"> </span></p> </div> <div class="OutlineElement Ltr SCXW109991172 BCX0"> <p class="Paragraph SCXW109991172 BCX0"><span class= "NormalTextRun SCXW109991172 BCX0">Tune in now.</span><span class= "EOP Selected SCXW109991172 BCX0" data-ccp-props= "{"201341983":0,"335559738":240,"335559739":240,"335559740":420}"> </span></p> </div> <div class="OutlineElement Ltr SCXW109991172 BCX0"> <p class="Paragraph SCXW109991172 BCX0"><span class= "NormalTextRun SCXW109991172 BCX0">Host:</span><span class= "NormalTextRun SCXW109991172 BCX0"> Neale Blackwood CPA. He has more than 20 years of experience as a Microsoft Excel educator and is the author of more than 200 </span><a class= "Hyperlink SCXW109991172 BCX0" href= "https://intheblack.cpaaustralia.com.au/topic/excel" target= "_blank" rel="noreferrer noopener"><span class= "NormalTextRun SCXW109991172 BCX0" data-ccp-charstyle= "Hyperlink">INTHEBLACK</span></a><span class= "NormalTextRun SCXW109991172 BCX0"> articles as well as a book, </span><span class= "NormalTextRun SCXW109991172 BCX0">Advanced Excel Reporting for Management Accountants</span><span class= "NormalTextRun SCXW109991172 BCX0">.</span><span class= "EOP Selected SCXW109991172 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> <div class="OutlineElement Ltr SCXW109991172 BCX0"> <p class="Paragraph SCXW109991172 BCX0"><span class= "NormalTextRun SCXW250770298 BCX0">There is a useful</span><span class= "NormalTextRun SCXW250770298 BCX0"> </span><a class= "Hyperlink SCXW250770298 BCX0" href="https://youtu.be/5Yf9aO0_EDo" target="_blank" rel="noreferrer noopener"><span class= "NormalTextRun SCXW250770298 BCX0" data-ccp-charstyle= "Hyperlink">companion video</span></a> <span class= "NormalTextRun SCXW250770298 BCX0">to go with this episode of Excel Tips.</span></p> </div> <div class="OutlineElement Ltr SCXW109991172 BCX0"> <p class="Paragraph SCXW109991172 BCX0"><span class= "TextRun SCXW109991172 BCX0" lang="EN-AU" xml:lang="EN-AU" data-contrast="auto"><span class= "NormalTextRun SCXW109991172 BCX0">And you can read </span><span class= "NormalTextRun SCXW109991172 BCX0">more of </span></span><a class="Hyperlink SCXW109991172 BCX0" href= "https://intheblack.cpaaustralia.com.au/contributors/neale-blackwood" target="_blank" rel="noreferrer noopener"><span class= "TextRun Underlined SCXW109991172 BCX0" lang="EN-AU" xml:lang= "EN-AU" data-contrast="auto"><span class= "NormalTextRun SCXW109991172 BCX0" data-ccp-charstyle= "Hyperlink">Neale's Excel articles </span><span class= "NormalTextRun SCXW109991172 BCX0" data-ccp-charstyle= "Hyperlink">on</span><span class="NormalTextRun SCXW109991172 BCX0" data-ccp-charstyle="Hyperlink"> INTHEBLACK</span><span class= "NormalTextRun SCXW109991172 BCX0" data-ccp-charstyle= "Hyperlink">.</span></span></a><span class= "NormalTextRun SCXW109991172 BCX0"> </span></p> </div> <div class="OutlineElement Ltr SCXW109991172 BCX0"> <p class="Paragraph SCXW109991172 BCX0"><span class= "NormalTextRun SCXW109991172 BCX0">You can </span><a class= "Hyperlink SCXW109991172 BCX0" href= "https://apps.cpaaustralia.com.au/find-a-cpa/" target="_blank" rel= "noreferrer noopener"><span class= "NormalTextRun SCXW109991172 BCX0" data-ccp-charstyle= "Hyperlink">find a CPA at our custom portal</span></a><span class= "NormalTextRun SCXW109991172 BCX0"> on the CPA Australia website.</span><span class="EOP Selected SCXW109991172 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> <div class="OutlineElement Ltr SCXW109991172 BCX0"> <p class="Paragraph SCXW109991172 BCX0"><span class= "NormalTextRun SCXW109991172 BCX0">Loving this content? </span></p> </div> <div class="OutlineElement Ltr SCXW109991172 BCX0"> <p class="Paragraph SCXW109991172 BCX0"><span class= "TextRun SCXW109991172 BCX0" lang="EN-AU" xml:lang="EN-AU" data-contrast="auto"><span class= "NormalTextRun SCXW109991172 BCX0">Would you like to listen to more Excel Tips </span><span class= "NormalTextRun SCXW109991172 BCX0">and other CPA Australia podcasts like INTHEBLACK and With Interest</span><span class= "NormalTextRun SCXW109991172 BCX0">? Head to </span></span><a class="Hyperlink SCXW109991172 BCX0" href= "https://www.youtube.com/@CPAaustralia/podcasts" target="_blank" rel="noreferrer noopener"><span class= "NormalTextRun SCXW109991172 BCX0" data-ccp-charstyle= "Hyperlink">CPA Australia's YouTube channel</span></a><span class= "NormalTextRun SCXW109991172 BCX0">.</span><span class= "EOP Selected SCXW109991172 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> <div class="OutlineElement Ltr SCXW109991172 BCX0"> <p class="Paragraph SCXW109991172 BCX0"><span class= "NormalTextRun SCXW109991172 BCX0">CPA Australia </span><a class="Hyperlink SCXW109991172 BCX0" href= "https://www.cpaaustralia.com.au/tools-and-resources/podcasts" target="_blank" rel="noreferrer noopener"><span class= "NormalTextRun SCXW109991172 BCX0" data-ccp-charstyle= "Hyperlink">publishes four podcasts</span></a><span class= "NormalTextRun SCXW109991172 BCX0">, providing commentary and thought leadership across business, finance, and accounting:</span><span class="EOP Selected SCXW109991172 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> <div class="OutlineElement Ltr SCXW109991172 BCX0"> <p class="Paragraph SCXW109991172 BCX0"><a class= "Hyperlink SCXW109991172 BCX0" href= "https://www.cpaaustralia.com.au/tools-and-resources/podcasts/with-interest" target="_blank" rel="noreferrer noopener"><span class= "NormalTextRun SCXW109991172 BCX0" data-ccp-charstyle= "Hyperlink">With Interest</span></a><span class= "EOP Selected SCXW109991172 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> <div class="OutlineElement Ltr SCXW109991172 BCX0"> <p class="Paragraph SCXW109991172 BCX0"><a class= "Hyperlink SCXW109991172 BCX0" href= "https://www.cpaaustralia.com.au/tools-and-resources/podcasts/intheblack" target="_blank" rel="noreferrer noopener"><span class= "NormalTextRun SCXW109991172 BCX0" data-ccp-charstyle= "Hyperlink">INTHEBLACK</span></a><span class= "EOP Selected SCXW109991172 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> </div> <div class="OutlineElement Ltr SCXW109991172 BCX0"> <p class="Paragraph SCXW109991172 BCX0"><a class= "Hyperlink SCXW109991172 BCX0" href= "https://www.cpaaustralia.com.au/tools-and-resources/podcasts/excel-tips" target="_blank" rel="noreferrer noopener"><span class= "NormalTextRun SCXW109991172 BCX0" data-ccp-charstyle= "Hyperlink">Excel Tips</span></a><span class= "EOP Selected SCXW109991172 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> <div class="OutlineElement Ltr SCXW109991172 BCX0"> <p class="Paragraph SCXW109991172 BCX0"><a class= "Hyperlink SCXW109991172 BCX0" href= "https://www.cpaaustralia.com.au/tools-and-resources/podcasts/intheblack-outloud" target="_blank" rel="noreferrer noopener"><span class= "NormalTextRun SCXW109991172 BCX0" data-ccp-charstyle= "Hyperlink">INTHEBLACK Out Loud</span></a><span class= "EOP Selected SCXW109991172 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> <div class="OutlineElement Ltr SCXW109991172 BCX0"> <p class="Paragraph SCXW109991172 BCX0"><span class= "NormalTextRun SCXW109991172 BCX0">Search for them in your podcast platform.</span><span class="EOP Selected SCXW109991172 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> <div class="OutlineElement Ltr SCXW109991172 BCX0"> <p class="Paragraph SCXW109991172 BCX0"><span class= "NormalTextRun SCXW109991172 BCX0">You can email the podcast team at </span><a class="Hyperlink SCXW109991172 BCX0" href= "mailto:podcasts@cpaaustralia.com.au" target="_blank" rel= "noreferrer noopener"><span class= "NormalTextRun SCXW109991172 BCX0" data-ccp-charstyle= "Hyperlink">podcasts@cpaaustralia.com.au</span></a></p> </div>

July 1, 2026

How to create accounting reports with DAX

<div class="SCXW205452963 BCX0"> <div class="OutlineElement Ltr SCXW205452963 BCX0"> <p class="Paragraph SCXW205452963 BCX0"><span class= "TextRun SCXW205452963 BCX0" lang="EN-US" xml:lang="EN-US" data-contrast="auto"><span class= "NormalTextRun SCXW205452963 BCX0">From trial balances to profit and loss statements, reporting sits at the </span><span class= "NormalTextRun SpellingErrorV2Themed SCXW205452963 BCX0">centre</span><span class="NormalTextRun SCXW205452963 BCX0"> of modern finance.</span></span><span class= "EOP Selected SCXW205452963 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":240}"> </span></p> </div> <div class="OutlineElement Ltr SCXW205452963 BCX0"> <p class="Paragraph SCXW205452963 BCX0"><span class= "NormalTextRun SCXW205452963 BCX0">This episode explores how finance professionals can use DAX (Data Analysis Expressions) formulas and Power Pivot to build more powerful accounting reports in Excel.</span><span class="EOP Selected SCXW205452963 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":240}"> </span></p> </div> <div class="OutlineElement Ltr SCXW205452963 BCX0"> <p class="Paragraph SCXW205452963 BCX0"><span class= "TextRun SCXW205452963 BCX0" lang="EN-US" xml:lang="EN-US" data-contrast="auto"><span class= "NormalTextRun SCXW205452963 BCX0">Learn how to create scalable, maintainable reporting models using Excel</span><span class= "NormalTextRun SCXW205452963 BCX0">'</span><span class= "NormalTextRun SCXW205452963 BCX0">s data model, while applying techniques that can also be used in Power BI.</span></span><span class="EOP Selected SCXW205452963 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":240}"> </span></p> </div> <div class="OutlineElement Ltr SCXW205452963 BCX0"> <p class="Paragraph SCXW205452963 BCX0"><span class= "TextRun SCXW205452963 BCX0" lang="EN-US" xml:lang="EN-US" data-contrast="auto"><span class= "NormalTextRun SCXW205452963 BCX0">Some of the key </span><span class= "NormalTextRun SCXW205452963 BCX0">learnings</span><span class= "NormalTextRun SCXW205452963 BCX0">:</span></span><span class= "EOP Selected SCXW205452963 BCX0" data-ccp-props= "{"134233117":false,"134233118":false,"201341983":0,"335551550":1,"335551620":1,"335559685":0,"335559737":0,"335559738":0,"335559739":0,"335559740":240}"> </span></p> </div> <div class="ListContainerWrapper SCXW205452963 BCX0"> <ul class="BulletListStyle1 SCXW205452963 BCX0" role="list"> <li class="OutlineElement Ltr SCXW205452963 BCX0" role="listitem" aria-setsize="-1" data-leveltext="" data-font="Symbol" data-listid="16" data-list-defn-props= "{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1"> <p class="Paragraph SCXW205452963 BCX0"><span class= "NormalTextRun SCXW205452963 BCX0">Understand the relationship between Power Pivot and DAX</span><span class= "EOP Selected SCXW205452963 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":240}"> </span></p> </li> </ul> </div> <div class="ListContainerWrapper SCXW205452963 BCX0"> <ul class="BulletListStyle1 SCXW205452963 BCX0" role="list"> <li class="OutlineElement Ltr SCXW205452963 BCX0" role="listitem" aria-setsize="-1" data-leveltext="" data-font="Symbol" data-listid="16" data-list-defn-props= "{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="2" data-aria-level="1"> <p class="Paragraph SCXW205452963 BCX0"><span class= "NormalTextRun SCXW205452963 BCX0">Build accounting reports using multiple related tables</span><span class= "EOP Selected SCXW205452963 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":240}"> </span></p> </li> </ul> </div> <div class="ListContainerWrapper SCXW205452963 BCX0"> <ul class="BulletListStyle1 SCXW205452963 BCX0" role="list"> <li class="OutlineElement Ltr SCXW205452963 BCX0" role="listitem" aria-setsize="-1" data-leveltext="" data-font="Symbol" data-listid="16" data-list-defn-props= "{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="3" data-aria-level="1"> <p class="Paragraph SCXW205452963 BCX0"><span class= "TextRun SCXW205452963 BCX0" lang="EN-US" xml:lang="EN-US" data-contrast="auto"><span class= "NormalTextRun SCXW205452963 BCX0">Overcome </span><span class="NormalTextRun SCXW205452963 BCX0">financial year</span><span class= "NormalTextRun SCXW205452963 BCX0"> limitations in pivot tables</span></span><span class="EOP Selected SCXW205452963 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":240}"> </span></p> </li> </ul> </div> <div class="ListContainerWrapper SCXW205452963 BCX0"> <ul class="BulletListStyle1 SCXW205452963 BCX0" role="list"> <li class="OutlineElement Ltr SCXW205452963 BCX0" role="listitem" aria-setsize="-1" data-leveltext="" data-font="Symbol" data-listid="16" data-list-defn-props= "{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="4" data-aria-level="1"> <p class="Paragraph SCXW205452963 BCX0"><span class= "NormalTextRun SCXW205452963 BCX0">Correct debit and credit sign issues in trial balances</span><span class= "EOP Selected SCXW205452963 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":240}"> </span></p> </li> </ul> </div> <div class="ListContainerWrapper SCXW205452963 BCX0"> <ul class="BulletListStyle1 SCXW205452963 BCX0" role="list"> <li class="OutlineElement Ltr SCXW205452963 BCX0" role="listitem" aria-setsize="-1" data-leveltext="" data-font="Symbol" data-listid="16" data-list-defn-props= "{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="5" data-aria-level="1"> <p class="Paragraph SCXW205452963 BCX0"><span class= "TextRun SCXW205452963 BCX0" lang="EN-US" xml:lang="EN-US" data-contrast="auto"><span class= "NormalTextRun SCXW205452963 BCX0">Test and </span><span class="NormalTextRun SCXW205452963 BCX0">validate</span><span class="NormalTextRun SCXW205452963 BCX0"> DAX measures using pivot tables</span></span><span class= "EOP Selected SCXW205452963 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":240}"> </span></p> </li> </ul> </div> <div class="ListContainerWrapper SCXW205452963 BCX0"> <ul class="BulletListStyle1 SCXW205452963 BCX0" role="list"> <li class="OutlineElement Ltr SCXW205452963 BCX0" role="listitem" aria-setsize="-1" data-leveltext="" data-font="Symbol" data-listid="16" data-list-defn-props= "{"335552541":1,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="6" data-aria-level="1"> <p class="Paragraph SCXW205452963 BCX0"><span class= "TextRun SCXW205452963 BCX0" lang="EN-US" xml:lang="EN-US" data-contrast="auto"><span class= "NormalTextRun SCXW205452963 BCX0">Use AI to write, </span><span class= "NormalTextRun SCXW205452963 BCX0">explain</span><span class= "NormalTextRun SCXW205452963 BCX0"> and review DAX formulas</span></span><span class="EOP Selected SCXW205452963 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":240}"> </span></p> </li> </ul> </div> <div class="OutlineElement Ltr SCXW205452963 BCX0"> <p class="Paragraph SCXW205452963 BCX0"><span class= "TextRun SCXW205452963 BCX0" lang="EN-US" xml:lang="EN-US" data-contrast="auto"><span class= "NormalTextRun SCXW205452963 BCX0">Listen now to improve your Excel skills</span><span class= "NormalTextRun SCXW205452963 BCX0">.</span></span><span class= "EOP Selected SCXW205452963 BCX0" data-ccp-props= "{"134233117":false,"134233118":false,"201341983":0,"335551550":1,"335551620":1,"335559685":0,"335559737":0,"335559738":0,"335559739":0,"335559740":240}"> </span></p> </div> <div class="OutlineElement Ltr SCXW205452963 BCX0"> <p class="Paragraph SCXW205452963 BCX0"><span class= "NormalTextRun SCXW205452963 BCX0">Host:</span><span class= "NormalTextRun SCXW205452963 BCX0"> Neale Blackwood CPA. He has more than 20 years of experience as a Microsoft Excel educator and is the author of more than 200 </span><a class= "Hyperlink SCXW205452963 BCX0" href= "https://intheblack.cpaaustralia.com.au/topic/excel" target= "_blank" rel="noreferrer noopener"><span class= "NormalTextRun SCXW205452963 BCX0" data-ccp-charstyle= "Hyperlink">INTHEBLACK</span></a><span class= "NormalTextRun SCXW205452963 BCX0"> articles as well as a book, </span><span class= "NormalTextRun SCXW205452963 BCX0">Advanced Excel Reporting for Management Accountants</span><span class= "NormalTextRun SCXW205452963 BCX0">.</span><span class= "EOP Selected SCXW205452963 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> </div> <div class="OutlineElement Ltr SCXW205452963 BCX0"> <p class="Paragraph SCXW205452963 BCX0"><span class= "NormalTextRun SCXW26257965 BCX0">For more, </span><a class= "Hyperlink SCXW26257965 BCX0" href="https://youtu.be/ROndsa9ERWA" target="_blank" rel="noreferrer noopener"><span class= "TextRun Underlined SCXW26257965 BCX0" lang="EN-AU" xml:lang= "EN-AU" data-contrast="none"><span class= "NormalTextRun SCXW26257965 BCX0" data-ccp-charstyle= "Hyperlink">check out the accompanying YouTube video </span><span class="NormalTextRun SCXW26257965 BCX0" data-ccp-charstyle="Hyperlink">of </span><span class= "NormalTextRun SCXW26257965 BCX0" data-ccp-charstyle= "Hyperlink">this episode</span></span><span class= "NormalTextRun SCXW26257965 BCX0" data-ccp-charstyle= "Hyperlink">.</span></a></p> </div> <div class="OutlineElement Ltr SCXW205452963 BCX0"> <p class="Paragraph SCXW205452963 BCX0"><span class= "TextRun SCXW205452963 BCX0" lang="EN-AU" xml:lang="EN-AU" data-contrast="auto"><span class= "NormalTextRun SCXW205452963 BCX0">R</span><span class= "NormalTextRun SCXW205452963 BCX0">ead </span><span class= "NormalTextRun SCXW205452963 BCX0">more of </span></span><a class="Hyperlink SCXW205452963 BCX0" href= "https://intheblack.cpaaustralia.com.au/contributors/neale-blackwood" target="_blank" rel="noreferrer noopener"><span class= "TextRun Underlined SCXW205452963 BCX0" lang="EN-AU" xml:lang= "EN-AU" data-contrast="auto"><span class= "NormalTextRun SCXW205452963 BCX0" data-ccp-charstyle= "Hyperlink">Neale's Excel articles </span><span class= "NormalTextRun SCXW205452963 BCX0" data-ccp-charstyle= "Hyperlink">on</span><span class="NormalTextRun SCXW205452963 BCX0" data-ccp-charstyle="Hyperlink"> INTHEBLACK</span><span class= "NormalTextRun SCXW205452963 BCX0" data-ccp-charstyle= "Hyperlink">, </span><span class= "NormalTextRun SCXW205452963 BCX0" data-ccp-charstyle= "Hyperlink">i</span></span></a><span class= "NormalTextRun SCXW205452963 BCX0">ncluding this story that </span><a class="Hyperlink SCXW205452963 BCX0" href= "https://intheblack.cpaaustralia.com.au/technical-skills/excel-tips-use-data-model" target="_blank" rel="noreferrer noopener"><span class= "TextRun Underlined SCXW205452963 BCX0" lang="EN-AU" xml:lang= "EN-AU" data-contrast="none"><span class= "NormalTextRun SCXW205452963 BCX0" data-ccp-charstyle= "Hyperlink">explains DAX </span><span class= "NormalTextRun SCXW205452963 BCX0" data-ccp-charstyle= "Hyperlink">in further detail</span><span class= "NormalTextRun SCXW205452963 BCX0" data-ccp-charstyle= "Hyperlink">.</span></span></a><span class= "NormalTextRun SCXW205452963 BCX0"> </span></p> </div> <div class="OutlineElement Ltr SCXW205452963 BCX0"> <p class="Paragraph SCXW205452963 BCX0"><span class= "NormalTextRun SCXW205452963 BCX0">Loving this content? </span></p> </div> <div class="OutlineElement Ltr SCXW205452963 BCX0"> <p class="Paragraph SCXW205452963 BCX0"><span class= "TextRun SCXW205452963 BCX0" lang="EN-AU" xml:lang="EN-AU" data-contrast="none"><span class= "NormalTextRun SCXW205452963 BCX0">D</span><span class= "NormalTextRun SCXW205452963 BCX0">on</span><span class= "NormalTextRun SCXW205452963 BCX0">'</span><span class= "NormalTextRun SCXW205452963 BCX0">t</span><span class= "NormalTextRun SCXW205452963 BCX0"> forget to subscribe to EXCEL TIPS and share this episode with your colleagues and friends in the business community</span><span class= "NormalTextRun SCXW205452963 BCX0">. </span></span></p> </div> <div class="OutlineElement Ltr SCXW205452963 BCX0"> <p class="Paragraph SCXW205452963 BCX0"><span class= "TextRun SCXW205452963 BCX0" lang="EN-AU" xml:lang="EN-AU" data-contrast="auto"><span class= "NormalTextRun SCXW205452963 BCX0">Would you like to listen to more Excel Tips </span><span class= "NormalTextRun SCXW205452963 BCX0">and other CPA Australia podcasts like INTHEBLACK and With Interest</span><span class= "NormalTextRun SCXW205452963 BCX0">? Head to </span></span><a class="Hyperlink SCXW205452963 BCX0" href= "https://www.youtube.com/@CPAaustralia/podcasts" target="_blank" rel="noreferrer noopener"><span class= "NormalTextRun SCXW205452963 BCX0" data-ccp-charstyle= "Hyperlink">CPA Australia's YouTube channel</span></a><span class= "NormalTextRun SCXW205452963 BCX0">.</span><span class= "EOP Selected SCXW205452963 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> <div class="OutlineElement Ltr SCXW205452963 BCX0"> <p class="Paragraph SCXW205452963 BCX0"><span class= "TextRun SCXW205452963 BCX0" lang="EN-AU" xml:lang="EN-AU" data-contrast="auto"><span class= "NormalTextRun SCXW205452963 BCX0">And </span><span class= "NormalTextRun SCXW205452963 BCX0">don't</span><span class= "NormalTextRun SCXW205452963 BCX0"> forget to subscribe to the channel. </span></span></p> </div> <div class="OutlineElement Ltr SCXW205452963 BCX0"> <p class="Paragraph SCXW205452963 BCX0"><span class= "NormalTextRun SCXW205452963 BCX0">You can </span><a class= "Hyperlink SCXW205452963 BCX0" href= "https://apps.cpaaustralia.com.au/find-a-cpa/" target="_blank" rel= "noreferrer noopener"><span class= "NormalTextRun SCXW205452963 BCX0" data-ccp-charstyle= "Hyperlink">find a CPA at our custom portal</span></a><span class= "NormalTextRun SCXW205452963 BCX0"> on the CPA Australia website.</span><span class="EOP Selected SCXW205452963 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> <div class="OutlineElement Ltr SCXW205452963 BCX0"> <p class="Paragraph SCXW205452963 BCX0"><span class= "NormalTextRun SCXW205452963 BCX0">CPA Australia </span><a class="Hyperlink SCXW205452963 BCX0" href= "https://www.cpaaustralia.com.au/tools-and-resources/podcasts" target="_blank" rel="noreferrer noopener"><span class= "NormalTextRun SCXW205452963 BCX0" data-ccp-charstyle= "Hyperlink">publishes four podcasts</span></a><span class= "TextRun SCXW205452963 BCX0" lang="EN-AU" xml:lang="EN-AU" data-contrast="auto"><span class= "NormalTextRun SCXW205452963 BCX0">, providing commentary and thought leadership across business, </span><span class= "NormalTextRun SCXW205452963 BCX0">finance</span><span class= "NormalTextRun SCXW205452963 BCX0"> and accounting:</span></span><span class= "EOP Selected SCXW205452963 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> <div class="OutlineElement Ltr SCXW205452963 BCX0"> <p class="Paragraph SCXW205452963 BCX0"><a class= "Hyperlink SCXW205452963 BCX0" href= "https://www.cpaaustralia.com.au/tools-and-resources/podcasts/with-interest" target="_blank" rel="noreferrer noopener"><span class= "NormalTextRun SCXW205452963 BCX0" data-ccp-charstyle= "Hyperlink">With Interest</span></a><span class= "EOP Selected SCXW205452963 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> <div class="OutlineElement Ltr SCXW205452963 BCX0"> <p class="Paragraph SCXW205452963 BCX0"><a class= "Hyperlink SCXW205452963 BCX0" href= "https://www.cpaaustralia.com.au/tools-and-resources/podcasts/intheblack" target="_blank" rel="noreferrer noopener"><span class= "NormalTextRun SCXW205452963 BCX0" data-ccp-charstyle= "Hyperlink">INTHEBLACK</span></a><span class= "EOP Selected SCXW205452963 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> <div class="OutlineElement Ltr SCXW205452963 BCX0"> <p class="Paragraph SCXW205452963 BCX0"><a class= "Hyperlink SCXW205452963 BCX0" href= "https://www.cpaaustralia.com.au/tools-and-resources/podcasts/excel-tips" target="_blank" rel="noreferrer noopener"><span class= "NormalTextRun SCXW205452963 BCX0" data-ccp-charstyle= "Hyperlink">Excel Tips</span></a><span class= "EOP Selected SCXW205452963 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> <div class="OutlineElement Ltr SCXW205452963 BCX0"> <p class="Paragraph SCXW205452963 BCX0"><a class= "Hyperlink SCXW205452963 BCX0" href= "https://www.cpaaustralia.com.au/tools-and-resources/podcasts/intheblack-outloud" target="_blank" rel="noreferrer noopener"><span class= "NormalTextRun SCXW205452963 BCX0" data-ccp-charstyle= "Hyperlink">INTHEBLACK Out Loud</span></a><span class= "EOP Selected SCXW205452963 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> <div class="OutlineElement Ltr SCXW205452963 BCX0"> <p class="Paragraph SCXW205452963 BCX0"><span class= "NormalTextRun SCXW205452963 BCX0">Search for them in your podcast platform.</span><span class="EOP Selected SCXW205452963 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> <div class="OutlineElement Ltr SCXW205452963 BCX0"> <p class="Paragraph SCXW205452963 BCX0"><span class= "NormalTextRun SCXW205452963 BCX0">You can email the podcast team at </span><a class="Hyperlink SCXW205452963 BCX0" href= "mailto:podcasts@cpaaustralia.com.au" target="_blank" rel= "noreferrer noopener"><span class= "NormalTextRun SCXW205452963 BCX0" data-ccp-charstyle= "Hyperlink">podcasts@cpaaustralia.com.au</span></a><span class= "EOP Selected SCXW205452963 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div>

June 1, 2026

Why Excel macros still matter in 2026

<div class="SCXW86518476 BCX0"> <div class="OutlineElement Ltr SCXW86518476 BCX0"> <p class="Paragraph SCXW86518476 BCX0"><span class= "TextRun SCXW86518476 BCX0" lang="EN-US" xml:lang="EN-US" data-contrast="auto"><span class= "NormalTextRun SCXW86518476 BCX0">Excel macros are far from obsolete. </span><span class= "NormalTextRun SCXW86518476 BCX0">And </span><span class= "NormalTextRun SCXW86518476 BCX0">here's</span><span class= "NormalTextRun SCXW86518476 BCX0"> why. </span></span></p> </div> <div class="OutlineElement Ltr SCXW86518476 BCX0"> <p class="Paragraph SCXW86518476 BCX0"><span class= "TextRun SCXW86518476 BCX0" lang="EN-US" xml:lang="EN-US" data-contrast="auto"><span class= "NormalTextRun SCXW86518476 BCX0">This episode explores why </span><span class= "NormalTextRun SCXW86518476 BCX0">VBA</span><span class= "NormalTextRun SCXW86518476 BCX0">s (</span><span class= "NormalTextRun SCXW86518476 BCX0">V</span><span class= "NormalTextRun SCXW86518476 BCX0">isual</span><span class= "NormalTextRun SCXW86518476 BCX0"> </span><span class= "NormalTextRun SCXW86518476 BCX0">B</span><span class= "NormalTextRun SCXW86518476 BCX0">asic</span><span class= "NormalTextRun SCXW86518476 BCX0"> </span><span class= "NormalTextRun SCXW86518476 BCX0">for </span><span class= "NormalTextRun SCXW86518476 BCX0">A</span><span class= "NormalTextRun SCXW86518476 BCX0">pplications</span><span class= "NormalTextRun SCXW86518476 BCX0">) </span><span class= "NormalTextRun SCXW86518476 BCX0">still</span><span class= "NormalTextRun SCXW86518476 BCX0"> </span><span class= "NormalTextRun SCXW86518476 BCX0">play</span><span class= "NormalTextRun SCXW86518476 BCX0"> </span><span class= "NormalTextRun SCXW86518476 BCX0">an important role</span><span class="NormalTextRun SCXW86518476 BCX0"> in workflow efficiency for accountants and finance professionals.</span></span><span class="EOP SCXW86518476 BCX0" data-ccp-props= "{"201341983":0,"335559738":240,"335559739":240,"335559740":240}"> </span></p> </div> <div class="OutlineElement Ltr SCXW86518476 BCX0"> <p class="Paragraph SCXW86518476 BCX0"><span class= "NormalTextRun SCXW86518476 BCX0">Key learnings:</span><span class= "EOP SCXW86518476 BCX0" data-ccp-props= "{"201341983":0,"335559738":240,"335559739":240,"335559740":240}"> </span></p> </div> <div class="ListContainerWrapper SCXW86518476 BCX0"> <ul class="BulletListStyle1 SCXW86518476 BCX0" role="list"> <li class="OutlineElement Ltr SCXW86518476 BCX0" role="listitem" aria-setsize="-1" data-leveltext="" data-font="Symbol" data-listid="14" data-list-defn-props= "{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1"> <p class="Paragraph SCXW86518476 BCX0"><span class= "NormalTextRun SCXW86518476 BCX0">Why macros still matter in modern Excel workflows </span></p> </li> </ul> </div> <div class="ListContainerWrapper SCXW86518476 BCX0"> <ul class="BulletListStyle1 SCXW86518476 BCX0" role="list"> <li class="OutlineElement Ltr SCXW86518476 BCX0" role="listitem" aria-setsize="-1" data-leveltext="" data-font="Symbol" data-listid="14" data-list-defn-props= "{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="2" data-aria-level="1"> <p class="Paragraph SCXW86518476 BCX0"><span class= "NormalTextRun SCXW86518476 BCX0">How VBA compares with Power Query </span></p> </li> </ul> </div> <div class="ListContainerWrapper SCXW86518476 BCX0"> <ul class="BulletListStyle1 SCXW86518476 BCX0" role="list"> <li class="OutlineElement Ltr SCXW86518476 BCX0" role="listitem" aria-setsize="-1" data-leveltext="" data-font="Symbol" data-listid="14" data-list-defn-props= "{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="3" data-aria-level="1"> <p class="Paragraph SCXW86518476 BCX0"><span class= "TextRun SCXW86518476 BCX0" lang="EN-US" xml:lang="EN-US" data-contrast="auto"><span class= "NormalTextRun SCXW86518476 BCX0">The limits of Power Query for in-</span><span class= "NormalTextRun SCXW86518476 BCX0">situ </span><span class= "NormalTextRun SCXW86518476 BCX0">data</span><span class= "NormalTextRun SCXW86518476 BCX0"> fixes </span></span></p> </li> </ul> </div> <div class="ListContainerWrapper SCXW86518476 BCX0"> <ul class="BulletListStyle1 SCXW86518476 BCX0" role="list"> <li class="OutlineElement Ltr SCXW86518476 BCX0" role="listitem" aria-setsize="-1" data-leveltext="" data-font="Symbol" data-listid="14" data-list-defn-props= "{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="4" data-aria-level="1"> <p class="Paragraph SCXW86518476 BCX0"><span class= "NormalTextRun SCXW86518476 BCX0">How AI can help write and debug VBA code </span></p> </li> </ul> </div> <div class="ListContainerWrapper SCXW86518476 BCX0"> <ul class="BulletListStyle1 SCXW86518476 BCX0" role="list"> <li class="OutlineElement Ltr SCXW86518476 BCX0" role="listitem" aria-setsize="-1" data-leveltext="" data-font="Symbol" data-listid="14" data-list-defn-props= "{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="5" data-aria-level="1"> <p class="Paragraph SCXW86518476 BCX0"><span class= "NormalTextRun SCXW86518476 BCX0">How to automate data cleansing tasks in Excel </span></p> </li> </ul> </div> <div class="ListContainerWrapper SCXW86518476 BCX0"> <ul class="BulletListStyle1 SCXW86518476 BCX0" role="list"> <li class="OutlineElement Ltr SCXW86518476 BCX0" role="listitem" aria-setsize="-1" data-leveltext="" data-font="Symbol" data-listid="14" data-list-defn-props= "{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="6" data-aria-level="1"> <p class="Paragraph SCXW86518476 BCX0"><span class= "NormalTextRun SCXW86518476 BCX0">Why VBA is a useful entry point into programming </span></p> </li> </ul> </div> <div class="ListContainerWrapper SCXW86518476 BCX0"> <ul class="BulletListStyle1 SCXW86518476 BCX0" role="list"> <li class="OutlineElement Ltr SCXW86518476 BCX0" role="listitem" aria-setsize="-1" data-leveltext="" data-font="Symbol" data-listid="14" data-list-defn-props= "{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="7" data-aria-level="1"> <p class="Paragraph SCXW86518476 BCX0"><span class= "NormalTextRun SCXW86518476 BCX0">How to store macros in the personal macro workbook </span></p> </li> </ul> </div> <div class="ListContainerWrapper SCXW86518476 BCX0"> <ul class="BulletListStyle1 SCXW86518476 BCX0" role="list"> <li class="OutlineElement Ltr SCXW86518476 BCX0" role="listitem" aria-setsize="-1" data-leveltext="" data-font="Symbol" data-listid="14" data-list-defn-props= "{"335552541":1,"335559683":0,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" data-aria-posinset="8" data-aria-level="1"> <p class="Paragraph SCXW86518476 BCX0"><span class= "NormalTextRun SCXW86518476 BCX0">Ways to run macros from the quick access toolbar</span><span class="EOP SCXW86518476 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":240}"> </span></p> </li> </ul> </div> <div class="OutlineElement Ltr SCXW86518476 BCX0"> <p class="Paragraph SCXW86518476 BCX0"><span class= "TextRun SCXW86518476 BCX0" lang="EN-US" xml:lang="EN-US" data-contrast="auto"><span class= "NormalTextRun SCXW86518476 BCX0">Listen now</span><span class= "NormalTextRun SCXW86518476 BCX0"> to </span><span class= "NormalTextRun SCXW86518476 BCX0">help </span><span class= "NormalTextRun SCXW86518476 BCX0">level</span><span class= "NormalTextRun SCXW86518476 BCX0"> </span><span class= "NormalTextRun SCXW86518476 BCX0">up</span><span class= "NormalTextRun SCXW86518476 BCX0"> </span><span class= "NormalTextRun SCXW86518476 BCX0">your Excel skills</span><span class= "NormalTextRun SCXW86518476 BCX0"> with macros. </span></span></p> </div> <div class="OutlineElement Ltr SCXW86518476 BCX0"> <p class="Paragraph SCXW86518476 BCX0"><span class= "NormalTextRun SCXW86518476 BCX0">Host:</span><span class= "NormalTextRun SCXW86518476 BCX0"> Neale Blackwood CPA. He has more than 20 years of experience as a Microsoft Excel educator and is the author of more than 200 </span><a class= "Hyperlink SCXW86518476 BCX0" href= "https://intheblack.cpaaustralia.com.au/topic/excel" target= "_blank" rel="noreferrer noopener"><span class= "NormalTextRun SCXW86518476 BCX0" data-ccp-charstyle= "Hyperlink">INTHEBLACK</span></a><span class= "NormalTextRun SCXW86518476 BCX0"> articles as well as a book, </span><span class= "NormalTextRun SCXW86518476 BCX0">Advanced Excel Reporting for Management Accountants</span><span class= "NormalTextRun SCXW86518476 BCX0">.</span><span class= "EOP SCXW86518476 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> <div class="OutlineElement Ltr SCXW86518476 BCX0"> <p class="Paragraph SCXW86518476 BCX0"><span class= "NormalTextRun SCXW75023298 BCX0">For more,</span><span class= "NormalTextRun SCXW75023298 BCX0"> </span><a class= "Hyperlink SCXW75023298 BCX0" href="https://youtu.be/nR_fI9IFLKA" target="_blank" rel="noreferrer noopener"><span class= "TextRun Underlined SCXW75023298 BCX0" lang="EN-AU" xml:lang= "EN-AU" data-contrast="none"><span class= "NormalTextRun SCXW75023298 BCX0" data-ccp-charstyle= "Hyperlink">check out the accompanying YouTube video </span><span class="NormalTextRun SCXW75023298 BCX0" data-ccp-charstyle="Hyperlink">of </span><span class= "NormalTextRun SCXW75023298 BCX0" data-ccp-charstyle= "Hyperlink">this episode</span></span></a><span class= "NormalTextRun SCXW75023298 BCX0">.</span><span class= "EOP SCXW75023298 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> </div> <div class="OutlineElement Ltr SCXW86518476 BCX0"> <p class="Paragraph SCXW86518476 BCX0"><span class= "TextRun SCXW86518476 BCX0" lang="EN-AU" xml:lang="EN-AU" data-contrast="auto"><span class= "NormalTextRun SCXW86518476 BCX0">R</span><span class= "NormalTextRun SCXW86518476 BCX0">ead </span><span class= "NormalTextRun SCXW86518476 BCX0">more of </span></span><a class="Hyperlink SCXW86518476 BCX0" href= "https://intheblack.cpaaustralia.com.au/contributors/neale-blackwood" target="_blank" rel="noreferrer noopener"><span class= "TextRun Underlined SCXW86518476 BCX0" lang="EN-AU" xml:lang= "EN-AU" data-contrast="auto"><span class= "NormalTextRun SCXW86518476 BCX0" data-ccp-charstyle= "Hyperlink">Neale's Excel articles </span><span class= "NormalTextRun SCXW86518476 BCX0" data-ccp-charstyle= "Hyperlink">on</span><span class="NormalTextRun SCXW86518476 BCX0" data-ccp-charstyle="Hyperlink"> INTHEBLACK</span><span class= "NormalTextRun SCXW86518476 BCX0" data-ccp-charstyle= "Hyperlink">.</span></span></a><span class= "NormalTextRun SCXW86518476 BCX0"> </span><span class= "EOP SCXW86518476 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"><br /> </span></p> </div> <div class="OutlineElement Ltr SCXW86518476 BCX0"> <p class="Paragraph SCXW86518476 BCX0"><span class= "NormalTextRun SCXW86518476 BCX0">Loving this content?</span> <span class="EOP SCXW86518476 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> <div class="OutlineElement Ltr SCXW86518476 BCX0"> <p class="Paragraph SCXW86518476 BCX0"><span class= "TextRun SCXW86518476 BCX0" lang="EN-AU" xml:lang="EN-AU" data-contrast="none"><span class= "NormalTextRun SCXW86518476 BCX0">D</span><span class= "NormalTextRun SCXW86518476 BCX0">on</span><span class= "NormalTextRun SCXW86518476 BCX0">'</span><span class= "NormalTextRun SCXW86518476 BCX0">t</span><span class= "NormalTextRun SCXW86518476 BCX0"> forget to subscribe to EXCEL TIPS and share this episode with your colleagues and friends in the business community</span><span class= "NormalTextRun SCXW86518476 BCX0">. </span></span></p> </div> <div class="OutlineElement Ltr SCXW86518476 BCX0"> <p class="Paragraph SCXW86518476 BCX0"><span class= "TextRun SCXW86518476 BCX0" lang="EN-AU" xml:lang="EN-AU" data-contrast="auto"><span class= "NormalTextRun SCXW86518476 BCX0">Would you like to listen to more Excel Tips </span><span class= "NormalTextRun SCXW86518476 BCX0">and other CPA Australia podcasts like INTHEBLACK and With Interest</span><span class= "NormalTextRun SCXW86518476 BCX0">? </span></span></p> </div> <div class="OutlineElement Ltr SCXW86518476 BCX0"> <p class="Paragraph SCXW86518476 BCX0"><span class= "NormalTextRun SCXW86518476 BCX0">Head to </span><a class= "Hyperlink SCXW86518476 BCX0" href= "https://www.youtube.com/@CPAaustralia/podcasts" target="_blank" rel="noreferrer noopener"><span class= "NormalTextRun SCXW86518476 BCX0" data-ccp-charstyle= "Hyperlink">CPA Australia's YouTube channel</span></a><span class= "NormalTextRun SCXW86518476 BCX0">.</span><span class= "EOP SCXW86518476 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> <div class="OutlineElement Ltr SCXW86518476 BCX0"> <p class="Paragraph SCXW86518476 BCX0"><span class= "TextRun SCXW86518476 BCX0" lang="EN-AU" xml:lang="EN-AU" data-contrast="auto"><span class= "NormalTextRun SCXW86518476 BCX0">And </span><span class= "NormalTextRun SCXW86518476 BCX0">don't</span><span class= "NormalTextRun SCXW86518476 BCX0"> forget to subscribe to the channel. </span></span></p> </div> <div class="OutlineElement Ltr SCXW86518476 BCX0"> <p class="Paragraph SCXW86518476 BCX0"><span class= "NormalTextRun SCXW86518476 BCX0">You can </span><a class= "Hyperlink SCXW86518476 BCX0" href= "https://apps.cpaaustralia.com.au/find-a-cpa/" target="_blank" rel= "noreferrer noopener"><span class="NormalTextRun SCXW86518476 BCX0" data-ccp-charstyle="Hyperlink">find a CPA at our custom portal</span></a><span class= "NormalTextRun SCXW86518476 BCX0"> on the CPA Australia website.</span><span class="EOP SCXW86518476 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> <div class="OutlineElement Ltr SCXW86518476 BCX0"> <p class="Paragraph SCXW86518476 BCX0"><span class= "NormalTextRun SCXW86518476 BCX0">CPA Australia </span><a class="Hyperlink SCXW86518476 BCX0" href= "https://www.cpaaustralia.com.au/tools-and-resources/podcasts" target="_blank" rel="noreferrer noopener"><span class= "NormalTextRun SCXW86518476 BCX0" data-ccp-charstyle= "Hyperlink">publishes four podcasts</span></a><span class= "TextRun SCXW86518476 BCX0" lang="EN-AU" xml:lang="EN-AU" data-contrast="auto"><span class= "NormalTextRun SCXW86518476 BCX0">, providing commentary and thought leadership across business, </span><span class= "NormalTextRun SCXW86518476 BCX0">finance</span><span class= "NormalTextRun SCXW86518476 BCX0"> and accounting:</span></span><span class="EOP SCXW86518476 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> <div class="OutlineElement Ltr SCXW86518476 BCX0"> <p class="Paragraph SCXW86518476 BCX0"><a class= "Hyperlink SCXW86518476 BCX0" href= "https://www.cpaaustralia.com.au/tools-and-resources/podcasts/with-interest" target="_blank" rel="noreferrer noopener"><span class= "NormalTextRun SCXW86518476 BCX0" data-ccp-charstyle= "Hyperlink">With Interest</span></a><span class= "EOP SCXW86518476 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> <div class="OutlineElement Ltr SCXW86518476 BCX0"> <p class="Paragraph SCXW86518476 BCX0"><a class= "Hyperlink SCXW86518476 BCX0" href= "https://www.cpaaustralia.com.au/tools-and-resources/podcasts/intheblack" target="_blank" rel="noreferrer noopener"><span class= "NormalTextRun SCXW86518476 BCX0" data-ccp-charstyle= "Hyperlink">INTHEBLACK</span></a><span class= "EOP SCXW86518476 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> <div class="OutlineElement Ltr SCXW86518476 BCX0"> <p class="Paragraph SCXW86518476 BCX0"><a class= "Hyperlink SCXW86518476 BCX0" href= "https://www.cpaaustralia.com.au/tools-and-resources/podcasts/excel-tips" target="_blank" rel="noreferrer noopener"><span class= "NormalTextRun SCXW86518476 BCX0" data-ccp-charstyle= "Hyperlink">Excel Tips</span></a><span class= "EOP SCXW86518476 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> <div class="OutlineElement Ltr SCXW86518476 BCX0"> <p class="Paragraph SCXW86518476 BCX0"><a class= "Hyperlink SCXW86518476 BCX0" href= "https://www.cpaaustralia.com.au/tools-and-resources/podcasts/intheblack-outloud" target="_blank" rel="noreferrer noopener"><span class= "NormalTextRun SCXW86518476 BCX0" data-ccp-charstyle= "Hyperlink">INTHEBLACK Out Loud</span></a><span class= "EOP SCXW86518476 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> <div class="OutlineElement Ltr SCXW86518476 BCX0"> <p class="Paragraph SCXW86518476 BCX0"><span class= "NormalTextRun SCXW86518476 BCX0">Search for them in your podcast platform.</span><span class="EOP SCXW86518476 BCX0" data-ccp-props= "{"201341983":0,"335559739":0,"335559740":276}"> </span></p> </div> <div class="OutlineElement Ltr SCXW86518476 BCX0"> <p class="Paragraph SCXW86518476 BCX0"><span class= "NormalTextRun SCXW86518476 BCX0">You can email the podcast team at </span><a class="Hyperlink SCXW86518476 BCX0" href= "mailto:podcasts@cpaaustralia.com.au" target="_blank" rel= "noreferrer noopener"><span class="NormalTextRun SCXW86518476 BCX0" data-ccp-charstyle= "Hyperlink">podcasts@cpaaustralia.com.au</span></a></p> </div>

50 total episodes available

Similar Podcasts

Discover related shows you might enjoy

INTHEBLACK Out Loud

CPA Australia

INTHEBLACK

CPA Australia

With Interest

CPA Australia

The Fin

Australian Financial Review

If You're Listening

ABC Australia

The AI Breakdown: Daily Artificial Intelligence News and Discussions

Nathaniel Whittemore

Chanticleer

Australian Financial Review

Economist Podcasts

The Economist

The Money

ABC Australia

ABC News Daily

ABC Australia

Relax with Excel

Excel Training 101

Mamamia Out Loud

Mamamia Podcasts

5 in 5 with ANZ

ANZ

Gadget Lab: Weekly Tech News from WIRED

WIRED

The McKinsey Podcast

McKinsey & Company

Deep-dive analytics for Excel Tips

Frequently asked questions

Have a different question and can't find the answer you're looking for? Reach out to our support team by sending us an email and we'll get back to you as soon as we can.

What is Excel Tips?: 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.
How often does this podcast release new episodes?: This podcast updates bi-weekly.
Where can I listen to this podcast?: This podcast is available on 10 platforms including Apple Podcasts, Spotify, and more. You can also use the RSS feed directly.
Does this podcast accept guests?: No, this podcast does not typically feature guests.

Legal Disclaimer

Pod Engine is not affiliated with, endorsed by, or officially connected with any of the podcasts displayed on this platform. We operate independently as a podcast discovery and analytics service.

All podcast artwork, thumbnails, and content displayed on this page are the property of their respective owners and are protected by applicable copyright laws. This includes, but is not limited to, podcast cover art, episode artwork, show descriptions, episode titles, transcripts, audio snippets, and any other content originating from the podcast creators or their licensors.

We display this content under fair use principles and/or implied license for the purpose of podcast discovery, information, and commentary. We make no claim of ownership over any podcast content, artwork, or related materials shown on this platform. All trademarks, service marks, and trade names are the property of their respective owners.

While we strive to ensure all content usage is properly authorized, if you are a rights holder and believe your content is being used inappropriately or without proper authorization, please contact us immediately at hey@podengine.ai for prompt review and appropriate action, which may include content removal or proper attribution.

By accessing and using this platform, you acknowledge and agree to respect all applicable copyright laws and intellectual property rights of content owners. Any unauthorized reproduction, distribution, or commercial use of the content displayed on this platform is strictly prohibited.