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
Need to turn stock market data into smart, professional reports? Discover how to use Excel’s .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;}
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...
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
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
Starting a new role in accounting and finance? We understand it can be stressful as you try to make a good first impression.
This Excel Tips episode is specially designed with your first 100 days in mind, to help you hit the ground running.
For fas...
Do you want an Excel edge?
Whether you're a seasoned pro or starting out, master these 10 new and revamped features to help streamline your workflow and boost your spreadsheet efficiency.
For fast access, use these timestamps:
Popular Podcasts
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
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.
Join me on this podcast as I navigate the murky waters of human behavior, current events, and personal anecdotes through in-depth interviews with incredible people—all served with a generous helping of sarcasm and satire. After years as a forensic and clinical psychologist, I offer a unique interview style and a low tolerance for bullshit, quickly steering conversations toward depth and darkness. I honor the seriousness while also appreciating wit. I’m your guide through the twisted labyrinth of the human psyche, armed with dark humor and biting wit.
Listen to 'The Bobby Bones Show' by downloading the daily full replay.
The Clay Travis and Buck Sexton Show. Clay Travis and Buck Sexton tackle the biggest stories in news, politics and current events with intelligence and humor. From the border crisis, to the madness of cancel culture and far-left missteps, Clay and Buck guide listeners through the latest headlines and hot topics with fun and entertaining conversations and opinions.