Главная
Study mode:
on
1
Intro
2
Rob Collie
3
Three different flavors of failure
4
Bill Gates
5
Excel 2007
6
Power Pivot
7
Software
8
Ohio
9
Indiana
10
Book
11
Questions
12
VLOOKUP and Pivot
13
Sheet Tabs
14
Disk Size
15
Separate Windows
16
Manage Button
17
Power Pivot Window
18
Add to Data Model
19
Pivot Table
20
Orders Table
21
Dates Table
22
Order Date
23
Create Relationship
24
Relationship Diagram
25
VLOOKUP
26
Excel Duel
Description:
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.

Modern Excel - The Supercomputer Hiding on Everyone’s Desktop

PASS Data Community Summit
Add to list