Create a Checklist in Excel

Are you a person that likes lists? Do you like that feeling of crossing off or checking off tasks that are done? This this video is for you! It shows how to create a checklist or a to do list with check marks with three different examples.
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltrain...
📚 Excel Books & Tech Gear ➜ www.amazon.com...
⚙️ Tools: Screencasting ➜ techsmith.z6rj...
⚙️ Tools: Microsoft Office ➜ microsoft.msaf...
⚙️ Tools: TubeBuddy ➜ www.tubebuddy....
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoff...
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~

[@adolphep3958]

I used these formulas for one of my company's spread sheets and they love it, thank you sir! :)

[@hamzahalsagoff896]

Excellent Teacher, Clear and Simple tutorial. Thanks

[@1gopalakrishnarao]

Thanks for the technique. It is very simple way of highlighting the data in the check box method. Shall we expect many more useful and wonderful technique from you in the next few days?

[@ayapcredo]

this is sooo helpful, this made me love excel more, thanks for sharing your knowledge with this software.

[@Deeboogie82]

Figured it out, thank you for all your videos they are great way to refresh the memory.

[@TheVampire4241]

Thanks, your videos are very informative and easy to follow.

[@sandeep_nair11]

Thank you Doug!!!
You are awesome... Nicely explained

[@malaykchatterjee]

This is a very good video and nicely explained - I wish there are more videos to cover other areas of excel

[@malaykchatterjee]

Thanks for your answer. I will subscribe to your channel now.

[@AgungSuhartoagungscorta]

Nice format , thanks guys....

[@govindrai93]

Super clear and to the point! Thank you!

[@DougHExcel]

You're welcome!

[@Luciano_mp]

Excelente tutorial, explicação excelente, muito obrigado.
São Paulo,Brasil.

[@ImproveYourExcel]

great video - I have linked it on the Improve your Excel website for you and I hope this will add to your fan base.

[@hawa8171]

thank you man that's just awesome. Good Luck

[@khurramali42]

thank you so much Doug H...

[@ferfavole]

Great video!! Thank you for sharing these tips

[@DougHExcel]

Glad you liked!

[@olivaresd18]

Gracias Doug,
Fue de gran ayuda.

[@M55Mb]

Nice! You are a very good teacher!
I would like to make check list for month end close in Excel, showing accounting activities to be done and the different status.
Functions like sorting by type av activity, responsible person etc. and a box showing the "progress in percentage", would be nice.
Is there any easy way to make this?

[@camilodaza4967]

Thanks Doug!

[@muadz_lolz]

Thank you so much sir... Really helps

[@DougHExcel]

Glad it helped you out!

[@mohammadhossain148]

Thanks very much. It helped.

[@faribataheri2694]

that was very clear and great tanx alot

[@DougHExcel]

Glad it helped!

[@samipiyash9322]

Last one just wooooww!

[@DougHExcel]

Hi sami piyash, thanks for the comment!

[@justineantoinette5026]

Awesome thanks!

[@beckymck4871]

Thank you! that was helpful

[@DougHExcel]

You're welcome, thanks for the comment!

[@oksanaflyud8649]

Hi Doug! Just wanted to check if you used Excel 2010 in this example. When i tried to used Conditional formatting i had slightly different options. I use Excel 2007. Thanks

[@mlnxXxvirusxXxmln]

Thank you. It really helps :)

[@DougHExcel]

Glad it helped you out!

[@RhondaRoseRSAccounting]

awesome thank you!

[@chicadespuma]

Thank you sooo much for this video, it really helped me a lot! I would like to know though how can I add a third option for example (Yes, No, No information). I can put the third option in the status but I am not sure how to change the formula fx. Any advice?

[@Harishchennamsetty]

Thanks Cheers!!

[@Lys0518]

THANK YOU! THANK YOU!!!!! :)

[@DougHExcel]

Hi Bonnie Sierras, you're welcome!

[@zebiikhan8560]

great dude!!! Thanks!!

[@amirmahmood1895]

Hi, I have large number list of client and i need search able data validation (easy)

[@davidbecerra6688]

Gracias por la información.

[@valkiriaceleste]

Thanks you!

[@DougHExcel]

Hi valkiriaceleste, you're welcome!

[@sohelarman5799]

It is helpful for new user. I am also new user. Its really amazing. Do you tell me how will become a professional excel expert.

[@sohelarman5799]

Thanks. God bless you.

[@enumaelish11]

Thanks!

[@DougHExcel]

Hi Andrew BMc., you're welcome!

[@Madridistas1994]

Nice Video. I just have one questions. Do you know how I could get the "icon only" to replace the number "1" & "0" on a Mac?

[@Dauda100]

Thanks Doug! Learned excel alot from you. But isit possible to get a total summary of the checklist (√, O, X)?

[@DougHExcel]

this would have to be done with a helper column to count it up and using COUNTIF function. This vidoe covers the various count functions----> th-cam.com/video/qlEegBHlPMg/w-d-xo.html

[@Dauda100]

Thanks Dough!

[@josselynwhite1615]

How can I make a pivot table of the items I checked and another of the ones unchecked? I'm working with a check list that is almost 20,000 names. Great video !

[@DougHExcel]

You'd have create a helper column for "Checked" and "Unchecked" and use that as your pivot table selector

[@danecustance2734]

Awesome, really helpful! :D

[@azeezadelekan9855]

nice!!

[@jsprhrmsn]

HI, thanks for this tutorial.
Once question, maybe you can help me with this.
I'm looking for the way of doing the same formula but instead of returning the check from a yes or no value, I would like it to return the date of when I marked the action as checked for later use. So you'll get the checked icon with the date of when you checked it.
Thanks!

[@epa05]

is there a video that shows how you created each of these blocked sections?

[@bythewithe23]

You totally help me bro! :D
Sie sie

[@AmrutKatigar]

can we make a checklist thing combining both 2nd typ and 3rd typ?

[@josenildoalmeida3664]

Muito bom!

[@DougHExcel]

Olá Josenildo Almeida, muito obrigado por seu comentário!

[@nisarahmadinan2749]

Where can we find the Developer Menu to our Excel work sheet?

[@britnirussell4661]

I need help. I'm creating a personal expense calculator. Using the third technique, picture the To Do column being the name of my bill, a middle column for the amount of the bill, and the third being the check boxes, (except my 0 value is set to no icon.) How do I create a box that says IF there is a check in my third column, add the coinciding amount of that bill. Basically, if I check of that I've paid the bill, what is the total I've spent in bills.... I'm up to the stopping point at the end of this video, I just can't figure out how to do a 'conditional' SUM.

[@deleonleo9]

Excelente

[@DougHExcel]

Thanks leo deleon!

[@vichay7811]

How to add more ? Example : For None we need Blank , how to do ?

[@Deeboogie82]

for the last option how do you open the new rule?

[@krishnamanjunatha6183]

if i put N for all C8:C11, got CHECK mark instead WHITE circle
please help

[@MrDaBoris]

Nice video
but how to change state by onclick

[@vinaykorlahalli4924]

how to make it default as zero??
and only on click it will be 1??

[@aaartsygal]

Is there any way I can make the cell show as blank but when I type a yes or no the cell will show an icon?Thank you

[@DougHExcel]

Hi aaartsygal, sorry 🙁....but try a post on the mrexcel.com forum!

[@richardtrustallen4192]

I'm trying to get check box to move a word to a cell. i can make it move a number, just not a word. Thank you

[@DougHExcel]

Hi Rick Allen, thanks for the comment!

[@britnirussell4661]

I need help. I'm creating a personal expense calculator. Using the third technique, picture the To Do column being the name of my bill, a middle column for the amount of the bill, and the third being the check boxes, (except my 0 value is set to no icon.) How do I create a box that says IF there is a check in my third column, add the coinciding amount of that bill. Basically, if I check of that I've paid the bill, what is the total I've spent in bills.... I'm up to the stopping point at the end of this video, I just can't figure out how to do a 'conditional' SUM.