How To Make A Daily To Do List In Excel
ฝัง
- เผยแพร่เมื่อ 18 ม.ค. 2023
- SUBSCRIBE for more Excel Tutorials: bit.ly/3SYHKFQ
Courses: bit.ly/EssentialCourseEWM
Templates: bit.ly/TemplatesEWM
Resources:
amzn.to/3zuuvIW
Computer Add Ons:
amzn.to/3W8Aw6L
Equipment:
amzn.to/3W6YWxF
================
In this Excel tutorial, you'll learn how to create a daily to-do list in Excel. A to-do list can help you stay organized, productive, and focused on your daily tasks. With Excel, you can create a customized to-do list that suits your needs and preferences. In this video, we'll cover the following topics:
How to set up your Excel sheet for a to-do list
How to format your to-do list to make it easy to read and use
How to add and prioritize tasks
How to use Excel formulas and functions to calculate deadlines and progress
Tips and tricks for using your to-do list effectively
Whether you're a student, professional, or just looking to stay on top of your daily tasks, this Excel tutorial will help you create a to-do list that works for you. So, let's get started and learn how to make a daily to-do list in Excel!
================
Socials:
Instagram : / excelwithmark
TikTok: / excelwithmarkyt
🙌 SUBSCRIBE for more Excel Tutorials: bit.ly/3SYHKFQ
👨🏫 FREE Excel Courses: bit.ly/EssentialCourseEWM
🖥 Templates: bit.ly/TemplatesEWM
Short and straight to point. Thanks, Mark.
From all of my heart I say thank you so much , I swear my teacher has been explaining excel and I didn’t understand most of them LOL , I did this as an excel project and I am confident about the grade I will receive, will continue watching your excel explanation
Great video! Thank you!
Hello and thank you so much for creating this video. I am learning Excel and it's a bit intimidating, but by following your steps, I was able to create this task management sheet which has boosted my confidence. As a freshman college student, it is key for me to stay organized and track my progress effectively. This will definitely help me, so thank you so much again. Happy holidays!
Great step by step tutorial! I actually use a ready-to-use to-do list template I purchased from Someka. However, it's good to know how to prepare a basic task list from scratch. Thank you for the video:)
Thank You Very much Mr. Mark
Thanks man! God bless you!
thank you you too
All I can say is WOW! I thank you sooooo much for this! I have been afraid/avoidant of Excel because I could not grasp some of the concepts above VERY basic lol... You have helped me tremendously! I'm so proud of my lil spreadsheet right now, I'm like a kid wanting to show everyone 😂😂... Thank you!!
You are very welcome glad it helped :)
The formula for 'Due Today' is =COUNTIF(D9:D41,TODAY()) ...That's open bracket and 2 close brackets after the word TODAY by the way. Awesome video. Thanks for sharing.
Tysm 🙏🏼🙏🏼🙏🏼
Thank you very much, I find my to-do-list is not as smart as I wish, your sharing is very useful!
Thank you so much! This video is so helpful! You are very talented!!
Thank you so much!
Thank you so much🤙
The Deadline part is what I am trying to understand
Thank you for this tutorial. Is there a way to create a separate list of tasks from this list that are in progress? Not just a count, but a list
Hello and thanks for sharing this tutorial. Today I was reading the book (Time management) of brian Tracy and in the middle He mentioned the Make a daily To do list. Then I search for vedio and I found this amazing.
Thank you for the video. Its very easy to understand 👍
Thank you glad that it makes things clear. Hope it was helpful in some way
Thank you very much, I have learnt alot in this
I really appreciate you for this, thanks so much! :)
thank you
@@excelwithmark- The formulae for overdue in the video is wrong. Can you please advise the correction. Thanks
I just started a job in September and this will make organizing my tasks perfectly! I'm still learning but this is a great start. Thank you! 🙂
Glad it was helpful!
You are the best.
Genious
Very useful Excel tutorial! Thanks for sharing, have a wonderful day :)
Great video! Thanks! Quick question can you have just the to do list on one sheet and the data at the top on the settings sheet? If that makes sense
Thanks, very useful
You're welcome!
thank you so much, I just got one problem in the cell due today it doesn't change by itself please help
Great Video, thanks. Is there a way to automatically move ‘Completed’ items to a separate list or at least to the bottom of this list? Just looking to keep the main list for active items only. Thanks
Shout out 👏👏
sorry, may i ask Ctrl + what to use the format cell since i always use mouse to clizk it in the tool bar
What is the formula for due today, you didn't mention that in the video. Thanks
Hi sir, can you make a vedio that shows all of the "In progress" data please.
This was a great video! I’m curious, is it possible to have a rule where a “completed” status moves to the bottom of the list?
You could sort by cell value and make it so completed goes to the bottom
Please tell me the formula you used for 'Due Today"
04:50 it is better to choose cell above... completed ,in progress....
Where I get a training for excel ? Are you able to give me a training
Hello the formule countif for the overdue, does not work for me. it says, IT may not be supported by older versions
I know this was a year ago but I'm going to ask a dumb question.
Does the formatting remain after the selected cells? If you fill up all the rows with tasks, and you're underneath the data area, did it continue or do you have to reformat everything?
Sorry I know it's probably obvious. Thanks for your video. I learned a lot.
It is only applicable for the selected cells. You can select the cell that has been formatted and copy it and paste it in whichever cell you want the rule to apply to.
I cant seem to find the part where you explained how to set the “Due Today” counter. Can you explain how to do it please?
=countif(range,"TODAY())
@@jriis2010 I spent so long trying to get this formula to work. It is actually =countif(range, “TODAY())
You missed out the space in between the hyphen and the quotation mark. However, brilliant video it has been so helpful.
I tried that, it doesn't work
The formatting on the "Deadline" column doesn't work for me. No matter how many times I try, all the res is ok. Am I doing anything wrong?
Please don't feel like you need to reply; I figured out what I was doing wrong: the right day and month but the wrong year. It seems I am still living in 2023, embarrassing lol
So if the deadline is tomorrow it's overdue? I think you made a mistake with the conditional formatting.
Definitely a mistake - can you please correct it so I can follow this list
What is the formula for the due today?
Firstly, in Over due formula it should be "" sign, and Due Date formula would be the same with just "=" in it. Hope it helps!!
Please write the formula for due date properly, as this is the last bit I need to complete
In the deadline, I put 24/04/2024 and this task was completed. But according to the overdue formula, this task is overdue....how???
I wish I knew how everyone saw what was being typed in and done. I’m struggling with seeing the screen.
would be a great video, but the part with dates are confusing and impossible to execute, and it makes the whole video pointless. Should I put today's date or the date 2 days after, as it is in the video? its confusing
alo due date is missing explanation, come on dude, I have spent like an hour on it already
MUU SE SUPPARI NIKAL KAR KE BAT KAR RE BABA
Great video! Thank you!!