Channel | Publish Date | Thumbnail & View Count | Actions |
---|---|---|---|
| 2023-11-08 18:45:02 | ![]() 101,166 Views |
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.