Lewati ke konten utama
Beranda

Google Sheets courses

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

Buat Akun Gratis Anda

atau

Dengan melanjutkan, Anda menerima Ketentuan Penggunaan kami, Kebijakan Privasi kami dan bahwa data Anda disimpan di Amerika Serikat.
Group

Pelatihan untuk 2 orang atau lebih?

Coba 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.

Kursus

Pengantar Google Sheets

DasarTingkat Keterampilan
2 jam
3.4K

Program

Dasar-Dasar Google Sheets

15 jam
1.2K
Jadilah ahli Google Sheets. Pelajari keterampilan dasar yang Anda butuhkan untuk menganalisis data menggunakan Google Sheets.

Tidak yakin harus mulai darimana?

Ikuti Penilaian

Cari Kursus dan Track Google Sheets

Kursus

Data Analysis in Google Sheets

DasarTingkat Keterampilan
3 jam
1.8K
Learn to use Google Sheets to clean, analyze, and draw insights from data. Discover how to sort, filter, and use VLOOKUP to combine data.

Kursus

Pengantar Statistik di Google Sheets

DasarTingkat Keterampilan
4 jam
938
Learn how to leverage statistical techniques using spreadsheets to more effectively work with and extract insights from your data.

Kursus

Google Sheets Tingkat Menengah

DasarTingkat Keterampilan
4 jam
876
Perluas pengetahuan Anda tentang Google Sheets dengan memahami lebih dalam tentang jenis data, termasuk data numerik, data logis, dan data yang hilang.

Kursus

Pivot Table di Google Sheets

DasarTingkat Keterampilan
2 jam
765
Pelajari cara membuat tabel pivot dan dengan cepat mengorganisir ribuan titik data hanya dengan beberapa klik.

Kursus

Analitik Keuangan di Google Sheets

DasarTingkat Keterampilan
4 jam
403
Pelajari cara membuat dashboard grafis menggunakan Google Sheets untuk memantau kinerja sekuritas keuangan.

Kursus

Analitik Pemasaran di Google Sheets

MenengahTingkat Keterampilan
4 jam
387
Pelajari cara memastikan entri data yang akurat dan membangun dasbor dinamis untuk menampilkan data pemasaran Anda.

Kursus

Pemodelan Keuangan di Google Sheets

MenengahTingkat Keterampilan
4 jam
342
Pelajari dasar-dasar pemodelan bisnis, termasuk arus kas, investasi, anuitas, amortisasi pinjaman, dan lainnya menggunakan Google Sheets.

Kursus

Kesalahan dan Ketidakpastian di Google Sheets

MenengahTingkat Keterampilan
4 jam
253
Learn to distinguish real differences from random noise, and explore psychological crutches we use that interfere with our rational decision making.

Kursus

Format Bersyarat di Google Sheets

DasarTingkat Keterampilan
2 jam
191
Pelajari cara menggunakan pemformatan bersyarat pada data Anda melalui opsi bawaan dan dengan membuat rumus kustom.

Kursus

Amortisasi Pinjaman di Google Sheets

MenengahTingkat Keterampilan
4 jam
84
Pelajari cara membuat dashboard amortisasi di Google Sheets menggunakan rumus keuangan dan rumus bersyarat.

Program

Dasar-Dasar Google Sheets

15 jam
1.2K
Jadilah ahli Google Sheets. Pelajari keterampilan dasar yang Anda butuhkan untuk menganalisis data menggunakan Google Sheets.

Program

Google Sheets Tingkat Menengah

12 jam
258
Perluas keterampilan Anda dalam menggunakan Google Sheets. Pelajari bagaimana validasi data, statistik, dan ekspresi reguler dapat menghemat waktu Anda saat menggunakan Excel dan Sheets!

Program

Dasar-Dasar Keuangan di Google Sheets

12 jam
135
Kembangkan keterampilan Anda dalam menggunakan Google Sheet untuk urusan keuangan. Pelajari cara membangun model bisnis dasar, menggunakan rumus keuangan, dan membuat jadwal amortisasi pinjaman.

Sumber daya terkait dengan Google Sheets

Tutorials

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 mnt

Tutorials

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 mnt

Tutorials

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 mnt


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.

Teknologi dan topik lainnya

teknologi