Тёмный

TECH-011 - Create a calendar in Excel that automatically updates colors by event category 

The Excel Challenge
Подписаться 54 тыс.
Просмотров 869 тыс.
50% 1

YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT www.theexcelchallenge.com
Learn a quick trick to automatically change the event colors in your calendar, accordingly to the text you are entering in the different cells.
You will use simple concepts like autofill, select all, and conditional formatting.
I hope this trick is something you can use in your projects so you get more with less effort.
If you have an Excel challenge that you need help with, whether it is at work, at home, or at school, please write it in the comments below. I try to resolve common Excel challenges of our viewers and subscribers.
Thank you for watching.
Check out some of our previous videos in the links below:
* TECH-010 - Fill several blank cells (empty cells) all at once
• TECH-010 - Fill severa...
* TECH-009 - Create a TOP 5 chart (Pareto) that updates automatically
• TECH-009 - Create a TO...
* TECH-008 - Create a chart with stacked pictures
• TECH-008 - Create a ba...

Опубликовано:

 

10 июн 2017

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 236   
@ZTGaming91
@ZTGaming91 4 года назад
Actual life saver !!! was attempting to do this for at least an hour and you video helped me through it in 5 minutes !
@notmichelle4552
@notmichelle4552 5 лет назад
I need this so much, thanks a bunch. You're basically a life saver.
@AI-ec2qb
@AI-ec2qb 3 года назад
I got a better formula for your 32 days... lol
@ccpnavigator5583
@ccpnavigator5583 4 года назад
Excellent!! I am a beginner Excel user and was able to follow along and create a perfect usable calendar for work projects. Thank you for sharing!
@karladuenas441
@karladuenas441 4 года назад
You are the master! Thank you for posting this video! Blessings!
@elisan320
@elisan320 5 лет назад
Thank you very much for this thoroughly informative video. You explain things so well. I truly appreciate your explanations.
@perrymagpoc4410
@perrymagpoc4410 5 лет назад
This is great information - I already know someone who could use this procedure - Thank you
@JoseGarcia-zn6hw
@JoseGarcia-zn6hw Год назад
You explained very clearly and I only had to watch it like 7 times to get it, but thank you for time. Your awesome!
@taniogbe9777
@taniogbe9777 3 года назад
So useful! Thank you so much for this very clear and detailed information!
@weneedmoreconsideratepeopl4006
Life-saver. Thank you so much!! Love how you answer (like a pro) whoever asks for more info. You're doing a great job, it kinda inspires me to do the same.. For now, hi from a new sub 😁 Will be lurking around and trying out some of your vids
@waellerbe
@waellerbe 6 лет назад
Your video example is truly *amazing*. Can't thank you enough for sharing this incredible information with us here on RU-vid. My appreciation for Excel has grown, thanks to the instruction that you shared. Continued blessings in return.
@TheExcelChallenge
@TheExcelChallenge 6 лет назад
William, it is very encouraging to see that my work is helping others on the other side of the PC. Your words are a motivation boost for me to continue producing content that others can use. Blessings for you as well. Come back to see the videos I often post.
@Waitatiri
@Waitatiri 5 лет назад
Thank you for the detailed and clear information!
@billkoch2189
@billkoch2189 6 лет назад
This is genius -- thank you so much! I'm using this to create a content creation / review calendar for work. The formatting is great -- and numbering the days of the week with a formula is a huge time saver.
@TheExcelChallenge
@TheExcelChallenge 6 лет назад
Hello Bill. Thanks for your comment. I'm really happy to read this video was helpful for your work. I hope you can use it as a time saver so you can go and spend that time in other more important things in life, like spending time with the family. Good picture!! T-E-CH
@yarafortes6978
@yarafortes6978 7 месяцев назад
Same reason I can to find the video 😂
@roomiesroom
@roomiesroom Год назад
Wow! This is one of the best tutorials I have seen.
@mundex125bieszczady
@mundex125bieszczady 5 лет назад
Dzięki. Tego szukałem długi czas :). pozdrawiam
@dminky1126
@dminky1126 Год назад
This is a very effective tutorial on how to build a interactive calendar. Thanks!
@vicka77ukraine
@vicka77ukraine 11 месяцев назад
I liked to follow very detailed examples shown in this video 😊. Thank you !
@reformerx667
@reformerx667 2 года назад
This is super helpful. Ctrl + drag is the top.
@mirzajuaid8
@mirzajuaid8 3 года назад
Bro you’re simply dope .... I thought it will be very tough... you made it very easy... love you alot.
@crumbcatdancing
@crumbcatdancing 3 года назад
very informative thank you for making this i really appreciate it!
@ccnmedia3605
@ccnmedia3605 5 лет назад
Thanks from Canada!!
@mariamaria9178
@mariamaria9178 2 года назад
Thank you so much for this!!!! Very easy to follow with you and I learnt alot!!! I am preparing a Training matrix for my job this was very helpful!!
@lalalama4591
@lalalama4591 3 года назад
Thank you for this video! It will help with my backward calendar assignment
@amber6029
@amber6029 3 года назад
Awesome calendar and tutorial! Thank you!! And damn you type fast!!
@christinewaithera8092
@christinewaithera8092 4 года назад
Thank you so much. I really appreciate 😘
@fatemahsairat2120
@fatemahsairat2120 3 года назад
Excellent tutorial! thank you so much
@hectorslovebug6429
@hectorslovebug6429 4 года назад
This was so helpful. Thank you.
@fannyy90
@fannyy90 3 года назад
Game changer. Thank you!
@darylwhite9687
@darylwhite9687 2 года назад
I liked your demo. A challenge for me: assigning people (2-4) for different shifts (2, 2hr shifts) for different locations (4-6 locations, varies by lication and by day) for a calendar.
@marianaah88
@marianaah88 6 лет назад
Extremely usefull, thanks!
@TheExcelChallenge
@TheExcelChallenge 6 лет назад
Good to hear you found it helpful Mariana.
@rewaltersnc
@rewaltersnc 4 года назад
Thank you!
@lujain_1997
@lujain_1997 2 года назад
This is so helpful, thank you so much
@elizaporras2612
@elizaporras2612 3 года назад
THANK YOU SO MUCH!!!!
@midkort
@midkort 3 года назад
Thanks! This is very useful.
@crasaqmohamed7741
@crasaqmohamed7741 3 года назад
Thank you for sharing! :)
@oligei666
@oligei666 3 года назад
Thank you soooo much this is soooo useful !!
@jodibur7418
@jodibur7418 4 года назад
thank you for sharing this video.
@a1moto283
@a1moto283 2 года назад
Awesome - thank you so much!!
@MdSohelRana-cl5lk
@MdSohelRana-cl5lk 2 года назад
absolutely amazing video
@amaliatacadena7058
@amaliatacadena7058 Год назад
Thank you sir for sharing. GOD bless you
@gp2296
@gp2296 Год назад
Excellent content and very well explained. Is there a way to be able to filter down based off of event and only see those events on calendar once filtered? Please help :)
@zmoullan86
@zmoullan86 4 года назад
super explanation. thanks.
@yarafortes6978
@yarafortes6978 7 месяцев назад
This videos was very useful. Thank you so much🩷 keep up to good work.
@julkernaim
@julkernaim 4 года назад
Many many thanks.
@ekangl1275
@ekangl1275 4 года назад
Nicest content I've seen today.
@tamidara
@tamidara 3 года назад
Thanks a lot. It was helpful.
@nancyj5871
@nancyj5871 3 года назад
Awesome!! Very helpful for me.thanks! Can you please make a tutorial of How to create a Swap schedule
@diptibist2222
@diptibist2222 5 лет назад
Great!!
@allanalcancia3715
@allanalcancia3715 4 года назад
Nice work. Thank you! Need your help for a sign-up sheet that calculates the number of registrants and wait list
@carop9434
@carop9434 Год назад
Super helpful!!!
@aaronaustrie
@aaronaustrie 3 года назад
Great demo bro!
@SukkarinAcademy
@SukkarinAcademy 5 лет назад
wow thank you so much
@crystalskullsucked
@crystalskullsucked 2 года назад
Thank you!!!!!
@krisannecajano9684
@krisannecajano9684 5 лет назад
Thank sir. 😁👍🇵🇭🤓
@narpindersingh5733
@narpindersingh5733 3 года назад
I need this one thanks so much
@aureliojaimes4438
@aureliojaimes4438 2 года назад
Thank you soooo much!!!!
@TheAcizgirl
@TheAcizgirl 3 года назад
Thanks u. I am using this very sheet for my skincare calender
@rim_des7652
@rim_des7652 3 года назад
Thanks!
@CherishedNike
@CherishedNike Год назад
Genius i appreciate the video
@GeorgeAJululian
@GeorgeAJululian 2 года назад
Many Thanks
@danielpavlin
@danielpavlin 2 года назад
Dude, your awesome
@tsekokhumalo4024
@tsekokhumalo4024 2 года назад
you exceptional
@maryfrancis8288
@maryfrancis8288 3 года назад
Soo helpful!!!!
@umerkayani79
@umerkayani79 5 лет назад
Thanks sir
@StayceMichelle
@StayceMichelle 3 года назад
Thank You!
@Randomtrend111
@Randomtrend111 2 года назад
Excellent video well explained
@carolobrien9311
@carolobrien9311 4 года назад
Thank you so much for this info. Do you know how to copy a template and all the events from one year to the next
@nashreennadzmi6122
@nashreennadzmi6122 3 года назад
Hi, what did you do to highlight the cells when you hover over a category? At the start 0:05
@monicahart1972
@monicahart1972 Год назад
Hi -= this is a great video, so well explained. I'd like to be able to do this for a 6 month calendar instead of monthly, is there a way to turn the formula function off once I've created the calendar so I can write in the same cell as the date?
@mostlikely...
@mostlikely... 2 года назад
Great info
@Miyunz
@Miyunz 3 года назад
Thank you so much
@PAWORDI
@PAWORDI 4 года назад
thnx for uploading this video
@paulisskylark3958
@paulisskylark3958 5 лет назад
Thanks you so much :_)
@khawajarizwan7006
@khawajarizwan7006 7 месяцев назад
thanks very useful
@ladykilla6
@ladykilla6 Год назад
Hi thank you so much, is it possible to have set dates for categories as well that way they auto populate into the calendar along with color ?
@elviequilang5673
@elviequilang5673 2 года назад
Thank you verymuch sir
@yuvarajpatilpoetry6170
@yuvarajpatilpoetry6170 Год назад
Thank you
@farihinrimu7142
@farihinrimu7142 4 года назад
It was pretty useful
@mahniamcmullen2865
@mahniamcmullen2865 6 лет назад
This is Great! Thanks for the video. Is there any way to make this full page sized for printing? I would like to post this in my kitchen for my family, and I am having trouble trying to make it proportionally bigger to a full page with the template on the bottom.
@TheExcelChallenge
@TheExcelChallenge 6 лет назад
Hello Mahnia. Thanks for watching. I'm glad to hear you liked it. You can adjust the size of your calendar easy. First select the print area you want printed, and then go to the "Page Layout" tab and click on the "Print Area" button. Then click on the "Size" button and select the size you need. Finally, on the bottom right of the "Page Setup" group in the same tab you will see a small arrow pointing to the bottom right. Click on it to display the "Page Setup" window. In the "Scaling" section of the "Page" tab you will see the "Adjust to" button. Adjust the size of your print out until you are happy with it. I tried 135% and it fits an 8 1/2 x 11" sheet. Now, your printer, row heights and column widths will be different than mine, so just keep adjusting. If you want my file, I can email it to you. Just send me your email address. Thanks for watching.
@perrymagpoc4410
@perrymagpoc4410 5 лет назад
Challenge - I have a spreadsheet that has events in columns and rows, but I want to auto-populate an excel based calendar, without having to cut and paste the values into the calendar. Auto-update of the spreadsheet changes would be a good bonus. I actually have to do multiple months, but If I can get one month to work. I can sort the spreadsheet into months and work it one month at a time. Thank you
@phylyn7630
@phylyn7630 2 года назад
Thank you so muchh😍
@johanangabriel3159
@johanangabriel3159 4 года назад
Very Nice. Question.. Is there a way to add up at the end of week or month how many Practices, Gym, ETC.. automatically?
@frankvalle308
@frankvalle308 4 года назад
very educational
@tokamedia4063
@tokamedia4063 4 года назад
great content bro... salam creator excel from indonesia
@Anikvikram
@Anikvikram Год назад
Thanks
@hursty28
@hursty28 3 года назад
When you enter items into cells can it be set so it has to be the exact word on your list that changes colour and not if a letter is in the text it changes
@Dayana17ist
@Dayana17ist 2 года назад
Awesome
@emmanuelerinwusi5539
@emmanuelerinwusi5539 3 года назад
Thanks boss
@biplabgayen5400
@biplabgayen5400 4 года назад
Hello sir please make a vedio regarding automatic school class schedule.
@samantha6670
@samantha6670 2 года назад
Amazingly explained. Would have been great with hours ( 9:30, 10:00, 10:30..) on the left side
@karensmith1946
@karensmith1946 3 года назад
Great video. But is there a way to convert my data in a spreadsheet automatically into a calendar just like the one in the video? Thanks for any help.
@mohamedalitalbe739
@mohamedalitalbe739 3 года назад
شكرا جزيلا
@bryanjayzacarias7250
@bryanjayzacarias7250 Год назад
Challenge - I have sheet1, sheet2, sheet3, sheet4 and sheet5, every sheet contains date and time of the 12months, for example Sept. 09, I put an agenda on the 9am, then in sheet 2 I put agenda on 12nn, next sheet, 2pm, sheet 4 3pm and sheet 5 5pm. Then in Sheet 6 it shows all the activity I made on different sheet. I hove you notice my comments, because It is very big help to manage the class activity of 5 section handle. Thank you so much :) very helpful videos you always content :)
@TheExcelChallenge
@TheExcelChallenge Год назад
Hi Bryan and thanks for your comments. I’m not 100% sure I understand the challenge. Do you have a sheet you can share with me to look at? If yes, email it to theexcelchallenge@gmail.com and I’ll check it out.
@shaniyapickleberri8986
@shaniyapickleberri8986 5 лет назад
How can I get excel to auto fill info. into a specific date cell based on the information entered in another dated cell? Its for a calendar schedule log & I dont want to have to enter followup appointments manually
@bilalsabri6614
@bilalsabri6614 4 года назад
can you please make a video about how the employee attendance record template works in excel? i need some validations and formulas used there but cant figure out how it works. its so complicated for me help please!!
@mdhorton422
@mdhorton422 3 года назад
Is there a way to filter this calendar by the 'type'; so for example if you only wanted to see the practices you had scheduled for the month.
@joannstreem9921
@joannstreem9921 Год назад
This was great. Do you know if there is a way to take data in a table format and have it show up on a calendar view like this? I am trying to create something to manage multiple childrens activities. Thanks.
@ajmacconville1
@ajmacconville1 Год назад
Yes please! This is exactly what I'm looking for too. If you find it, please do share 🙏
@MdSumon-tp2km
@MdSumon-tp2km 2 года назад
nice video.
@wadetomczyk8043
@wadetomczyk8043 5 лет назад
Nice
@mdsoibe6282
@mdsoibe6282 2 года назад
Nice video ❣️❣️
@simuislam5752
@simuislam5752 2 года назад
Nice video
Далее
24 часа в самом маленьком отеле
21:19
Create a Team Calendar in Excel
7:35
Просмотров 413 тыс.
Create a Calendar in Excel - Tutorial
8:07
Просмотров 80 тыс.
How to create a Work Schedule (Roster) using Excel
11:25
Creating a Calendar in Excel
8:24
Просмотров 941 тыс.
How to Make an Event Calendar in Excel - Part 1
11:53
How I format a schedule in Excel
11:29
Просмотров 46 тыс.
Daily Activity Tracker In Excel
18:37
Просмотров 207 тыс.