MENU

Fun & Interesting

Make a Project Tracker with Excel’s NEW Checkbox Feature

Kenji Explains 105,483 1 year ago
Video Not Working? Fix It Now

New checkbox feature in Excel full tutorial. 🚀 10x your Excel with my course: https://www.careerprinciples.com/courses/excel-for-business-finance Link for Microsoft's 365 Insider Program: https://insider.microsoft365.com/en-us/join/windows In this tutorial, you'll learn how to add a checkbox using Excel's new checkbox feature located in cell controls under the insert tab. You'll also learn to add a checkbox using an alternate method by going to the developer tab and inserting a checkbox from form control. We'll also cover all of the checkbox functionality such as check and uncheck shortcuts, changing checkbox colors, and more. Then, you'll learn to make a progress bar. This will involve the COUNTIF formula and the data bar feature from conditional formatting. Finally, you'll make another conditional formatting for a strikethrough feature to showcase when a project is finished. As soon as you tick the final checkbox, the project name will be crossed out. By the end of the video, you'll have a dynamic project management dashboard in Excel! LEARN: 🔥Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics 📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance 🚀 All our courses: https://www.careerprinciples.com/all-courses SOCIALS: 📸 Instagram - https://www.instagram.com/careerprinciples/?hl=en 🤳 TikTok - https://www.tiktok.com/@career_principles 🧑‍💻 LinkedIn - https://www.linkedin.com/company/careerprinciples/ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00​ -​ New Checkbox Feature in Excel 1:40​ - Alternate Checkbox Feature in Excel 4:03​ - Dynamic Progress Bar with Checkbox 8:16​ - Strikethrough to cross out finished tasks

Comment