Skip to Main Content
|
University Libraries
See
Updates
and
FAQs
for the latest library services updates. Subject Librarians are available for
online appointments
, and
Virtual Reference
has extended hours.
University Libraries
InfoGuides
Data & Digital Scholarship
Spreadsheets
Summarizing Data
Search this Group
Search
Spreadsheets
About using Spreadsheets, such as Excel, Google Sheets, Calc, Numbers, and others.
Get Started
Basic Skills
Software
OpenRefine
Clean & Tidy Data
Summarizing Data
Charts & Graphs
Statistical Analysis
Get Help
Pivot Tables & Pivot Charts
Interactive Tutorial Workbooks from Microsoft
Open Excel, then look at the template files labeled "Tutorial"
or download from
Make your first
PivotTable
Quick-Start from Microsoft:
Create and format
PivotTables
and
PivotCharts
A gentle introduction to exploring and understanding your data
(
School of Data
)
Uses pivot tables in Libre Office's Sheets to look at counts, percentages, and means
Chapter 5: Manipulating data in spreadsheets
(by Martha Stuit; Ch 5 from
Creating Data Literate Students
)
Introduces filtering and Pivot tables to summarize data, and reviews the questions that can be answered by doing so.
Video Tutorials
Pivot Tables in
Excel 2016
(or
Excel 2007
,
Excel 2010
,
Excel 2013
) - Videos and tutorials from
GCF LearnFree
Introduction to Pivot Tables, Charts, and Dashboards in Excel -
Part 1
and
Part 2
from Jon Acampora of
Excel Campus
, also creator of
PivotPal
Pivot Table
Playlist
– Videos with practice at a slow pace. from
Lynda.com
<<
Previous:
Clean & Tidy Data
Next:
Charts & Graphs >>