Make an Awesome Dynamic Calendar in Excel
Om episoden
Episodebeskrivelse
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/all-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
Se mer fra samme kanal
Flere episoder fra denne kanalen
Dette kan interessere deg
