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
