Creating Dynamic Calendar in Excel using Functions | SEQUENCE | WEEKDAY | SPIN BUTTON
In this video, we will learn how to create a dynamic calendar in Excel using functions like Sequence and Weekday.
Don't worry if your excel doesn't have a Sequence function, I will show you an alternate method as well.
Once this is created, use your creativity with Conditional Formatting to highlight various date-related events.
Check the practice file on the below link.
https://bit.ly/3G13M5A
00:00 Intro
00:45 Sequence function
01:37 Align First Date with correct Weekday
03:10 Basic Calendar Formatting
03:38 Conditional Formatting
05:05 Dynamic Month Selection
06:49 Formula without Sequence
08:14 Outro
Also, if you want to learn more check these videos
1 Min Excel: If you enjoy short videos check this section
• Shorts : Random
Excel: Check this playlist for Excel-related things
• Excel
Keyboard Shortcuts: Check this section to save some time in everyday excel work
• Excel Keyboard Shortcuts
Pivot Tables: Check this playlist for Pivot Table, Slicers, and Auto refreshing reports
• Pivot Tables
Power Query: Check the Power Query playlist for Data Preparation & its Automation
• Power Query
Power BI: Check the PowerBI related videos for Business Intelligence, Dashboard & Visualisations
• Power BI
Please subscribe to our channel and Follow us on other social media platforms for regular updates :
Tiktok https://vm.tiktok.com/ZSH28XEt/
Facebook / datacense
Twitter / datacense
LinkedIn / datacense
Instagram / datacense32