跳至内容
首页

Google Sheets courses

Learn how to effectively use Google Sheets to organize, analyze, and visualize data, enhancing your productivity and decision-making skills.

创建您的免费帐户

继续使用 Google显示更多选项


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

培训 2 人或更多?

试用DataCamp for Business

Recommended for Google Sheets beginners

Build your Google Sheets and report-building skills with interactive courses, tracks and projects, curated by real-world experts.

课程

Google Sheets 入门

基础技能水平
4.8+
1,920 条评价
2小时
通过掌握公式、运算和单元格引用等基础技能,让你的 Google Sheets 焕发生机。

学习路径

Google 表格基础知识

4.9+
12 条评价
15小时
成为 Google Sheets 高手。 学习使用 Google Sheets 分析数据所需的核心技能。

不确定从哪里开始?

参加评估

浏览 Google Sheets 课程和学习路径

课程

Google Sheets 入门

基础技能水平
4.8+
1,920 条评价
2小时
通过掌握公式、运算和单元格引用等基础技能,让你的 Google Sheets 焕发生机。

课程

Google Sheets 数据分析

基础技能水平
4.8+
1,220 条评价
3小时
学会使用 Google Sheets 清理、分析数据并提炼洞见。 掌握排序、筛选和使用 VLOOKUP 合并数据。

课程

Google Sheets 中的 Pivot Table

基础技能水平
4.8+
222 条评价
2小时
学习如何创建数据透视表,并通过几次点击快速整理数千个数据点。

课程

Google Sheets 统计学入门

基础技能水平
4.8+
609 条评价
4小时
学习如何利用电子表格中的统计技术,更有效地处理数据并提取洞察。

课程

Google Sheets 中级

基础技能水平
4.8+
826 条评价
4小时
扩展你的 Google Sheets 词汇,深入了解数据类型,包括数值数据、逻辑数据和缺失数据。

课程

Google Sheets 中的误差与不确定性

中级技能水平
4.7+
153 条评价
4小时
学会区分真实差异与随机噪声,并探索我们在理性决策中使用的会干扰判断的心理依赖。

课程

Google Sheets 金融建模

中级技能水平
4.7+
275 条评价
4小时
使用 Google Sheets 学习基础商业建模,包括现金流、投资、年金、贷款摊销等。

课程

Google Sheets 条件格式

基础技能水平
4.8+
100 条评价
2小时
学习如何通过内置选项和创建自定义公式,使用条件格式化处理数据。

学习路径

Google 表格基础知识

4.9+
12 条评价
15小时
成为 Google Sheets 高手。 学习使用 Google Sheets 分析数据所需的核心技能。

学习路径

金融基础知识 在 Google 表格中

5
1 条评价
12小时
提升你的财务 Google Sheet 技能。 学习如何构建基本商业模型、使用财务公式并创建贷款摊销计划。

学习路径

中级 Google 表格

5
1 条评价
12小时
扩展你的 Google 表格技能。 了解数据验证、统计和正则表达式如何帮你在 Excel 和 Sheets 中节省时间!

Google Sheets 相关资源

教程

How to Analyze Data in Google Sheets With Python: A Step-By-Step Guide

Boost your data analysis skills with our step-by-step guide on how to analyze, manipulate and write back data in Google Sheets using Python.
Filip Schouwenaars's photo

Filip Schouwenaars

11分钟

教程

How to Add, Subtract, Divide and Multiply in Spreadsheets

Learn how to apply operations like add, subtract, divide, multiply, and a lot more in Google Spreadsheets with the help of an actual dataset.
Aditya Sharma's photo

Aditya Sharma

9分钟

教程

Getting Started with Spreadsheets

This tutorial will give you a basic understanding of the terminology in spreadsheets along with learning how to create a basic table.
Ryan Sheehy's photo

Ryan Sheehy

5分钟


Frequently asked questions

What is the best way to start learning about Google Sheets?

The best way to start is by enrolling in our Introduction to Google Sheets course, which will help you master the fundamental skills such as formulas, operations and cell references. From there, you can continue working through our more advanced courses and completely level up your Google Sheets skills!

Who should take Google Sheets courses?

Our Google Sheets courses are suitable for anyone looking to improve their spreadsheet skills, from beginners who need to understand the basics to advanced users who want to leverage Google Sheets for complex data tasks.

What types of skills can I expect to gain from a Google Sheets courses?

You can expect to learn skills such as creating and formatting spreadsheets, using formulas and functions for calculations, cleaning, analyzing and drawing insights from data, plus creating pivot tables to quickly organize data points.

Do Google Sheets courses require special software?

Google Sheets courses only require a stable internet connection and a Google account, as Google Sheets is a free, web-based application accessible through your web browser.

Should I learn Google Sheets or Excel?

Whether you should learn Google Sheets or Excel depends on your specific needs and work environment. Google Sheets is ideal for real-time collaboration and accessibility from any device with internet, while Excel offers more advanced features for complex data analysis and comprehensive offline work.

If you’re interested in learning Excel, we’ve got you covered - check out our Introduction to Excel course.

How similar are Google Sheets and Excel?

Google Sheets and Excel share many core functionalities such as the use of formulas, pivot tables, and the ability to create various types of data visualizations. Excel, however, typically offers a broader range of complex functions and more advanced data analysis tools, like Power Query and Power Pivot, which are suited for handling large datasets and complex modeling.

On the other hand, Google Sheets excels in real-time collaboration, allowing multiple users to edit and comment simultaneously and integrates seamlessly with other Google services like Google Drive and Google Docs. While Excel provides more extensive customization and scripting capabilities through VBA (Visual Basic for Applications), Google Sheets supports scripting through Google Apps Script, which is based on JavaScript. The choice between the two may depend on the specific needs of your projects, whether you prioritize collaboration or require deep data analysis features.

其他技术和主题

技术

通过 DataCamp for Mobile 提升您的数据技能

随时随地通过我们的移动课程和每日 5 分钟编程挑战提升技能。