Google Sheets Fundamentals

อัปเดตแล้ว 03/2569

Become a Google Sheets master. Learn the core skills you need to analyze data using Google Sheets.

สร้างบัญชีฟรีของคุณ

หรือ

เมื่อดำเนินการต่อ คุณยอมรับข้อกำหนดการใช้งานของเรา นโยบายความเป็นส่วนตัวของเรา และยอมรับว่าข้อมูลของคุณจะถูกจัดเก็บไว้ในสหรัฐอเมริกา

คำอธิบายแทร็ก

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.
Course
4
Pivot Tables in Google Sheets
Learn how to create pivot tables and quickly organize thousands of data points with just a few clicks.
Course
5
Data Visualization in Google Sheets
Learn the fundamentals of data visualization using Google Sheets.