You’ve got a massive amount of data in a spreadsheet 1200 rows & 40 columns, and it just keeps growing. But there are just 5 to 10 things you want to know about this information. How are you going to dig it out? Some people give up and just guess.
Let’s bring together Pivot Tables and Excel functions to build dynamic summaries of the most important details; i.e., a Dashboard.
We’ll go over the diagnosis of the data quality, discuss layout of the dashboard, build the dashboard and install internal alerts to ensure that we can trust the dashboard’s results.
After the course, students will be emailed a copy of the finished work.
NOTE: The content of this workshop will be solidly intermediate Excel skill level. Beginners are welcome if they’d like to see what’s possible.