Free Course Image Google Sheets for Beginners

Free online course Google Sheets for Beginners

Duration of the online course: 1 hours and 56 minutes

New

Boost productivity with a free Google Sheets course: master formulas, VLOOKUP, pivot tables, and linked spreadsheets to analyze data faster and smarter.

In this free course, learn about

  • Navigate the Google Sheets interface: menus, toolbar, sheets, and cells
  • Set up and start using Sheets: creating files, entering/editing data, formatting basics
  • Use AutoFill/Fill handle to quickly extend patterns and series (days, months, numbers)
  • Apply VLOOKUP: syntax, exact vs approximate match, and common use cases
  • Understand what VLOOKUP does: retrieve matching data from a table by key
  • Create and customize pivot tables to summarize and analyze datasets
  • Recognize pivot table benefits: fast aggregation, grouping, filtering, and insights
  • Link data across sheets/spreadsheets using IMPORTRANGE and cell references
  • Reference sheet names with spaces correctly using single quotes in formulas
  • Manage permissions/authorization when importing data from another spreadsheet

About the free online course

Learning Google Sheets can change the way you organize information, make decisions, and collaborate at work or in your studies. This beginner-friendly course helps you build real confidence with spreadsheets, starting from the very first steps and moving toward the skills that make you faster and more effective. If you have ever felt stuck formatting data, unsure how to structure a table, or frustrated by repetitive tasks, you will discover practical ways to work smarter and keep your files clean and reliable.

Because Google Sheets runs in the browser, it is ideal for teamwork. You will understand what you need to start using it well, how to navigate the interface, and how to set up sheets that are easy to read and share. Along the way, you will learn time-saving techniques that reduce manual effort, including tools that quickly continue patterns and series such as days, months, and repeating sequences, so you can focus on analysis instead of busywork.

As you progress, you will gain the ability to pull the right information at the right time using lookups. This is where your spreadsheets start to feel truly powerful: instead of searching by hand, you can retrieve data based on a key value and keep your tables consistent. You will also work with pivot tables to turn raw rows into clear summaries, making it easier to spot trends, compare categories, and answer questions quickly.

Finally, you will connect information across sheets and even between different spreadsheets, a crucial skill for building scalable workflows. You will learn to keep separate files in sync, reference data accurately, and handle practical details like linking sources with names that include spaces. By the end, you will be ready to create, automate, summarize, and connect spreadsheets in a way that supports productivity in everyday tasks and professional projects.

Course content

  • Video class: Beginners Google Sheets Tutorial - Lesson 1 43m
  • Exercise: What is necessary to start using Google Sheets?
  • Video class: Beginners Google Sheets Tutorial - Lesson 2 38m
  • Exercise: Which feature in Google Sheets helps you quickly fill patterns or series like months or days?
  • Video class: How to use VLOOKUP in Google Sheets 12m
  • Exercise: Which of the following functionalities does the VLOOKUP function in Google Sheets provide?
  • Video class: Unleash the Power of Pivot Tables in Google Sheets 10m
  • Exercise: What is a primary advantage of using pivot tables in Google Sheets?
  • Video class: How to Link Data Between Sheets and Spreadsheets in Google Sheets 11m
  • Exercise: How can you link data from one Google Sheet to another when the sheet names contain spaces?

This free course includes:

Icon for learning via the audio course

1 hours and 56 minutes of online video course

Icon for the digital course completion certificate

Digital certificate of course completion (Free)

Icon for exercises to practice what you've learned

Exercises to train your knowledge

Icon for courses that are 100% free from start to finish

100% free, from content to certificate

What do I need to start using Google Sheets?

You need a Google account, an internet connection, and a web browser or the Google Sheets mobile app.

How does VLOOKUP work in Google Sheets?

VLOOKUP searches the first column of a range for a value and returns related data from another column in the same row.

How can I link data from another Google Sheet when sheet names contain spaces?

Use the IMPORTRANGE function and wrap sheet names containing spaces in single quotes within the range reference.

Ready to get started?Download the app and get started today.

Install the app now

to access the course
Icon representing technology and business courses

Over 5,000 free courses

Programming, English, Digital Marketing and much more! Learn whatever you want, for free.

Calendar icon with target representing study planning

Study plan with AI

Our app's Artificial Intelligence can create a study schedule for the course you choose.

Professional icon representing career and business

From zero to professional success

Improve your resume with our free Certificate and then use our Artificial Intelligence to find your dream job.

You can also use the QR Code or the links below.

QR Code - Download Cursa - Online Courses

More free courses at Office Productivity (Excel, Word and More)

Free Ebook + Audiobooks! Learn by listening or reading!