Pivot Tables in Google Sheets
| Course Details | ||||||||
|---|---|---|---|---|---|---|---|---|
|
||||||||
| Languages | ||||||||
|
||||||||
| Outcomes | ||||||||
|
||||||||
| Price & Terms | ||||||||
|
||||||||
| Technical | ||||||||
|
||||||||
| Specification | ||||||||
|
||||||||
Build, filter and adjust pivot tables in Google Sheets to summarize large datasets, add calculated fields and fix errors in source data.
Pivot tables condense a large Google Sheets dataset into a compact summary that is quick to organize and read. You set one up, decide which rows, columns and values it shows, and then shape the result with filters, counts, averages and calculated fields. The lessons also deal with what happens to a pivot table when its source data is edited, inconsistent or incomplete.
What You Will Achieve
- Turn a large sheet of records into a pivot table laid out with the rows, columns and values a question needs
- Narrow a summary to the records that matter by filtering on text, minimum or maximum values
- Write a custom calculation into the table and show figures as a share of each row or of the grand total
- Spot errors and gaps in the source data and correct them before they distort a summary
Program Overview
Building Your First Pivot Table
Sets out what a pivot table is and walks through creating one and arranging the fields that shape its layout.
- What a pivot table is and how to create one
- Selecting and rearranging rows and columns
- Adding one or several values
Filters, Calculated Fields, and Advanced Options
Looks at how the table treats its underlying data, then narrows and extends the summary with filters and further calculations.
- How a pivot table reads the underlying data
- Filters by string, min/max and value
- Counts, minimum, maximum, average and median
- Calculated fields, percentages, drilling down and grouping rows
Editing Data and Troubleshooting
Covers changing the data behind a finished table and tracking down the problems that distort its results.
- Changing and adding source data
- Correcting inconsistent and missing data
- Best practices on categories and measurements
- Alternatives to pivot tables
Certificate Awarded (Paid)
Job Outlook
Summarizing spreadsheet data with pivot tables is part of routine reporting in business analysis, academic research and personal projects kept in Google Sheets files.
Good for: Google Sheets users who handle large tables of records and want a faster way to group, count and compare them.
Keep in mind: Several tasks, such as building a complete pivot table or a calculated field, are split into two or three short exercises that follow on from each other.
Bottom line: A focused look at one Google Sheets feature that ends with practical work on fixing the data behind the table.
Frequently Asked Questions
What does a pivot table actually do?
It takes a long list of records and condenses it into a short summary table, grouping entries and totaling, counting or averaging them so patterns and trends in the data become easier to read.
Which calculations can the pivot tables show?
The lessons work with counts of text and numeric entries, minimum and maximum values, averages and medians, and calculated fields, plus showing results as a percentage of each row or of the grand total.
What happens when the source data changes or contains mistakes?
The final chapter covers changing the source range, adding new data, correcting inconsistent entries and finding missing values, then closes with best practices and a look at alternatives to pivot tables.
Which datasets are summarized in the practice?
Practice draws on varied datasets, including average rainfall across several US cities, the top ten companies of the Fortune Global 500, and a selection of films released between 2010 and 2016.
User Reviews
Write your review
You must be logged in to post a review.
Reviews can only be posted by registered learners. Log in or create a free account, then you will return here to post.
There are no reviews yet.