Excel Checkboxes Updated: Boost Your Efficiency with New Features 🚀

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
https://efficiency365.com/wp-content/uploads/2023/11/Excel-Checkboxes-Sample-File.xlsx


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

Related videos
Conditional formatting https://youtu.be/BlYCdMHAiAE
How to enter and edit Excel Formulas - Back to Basics - https://youtu.be/rtDlORLmjlE
Excel Green Marks - Error Checking - Best Practices - https://youtu.be/XeLtlzd9lRY
Excel Best Practices - Part 1 of 3 - Data Management - https://youtu.be/rr_1ha6g6lc
Excel Best Practices - Part 2 of 3 – Formulas - https://youtu.be/kz_zAvMINAk
Excel Best Practices - Part 3 of 3 - Analytics - https://youtu.be/JNR5yx_Pg4A
10 Excel Settings You Must CHANGE! - https://youtu.be/vXrrXdKyJFk
Automatic data clean up with Excel Flash Fill - https://youtu.be/N3p_x_lXT_c
Instant Excel Audit, Comparison and Analysis - Inquire - https://youtu.be/cDdvUZxOUis
Six powerful Excel Navigation Shortcuts - https://youtu.be/bR-yMbGPq50
Handle millions of rows in Excel – Slow to fast - https://youtu.be/93h7rRsLF7Y
Convert crosstab to tabular – Unpivot - Excel Power Query - https://youtu.be/mTtOtZH-nNM

#efficiency365 #excel #exceltutorial #checkbox

Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster

https://s.efficiency365.com/bk

Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
https://hi.switchy.io/mms

Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - https://s.efficiency365.com/ptyt
Excel to Power BI - https://swiy.io/uxlpbi

Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: https://efficiency365.com/blog

LinkedIn : https://www.linkedin.com/in/nitinparanjape/
Twitter : https://twitter.com/drnitinp

Production
--------------------
Music and Effects: https://elements.envato.com/
Created using Adobe Premiere: https://www.adobe.com/in/creativecloud/video.html
AI based captions: https://videoindexer.ai (Microsoft service)