Skip to Main Content
Excel Power Pivot & Power Query For Dummies, 2nd Edition
book

Excel Power Pivot & Power Query For Dummies, 2nd Edition

by Michael Alexander
March 2022
Beginner to intermediate content levelBeginner to intermediate
288 pages
7h 21m
English
For Dummies
Content preview from Excel Power Pivot & Power Query For Dummies, 2nd Edition

Chapter 3

The Pivotal Pivot Table

IN THIS CHAPTER

check Getting to know pivot tables

check Laying out the geography of a pivot table

check Building your first pivot table

check Creating top and bottom reports

check Understanding, creating, and formatting slicers

check Sprucing up slicers with customization

check Controlling multiple pivot tables with slicers

check Using timeline slicers

When creating Power Pivot data models, you will have to use some form of pivot table structure to expose the data in those models available to your audience.

Pivot tables have a reputation for being complicated, but if you’re new to pivot tables, rest easy. This chapter gives you the fundamental understanding you need in order to analyze and report ...

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,
and much more.
Start your free trial

You might also like

Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition

Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition

Wayne Winston
Microsoft Excel 365 Bible

Microsoft Excel 365 Bible

Michael Alexander, Dick Kusleika
Excel 2019 Bible

Excel 2019 Bible

Michael Alexander, Richard Kusleika, John Walkenbach

Publisher Resources

ISBN: 9781119844488Purchase Link