How to create interactive check boxes in Excel, which can be linked to formulas, charts, conditional formatting and other features. Check boxes can be a great way to make your spreadsheets more visually appealing, user-friendly and efficient, allowing users to quickly select options and see the results of their selections in real-time. We'll walk you through the process step-by-step.
🔻 DOWNLOAD EXCEL FILE HERE: https://www.myonlinetraininghub.com/interactive-excel-check-boxes
🎓 LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: https://www.linkedin.com/in/myndatreacy/
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 Interactive Excel Reports with Check Boxes
0:48 Check Box Task List
3:02 Status Bar Linked to Task List
4:48 IF formula linked to Check Box
6:37 Conditonal Formatting linked to Check Boxes
9:58 Charts Linked to Check Boxes