fbpx

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.

New Checkboxes In Excel & It's Use cases | Efficiency 365

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

Everything About Conditional formatting in MS Excel | Efficiency 365

How to enter and edit Excel Formulas – Back to Basics

How to enter and edit Excel Formulas - Back to Basics

Excel Green Marks – Error Checking – Best Practices

Excel Green Marks - Error Checking Best Practices - Operational Risk

Excel Best Practices – Part 1 of 3 – Data Management

Excel Best Practices - Data Management - Part 1 of 3 - 2023

Excel Best Practices – Part 2 of 3 – Formulas

Excel Best Practices - Part 2 of 3 - Formulas - 2023

Excel Best Practices – Part 3 of 3 – Analytics

Excel Best Practices - Part 3 of 3 - Analytics - 2023

10 Excel Settings You Must CHANGE!

10 Excel Settings You Must CHANGE! | Efficiency 365

Automatic data clean up with Excel Flash Fill

Automatic data clean up with Excel Flash Fill

Instant Excel Audit, Comparison and Analysis – Inquire

Instant Excel file Audit, Comparison and Analysis - Inquire - the hidden gem

Six powerful Excel Navigation Shortcuts

Six powerful Excel Navigation Shortcuts | Efficiency 365

Queries | Comments | Suggestions | Wish list