Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2023/04/Create-a-progress-tracker-with-check-boxes-in-Excel.xlsx

In this Microsoft Excel video tutorial, I show you how to create a progress tracker controlled with checkboxes in Excel. This progress tracker can be used to track the progress of a project or task, and it's easy to create!

00:00 Introduction
00:46 Track non-weighted project phases
00:50 Insert checkboxes
01:43 Link checkbox to cell to return TRUE or FALSE
02:42 Hide TRUE and FALSE values
03:18 Count checked checkboxes + calculate % checked
04:20 Create progress bars using conditional formatting
05:03 Create progress bar using a bar chart
07:37 Track weighted project phases (weighted by work hours)