🙌 SUBSCRIBE for more Excel Tutorials: bit.ly/3SYHKFQ 👨🏫 FREE Excel Courses: bit.ly/EssentialCourseEWM 🖥 Templates: bit.ly/TemplatesEWM
@عزهالغامدي-ش9س
9 ай бұрын
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
@LeilaLeila-929
Жыл бұрын
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!!
@excelwithmark
Жыл бұрын
You are very welcome glad it helped :)
@IPLFAMILY
4 ай бұрын
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.
@monmon7873
10 күн бұрын
Thanks! Great help for me
@karenkim8756
8 ай бұрын
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! 🙂
@excelwithmark
8 ай бұрын
Glad it was helpful!
@irissine710
2 ай бұрын
Thank you so much, very user friendly guide to follow. I missed the number of tasks due "Due". Could you please provide the formula / guidance. THANK YOU
@captainzakir1262
9 ай бұрын
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.
@5-minutes-relax
13 күн бұрын
Thanks for the awesome video! I added a cool formula that automatically decreases the number of high-priority tasks once they're marked as completed: =COUNTIF(xy:xy,"high")-COUNTIF(xy:xy,"completed") It's a simple trick, but it makes managing tasks so much easier! Just replace 'xy' with the relevant cells."
@deysiberber3889
3 ай бұрын
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
@rwc1386
3 ай бұрын
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
@OrlandoExecVilla
7 күн бұрын
Outstanding video - thank you
@miguelhernandezdelgado1084
9 ай бұрын
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!
@atuhebwaarnold5926
6 ай бұрын
Thank you very much, I have learnt alot in this
@kevindurham8980
Жыл бұрын
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:)
@MP-kl3co
Ай бұрын
Thank you Carl Froach, much appreciated.
@fannylam85
Жыл бұрын
Thank you very much, I find my to-do-list is not as smart as I wish, your sharing is very useful!
@Teeknee50
4 ай бұрын
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?
@excelwithmark
4 ай бұрын
You could sort by cell value and make it so completed goes to the bottom
@NJawte
9 ай бұрын
Short and straight to point. Thanks, Mark.
@rilo3880
Жыл бұрын
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
@nenah786ify
5 ай бұрын
What is the formula for due today, you didn't mention that in the video. Thanks
@MuhammadUsama-ge7og
11 ай бұрын
Thanks man! God bless you!
@excelwithmark
11 ай бұрын
thank you you too
@NjeriMootian
10 ай бұрын
The Deadline part is what I am trying to understand
@tan4676
4 ай бұрын
Very useful Excel tutorial! Thanks for sharing, have a wonderful day :)
@macelwilliams6961
Жыл бұрын
thank you so much, I just got one problem in the cell due today it doesn't change by itself please help
@ΙλιαδαΜπ
10 ай бұрын
Great video! Thank you!
@hugoq2511
6 ай бұрын
So if the deadline is tomorrow it's overdue? I think you made a mistake with the conditional formatting.
@nenah786ify
5 ай бұрын
Definitely a mistake - can you please correct it so I can follow this list
@sebastianpetrescu382
Ай бұрын
@@nenah786ify the correct formula for the Over Due counting should be =COUNTIF(D9:D32,"
@sadasohnawasaib4806
4 ай бұрын
Thank You Very much Mr. Mark
@Beaniexxxxx
Жыл бұрын
Thank you so much! This video is so helpful! You are very talented!!
@excelwithmark
Жыл бұрын
Thank you so much!
@ayou2470
7 ай бұрын
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.
@onur8999
7 ай бұрын
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.
@sebastianpetrescu382
Ай бұрын
If you convert that range into a table, everything is going to format automatically
@widiokta
Жыл бұрын
Thank you for the video. Its very easy to understand 👍
@excelwithmark
Жыл бұрын
Thank you glad that it makes things clear. Hope it was helpful in some way
@cindygutierrez8640
8 ай бұрын
Tysm 🙏🏼🙏🏼🙏🏼
@AderorhoFestus
7 ай бұрын
You are the best.
@Love_above_hate
8 ай бұрын
Please tell me the formula you used for 'Due Today"
@jwbirdxd3746
Жыл бұрын
sorry, may i ask Ctrl + what to use the format cell since i always use mouse to clizk it in the tool bar
@iqrausman5147
10 ай бұрын
Where I get a training for excel ? Are you able to give me a training
@Yunqsam
Ай бұрын
Thank you
@ms.sherlyn319
Жыл бұрын
Hi sir, can you make a vedio that shows all of the "In progress" data please.
@hmhark
Ай бұрын
great video
@samu_el_pack
5 ай бұрын
Hello the formule countif for the overdue, does not work for me. it says, IT may not be supported by older versions
@YeoItsKai
Жыл бұрын
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?
@jriis2010
Жыл бұрын
=countif(range,"TODAY())
@natasharhone8891
7 ай бұрын
@@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.
@nenah786ify
5 ай бұрын
I tried that, it doesn't work
@allott272
11 ай бұрын
Thank you so much🤙
@H2O_Atlanta
Жыл бұрын
I really appreciate you for this, thanks so much! :)
@excelwithmark
5 ай бұрын
thank you
@nenah786ify
5 ай бұрын
@@excelwithmark- The formulae for overdue in the video is wrong. Can you please advise the correction. Thanks
@joseluisjimenez-fernandez327
9 ай бұрын
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?
@joseluisjimenez-fernandez327
9 ай бұрын
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
@gowatrG
Жыл бұрын
Thanks, very useful
@excelwithmark
Жыл бұрын
You're welcome!
@kedarsingh5348
4 ай бұрын
Shout out 👏👏
@Wowwow-wl3kx
Жыл бұрын
04:50 it is better to choose cell above... completed ,in progress....
@nenah786ify
5 ай бұрын
In the deadline, I put 24/04/2024 and this task was completed. But according to the overdue formula, this task is overdue....how???
@sebastianpetrescu382
Ай бұрын
the correct formula for the Over Due counting should be as follow: =COUNTIF(D9:D32,"
@memoirsofjustinako6849
8 ай бұрын
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
@memoirsofjustinako6849
8 ай бұрын
alo due date is missing explanation, come on dude, I have spent like an hour on it already
@HansJacobTorkelsenFagerv-en8gk
Жыл бұрын
Genious
@MP-kl3co
Ай бұрын
12:08 I can't see what you are typing????
@scichanalexis6139
Жыл бұрын
What is the formula for the due today?
@surabhibhalekar3127
Жыл бұрын
Firstly, in Over due formula it should be "" sign, and Due Date formula would be the same with just "=" in it. Hope it helps!!
@nenah786ify
5 ай бұрын
Please write the formula for due date properly, as this is the last bit I need to complete
@speakingfromthecloset6767
6 ай бұрын
I wish I knew how everyone saw what was being typed in and done. I’m struggling with seeing the screen.
Пікірлер: 78