Dashboard using Advance Excel |Excel Project| Advance Excel | Yajat Goswami | Ivy Pro School

Get Started with your own Analysis now: https://bit.ly/3cL1Css Advance Excel Project on creating a Dashboard. Steps to create this Dashboard:- Step 1:Setup your data, make it ready to perform operations by cleaning the data. Step 2:Create relevant data summary using Conditional function(Sumif) on the basis of how you want your chart to look(Be clear about it) Step 3:Create a form control and link it to the sheet where your summarized data is present. Step 4:Now using Vlookup create a dynamic table in which the data will change depending on the value of form control. Step 5:Create a chart using this dynamic table. This chart will now vary as we select different dates. Step 6:Follow Step 1 to 5 for the other 3 charts as well to create the desired dashboard. Like, Share, and Subscribe to our channel!! Want to take up a Data Science and Tableau Course, Visit us at https://ivyproschool.com/growwith/ For More Info Call Us At 7676882222 #ExcelProject #AdvancedExcel #IvyPro