Make an Awesome Dynamic Calendar in Excel

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 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/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 Add-in