Watch Make a Dynamic Task Management Tracker in Excel! Video Tutorial

Make a Dynamic Task Management Tracker or Project Management Tracker in Excel. 👉 Get the 5 Essential Resources for Using ChatGPT at Work: https://clickhubspot.com/3ff29f 🆓 DOWNLOAD Free Excel Start file for this video: https://careerprinciples.myflodesk.com/xmg83kahie In this video, I'll show you how to make an interactive task management tracker in Excel. On the top of the Excel dashboard, we'll will show the KPIs, including tasks completed, tasks in progress, and tasks not started. We will also show the distribution of tasks by owner and employees and the number of tasks that are overdue. Below will show all of the different tasks, with formulas and conditional formatting to detect the task status, and which tasks are overdue. Throughout we'll be using Excel formulas like COUNTIF, SUM, or TODAY to make sure the file is dynamic. We'll also be using Excel tables, conditional formatting, drop-down lists, and much more to create a fully interactive task management tracker in Excel. Finally, for the KPIs, we'll be using bar charts, text boxes, and shapes. LEARN: 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance 📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course 🔥 Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics 🚀 All our courses: https://www.careerprinciples.com/all-courses ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00​ -​ Setting Up the Tasks 3:42​ - Future Proofing the File 5:28​ - Adding KPI shapes 8:32​ - Adding the KPI Values 15:55​ - Improving the User Interface