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 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.
Episodes
In this second episode of a three-part series, you will
Unlock the potential of Python in Excel with this essential first episode in a three-part se...
Excel’s new functions, GROUPBY and PIVOTBY, offer a smarter...
Need to turn stock market data into smart, professional reports? Discover how to use Excel’s
The Pareto principle is a powerful concept for business.
What if you could seamlessly collect and analyse data right inside Excel?
Ready to unlock a hidden gem in your Microsoft Excel subscription?
Ever struggled to extract crucial financial
Excel doesn’t have a built-in timeline chart but we’ll show you how to create one. In this episode you’ll learn how using a scatter chart can help you build a timeline chart.
For easy reference, here are the episode timestamps:
- 0:17 - About timeline charts in Excel
- 1:33 - Hacking the scatter chart to make a timeline chart
Calendars are your go-to tool for planning. In this Excel Tips episode, you'll learn the steps to create a single-month calendar from scratch.
Discover how to combine advanced functions to build a two-dimensional calendar structure, and how to format your dates and highlight weekends and holidays.
You'll also gain knowledge of how to customise the calendar to fit your s...
Reports are crucial to your work, aren't they? Power Query is a valuable tool for importing many types of data into Excel to help you create these reports.
However, it does have limitations.
In this episode, you’ll learn how to address one of Power Query’s key shortcomings: user interactions.
By using staging queries, reference techniques and range ...
Looking to improve your report-building skills? If so, this is the episode for you.
Uncover tips on how to leverage multiple Excel features to create a system that effortlessly hides blank...
Looking for ways to gain deeper insights from your sales and costs data in Excel?
This episode explores the power of heat maps, a data visualisation technique often used for climate data, but equally effective for business analysis.
For fast access, use these timestamps:
- 0:15 – Using heat maps for sales and cost information.
There's a misconception that Excel macros are outdated or unnecessary. In this episode we set the record straight and explore their continued value.
Delve into three practical macros that can streamline various tasks in your Excel workflow.
More importantly, you’ll come away with the knowledge to decide when creating a macro makes sense for optimising your efficiency.
<...Tune in to discover how mastering custom functions can help simplify two complex issues with Excel formulas.
Improve your problem-solving skills by harnessing the power of custom functions. For fast access, use these timestamps:
- 0:20 - Custom functions, episode overview.
- 1:39 - Summing spill ranges.
- 2:58 - Using prefixes...
Do you want to improve your dashboard-creating skills in Excel? Look no further.
This episode has all the expert tips you need to know using dynamic arrays to create a dashboard.
Don’t miss this episode, the second in a three-part series that explains how you can use the power of dynamic arrays in report building. Learn how to review a report that’s using dynamic arrays to create an automated month and year-to-date report.
For fast access, use these timestamps:
Are you an accountant or finance professional looking to enhance your daily workflows?
Don’t miss this episode, which delves into the exciting capabilities of dynamic arrays, empowering you to effortlessly build automated reports.
For fast access, u...
For accounting and finance professionals, it’s vital that you keep up-to-date with changes to Microsoft Excel functionality.
This episode explains what you need to know, including the latest changes to three Excel functions, and opening and working with CSV files Read more
Do you want to improve your Excel skills in 2024? Start the new year on a positive note with these essential tips that can help you master a couple of Excel techniques together.
In this episode, we show you how to build custom lists and use range names.
Read more
Popular Podcasts
UConn basketball star Azzi Fudd brings her championship swag to iHeart Women’s Sports with Fudd Around and Find Out, a weekly podcast that takes fans along for the ride as Azzi spends her final year of college trying to reclaim the National Championship and prepare to be a first round WNBA draft pick. Ever wonder what it’s like to be a world-class athlete in the public spotlight while still managing schoolwork, friendships and family time? It’s time to Fudd Around and Find Out!
Does hearing about a true crime case always leave you scouring the internet for the truth behind the story? Dive into your next mystery with Crime Junkie. Every Monday, join your host Ashley Flowers as she unravels all the details of infamous and underreported true crime cases with her best friend Brit Prawat. From cold cases to missing persons and heroes in our community who seek justice, Crime Junkie is your destination for theories and stories you won’t hear anywhere else. Whether you're a seasoned true crime enthusiast or new to the genre, you'll find yourself on the edge of your seat awaiting a new episode every Monday. If you can never get enough true crime... Congratulations, you’ve found your people. Follow to join a community of Crime Junkies! Crime Junkie is presented by audiochuck Media Company.
The latest news in 4 minutes updated every hour, every day.
If you've ever wanted to know about champagne, satanism, the Stonewall Uprising, chaos theory, LSD, El Nino, true crime and Rosa Parks, then look no further. Josh and Chuck have you covered.
The World's Most Dangerous Morning Show, The Breakfast Club, With DJ Envy, Jess Hilarious, And Charlamagne Tha God!