Create Easy Yearly Calendar in Excel and Sheets with a SINGLE Formula
ฝัง
- เผยแพร่เมื่อ 11 มิ.ย. 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
In this easy-to-follow video, we guide you through the process of creating a dynamic, interactive yearly calendar using just one formula in both Excel and Google Sheets. This tool is perfect for anyone looking for a customizable calendar template.
⬇️ DOWNLOAD the workbook here: pages.xelplus.com/dynamic-cal...
🔑 Highlights:
▪️ Learn to make a yearly calendar that updates with a change in the year.
▪️ Discover how to use the SEQUENCE function for an entire year's calendar.
▪️ Understand the use of the DATE and WEEKDAY functions to identify start dates.
▪️ Improve readability with conditional formatting for better visual appeal.
▪️ Find out how to distinguish different months with color coding.
With this calendar you're able to input the year in a cell and the calendar will update automatically for you. To make the calendar even better I use Excel conditional formatting to color every other month in a different color (MOD function can be used here to identify every other month).
You can also use this Excel calendar in your dashboards. It's interactive and you can combine it with data entry for the year.
00:00 Yearly, Dynamic Calendar in Excel and Google Sheets
00:42 SEQUENCE Function for a Yearly Calendar in Excel and Sheets
02:22 DATE and WEEKDAY Function to Identify the Start date
06:11 Conditional Formatting to Improve Readability for Yearly Calendar
Video on MOD Function: • Excel MOD Function - E...
Playlist for Excel 365 new formulas and functions: • Excel for Office 365 &...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel
Grab the file I used in the video from here 👉 pages.xelplus.com/dynamic-calendar-file
Anyone ever told you.... "You r the best teacher on the globe?" Keep up the good work. Really appreciate all your efforts.
That's really kind! Thank you for watching and commenting.
Liela create a channel on VBA..🙏
Your channel is the first and only place I go for Excel help. Everything is so clear and concise. Stuff that used to take me hours to figure out takes ten minutes now. You're a hero in my book!
I've learnt more about date management in excel in these 10 minutes than in 10 years of no-brain use of it. Thanks!
I have been watching many excel help videos, your teaching is the most clear and understandable! I really appreciated! From now on, I will keep on watching your videos! Love it!
Leila, you deserve all the money in the world for helping so many people!!
Wow, I just discovered your videos and already watched 4 today - super helpful and extremely well done! Thank you!
I am going to start binge watching your Excel and PowerPoint videos! You are awesome! Thank you!
Love it Leila. What a difference from creating calendars dynamically in the past. Thanks for the great video as always.
Thanks so much! 😊
Really useful, Thanks again Leila!! Amazing O365 improvements!
Awesome, didn't know that this is possible with only one function.
Thanks for sharing and for your amazing teaching skills!
I’ve never learned from someone who explains themselves so clearly. Thank you Leila!!
Glad it was helpful! Thank you.
I have some questions about excel and power bi what is carrier level of excel and power bi ..What is level required to got job on these two technology's iam already 1 year experience in excel but I idea what I can do for got job in Karachi Pakistan or others country please suggestions me leela or any one
Liela create a channel on VBA..🙏
Nicely done, Leila! Easy to follow, logical, and articulatley presented. Thank you.
Glad you enjoyed it, Nathan!
It is just so simple to understand after playing it over 20 times slowly. Thank you.
Amazing .. watch any number of times ... your learning skill is excellent ... a big thank you again
You're the best Leila! Thank you for teaching us in a great way 🙏
You are So inspirational Leila... God Bless You!!!
Leila your videos are truly great and are helping me a lot. You make everything super easy.... A big thank you
this is incredible . i never knew that excel can have a calendar with just a formula o.my.god thank you so much leila . you put a lot of effort on these tutorials proud of you . wow 👍👍
Glad you like it, Mark!
@@LeilaGharani i'm of couse leila
What I really like about this & other video of yours is that the learning one gets. More than the main concepts there are minor things e.g. conditional formating nuances etc.. in this one. Very well done !!
Awesome, thank you!
Oh my. Your beautiful brain is solving so many problems that I use to solve by excruciating sessions trying to learn special skills in Excel.
I am humbled by your knowledge and motivated to learn more. Thank you!
It’s really nice and time saving, Tank you Leila
Genius.
Such brilliantly constructed videos too.
just love the way you explain. cheers
Whenever I watch your video, whenever I learn something new. Thanks a lot Leila.
Happy to hear that!
I have soooooo much to learn in life... and only fewer than about 30 years to learn it in! Every time I watch your videos and other such on You Tube, I realise that I know nothing!
Many thanks...
I always like your innovative way of thinking for using functions and formula
Thank you very much. I learn a lot from your tutorials.
THANK YOU SO MUCH!!!! Excellent presentation...!!! You are a great teacher!!!
Thank you so much for this! You are seriously the best!
These tutorials are amazing, thank you.
Fantastic tutorial. I learned several new things on this one. Thanks again Leila!
Glad it was helpful!
WOW! This is awesome! So many calendars I've made over the years that were a lot more manual. Thank you!
You are so welcome!
Your voice is very soothing and pleasant to the ears! You’re a very good teacher and trainer. Wow! More power! 👏👏👏
Hi Leila, do you have videos which may be helpful in monitoring stocks in excel? Thanks a lot in advance.
So handy and step by step explanation.
Thanks for sharing
Brilliant Trick!
Many Thanks
Wish you be always Healthy & Happy:)
thanks Leila, smart info from a beautiful teacher!!
You explain very clear and at pace anyone can keep up with, thank you from a Newbie.
Fab video. Very useful. Thanks.
Smart as usual, Leila
Thank you!
This is simply a great way to create a calendar which was frustrating till now. Your presentation is awesome. Thank you so much!
Most welcome 😊
every time the videos teach me something! good work!
Great tutorial! Thanks for sharing this with us!
Thank you for your nice and informative videos
Very good and useful. Thanks a lot.
Loved the music in the end - Relive uses exactly the same tune :) Joke aside, Leila taught me to use excel more efficiently in a few videos than what I learned since Office 2.0 in 1996 or something! Another excellent and simple video! Thank you
Wow, amazing. Thank you for the video.
Truly you are amazing tutor
Thank you Leila. A great formula update to create a yearly calendar, with a nice CF for the different years.
You're very welcome, Steve!
Thanks a lot...you are wonderful!
I always thought it was very complicated to make an excel calendar. But you showed in this video that there is a very simple and easy way to create the calendar. Thank you Leila.
You're very welcome, Jean!
Awesome Leila! This is really helpful. Your style and explanations are excellent!
Thank you so much, Charles!
wow! Brilliant!! Thank you so much
Yeah, it’s amazing how much you can do in one cell now. With the addition of the LET function as well, you can do a lot more with a lot less.
Very true Andrew....
Nice job. Thanks for the formula.
thank you for this!
Super! Thank you Leila.
Awesome.....Thanks for sharing
Great learning. Thanks for the video.
I’ve always loved Excel really , but all the tricks I learned from you add much flavours to it!!! Thank you
Glad it was helpful! Thank you.
Brilliant! I honestly had my doubts that you could do it with one formula....but I had never used the Sequence function before: thanks for introducing me to that function.
Plus the use of multiple conditional formatting rules to add dynamic formatting was a very sweet touch.
Excellent video. Will definitely make use of this in project
Really appreciate your efforts
Thanks 👍
Thanks for your lessons
It's my pleasure.
You change my life on a weekly basis!
Great lecture
Stumbled upon this video today. It didn't take much time after watching the video to subscribe. Thanks for this so interesting and informative video.
Thanks for this channel. I recently started learning excel in.my old age. And I am sure I will soon become pro in excel by seeing your channel tips and sessions on excel. This is helping me a lot in excelling in my job. Thanks for becoming an idol for old age learning students who somewhere struggle with new generation on these new tricks..
AGAIN THANK YOU VERY MUCH FROM THE CORE OF MY HEART..YOUR SUGGESTIONS ARE HELPING ME IN EARNING MONEY..
This is SO AWESOME!! Thank you for sharing these extremely useful tips!
You're so welcome!
Amazing. You are great. Thanks for sharing. 😊
Simply amazing! Subscribed!
Welcome aboard!
Thanks liela. Thanks again.
Awesome, good job and thx a lot
Brilliant as always! Love your videos. Keep it up 😊
Thanks so much! 😊
Leila Ma'am you are brilliant...
Brilliant as always - thanks :)
Great tip!
Je vais essayer, Merci Leila !
Thanks Leila! My day is not complete if I don't learn something from you! :)
Thank you very much
So helpful!
Muchas gracias! era exactamente lo que estaba buscando :)
This was great and useful 🙏
Nice use of SEQUENCE, love these dynamic array functions!
Many thanks Doug!
I watched the entire video and the last few frames were good to hear since I am using Excel 2019 . I practiced the same in google sheet.. thanks
There were multiple banners explaining it's in 365 including online but glad it made sense eventually. I'm annoyed MS doesn't allow some functions like queries in online 365 but doesn't in 2019, but that's a different conversation
Excelente trabajo, soy un apasionado de los calendarios
Awesome, Awesome, Awesome. Your videos demonstrate platinum standards of simplicity !!
Thank you very much!
Great
Thank you
An excellent tutor
Brilliant! Thanks.
Great stuff. Dynamic arrays are great
Yes they are, Patrick!
Thanks! Really great information as usual - added this calendar hack to my bag of tricks.
Great! Hope it'll come in handy.
Very cool! I liked the conditional formatting at the end. Nice touch.
Thank you! Cheers!
This is super easy and so helpful. Great video. Thanks a lot!
Great to hear!
You nd Your Video is Awesome!
Leila, that's an amazing idea to apply dynamic arrays to generate calendar! Great great application of dynamic arrays!
Glad you think so!
Wish I found your videos a lonnng time ago. I’ll be retiring soon but always want learn.
Your video are great for everyone-non power user and power user alike.
Stay well.
It was awsum learning, thanks Leila
You're welcome 😊
Thank you so much, Leila