fbpx
Site logo white shadow

New Checkboxes in Excel & It’s Use cases

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.

Download sample file

Contents

  1. Intro – 00:00
  2. The old checkbox (form controls) – 01:26
  3. How to use the new checkbox – 02:54
  4. How to add the old checkbox – 03:20
  5. Clearing checkboxes – 04:10
  6. Checklists – 04:37
  7. Playing with AND / OR / COUNTIF functions – 05:21
  8. Using checkboxes for comparisons – 06:19
  9. Business models using checkboxes – 09:15

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

Queries | Comments | Suggestions | Wish list

Subscribe to Blog

Join 1,758 other subscribers

Popular articles

Pivot Table Pro Course

Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.

Excel to Power BI Course

Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.