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

I liked to follow very detailed examples shown in this video 😊. Thank you !

How do you make the color-coded things actually clickable to show only that content on the calendar?

Hi. I would like to have a color coded calendar with biblical characters and their children that covers 6,000 years. Any suggestions?

How do I calclate precentage worked on the different categories?

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?

This is a very effective tutorial on how to build a interactive calendar. Thanks!

How can i do recurring appointments in excel easily? Need my appointments to be HIPAA compliant so outlook does not work, TEAMS is HIPAA but you can't separate outlook and TEAMS calendars....any advice? TY

Thanks

Too fast..👎

Thank you sir for sharing. GOD bless you

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 :)

which excel is this? i may need to update

Wow! This is one of the best tutorials I have seen.

Thank you

Your clicking the mouse to make the colours flash lmao 😂😂😂😂

Genius i appreciate the video

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 :)

Super helpful!!!

I know this has been years ago, but can you design something can be updated to Outlook-shared calendar automatically with colors in Outlook, seen by various users? Please

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.

You explained very clearly and I only had to watch it like 7 times to get it, but thank you for time. Your awesome!

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 ?

I like it but so difficult you to fast

So fast I cannot follow so difficult

Good

thanks man uwu

Nice video

nice video.

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.

absolutely amazing video

Nice video ❣️❣️

Actual life saver !!! was attempting to do this for at least an hour and you video helped me through it in 5 minutes !

Good vide

Great info

wondering if there is a way I can export my outlook calendar into Excel so I can see al my weekly and bi-weekly meetings and make a meeting cadence spreadsheet.

Thank you soooo much!!!!

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!!

Can I also have a clear calendar and as I complete tasks just drag and drop on the days I choose ?

Excellent video well explained

Thank you!!!!!

Hi, Im looking to create a calander on excel for reservations and events scheduleing for a bar/restaurant to use for guest reservation details / group reservation details / Live events / F&B Special days / Holiday events... Do you have tutorial about this?

This is so helpful, thank you so much

Awesome - thank you so much!!

I don't understand how you added the same event on multiple days

is it possible to create a schedule that automatically populates your day based on level of importance?

How I get the space where you can type in your tool area where July is showing on to in you Excel blue area? Thanks

Many Thanks

This is super helpful. Ctrl + drag is the top.

wow