Special Unicode Characters in Data Validation Lists: ☐, ☑, ✓, ✔ - This may be my favorite approach. You can include special characters like this in a Data Validation drop-down list. This isn't quite as good as clicking once to fill in a checkbox, but it is great for the mobile Excel apps. The only hard part is remembering how to insert a check mark symbol in Excel. For more information, see my article Using Unicode Character Symbols in Excel.

It’s likely that the bulk of the audience doesn’t need any explanation of what a checklist is. In a nutshell, it is a list of questions or bullet points that characterize the status/progress of a certain activity or process. The list may contain any essential data regarding your accomplishments or plans. Due to their versatility, checklists can be leveraged in any industry regardless of the business focus. But what is the purpose and benefit of using this process organization tool?
‘Normal’ checklists are effective whenever there are advantages to standardising performance, time is not critical, the series of tasks is too long to be committed to memory (or there are likely to be interruptions to execution of the task that might interfere with memory retrieval), and the environment enables a physical list to be accessed and used.
Checkbox Form Object - Use the checkbox form field only if you are wanting to add interactivity to your checklist. The checkbox form field, found in the Forms toolbar, can link to a cell in the spreadsheet without requiring any Visual Basic programming. The linked cell will be a boolean value TRUE or FALSE. Like the drawing objects, working with a large number of checkboxes can get messy.
Filming YouTube videos. Over the past few years, I’ve worked with Jordan Crowder to produce more video content for our YouTube channel. While Jordan edits and films many of our videos, I’ll do some filming myself sometimes and then send him the footage to edit. Over the years, I’ve run into some regular problems that have mucked up the filming process. They’re stupid simple things that I just forget about. So I made myself a “READ-DO” checklist of things I need to do before I start recording, and it has saved me boatloads of time:

Checklists make it easy to delegate tasks if someone offers to help you. If you are lucky enough to have assistance, you can refer to your list and know what to ask them to do right away. You can even share your list with them and let them pick what appeals to them. The disadvantage to delegating in this way is losing control when other people choose what they want to do. If you are concerned about giving away easy tasks and getting stuck with the challenges, keep your list to yourself.
If you're a fan of writing in Markdown and using keyboard shortcuts, Checkvist is made for you. It's a web app that lets you create checklists that you can print or share with others, and even set up daily reports. If you need collaborative checklist management, or you want a checklist that integrates with your favorite services like Evernote, try Checkvist.
But the military still bought a few Boeings to experiment with. Some test pilots believed the Boeing bomber was a much more effective warplane and got together to figure out how they could get pilots to fly it. Instead of requiring more training, the test pilots implemented a simple pre-flight checklist. It spelled out all the basic tasks that were needed to fly the plane successfully, like checking to see if the battery switches and radio were on before taking off. By implementing the checklist, pilots flew the Boeing bomber 1.8 million miles without a single accident. Thanks to a “stupidly” simple checklist, the Army ended up ordering thirteen thousand Boeing bombers and the B-17 soared into the annals of wartime history.

Investigators discovered the crash wasn’t caused by a mechanical malfunction, but rather pilot error. The problem was while the new bomber could carry more and fly faster and further than any other bomber in history, it was also an extremely complex plane to operate. To fly it, a pilot had to pay attention to four different engines, retractable landing gear, wing flaps, electric trim tabs, and much, much more. Because the pilot was so preoccupied with all these different systems, he forgot to release a new locking mechanism on the elevator and rudder controls. Overlooking something so simple killed the two men at the helm.
ALL TRADEMARKS AND LOGOS ARE THE PROPERTY OF THEIR RESPECTIVE OWNERS. THIS SITE AND THE PRODUCTS AND SERVICES OFFERED ON THIS SITE ARE NOT ASSOCIATED, AFFILIATED, ENDORSED, OR SPONSORED BY ANY BUSINESS LISTED ON THIS PAGE NOR HAVE THEY BEEN REVIEWED TESTED OR CERTIFIED BY ANY OTHER COMPANY LISTED ON THIS PAGE. THE RESULTS SHOWN ARE NOT TYPICAL AND RESULTS WILL VARY BASED ON YOUR MARKET, YOUR EFFORTS, COMPETITION AND MANY OTHER FACTORS OUTSIDE OF OUR CONTROL. WE DO NOT GUARANTEE ANY RESULTS FROM PURCHASING ANY OF OUR PRODUCTS. IF YOU DECIDE THIS PRODUCT IS NOT FOR YOU WITHIN 14 DAYS CONTACT US FOR A NO QUESTIONS ASKED REFUND. 
×