Modern Excel - The Supercomputer Hiding on Everyone’s Desktop

Discover the hidden power of Excel in this conference talk from PASS Data Community Summit. Explore how Microsoft has integrated advanced Business Intelligence and Reporting engines into Excel, making it a powerful tool for data-driven decision-making. Learn about multi-data source import, rapid data shaping and cleansing, creating reusable "portable" formulas, and constructing insightful reports and dashboards. Gain hands-on experience through an end-to-end walkthrough of these game-changing Excel-based tools, designed for immediate success. Delve into topics such as Power Pivot, data modeling, relationship diagrams, and advanced functions like VLOOKUP. Uncover the potential of Excel as a supercomputer on your desktop and revolutionize your approach to data analysis and visualization.

Intro
Rob Collie
Three different flavors of failure
Bill Gates
Excel 2007
Power Pivot
Software
Ohio
Indiana
Book
Questions
VLOOKUP and Pivot
Sheet Tabs
Disk Size
Separate Windows
Manage Button
Power Pivot Window
Add to Data Model
Pivot Table
Orders Table
Dates Table
Order Date
Create Relationship
Relationship Diagram
VLOOKUP
Excel Duel