Make a dynamic calendar in Excel (3 different methods)
Take our Finance & Valuation Course: https://www.careerprinciples.com/cour...

DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.co...

In this video I'll show you 3 ways to create a dynamic calendar in Excel. First we'l use Excel's built in templates to create a new tab for every month. Second, we'll build a calendar from scratch in Excel using formulas such as the sequence, weekday, and weeknum. We'll then make the calendar dynamic with dropdown lists. Finally, we'll use the free addins. More specifically we'll use the mini calendar excel addin. By the end of the video, you'll have made full page calendars by month, as well as dynamic calendar where you can switch the month, year, and week number.

LEARN:
Power BI for Business Analytics: https://www.careerprinciples.com/cour...
The Complete Finance & Valuation Course: https://www.careerprinciples.com/cour...
Excel for Business & Finance Course: https://www.careerprinciples.com/cour...
All our courses: https://www.careerprinciples.com/courses

SOCIALS:
Instagram https://www.instagram.com/careerprinc...
TikTok   / career_principles  
‍ LinkedIn   / careerprinciples  

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ ​ Excel Calendar Templates
1:55​ Excel Calendar with Formulas
8:26​ Making it Dynamic
9:11​ Adding Conditional Formatting
10:11​ Calendar Free Addin