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

🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/y17dxr829z

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 add-ins. More specifically we'll use the mini calendar excel add-in. 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/courses/power-bi-for-business-analytics
The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
All our courses: https://www.careerprinciples.com/courses

SOCIALS:
Instagram - https://www.instagram.com/careerprinciples/?hl=en
🤳 TikTok - https://www.tiktok.com/@career_principles
🧑‍ LinkedIn - https://www.linkedin.com/company/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 Add-in