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.