Interactive Excel Dashboards

About this course

**Includes exercises and two, follow-along Dashboard Projects**Have you ever looked at an interactive dashboard in Excel and thought “I wish I could create something like that!”. Well, now you can. We’ve drawn on our years of expertise as a Microsoft Excel training provider and have put together the ultimate Excel dashboards course.We’ll teach you how to create dashboards that look amazing, that are fully interactive so you (or anyone else!) can change the data they are seeing, and that can be updated with new data in a couple of clicks.If you need to analyze and present data in Excel, then this course will show you step-by-step how to create jaw-dropping Excel dashboards that leave people wondering how you became that good in Excel!In this advanced Excel course, we look at how to create stunning, interactive dashboards in Excel.Once we’ve taught you all the techniques you need to create your dashboards we end the course with two, super projects:Creating a fully interactive Sales Dashboard from scratchCreating a fully interactive HR Dashboard from scratchIn this course you will learn:About Dashboard architecture and inspirationHow to prepare data for analysis (cleaning data)Useful formulas for creating dashboards in ExcelHow to create and edit Pivot Tables in ExcelHow to create Pivot Charts from Pivot TablesAdvanced chart techniques in ExcelHow to add interactive elements (form controls) into your dashboardsHow to create a Sales Dashboard from scratchHow to create an HR Dashboard from scratchThis course includes:9+ hours of video tutorials70+ individual video lecturesExercise files to practice what

Course objectives

• to teach participants about dashboard architecture
• to enable students to add interactive elements to their dashboards
• to provide hands-on experience through real-world projects