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
Handy new Excel features are added .css-1t8gq41{border:none;background-image:none;background-color:transparent;box-shadow:none;color:#2F3133;cursor:pointer;font-size:inherit;padding:0;-webkit-text-decoration:inherit;text-decoration:inherit;width:-webkit-max-content;width:-moz-max-content;width:max-content;}.css-1t8gq41:hover,.css-1t8gq41:focus{-webkit-text-decoration:inherit;text-decoration:inherit;}
Did you know that you can transform the way
In this episode of Excel Tips, we explore the latest Excel ...
In this third
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.
Popular Podcasts
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.
My Favorite Murder is a true crime comedy podcast hosted by Karen Kilgariff and Georgia Hardstark. Each week, Karen and Georgia share compelling true crimes and hometown stories from friends and listeners. Since MFM launched in January of 2016, Karen and Georgia have shared their lifelong interest in true crime and have covered stories of infamous serial killers like the Night Stalker, mysterious cold cases, captivating cults, incredible survivor stories and important events from history like the Tulsa race massacre of 1921. My Favorite Murder is part of the Exactly Right podcast network that provides a platform for bold, creative voices to bring to life provocative, entertaining and relatable stories for audiences everywhere. The Exactly Right roster of podcasts covers a variety of topics including historic true crime, comedic interviews and news, science, pop culture and more. Podcasts on the network include Buried Bones with Kate Winkler Dawson and Paul Holes, That's Messed Up: An SVU Podcast, This Podcast Will Kill You, Bananas and more.
Current and classic episodes, featuring compelling true-crime mysteries, powerful documentaries and in-depth investigations. Follow now to get the latest episodes of Dateline NBC completely free, or subscribe to Dateline Premium for ad-free listening and exclusive bonus content: DatelinePremium.com
The World's Most Dangerous Morning Show, The Breakfast Club, With DJ Envy, Jess Hilarious, And Charlamagne Tha God!
The official podcast of comedian Joe Rogan.