The new Excel checkboxes are FINALLY here and they are better than ever. They are automatically inserted inside cells and assigned a value depending on whether its checked or not. This allows us to write formulas referencing the checkboxes, visualize the checkboxes, create interactive dashboards containing checkboxes, and SO much more.

In this video, I’ll show you step-by-step how to insert multiple checkboxes, how to format the checkboxes, how to add conditional formatting to checked tasks in a to-do list, how to count the number of checked checkboxes, how to calculate the percent of checked checkboxes, how to visualize the number of checked checkboxes using data bars, and finally, how to delete the checkboxes.

📖RESOURCES
- Download the workbook and follow along: https://excel-dictionary.com/pages/yo...

🤓SHOP EXCEL DICTIONARY
- COURSES: https://excel-dictionary.com/collecti...
-GUIDES: https://excel-dictionary.com/collecti...
-MERCH: https://excel-dictionary.com/collecti...
-TEMPLATES: https://excel-dictionary.com/collecti...

📩NEWSLETTER
-Unlock the full potential of Excel and PowerPoint with expert tips delivered to your inbox each week: https://www.excel-dictionary.com/subs...

📺SUBSCRIBE
-Subscribe to never miss a video:    / exceldictionary  

🕰️TIMESTAMPS
‘0:00 Intro
‘0:29 Insert Multiple Checkboxes
‘0:45 Format The Checkboxes
‘0:59 Checkbox Logic Explained
‘1:20 Add Conditional Formatting to Checked Tasks
‘2:03 Count the Number of Checkboxes Checked
‘2:38 Calculate Percent of Checkboxes Checked
‘3:08 Visualize Checkboxes Checked with Data Bars
‘4:14 How to Delete Checkboxes
4:23 Wrap up
#excel #exceltips