A little too fast paced for me but with pauses and rewinding the steps and visual helped me tremendously. Definitely saved to favorites. Watching this in 12/2023 to get a refresher for a new job!
I thought the same thing... I couldn't listen to what she said, process it, AND watch what she was doing and comprehend THAT In such a terribly short amount of time. Stopping, rewinding, rewatching, and sometimes repeating is almost worse because I can't maintain the information in my head for long enough. (OH ADHD, how I love thee! 😂) What you can do, however (even WITHOUT ADHD 😉), is go up to the gear, choose "playback speed", and adjust it accordingly. A number smaller than 1.0 is SLOWER, a number larger than 1.0 is FASTER. (Personally, I can't handle slowing it down any more than 0.75. Voices are obviously affected when speeds change. If it's too slow, they start to sound as if they are in the process of falling asleep... If it's too slow, they start to sound as if they are additional/replacement members of the Alvin and the Chipmunks band! 👉😖👈) Whether you go faster or slower, don't forget to turn it back to normal after you are finished watching that video/videos by that creator!!! 😅😅😅
The tutorial was really really helpful and easy to follow. Thank you so much! And your voice is really pleasing to the ears. So, really liked the video!
Great work! What I would find very useful is an option to schedule a meeting in between two time slots. For example: Lets assume I have a meeting from 9:45-10:15. Is there also a method to generate a table with flexible times? Alternatively I guess I could increase the granularity for the timeslots from 30 min to 15 min.
That’s excellent, Ali! There are so so many things you can do with Excel once you get comfortable with it. I’m so happy my tutorial helped you, at least a little bit, in learning how to use it 🙂
What a detailed and easy-to-follow tutorial! Exactly what i needed, thanks!! Because im making this in late October, the dates take up quite a bit of space when initially entering them. My last day extends over on to the next whole page. I tried changing the page orientation and it all fits in one when on landscape, which is great. However, do you know how i could fit it all in on a portrait page? Thanks, keep up the good work!
Hi, Aadam. You can set this in the Page Setup options. On the Page tab, in the Scaling section, select Fit to and set it to 1 page wide by 1 page tall. Just make sure to check the Print Preview to make sure it's not so small you can't ready it. You could also apply Wrap Text to the dates so you can make the columns smaller. You'll find this in the Home tab, in the Alignment section. Thanks! 🙂
My list wouldn't show up. Only the title. Is it because my description was to long to fit in one column? Or did I do something wrong, I am doing an assignment for school. I need to use Excel to make a schedule for a doctor.
How does the weekly calendar repeat itself for the whole calendar year. Meaning, I've followed step by step but it only covered 1 week in the month how do I repeat it so if I wanna book in August the calendar will go that far
Could you show how to save a new item to the “activities list”. It doesn’t automatically add to the values saved to auto populate. Or do we have to save it as a new table every time? Thanks
Thank you for this video, it has been extremely helpful and easy to follow, the only issue I am having is trying to make my timetable blank areas link with my activities list, every time I do it it says there is an error because excel would recognise it as a formula, which I want, but then it won't let me do it? I don't understand what I'm doing wrong since I have followed your tutorial and you did not have the same issue
"A named range you specified cannot be found" is the error message I get when I'm in data validation and I write "= activities" in the source box. How do I fix this?
Wow! Thanks much!!! I am gonna try this for my work today itself!!!! Quick question what if I want to have both the drop down option and and option to type notes in cells when needed. ( appointment that isn't on the drop down option to be typed ) how may i do that please, let me know soon as I really need to get this working! THANK YOU!!!
Hi. When I first copied the dates into the cells, the cells were too small to display the date formatting I was using. When this happens, Excel displays hashtags. Once I expanded the column size, making the cells wider, the hashtags were replaced with the date. Hope this helps. Thanks!
To anyone having trouble or getting an error with Data Evaluation in the Settings tab, instead of putting "=Activities", after clicking "Allow: List", I just clicked on the Activities tab (the one near your weekly schedule name), and I highlighted the whole activities chart and it automatically puts the list in the Source box. Hope this helps!
Hi, lile. I used the copy & paste keyboard shortcuts. After I typed the formula in cell C2, I selected the cell and pressed Ctr+C to copy it. Then, while holding down the Shift key, I used my right arrow to select the other cells. Once they were all selected, pasted the formula using Ctrl+V.
Thanks for the instructions! I am having some trouble in the "Data Validation" part. When I input "=Activities" for the Source, I get an error message. Instead I have to highlight the items in my activities list in order for the function to work. Is anyone else experiencing this? If so, were you able to fix it?
Hello! This was so helpful. Thank you!! I have one question though. Some meetings that are more than 30 minutes. How to I add them to the the sheet and extend for more than 30 minutes?
Hi, La Toya. In my opinion, the best option is to select the same meeting for an additional time slot. If you don't convert the week to a Table format (like we did in the tutorial), you can merge the cells after you select a meeting type, but then that starts to get clunky if you want to make a copy of it to reuse in a future week. You'd need to remember to unmerge any merged cells.
Hi. Make sure you're that the name you're referencing in the Source section is the same name that you assigned to your list of activities. If it continues to give you troubles, you could type the = sign and, with your cursor, select the range of cells you want to use for the drop down list. As long as the range is formatted as a Table, it will still auto update with any new activities you add later. I hope this helps. Please let me know if you need more help. And thank you.
I want to make a once a week activity every Monday say 1700 hrs to take account of school holidays and have a list of different students doing a presentation by one student each of these Mondays. How can I do that? Please help and advise.
Hi. Make sure your cells are all formatted with a date format. You may also need to adjust the column width to make sure everything fits. Hope this helps. Thanks!
Hi and thanks for watching. I used the Ctrl+C command from my keyboard to copy the cell with the +1 formula, then pressed Ctrl+V on my keyboard to copy it to the other cells. Hope this helps and thank you.
Can you show us how we could use this method through the year and create a dashboard with graphs that would show time spent on activities as the year goes on? I’m trying to make a planner like this that would allow for tracking things over time. Like time spent on the job & returns or time spent exercising and body weight.
Thank you so much for your hard work, this is great content. I do have a question though, how can we merge cells? I noticed after creating a table, that button is dimmed and I don't know how to undo that.
Hi, is there any way to make it so that an activity that takes place over a longer period doesn't show as repeated in each block after dragging it down? And also Display the time in the text?
Hiiiii... Thank you for the Tutorial. I still have trouble when I get into the validation. After the validation staff is done what I got on the schedule list is only *Activities. So, what should I do?
I think you forgot to put the '=' sign in the source section for data validation. Instead of "Activities", it should be "=Activities". When you highlight all the necessary blocks and press data validation, make sure you choose "Allow: list" and "Source: =Activities" in the validation criteria. Goodluck!
hi, is there a way to create a new sheet for the next week but with correct dates and the table empty, without having to go through all the steps again?
Hi YAcosta soutions, thanks for the video really helpful. Could you please inform us on a way to quickly add up the time spent on each "separate activities" each day on a sperate table? I am trying to tally the length of time spent on each separate activities at the end of each week. Thanks!
I cant get it to work, neither in English or Swedish, it won't add the next hour, it just moves the inputted time / day / to the next cell. Your guide is really good, but what is wrong with myExcel (365).
Kudos for the video content! Apologies for butting in, I would love your thoughts. Have you considered - Weydaniel Organized Dominator (Have a quick look on google cant remember the place now)? It is a good exclusive guide for getting 7000 plus project management and business templates without the headache. Ive heard some pretty good things about it and my mate got cool success with it.
After going to Data Evaluation and adding =Activities, Excel would not allow me to click on Error Alert with a box coming up stating, "A named range you specified cannot be found." I was unable to specify a range. Help.
Also, I want to have a sheet with list of activities with corresponding dates and times. And I want my calendar to be auto populated based on my entries in other sheets. Do you think you can help me with this?
Hi, SJ. I used Autofill to fill in the times. Autofill / AutoComplete works by looking for a pattern in your data and then filling in the rest when you drag down or over. For example, type 8:00 AM in one cell, then 8:30 AM in the cell below it. Select the 2 cells and drag down. Excel should identify the pattern and fill in 1/2 hour intervals. If you want to do hour intervals, you would type 8:00 AM, then 9:00 AM. If this doesn't work for you, go to your File / Options / under "Advanced" / look for the "Editing" section. Make sure that "Enable fill handle and cell drag-and-drop" is selected. Hope this helps. Please let me know if you have problems. Thanks
Hi, Refugio Rivas. See if this formula helps you: =(COUNT($A3:$A23)-COUNTBLANK(B3:B23))*"0:30" Here's how this formula works: -The first part counts the cells in range A3:A23 that contain a value. Where A3:A23 refers to the cells in the column that contains the time labels. -It then subtracts any blank cells found in cells B3:B23 (with this range being all the time slots for the first day). If your first day is a Monday, then Tuesday would be C3:C23, etc. And the cells with no activities would be the blank ones. -It then multiplies the difference by "0:30". This represents 30 minutes for each time slot. If each is 15 minutes, then you would multiply by "0:15", and so on. Last, you should apply custom formatting to the cell with the result. It would look like this: [h]:mm. I have a tutorial on time formatting that can help you understand this formatting. If you're interested, you can watch it here: ua-cam.com/video/gmvTMACw420/v-deo.html Please let me know if this works for you. Thanks!
Hi, Lee. Try this - select all the cells you want to apply the formatting to so that your words fit, then, with the cells still selected, go to the Home tab of your ribbon, then the Alignment tab. Here you'll find options to help you wrap the text as well as for how to position your text in the cell. If the words are still too long, click to expand / open the Format Cells options. In the Alignment tab, you can select "Shrink to Fit." This will force the cell contents to be smaller. Hope this helps and thank you!
Hi, Musa. Usually, this happens for a couple of reasons. First, make sure to check that your cell is wide enough to display the date. You can always extend the column width. The hashtags can also show up if the date value is negative - which can easily happen from a typo. If your cell is wide enough to display the date, check that your date format is entered correctly in the cell and formatted with date formatting. Please let me know if you continue to have troubles. Thanks
Hi, Ethan. Make sure your dates are entered with the month/day/year. Then, use format them to display only the month/date. For this, go to Format Cells, in the Date options, select the one that looks like 3/14. I hope this answers your question. Please let me know if you need more help. Thanks
Hi, C C. You could do 2 drop downs per time block (one for meeting type and the other for the room). This would require 2 rows per each time. You could then merge the cells for the time. For example, say that rows 2 and 3 are both assigned to 8 AM. Row 2 could be the drop down for the meeting type. Row 3 could be the room selection. Then, cells A2 and A3 could be merged. One thing to keep in mind, you wouldn't be able to format your schedule as a Table. As you can't merge cells in a Table. I hope this helps. Please let me know if you have other questions. Thanks!
Hi, Yoda. This will take a little bit of playing around with your spreadsheet. First, in your View tab, select Page Break preview. This way you can see the changes right away. You can try making the columns a bit smaller. If you select all your “day” columns together, you can drag them a bit to the left and they’ll all shrink a bit and all should have the same length. You can also reduce your margin size. You’ll find the option to do this under the Home tab, in the Page Set up section. I hope this helps! And thank you 🙂
You’re welcome! Also, forgot to mention another option - you can also set your Print Area, then in Page Layout, reduce the percentage size of what you’re printing. It’s kind of like the zoom viewing options, but for printing. You’ll need to do a test print to make sure it’s not so tiny that you can’t read it. I usually don’t like to go smaller than 85%, but it can vary by document.
i got an error!!!!! The sentence from the activities does not format like this video. they are just horizontally over the another column. Please help me someone (urgent)
Hey! Thank you for this video. Pretty much self-explanatory. Can u tell how to copy same format for next weeks?. I mean how to copy paste the table on horizontal and vertical pages next to this one.
Hi, Tarun. You can either use copy and paste to copy this next to the original on the same sheet or make a copy of the sheet. To make a copy of the sheet, place your cursor on its tab, right-click and select Move or Copy. Then check off the option for “Make a Copy” and click OK. Either way, you'll need to update the dates. You can then use Format Painter to copy the Conditional Format to your new copy. To use Format Painter, select the entire original week, click Format Painter from your Home tab's Clipboard section, then select your new copy. The formatting, including the Conditional Format, will now be copied over. I hope this helps. Please let me know if you have more questions.
A little too fast paced for me but with pauses and rewinding the steps and visual helped me tremendously. Definitely saved to favorites. Watching this in 12/2023 to get a refresher for a new job!
I hope you have great success in your new job! Thanks for watching and commenting 🙂
I thought the same thing... I couldn't listen to what she said, process it, AND watch what she was doing and comprehend THAT In such a terribly short amount of time. Stopping, rewinding, rewatching, and sometimes repeating is almost worse because I can't maintain the information in my head for long enough. (OH ADHD, how I love thee! 😂)
What you can do, however (even WITHOUT ADHD 😉), is go up to the gear, choose "playback speed", and adjust it accordingly. A number smaller than 1.0 is SLOWER, a number larger than 1.0 is FASTER.
(Personally, I can't handle slowing it down any more than 0.75. Voices are obviously affected when speeds change. If it's too slow, they start to sound as if they are in the process of falling asleep... If it's too slow, they start to sound as if they are additional/replacement members of the Alvin and the Chipmunks band! 👉😖👈)
Whether you go faster or slower, don't forget to turn it back to normal after you are finished watching that video/videos by that creator!!! 😅😅😅
Mam your way of teach is so easy many youtubers enlarged content only
This tutorial was absolutely amazing! So concise and easy to follow! I appreciate it greatly :)
That’s awesome, Kelly! I’m so happy you liked this 🙂
Thank you your Royal Highness Queen of Excel!
What a generous compliment! Thank you ☺️ I’m so happy you liked this !
Awesome! Short and useful. No time wasted. It's so hard finding efficient educational videos. Great job!
Thank you so much 🙂 I'm happy this was useful for you.
Thanks for detailed explanation. May I know where did you click at 1:32 to change the squares to date.
I watched many of these and yours was the best. Thank you.
Thanks so much, Wendy! I really appreciate that 🙂
Great. Now I know more about scheduling shifts and thus I can work more efficiently, effectively, and maximize my income.
That’s excellent, Ryan! I’m so happy this helped you so much 🙂
The tutorial was really really helpful and easy to follow. Thank you so much! And your voice is really pleasing to the ears. So, really liked the video!
Thank you so much! I really appreciate the sweet feedback 🙂
I love how you explain things. Very clear and concise. Excellent!
Thank you, James. I really appreciate your feedback. I’m glad you liked this 🙂
This was fantastic. Thank you!
Thanks so much! I'm so glad you liked this so much 🙂
at 1:30 you somehow change the dates from hashtags into actual dates how do you do that?
try increasing the column width .
Thank you for this very cool tutorial! I'm gonna use it extensively!
That's great, Iryna! I'm happy you liked this so much 🙂
Great work! What I would find very useful is an option to schedule a meeting in between two time slots. For example: Lets assume I have a meeting from 9:45-10:15. Is there also a method to generate a table with flexible times? Alternatively I guess I could increase the granularity for the timeslots from 30 min to 15 min.
Thank you for sharing your knowledge to benefit many. Awesome work and may you be richly rewarded.
Thank you, Samuelu. That’s very kind of you 🙂 I’m glad you liked this tutorial.
I am only in middle school. Everyone was saying make schedule but I didnt know how, This was Very helpfull
fast and straight to the topic. EXCELLENT.
Thank you so much, Harshad! I really appreciate the compliment 🙂
hi is there a way to add multiple activities to one column?
Thank you so much for this tutorial, easy to follow and understand.
Glad you enjoyed it! Thanks 🙂
Thank you so much for this tutorial, its great and I followed along and it all worked well :) thank you!
That's great, Monica! I'm so happy this was useful for you 🙂
Thank you very much, I am just learning and you make it look easy😊
That’s excellent, Ali! There are so so many things you can do with Excel once you get comfortable with it. I’m so happy my tutorial helped you, at least a little bit, in learning how to use it 🙂
Thanks for your video. I want to create a weekly planner with different start and end times? Can you please explain how to do this?
What a detailed and easy-to-follow tutorial! Exactly what i needed, thanks!! Because im making this in late October, the dates take up quite a bit of space when initially entering them. My last day extends over on to the next whole page. I tried changing the page orientation and it all fits in one when on landscape, which is great. However, do you know how i could fit it all in on a portrait page? Thanks, keep up the good work!
Hi, Aadam. You can set this in the Page Setup options. On the Page tab, in the Scaling section, select Fit to and set it to 1 page wide by 1 page tall.
Just make sure to check the Print Preview to make sure it's not so small you can't ready it.
You could also apply Wrap Text to the dates so you can make the columns smaller. You'll find this in the Home tab, in the Alignment section.
Thanks! 🙂
My list wouldn't show up. Only the title. Is it because my description was to long to fit in one column? Or did I do something wrong, I am doing an assignment for school. I need to use Excel to make a schedule for a doctor.
How does the weekly calendar repeat itself for the whole calendar year. Meaning, I've followed step by step but it only covered 1 week in the month how do I repeat it so if I wanna book in August the calendar will go that far
Could you show how to save a new item to the “activities list”. It doesn’t automatically add to the values saved to auto populate. Or do we have to save it as a new table every time? Thanks
Thank you for this video, it has been extremely helpful and easy to follow, the only issue I am having is trying to make my timetable blank areas link with my activities list, every time I do it it says there is an error because excel would recognise it as a formula, which I want, but then it won't let me do it? I don't understand what I'm doing wrong since I have followed your tutorial and you did not have the same issue
Hi, looks like you've got this solved in a different comment. Thanks so much for stopping by and watching 🙂
This helped! Thanks! 🙌
That’s great, Tanvir! I’m glad this was helpful to you 🙂
Thank you for this! Assuming I won't be able to merge cells in this for activities that may take more than a single time slot?
very easy to follow! Thank you!
Thanks, Veronica. I’m happy you liked this 🙂
I LIKE THE WAY YOU ENDED
Thank you 🙂
"A named range you specified cannot be found" is the error message I get when I'm in data validation and I write "= activities" in the source box.
How do I fix this?
After creating everything how to extend it horizontally!!
Excellent! This video tutorial is clear and easy to follow! Thank you so much for your great work! It helped a lot:)
Yay! I’m so happy this helped you 🙂 Thanks so much!
Wow! Thanks much!!! I am gonna try this for my work today itself!!!! Quick question what if I want to have both the drop down option and and option to type notes in cells when needed. ( appointment that isn't on the drop down option to be typed ) how may i do that please, let me know soon as I really need to get this working! THANK YOU!!!
Can we do this in Google sheets? But have Google scripts involved?
I get an error message when write = activities to create a drop down list.
the time won't drag down in half hour interval insead it is coming in 1 hr interval while dragging down for me ?
When you set the date how do you get it to auto fill the rest
i loved your vid but im looking for more.. how can i stick aay 8 months worth of learning into a three month calendar and track my progress
1:30 how did the hashtags change into dates?
Hi. When I first copied the dates into the cells, the cells were too small to display the date formatting I was using. When this happens, Excel displays hashtags. Once I expanded the column size, making the cells wider, the hashtags were replaced with the date. Hope this helps. Thanks!
awesome tutorial thanks!
Thanks so much! I’m happy you liked this 🙂
Wow, life changing. Thank you!
That's great! I'm so glad this was useful for you 🙂
AMAZING!!!!!🥰
Brilliant! 👏 ... very helpful. Thanks 🙂
So happy it was helpful! Thanks 🙂
Its very useful and simple
Thanks
Thanks so much, Saira! I’m happy this helped you 🙂
Thank you for the tutorial, super helpful!
Thank you 🙂 Glad it was helpful!
Thanks! Great vid
Glad you liked it! Thanks so much 🙂
When activities are no longer used how do you delete them from appearing?
To anyone having trouble or getting an error with Data Evaluation in the Settings tab, instead of putting "=Activities", after clicking "Allow: List", I just clicked on the Activities tab (the one near your weekly schedule name), and I highlighted the whole activities chart and it automatically puts the list in the Source box. Hope this helps!
Great tip! Thanks so much for sharing 🙂
Omg thank you much, this tip saved my life!
Thank you!!
Thank you for the tip, unfortunately I still don't understand and I cannot seem to make it work. Can you please break it down? Sorry :-( Thank you
Thank you so much YAcosta Solutions, this really helps a lot, much appreciated, bless you!
Thanks, Rafie! I’m excited this helped you out 🙂
how did you paste those dates 1:27 ?
Hi, lile. I used the copy & paste keyboard shortcuts. After I typed the formula in cell C2, I selected the cell and pressed Ctr+C to copy it. Then, while holding down the Shift key, I used my right arrow to select the other cells. Once they were all selected, pasted the formula using Ctrl+V.
You're welcome 🙂
I'm new to Excel and this was very helpful, thank you [:
Excellent! I'm so happy this helped you 🙂
This tutorial was really Amazing, straight to the point & very helpful for me👌
That’s great! I’m so glad this helped you 🙂
Thanks for the instructions! I am having some trouble in the "Data Validation" part. When I input "=Activities" for the Source, I get an error message. Instead I have to highlight the items in my activities list in order for the function to work. Is anyone else experiencing this? If so, were you able to fix it?
Thank you so much! It helps a lot.
Glad it helped you, Argan! Thanks 🙂
Hello! This was so helpful. Thank you!! I have one question though. Some meetings that are more than 30 minutes. How to I add them to the the sheet and extend for more than 30 minutes?
Hi, La Toya. In my opinion, the best option is to select the same meeting for an additional time slot. If you don't convert the week to a Table format (like we did in the tutorial), you can merge the cells after you select a meeting type, but then that starts to get clunky if you want to make a copy of it to reuse in a future week. You'd need to remember to unmerge any merged cells.
Can you help me my tasks aren’t transferring to my sheet one
Very helpful, Thank you
Thanks, Anaida! I’m happy this was helpful for you 🙂
When i enter "=activies" In the "source:" section of data validation it notifies me that the formula i typed contains an error... What to do :((
Hi. Make sure you're that the name you're referencing in the Source section is the same name that you assigned to your list of activities.
If it continues to give you troubles, you could type the = sign and, with your cursor, select the range of cells you want to use for the drop down list. As long as the range is formatted as a Table, it will still auto update with any new activities you add later.
I hope this helps. Please let me know if you need more help. And thank you.
@@YAcostaSolutions thankyouuu 💓
thank you for the video
Thank you!! I'm happy you liked this 🙂
I want to make a once a week activity every Monday say 1700 hrs to take account of school holidays and have a list of different students doing a presentation by one student each of these Mondays. How can I do that? Please help and advise.
Thank you! It's very helpful. Is it possible to merge some cells?
Why are there hashtags when I try to drag the date and how do I fix that?
Hi. Make sure your cells are all formatted with a date format. You may also need to adjust the column width to make sure everything fits. Hope this helps. Thanks!
So helpful
Thank you! I’m happy you found this helpful 🙂
cant even figure ouut how you copy-pasted the date...
Hi and thanks for watching. I used the Ctrl+C command from my keyboard to copy the cell with the +1 formula, then pressed Ctrl+V on my keyboard to copy it to the other cells. Hope this helps and thank you.
What if you have a 3 hour class, let's say from 12 till 3, how do you merge the activities in one timeframe?
great viedo
Thanks so much! I’m glad you liked this 🙂
Can you show us how we could use this method through the year and create a dashboard with graphs that would show time spent on activities as the year goes on? I’m trying to make a planner like this that would allow for tracking things over time. Like time spent on the job & returns or time spent exercising and body weight.
Thank you so much for your hard work, this is great content. I do have a question though, how can we merge cells? I noticed after creating a table, that button is dimmed and I don't know how to undo that.
Hi, is there any way to make it so that an activity that takes place over a longer period doesn't show as repeated in each block after dragging it down? And also Display the time in the text?
thank you. great video !
Thanks so much, Rajan! I’m happy you liked this 🙂
very informative,,,
Glad you think so, Ajima! Thanks so much 🙂
Hiiiii... Thank you for the Tutorial. I still have trouble when I get into the validation. After the validation staff is done what I got on the schedule list is only *Activities. So, what should I do?
I think you forgot to put the '=' sign in the source section for data validation. Instead of "Activities", it should be "=Activities". When you highlight all the necessary blocks and press data validation, make sure you choose "Allow: list" and "Source: =Activities" in the validation criteria. Goodluck!
thank you so much YAcosta solutions this helped me so much god bless you stay safe
Thank you, Yoon! I'm happy this was helpful for you 🙂
hi, is there a way to create a new sheet for the next week but with correct dates and the table empty, without having to go through all the steps again?
How many activities can you add? Is it only 12?
Hi. You can have as many as you want. Thanks! 🙂
@@YAcostaSolutions it only let me have 12
Hi YAcosta soutions, thanks for the video really helpful.
Could you please inform us on a way to quickly add up the time spent on each "separate activities" each day on a sperate table?
I am trying to tally the length of time spent on each separate activities at the end of each week. Thanks!
I cant get it to work, neither in English or Swedish, it won't add the next hour, it just moves the inputted time / day / to the next cell. Your guide is really good, but what is wrong with myExcel (365).
Thank you soo much for this. The whole video was highly informative and Just plain Brilliant!
What kind feedback! Thanks so much. I’m happy this helped you 🙂
can i download this template?
Thank you so much for this video!
You're explanation is very concise and goes right to the point😃
Thank you, Niharika Jagdish. That’s sweet of you to comment 🙂 Happy this was helpful for you!
Kudos for the video content! Apologies for butting in, I would love your thoughts. Have you considered - Weydaniel Organized Dominator (Have a quick look on google cant remember the place now)? It is a good exclusive guide for getting 7000 plus project management and business templates without the headache. Ive heard some pretty good things about it and my mate got cool success with it.
After going to Data Evaluation and adding =Activities, Excel would not allow me to click on Error Alert with a box coming up stating, "A named range you specified cannot be found." I was unable to specify a range. Help.
You are a lifesaver
Thank you so much! I'm happy this helped you 🙂
Hey I can't repeat activities in the same and some don't even show up
Also, I want to have a sheet with list of activities with corresponding dates and times. And I want my calendar to be auto populated based on my entries in other sheets. Do you think you can help me with this?
How did you set Excel to automatically insert the times after 9:00 AM?
Hi, SJ. I used Autofill to fill in the times. Autofill / AutoComplete works by looking for a pattern in your data and then filling in the rest when you drag down or over.
For example, type 8:00 AM in one cell, then 8:30 AM in the cell below it. Select the 2 cells and drag down. Excel should identify the pattern and fill in 1/2 hour intervals. If you want to do hour intervals, you would type 8:00 AM, then 9:00 AM.
If this doesn't work for you, go to your File / Options / under "Advanced" / look for the "Editing" section. Make sure that "Enable fill handle and cell drag-and-drop" is selected.
Hope this helps. Please let me know if you have problems. Thanks
@@YAcostaSolutions thanks so much! That was an incredibly helpful description of what to do. Appreciate you taking the time to write it all out for me
Happy to help 🙂
How do I add an activity please?
Is there a way go quickly add up the time spent on the "activities" each day? -Thanks!
Hi, Refugio Rivas. See if this formula helps you:
=(COUNT($A3:$A23)-COUNTBLANK(B3:B23))*"0:30"
Here's how this formula works:
-The first part counts the cells in range A3:A23 that contain a value. Where A3:A23 refers to the cells in the column that contains the time labels.
-It then subtracts any blank cells found in cells B3:B23 (with this range being all the time slots for the first day). If your first day is a Monday, then Tuesday would be C3:C23, etc. And the cells with no activities would be the blank ones.
-It then multiplies the difference by "0:30". This represents 30 minutes for each time slot. If each is 15 minutes, then you would multiply by "0:15", and so on.
Last, you should apply custom formatting to the cell with the result. It would look like this:
[h]:mm.
I have a tutorial on time formatting that can help you understand this formatting. If you're interested, you can watch it here: ua-cam.com/video/gmvTMACw420/v-deo.html
Please let me know if this works for you. Thanks!
Pleas need help:
Does any body knows how to change dato on many activities together and not do it separately???
How about my activities are long why the words go to other side
Hi, Lee. Try this - select all the cells you want to apply the formatting to so that your words fit, then, with the cells still selected, go to the Home tab of your ribbon, then the Alignment tab. Here you'll find options to help you wrap the text as well as for how to position your text in the cell.
If the words are still too long, click to expand / open the Format Cells options. In the Alignment tab, you can select "Shrink to Fit." This will force the cell contents to be smaller.
Hope this helps and thank you!
@@YAcostaSolutions Thank you very much!!!
Thank you for sharing
Thank you for watching 🙂 I’m happy you liked this!
Thank you for sharing
Thank you for liking this 🙂
When i put in my dates and auto drag it shows ###### What can I do to fix this?
Hi, Musa. Usually, this happens for a couple of reasons.
First, make sure to check that your cell is wide enough to display the date. You can always extend the column width.
The hashtags can also show up if the date value is negative - which can easily happen from a typo. If your cell is wide enough to display the date, check that your date format is entered correctly in the cell and formatted with date formatting.
Please let me know if you continue to have troubles. Thanks
I can't do multiple dates the formula keeps saying #Value! What do I do
Hi, Ethan. Make sure your dates are entered with the month/day/year. Then, use format them to display only the month/date. For this, go to Format Cells, in the Date options, select the one that looks like 3/14.
I hope this answers your question. Please let me know if you need more help. Thanks
Nice. Thank you for sharing. Having been preparing for the exam. This is what I'm looking for. :)
Thank you, 刘文蒞 and best of luck with your exam! 🏆
Is there a way to add what room too meet?
Hi, C C. You could do 2 drop downs per time block (one for meeting type and the other for the room). This would require 2 rows per each time. You could then merge the cells for the time.
For example, say that rows 2 and 3 are both assigned to 8 AM. Row 2 could be the drop down for the meeting type. Row 3 could be the room selection. Then, cells A2 and A3 could be merged.
One thing to keep in mind, you wouldn't be able to format your schedule as a Table. As you can't merge cells in a Table.
I hope this helps. Please let me know if you have other questions. Thanks!
can anyone pls teach how to fit-in a column that have overlapped on the next page? thank you in advance
Hi, Yoda. This will take a little bit of playing around with your spreadsheet. First, in your View tab, select Page Break preview. This way you can see the changes right away.
You can try making the columns a bit smaller. If you select all your “day” columns together, you can drag them a bit to the left and they’ll all shrink a bit and all should have the same length.
You can also reduce your margin size. You’ll find the option to do this under the Home tab, in the Page Set up section.
I hope this helps! And thank you 🙂
@@YAcostaSolutions Thank you so much! This will rly help my spreadsheets look more appealing for presentations
You’re welcome! Also, forgot to mention another option - you can also set your Print Area, then in Page Layout, reduce the percentage size of what you’re printing. It’s kind of like the zoom viewing options, but for printing. You’ll need to do a test print to make sure it’s not so tiny that you can’t read it. I usually don’t like to go smaller than 85%, but it can vary by document.
i got an error!!!!! The sentence from the activities does not format like this video. they are just horizontally over the another column. Please help me someone (urgent)
Hey! Thank you for this video. Pretty much self-explanatory. Can u tell how to copy same format for next weeks?. I mean how to copy paste the table on horizontal and vertical pages next to this one.
Hi, Tarun. You can either use copy and paste to copy this next to the original on the same sheet or make a copy of the sheet.
To make a copy of the sheet, place your cursor on its tab, right-click and select Move or Copy. Then check off the option for “Make a Copy” and click OK.
Either way, you'll need to update the dates. You can then use Format Painter to copy the Conditional Format to your new copy.
To use Format Painter, select the entire original week, click Format Painter from your Home tab's Clipboard section, then select your new copy. The formatting, including the Conditional Format, will now be copied over.
I hope this helps. Please let me know if you have more questions.