How to Make a Checklist in Excel

This video will present how to make a checklist in Excel, plus some pointers on integrating it with other spreadsheet features.



Chapters:
0:00 Intro
0:23 How to use checkboxes in excel
1:26 How to link cells in an excel checklist
3:21 Modify your excel checklist using conditional formatting
4:38 How to make an interactive excel checklist
5:06 End screen



What you’ll learn:
1. How to Create a Checklist in Excel
2. How to Use Checkboxes in Excel
a. How to make a checkbox in Excel which you can tick to indicate that the entry is completed
b. How to have the Developer tab on the Microsoft Excel toolbar
c. How to customize ribbon d. How to copy the exact checkbox on the succeeding cells
3. How to Link Cells in an Excel Checklist
a. How to tally the boxes ticked
b. How to make the linked cell will display TRUE
c. How To get a summary of how many boxes were ticked
d. How to hide the column
4. Modify Your Excel Checklist Using Conditional Formatting
a. How to Use a formula to determine which cells to format
5. How to Make an Interactive Excel Checklist
a. How To track the completion rate of all the entries
6. How to Create a Checklist in Microsoft Excel


















Song: Sapajou – Life Doesn’t Escape Us
Music provided by Vlog No Copyright Music.
Creative Commons – Attribution 3.0 Unported
Video Link: https://youtu.be/tgHqWURAPdw

Song: Atch – Freedom
Music provided by Vlog No Copyright Music.
Creative Commons – Attribution 3.0 Unported
Video Link: https://youtu.be/oe5EiOx4huM

#computereverywhere #howtomake #checklist #excel