课程
Pivot Tables in Google Sheets
基础技能水平
更新时间 2026年1月
Google SheetsData Manipulation2小时13 视频54 道练习4,150 XP71,822成就证明
创建您的免费帐户
继续使用 Google显示更多选项或
继续操作即表示您接受我们的《使用条款》和《隐私政策》，并同意您的数据存储在美国。
深受数千家公司学习者的喜爱
需要团队培训？
企业版试用课程描述
Why Pivot Tables
Working with large quantities of data in Google Sheets can be difficult and time-consuming. Have you ever wished there was a quick and efficient way to organize and evaluate your data within seconds? Pivot Tables are your answer!Introduction to Pivot Tables
This course provides a comprehensive introduction to the powerful tool of pivot tables for data analysis within Google Sheets. It starts by explaining the basics of pivot tables, demonstrating how they can be used to quickly organize and summarize large datasets. Through practical examples, you’ll understand how to transform thousands of data points into clear and actionable insights.Using Pivot Tables to conduct real-world data analysis
You will learn how to customize your pivot table by applying standard analyses like sorting, subtotaling, and filtering—as well as more advanced statistical analysis like creating calculated fields and counting both numerical and text fields.Explore real-world applications by analyzing diverse datasets such as the average rainfall across multiple US cities, the Top 10 companies of the Fortune Global 500, and a selection of films released between 2010 and 2016.
Mastering custom Pivot Tables
By the end of the course, you'll have the skills to create your own custom pivot tables with datasets of any size.Whether for business analysis, academic research, or personal projects, you'll leave with the ability to turn raw data into meaningful insights, all through the power of Pivot Tables in Google Sheets.
先决条件
Intermediate Google Sheets1
Introduction to Pivot Tables for Google Sheets
This chapter will discuss what a pivot table is, how it works, and will lead you through the steps of creating and setting up your first pivot table.
2
Behind the Scenes of the Pivot Table
This chapter discuss how a pivot table works, and how it deals with the underlying data.
3
Advanced Options
This chapter will discuss more advanced options that will help you to get the most of your pivot tables.
4
Editing Data and Troubleshooting
This chapter will walk you through modifying data in a pivot table, and troubleshooting various issues you may encounter.
Pivot Tables in Google Sheets
课程完成 加入超过19百万学习者，今天就开始Pivot Tables in Google Sheets！
创建您的免费帐户
继续使用 Google显示更多选项或
继续操作即表示您接受我们的《使用条款》和《隐私政策》，并同意您的数据存储在美国。
通过 DataCamp for Mobile 提升您的数据技能
随时随地通过我们的移动课程和每日 5 分钟编程挑战提升技能。