Google表格入门

你将学到什么

课程概况

Google Sheets is a robust, cloud-based application that empowers you to create sophisticated spreadsheets. Whether you are working at your desk—or from your smartphone or tablet on-the-go—Google Sheets helps you organize, analyze, and share your most important data. In this course for Sheets users, you’ll learn how to make your own supercharged spreadsheets. First, you’ll learn how to input and format your data. Next, you’ll learn how formulas, functions and a few exclusive Google Sheets features can accelerate your data analysis. Finally, you’ll get tips for sharing your spreadsheets and collaborating on them with your team.

About the Instructor
Malia is a tech professional based in Los Angeles who uses G Suite and Google Sheets everyday to manage projects, collaborate with remote teams, and make data-driven decisions.

课程大纲

周1
Welcome to Google Sheets: how to create, edit, and print your spreadsheet
Getting started with Google Sheets is simple. Let’s start with the basics. Learn how to create and edit your spreadsheet. Then print or publish it to the web.

周2
Working with formulas and functions: how to import and analyze your data
Anyone can be a data analyst with Google Sheets. Learn how to use formulas, functions, and other key features to help you analyze data effectively.

周3
Telling stories with data: how to design your sheet to highlight trends
Explore how Google Sheets allows you to design spreadsheets that are both aesthetically pleasing and informative.

周4
Supercharge your sheet: how to create charts, pivot tables, and reports
Google Sheets empowers you to detect and visualize data with no advanced coding required. This module will show you how to generate charts, pivot tables, and other shareable reports of your data.

周5
Collaborating in Sheets: how to share your data with your team
With Google Sheets you can work in real-time on a spreadsheet. Learn how to share your data with your team.