Excel is a powerful tool. Using THREE formulas, the audience will be able to build a dynamic dashboard that can show different information depending on the drop downs selected. One report can show the all crime in District 2, and only homicides in all districts without the analyst needing to design different reports. While the report might take a few hours to set up, the dynamic functionality of those 3formulas will keep the report working as long as new data is added to another table. This is not a beginner excel course, and it doesn't require any macro or v-basic knowledge. All it needs is COUNTIF, SUMIF, and IF/THEN formulas. Come join us for November’s Free Friday Webinar on November 9, 2018, from 1-3pm EST as Sally Tarabah debunks all of your Excel fears.