With the modern Excel power tools, you can transform raw data into insightful and interactive reports. Then, when new data comes in, the reports can update themselves with a simple button-press. In this session, we’ll leverage tools like Power Query and Power Pivot to build dashboards you can use to make data-driven decisions.

Topics include:

• Importing and cleaning data with Power query
• Transforming and shaping data sets
• Designing dynamic PivotTables for flexible reports
• Building interactivity with slicers and timelines