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.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ www.tubebuddy.com/et101
📝 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.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~
Пікірлер: 78
Thank you Doug!!! You are awesome... Nicely explained
I used these formulas for one of my company's spread sheets and they love it, thank you sir! :)
Excelente tutorial, explicação excelente, muito obrigado. São Paulo,Brasil.
Excellent Teacher, Clear and Simple tutorial. Thanks
this is sooo helpful, this made me love excel more, thanks for sharing your knowledge with this software.
Figured it out, thank you for all your videos they are great way to refresh the memory.
Thanks, your videos are very informative and easy to follow.
Thanks Doug!
Gracias Doug, Fue de gran ayuda.
Awesome, really helpful! :D
Thanks very much. It helped.
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?
Nice format , thanks guys....
awesome thank you!
Super clear and to the point! Thank you!
@DougHExcel
7 жыл бұрын
You're welcome!
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?
Awesome thanks!
thank you man that's just awesome. Good Luck
Great video!! Thank you for sharing these tips
@DougHExcel
7 жыл бұрын
Glad you liked!
great video - I have linked it on the Improve your Excel website for you and I hope this will add to your fan base.
thank you so much Doug H...
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!
Thanks Cheers!!
Gracias por la información.
Thank you! that was helpful
@DougHExcel
7 жыл бұрын
You're welcome, thanks for the comment!
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?
Thank you so much sir... Really helps
@DougHExcel
7 жыл бұрын
Glad it helped you out!
You totally help me bro! :D Sie sie
great dude!!! Thanks!!
@amirmahmood1895
8 жыл бұрын
Hi, I have large number list of client and i need search able data validation (easy)
that was very clear and great tanx alot
@DougHExcel
7 жыл бұрын
Glad it helped!
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
Thanks you!
@DougHExcel
3 жыл бұрын
Hi valkiriaceleste, you're welcome!
Thank you. It really helps :)
@DougHExcel
8 жыл бұрын
Glad it helped you out!
can we make a checklist thing combining both 2nd typ and 3rd typ?
for the last option how do you open the new rule?
Last one just wooooww!
@DougHExcel
5 жыл бұрын
Hi sami piyash, thanks for the comment!
THANK YOU! THANK YOU!!!!! :)
@DougHExcel
3 жыл бұрын
Hi Bonnie Sierras, you're welcome!
This is a very good video and nicely explained - I wish there are more videos to cover other areas of excel
@malaykchatterjee
10 жыл бұрын
Thanks for your answer. I will subscribe to your channel now.
nice!!
Thanks!
@DougHExcel
3 жыл бұрын
Hi Andrew BMc., you're welcome!
is there a video that shows how you created each of these blocked sections?
if i put N for all C8:C11, got CHECK mark instead WHITE circle please help
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
7 жыл бұрын
You'd have create a helper column for "Checked" and "Unchecked" and use that as your pivot table selector
Excelente
@DougHExcel
7 жыл бұрын
Thanks leo deleon!
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?
Muito bom!
@DougHExcel
5 жыл бұрын
Olá Josenildo Almeida, muito obrigado por seu comentário!
Where can we find the Developer Menu to our Excel work sheet?
how to make it default as zero?? and only on click it will be 1??
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.
Thanks Doug! Learned excel alot from you. But isit possible to get a total summary of the checklist (√, O, X)?
@DougHExcel
7 жыл бұрын
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----> kzread.info/dash/bejne/o6B5x8l7eM-2fco.html
@Dauda100
7 жыл бұрын
Thanks Dough!
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
10 жыл бұрын
Thanks. God bless you.
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
3 жыл бұрын
Hi aaartsygal, sorry 🙁....but try a post on the mrexcel.com forum!
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
3 жыл бұрын
Hi Rick Allen, thanks for the comment!
How to add more ? Example : For None we need Blank , how to do ?
Nice video but how to change state by onclick
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.