Make a Project Tracker with Excel’s NEW Checkbox Feature

Make a Project Tracker with Excel’s NEW Checkbox Feature

HomeOther ContentMake a Project Tracker with Excel’s NEW Checkbox Feature
ChannelPublish DateThumbnail & View CountActions
Channel Avatar Kenji Explains2023-11-08 18:45:02 Thumbnail
101,166 Views
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/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

Please take the opportunity to connect and share this video with your friends and family if you find it useful.