The Ultimate Google Sheet Course - Beginner to Intermediate

Learn how to create, manipulate, visualize and analyze data with Google Sheet

Created byEmmanuel Chukwudi Onyewuchi

Last updated 9/2026

English

English [Auto],

What you'll learn

Spreadsheet 101-Understand the concepts of Spreadsheet software
How to create, organize, analyze, manipulate data with Google sheet
How to use Autosum, Subtotal, IF function to perform simple and complex calculations
How to sort and filter data Google sheet
How to use chart and pivot table to analysis data
And More

Course content

2 sections • 11 lectures • 1h 44m total length

What Is Spreadsheet Software?4:57

Intro To Google Sheet6:11
Overview Of Google Drive12:52
Explore Google Drive basics, sign in, and access files, upload and organize with new folders, and share with view or edit permissions, using Google Sheets and 15 gig storage.
Overview Of Google Sheet7:51
Explore the Google Sheets interface, compare it with Excel, and learn to create and name workbooks, use menus and toolbars, and share with view, comment, or edit permissions.
Formatting Cells Data In Google Sheet11:10
Modifying Column Rows And Cell Google Sheet10:39
Working With Multiple Worksheet In Google Sheet5:14
Formula And Simple Formula In Google Sheet11:16
Learn how to apply simple formulas in Google Sheets, starting with the equals sign, using basic operations and cell references to calculate totals and cost per unit with drag-and-fill.
Applying Complex Formula In Google Sheet12:46
Functions And Autosum Functions Google Sheet13:11
Sorting And Filtering Google Sheet8:30

Requirements

Basic Computer operation skill
A Computer to practices what you will be learning
Determination and commitment to learning new skills
Ability to follow instructions and guide

Description

Do you want to master the Ins and outs of one of the top spreadsheet programs in use today, Google Sheets?

Spreadsheet is one of the top office productive tools used in the business world today, it's also one of the top in-demand skills for jobs, professional or career excellence.

This course is designed to take you from a beginner's level to an intermediate level when it comes to using Google Spreadsheets.

You will learn about the environment of one of the top spreadsheet programs that are often used in the office today.

Spreadsheet is one of the top office productive tools used in the business world today, it's also one of the top in-demand skills for jobs, professional or career excellence.

Google Sheet

In this Module, you will learn how to organize, manipulate and analyze data with Google Sheets.

More Concepts and guides shared in this course:

Understanding the environment of Google Sheet
How to create, save, and open a workbook.
Data entry, cell formatting, working with multiple worksheets and
Discover how to format dates and numbers.
Discover the essentials of using formulas and functions.
How to rename, insert, move, and reference worksheet.
Discover how to create charts and graphs
Learn practical methods to sort and filter your data
Learn to visualize data with charts and SmartArt
Discover how to analyze data with a Pivot table and pivot chart
And more

Who this course is for:

Graduate and undergraduate who wants to learn Spreadsheet skills and increase employment opportunity in a computer age
Professionals who want to learn how to work with spreadsheet software
Business owners or entrepreneurs who want to learn data analysis with spreadsheet

The Ultimate Google Sheet Course - Beginner to Intermediate

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 5min

Google Sheet10 lectures • 1hr 40min

Requirements

Description

Who this course is for: