Skip to Content
For Enterprise
For Government
For Higher Ed
For Individuals
For Marketing
For Enterprise
For Government
For Higher Ed
For Individuals
For Marketing
Explore Skills
Cloud Computing
Microsoft Azure
Amazon Web Services (AWS)
Google Cloud
Cloud Migration
Cloud Deployment
Cloud Platforms
Data Engineering
Data Warehouse
SQL
Apache Spark
Microsoft SQL Server
MySQL
Kafka
Data Lake
Streaming & Messaging
NoSQL Databases
Relational Databases
Data Science
Pandas
R
MATLAB
SAS
D3
Power BI
Tableau
Statistics
Exploratory Data Analysis
Data Visualization
AI & ML
Generative AI
Machine Learning
Artificial Intelligence (AI)
Deep Learning
Reinforcement Learning
Natural Language Processing
TensorFlow
Scikit-Learn
Hyperparameter Tuning
MLOps
Programming Languages
Java
JavaScript
Spring
Python
Go
C#
C++
C
Swift
Rust
Functional Programming
Software Architecture
Object-Oriented
Distributed Systems
Domain-Driven Design
Architectural Patterns
IT/Ops
Kubernetes
Docker
GitHub
Terraform
Continuous Delivery
Continuous Integration
Database Administration
Computer Networking
Operating Systems
IT Certifications
Security
Network Security
Application Security
Incident Response
Zero Trust Model
Disaster Recovery
Penetration Testing / Ethical Hacking
Governance
Malware
Security Architecture
Security Engineering
Security Certifications
Design
Web Design
Graphic Design
Interaction Design
Film & Video
User Experience (UX)
Design Process
Design Tools
Business
Agile
Project Management
Product Management
Marketing
Human Resources
Finance
Team Management
Business Strategy
Digital Transformation
Organizational Leadership
Soft Skills
Professional Communication
Emotional Intelligence
Presentation Skills
Innovation
Critical Thinking
Public Speaking
Collaboration
Personal Productivity
Confidence / Motivation
Features
All features
AI Academy
Courses
Certifications
Interactive learning
Live events
Answers
Insights reporting
Radar Blog
Buy Courses
Plans
Sign In
Try Now
O'Reilly Platform
book
Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot
by
Thomas Fragale
May 2024
Beginner to intermediate content level
Beginner to intermediate
304 pages
7h 43m
English
Wiley
Content preview from
Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot
Table of Contents
Cover
Table of Contents
Title Page
Foreword
Introduction
What Does This Book Cover?
Who Should Read This Book
Reader Support for This Book
CHAPTER 1: Preparing the Data for an Excel Pivot Table
What Is Data?
Importing Data from External Data Sources into Excel
Using Power Query to Clean the Data
Using Power Query to Create Calculations
Summary
CHAPTER 2: Summarizing and Presenting Data with a Pivot Table
What Is a Pivot Table?
Making a Pivot Table from Scratch
Using Recommended PivotTables and Analyzing Data
Making the Pivot Table Look Better
Summary
CHAPTER 3: Using Calculations in Pivot Tables
Using Built‐In Calculations in Your Pivot Table
Creating Custom Calculations
Refreshing Values on the Pivot Table
Using Numbers from the Pivot Table in Other Calculations
Summary
CHAPTER 4: Sorting and Filtering the Pivot Table
Sorting the Pivot Table
Filtering the Pivot Table
Summary
CHAPTER 5: Making the Pivot Table More Visual with Charts
Creating a Chart from a Pivot Table
Managing and Modifying Chart Elements
Creating and Managing a Pie Chart
Creating a Combo Chart
Creating and Using Chart Templates
Summary
CHAPTER 6: Summarizing Data by Date and Time
Summarizing a Pivot Table by the Built‐In Date Periods
Summarizing the Pivot Table Using Custom Date Calculations
Summary
CHAPTER 7: Creating a Pivot Table from Multiple Spreadsheets
Creating a Pivot Table from Multiple Ranges Using the PivotTable Wizard
Creating a Pivot Table Using the Data Model
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 - Pivot Tables In-Depth
Erin Olsen
Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)
Bill Jelen
Microsoft Excel 2019 Pivot Table Data Crunching
Bill Jelen, Michael Alexander
Microsoft Excel: A Beginners' Guide to Pivot Tables in Excel
Simon Sez IT
Publisher Resources
ISBN: 9781394243051
Purchase Link