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
DiSC
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 >>