Перейти к основному содержимому
Дом

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.

Course

Introduction to Google Sheets

БазовыйУровень навыка
4.8+
1 838 reviews
2 ч.
Bring your Google Sheets to life by mastering fundamental skills such as formulas, operations, and cell references.

Track

Основы Google Таблиц

4.9+
12 reviews
15 ч.
Станьте мастером Google Sheets. Освойте основные навыки, необходимые для анализа данных с помощью Google Sheets.

Не знаете, с чего начать?

Пройти Оценку

Просматривайте курсы и треки Google Sheets

Course

Introduction to Google Sheets

БазовыйУровень навыка
4.8+
1 838 reviews
2 ч.
Bring your Google Sheets to life by mastering fundamental skills such as formulas, operations, and cell references.

Course

Data Analysis in Google Sheets

БазовыйУровень навыка
4.8+
1 175 reviews
3 ч.
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

Introduction to Statistics in Google Sheets

БазовыйУровень навыка
4.8+
570 reviews
4 ч.
Learn how to leverage statistical techniques using spreadsheets to more effectively work with and extract insights from your data.

Course

Pivot Tables in Google Sheets

БазовыйУровень навыка
4.8+
212 reviews
2 ч.
Learn how to create pivot tables and quickly organize thousands of data points with just a few clicks.

Course

Intermediate Google Sheets

БазовыйУровень навыка
4.8+
797 reviews
4 ч.
Expand your Google Sheets vocabulary by diving deeper into data types, including numeric data, logical data, and missing data.

Course

Financial Analytics in Google Sheets

БазовыйУровень навыка
4.7+
121 review
4 ч.
Learn how to build a graphical dashboard with Google Sheets to track the performance of financial securities.

Course

Financial Modeling in Google Sheets

СреднийУровень навыка
4.7+
263 reviews
4 ч.
Learn basic business modeling including cash flows, investments, annuities, loan amortization, and more using Google Sheets.

Course

Marketing Analytics in Google Sheets

СреднийУровень навыка
4.8+
215 reviews
4 ч.
Learn how to ensure clean data entry and build dynamic dashboards to display your marketing data.

Course

Error and Uncertainty in Google Sheets

СреднийУровень навыка
4.7+
137 reviews
4 ч.
Learn to distinguish real differences from random noise, and explore psychological crutches we use that interfere with our rational decision making.

Course

Loan Amortization in Google Sheets

СреднийУровень навыка
4.7+
45 reviews
4 ч.
Learn how to build an amortization dashboard in Google Sheets with financial and conditional formulas.

Course

Conditional Formatting in Google Sheets

БазовыйУровень навыка
4.8+
89 reviews
2 ч.
Learn how to use conditional formatting with your data through built-in options and by creating custom formulas.

Track

Основы Google Таблиц

4.9+
12 reviews
15 ч.
Станьте мастером Google Sheets. Освойте основные навыки, необходимые для анализа данных с помощью Google Sheets.

Track

Промежуточный уровень Google Таблиц

5
1 review
12 ч.
Расширьте свои навыки работы с Google Таблицами. Узнайте, как проверка данных, статистика и регулярные выражения помогут вам экономить время в Excel и Sheets!

Track

Основы финансов в Google Sheets

5
1 review
12 ч.
Развивайте навыки работы с финансовыми Google Таблицами. Научитесь строить базовые бизнес-модели, использовать финансовые формулы и создавать графики амортизации кредитов.

Связанные ресурсы по Google Sheets

Tutorial

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 мин

Tutorial

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 мин

Tutorial

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.

Другие технологии и темы

technologies

Развивайте свои навыки работы с данными с помощью DataCamp для мобильных устройств.

Успевайте в обучении на ходу с помощью наших мобильных курсов и ежедневных 5-минутных заданий по программированию.