跳至内容
家Business Intelligence

Tracks

Google Sheets Fundamentals

更新 2026年3月
Become a Google Sheets master. Learn the core skills you need to analyze data using Google Sheets.
免费开始赛道

包含优质的 or 团队

Google SheetsData Manipulation15小时13,440

创建您的免费帐户

或者

继续操作即表示您接受我们的《使用条款》和《隐私政策》，并同意您的数据存储在美国。

深受数千家公司学员的喜爱

Group

培训2人或以上？

试试DataCamp for Business

曲目描述

Google Sheets Fundamentals

Learn the fundamental skills necessary to analyze data in Google Sheets! You’ll cover the foundational knowledge in data analysis, manipulation, and visualization and learn how to analyze and visualize data efficiently and effectively. You’ll start by understanding the core functionality of spreadsheets, exploring how to use predefined functions to analyze data. You’ll then learn about data types, manipulation of numeric and logical data, missing data, and error types. As you progress, you’ll discover how to use pivot tables to work with large quantities of data in Google Sheets efficiently. You’ll learn how to organize and evaluate data within seconds using a variety of real-world examples. Finally, you’ll cover spreadsheet data visualization techniques. You’ll learn how to create different types of charts, including bar charts, histograms, scatter charts, sparkline, and candlestick charts, and how to use data validation and VLookup formulas.

先决条件

本课程没有先决条件。

  • Course

    1

    Introduction to Google Sheets

    Bring your Google Sheets to life by mastering fundamental skills such as formulas, operations, and cell references.

  • Course

    2

    Data Analysis in Google Sheets

    Learn to use Google Sheets to clean, analyze, and draw insights from data. Discover how to sort, filter, and use VLOOKUP to combine data.

  • Course

    3

    Intermediate Google Sheets

    Expand your Google Sheets vocabulary by diving deeper into data types, including numeric data, logical data, and missing data.

Google Sheets Fundamentals
5 Courses
跟踪完成

获得成就证明

将此证书添加到您的 LinkedIn 个人资料、简历或个人简介中。
在社交媒体和绩效考核中分享它

包含优质的 or 团队

立即报名

加入 19百万名学习者 立即开始Google Sheets Fundamentals ！

创建您的免费帐户

或者

继续操作即表示您接受我们的《使用条款》和《隐私政策》，并同意您的数据存储在美国。