
Excel Tips
CPA Australia
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.
Categories: Education
Listen to the last episode:
Ready to unlock a hidden gem in your Microsoft Excel subscription?
In this episode you’ll discover the power of checkboxes with practical examples to explore how this new function can streamline your workflow.
This includes how to use TRUE/FALSE values in formulas and conditional formatting to dynamically control calculations and visuals. Learn from examples such as inflation adjustments in a budget model and applying a strikethrough format to a to-do list.
Additionally, gain insight into how checkboxes are used in the logical test of the IF function and learn essential keyboard shortcuts for an efficiency boost.
For fast reference, use the episode timestamps:
- 00:21 Introducing the new checkbox feature
-
01:03 How checkboxes work in Excel
-
02:35 Using checkboxes in budget models
-
03:23 Keyboard shortcuts for checkboxes
-
04:19 Protecting checkbox cells
-
04:50 Checkboxes with the IF function
-
05:32 Using checkboxes for task management
-
07:55 Checkboxes in formatted tables
-
09:20 Conclusion and further resources
You’ll find the new checkboxes function in the insert ribbon between illustrations and charts in the subscription version.
Level up your Excel game by tuning in now.
Host: 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.
CPA Australia publishes four podcasts, providing commentary and thought leadership across business, finance, and accounting:
Search for them in your podcast platform.
You can email the podcast team at podcasts@cpaaustralia.com.au
Previous episodes
-
32 - New tool explained: boost your efficiency with checkboxes Sun, 02 Feb 2025 - 0h
-
31 - Improve your PDF data handling with Power Query Thu, 02 Jan 2025 - 0h
-
30 - Handy hack to create timeline charts Sun, 01 Dec 2024 - 0h
-
29 - Master calendar creation in Excel Thu, 31 Oct 2024 - 0h
-
28 - How to add a user interaction into Power Query Mon, 30 Sep 2024 - 0h
-
27 - Learn a smart way to hide blank or zero rows Sat, 31 Aug 2024 - 0h
-
26 - The power of heat maps for sales and costs data Thu, 01 Aug 2024 - 0h
-
25 - 3 powerful macros to streamline your workflow Sun, 30 Jun 2024 - 0h
-
24 - Level up your custom functions skills Mon, 03 Jun 2024 - 0h
-
23 - How to create a dashboard using Excel’s dynamic arrays Wed, 01 May 2024 - 0h
-
22 - How to automate report building in Excel (part 2) Tue, 02 Apr 2024 - 0h
-
21 - How to automate report building in Excel Thu, 29 Feb 2024 - 0h
-
20 - Master the latest Excel changes: your ultimate guide Thu, 01 Feb 2024 - 0h
-
19 - How to master using different Excel techniques together Thu, 04 Jan 2024 - 0h
-
18 - Top Excel tips for your first 100 days in a new job Fri, 01 Dec 2023 - 0h
-
17 - How to create improved data visualisations in Excel Wed, 01 Nov 2023 - 0h
-
16 - Master 10 new and revamped Excel features Tue, 03 Oct 2023 - 0h
-
15 - Boost your skills with tips for Excel function updates Fri, 01 Sep 2023 - 0h
-
14 - Unlock 14 expert tips for Excel formulas Tue, 01 Aug 2023 - 0h
-
13 - Why Excel can be a university student’s secret weapon Sun, 02 Jul 2023 - 0h
-
12 - 22 Excel shortcuts to supercharge your efficiency Thu, 01 Jun 2023 - 0h
-
11 - Excel and ChatGPT Thu, 04 May 2023 - 0h
-
10 - Learn Excel’s built-in artificial intelligence feature Thu, 06 Apr 2023 - 0h
-
9 - How to use custom functions without macros Thu, 23 Mar 2023 - 0h
-
8 - How to do dynamic arrays (subscription version) Thu, 16 Mar 2023 - 0h
-
7 - How to create vertical lines in line charts Thu, 09 Mar 2023 - 0h
-
6 - Excel tips: how to use the new data types feature Thu, 02 Mar 2023 - 0h
-
5 - Excel tips: how to work with dates and days Mon, 20 Feb 2023 - 0h
-
4 - Excel tips: how to use Goal Seek Mon, 13 Feb 2023 - 0h
-
3 - Excel tips: how to improve your formatting Mon, 06 Feb 2023 - 0h
-
2 - Excel Tips: New text functions for Excel Tue, 31 Jan 2023 - 0h
-
1 - EXCEL TIPS, coming soon. Fri, 13 Jan 2023