EXCEL PORTFOLIO PROJECT | Build this Interactive Dashboard

Take Your Data Analysis Skills To The Next Level 🛣️ Ultimate Data Roadmap ➡ 💼 Ultimate Data Portfolio ➡ 📝 Ultimate Resume Template ➡ 🎓 1:1 Mentorship ➡ 📰 Career Compass Newsletter ➡ 💻 Portfolio Projects ➡ Follow me Professional Certificates 📊 CourseCareers Data Analytics Course ➡ 📈 Google Data Analytics Professional Certificate ➡ 💻 Google Advanced Data Analytics Professional Certificate ➡ 💹 Tableau Business Intelligence Professional Certificate ➡ 🖥️ Microsoft Power BI Data Analyst Professional Certificate ➡ 📖 IBM Data Science Professional Certificate ➡ 📝 Google Project Management Professional Certificate ➡ Related video 📊 Fastest Way to Become a Data Analyst ➡︎ Github repo for files ➡ Timestamps 00:00 Project Walkthrough 05:00 XLOOKUP 11:29 INDEX MATCH 17:46 Multiplication formula for Sales 18:12 Multiple IF functions 21:15 Date Formatting 22:50 Number Formatting 24:17 Check For Duplicates 24:45 Convert Range to Table 25:58 Pivot Tables and Pivot Charts + Formatting 32:05 Insert Timeline + Formatting 36:17 Insert Slicers + Formatting 36:48 Updating the Pivot Table Data Source 49:22 Building the Dashboard 53:54 Pro Tip 55:16 Outro 🙏 Thanks so much for taking a little time out of your day to watch this!