February 2013
Beginner to intermediate
576 pages
21h 30m
English
Content preview from Excel® 2013 On Demand
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Working with PowerPivot
If you’re using Office Professional Plus, you can also use the built-in PowerPivot add-in (New!), which allows you to build simple data models directly in Excel. PowerPivot is helpful when you want to import, filter out, and quickly process millions of rows of data from multiple data sources. You can use PowerPivot to define data hierarchies, calculation fields, and Key Performance Indicators (KPIs), and use the Data Analysis Expressions (DAX) language to create advanced formulas.
Build Data Models with PowerPivot
Click anywhere within the table range or select a range of cells.
Click the PowerPivot tab (New!).
• Enable ...