Master Excel: Create an Interactive Inventory Tracking Dashboard!

Unlock the power of Microsoft Excel with this step-by-step guide to creating an interactive inventory tracking dashboard! In this comprehensive tutorial, you'll learn to leverage advanced Excel features including Power Query, data modeling, DAX measures, and Power Pivot. Whether you're a beginner or an experienced user, this video will enhance your Excel skills and streamline your inventory management. Join us and transform the way you handle data! Time Stamps: 00:00 Introduction 01:00 Data cleaning and transformation 08:45 Data Modelling 12:30 Wireframing 16:25 Setting up measures and power pivot 38:12 Formatting and Conclusion Link to the working files: Final Dashboard: https://docs.google.com/spreadsheets/d/13bvnD2yRONSal0uhp2tdKu10nCWnKcuq/edit?usp=sharing&ouid=118335135631370423932&rtpof=true&sd=true Working Files: https://drive.google.com/drive/folders/12nVomkGqEcUryf4K7g5CIZQB-EPE59_U?usp=sharing Other Interesting Videos: Power Query: https://youtu.be/EyKiPn02GGk https://youtu.be/SDBZkjxC4vY Excel: https://youtu.be/eaSg0mu6nLM