New tool explained: boost your efficiency with checkboxes
Excel Tips2 Feb 2025

New tool explained: boost your efficiency with checkboxes

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

Episoder(45)

Master your messy data

Master your messy data

Messy, unstructured data.  It slows reporting, creates errors, and tests everyone's patience. Right?  This episode breaks down how the new Regular Expressions (REGEX) work and how they help you fi...

2 Mar 6min

Build Better Excel Models

Build Better Excel Models

You may know The Seven Habits of Highly Effective People as a cornerstone of modern business thinking.  But what happens when those same principles from this book are applied to one of the most wide...

2 Feb 12min

Smarter, faster, easier: Here's what's new in Excel

Smarter, faster, easier: Here's what's new in Excel

Excel Tips Summer Season Encore presentation from October 2025 In this episode of Excel Tips, we explore the latest Excel updates that can help to boost productivity and simplify workflows for finance...

1 Jan 14min

Unlock 7 underused Excel features you still need today

Unlock 7 underused Excel features you still need today

Handy new Excel features are added regularly – but some "older" functions are still particularly useful to your workflows. Smart power users know these older functions and their value – which is why...

1 Des 202516min

How to simplify complex calculations with custom functions

How to simplify complex calculations with custom functions

Did you know that you can transform the way you can build models, reports and schedules with custom functions?  This episode guides you on how they make complex calculations cleaner and easier to ma...

3 Nov 20258min

Smarter, faster, easier: Here's what's new in Excel

Smarter, faster, easier: Here's what's new in Excel

In this episode of Excel Tips, we explore the latest Excel updates that can help to boost productivity and simplify workflows for finance and accounting professionals. Listeners will learn: How ...

1 Okt 202513min

Unleash the power of Python in Excel

Unleash the power of Python in Excel

In this third and final episode of a three-part series, we explore how the integration of Python unlocks advanced tools for analysis, automation and visualisation. Listeners will learn: How Py...

1 Sep 20259min

Python in Excel: Practical applications

Python in Excel: Practical applications

In this second episode of a three-part series, you will build on the basics from part one to gain a clear understanding of how to use Python directly within Excel cells. This includes using the Pa...

1 Aug 202511min

Populært innen Business og økonomi

lydartikler-fra-aftenposten
stopp-verden
dine-penger-pengeradet
e24-podden
rss-penger-polser-og-politikk
rss-borsmorgen-okonominyhetene
livet-pa-veien-med-jan-erik-larssen
utbytte
pengesnakk
tid-er-penger-en-podcast-med-peter-warren
pengepodden-2
stormkast-med-valebrokk-stordalen
morgenkaffen-med-finansavisen
rss-sunn-okonomi
liberal-halvtime
rss-politisk-preik
finansredaksjonen
rss-markedspuls-2
lederpodden
okonomiamatorene