Checkboxes in Excel have been there for a long time. However, in Oct 2023, Microsoft introduced a simpler and more elegant way to add checkboxes right within Excel cells. Learn how to use the new and the OLD checkboxes. More importantly, learn WHEN to use the checkboxes. Three scenarios are covered – checklists, interactive business models and comparisons.
Contents
Download sample file
Contents
- Intro – 00:00
- The old checkbox (form controls) – 01:26
- How to use the new checkbox – 02:54
- How to add the old checkbox – 03:20
- Clearing checkboxes – 04:10
- Checklists – 04:37
- Playing with AND / OR / COUNTIF functions – 05:21
- Using checkboxes for comparisons – 06:19
- Business models using checkboxes – 09:15
Related videos
Conditional formatting
How to enter and edit Excel Formulas – Back to Basics
Excel Green Marks – Error Checking – Best Practices
Excel Best Practices – Part 1 of 3 – Data Management
Excel Best Practices – Part 2 of 3 – Formulas
Excel Best Practices – Part 3 of 3 – Analytics
10 Excel Settings You Must CHANGE!
Automatic data clean up with Excel Flash Fill
Instant Excel Audit, Comparison and Analysis – Inquire
Six powerful Excel Navigation Shortcuts
