Creating Dynamic Calendar in Excel using Functions | SEQUENCE | WEEKDAY | SPIN BUTTON
2.7 هزار بار بازدید -
3 سال پیش
-
In this video, we will
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 Facebook: datacense
Twitter Twitter: datacense
LinkedIn LinkedIn: datacense
Instagram Instagram: datacense32
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 Facebook: datacense
Twitter Twitter: datacense
LinkedIn LinkedIn: datacense
Instagram Instagram: datacense32
3 سال پیش
در تاریخ 1400/07/23 منتشر شده
است.
2,774
بـار بازدید شده