Download the featured file here: [ Ссылка ]

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)

свернуть