Uploaded November 2023 | Updated September 2026, 2 days ago
Join 500,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-courses
Excel checkboxes are finally here, and they are a game-changer for your spreadsheets! Forget the old, clunky form controls—these new checkboxes live inside the cell and work perfectly with formulas.
In this tutorial, I show you how to master the new Excel checkbox feature from scratch. We’ll build a dynamic "Learning Tracker" that automatically updates as you check off tasks.
⬇️ Download the file: xelplus.com/excel-checkboxes/#download-section
What you’ll learn in this video:
✅ The Basics: How to insert and format the new cell-based checkboxes.
✅ Dynamic Counting: Use COUNTIF to track completed vs. total tasks.
✅ Filtering: Create an "Outstanding Tasks" list that updates automatically.
✅ Conditional Formatting: Automatically cross off (strikethrough) and highlight rows.
✅ The Pro Secret: How to create an automatic, permanent timestamp when a box is checked.
Whether you're building a simple checklist or a complex project tracker, these techniques will make your Excel workbooks look and feel like professional apps.
Availability: Excel for Office 365.
🌍 My Online Courses ► xelplus.com/courses
00:00 Why Excel's new checkboxes are a game-changer
00:19 New Checkboxes in Excel Basics
01:27 How to insert and toggle checkboxes
03:23 How to count checked vs. unchecked boxes
06:03 Linking checkbox data to shapes and dashboards
07:05 Creating a "Look Forward" list with the FILTER function
08:39 Using Checkboxes with Conditional Formatting (Strikethrough)
11:02 MASTER TIP: Automatic Timestamps (Iterative Calculation)
14:00 Wrap Up
➡️ Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
🎬 LINKS to related videos:
🆕 Best NEW Excel Features EVERYONE Needs: youtu.be/UnU81ITTsHU
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
🎥 RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
🚩Let’s connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus
👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel
Join 500,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-courses
Excel checkboxes are finally here, and they are a game-changer for your spreadsheets! Forget the old, clunky form controls—these new checkboxes live inside the cell and work perfectly with formulas.
In this tutorial, I show you how to master the new Excel checkbox feature from scratch. We’ll build a dynamic "Learning Tracker" that automatically updates as you check off tasks.
⬇️ Download the file: xelplus.com/excel-checkboxes/#download-section
What you’ll learn in this video:
✅ The Basics: How to insert and format the new cell-based checkboxes.
✅ Dynamic Counting: Use COUNTIF to track completed vs. total tasks.
✅ Filtering: Create an "Outstanding Tasks" list that updates automatically.
✅ Conditional Formatting: Automatically cross off (strikethrough) and highlight rows.
✅ The Pro Secret: How to create an automatic, permanent timestamp when a box is checked.
Whether you're building a simple checklist or a complex project tracker, these techniques will make your Excel workbooks look and feel like professional apps.
Availability: Excel for Office 365.
🌍 My Online Courses ► xelplus.com/courses
00:00 Why Excel's new checkboxes are a game-changer
00:19 New Checkboxes in Excel Basics
01:27 How to insert and toggle checkboxes
03:23 How to count checked vs. unchecked boxes
06:03 Linking checkbox data to shapes and dashboards
07:05 Creating a "Look Forward" list with the FILTER function
08:39 Using Checkboxes with Conditional Formatting (Strikethrough)
11:02 MASTER TIP: Automatic Timestamps (Iterative Calculation)
14:00 Wrap Up
➡️ Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
🎬 LINKS to related videos:
🆕 Best NEW Excel Features EVERYONE Needs: youtu.be/UnU81ITTsHU
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
🎥 RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
🚩Let’s connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus
👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel
