Tutorialspoint

Celebrating 11 Years of Learning Excellence! Use: TP11

Learn to Work with Google Sheets

person icon Soniya

4.4

Learn to Work with Google Sheets

Learn the most useful functions in Google Sheets

updated on icon Updated on Jun, 2025

language icon Language - English

person icon Soniya

English [CC]

category icon Office Productivity,Google,Google Sheets

Lectures -22

Resources -2

Duration -1 hours

Lifetime Access

4.4

price-loader

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

I have worked in both small and large organizations and have found that Excel is the basic tool that is used starting from the CEO to the fresher joining the company. I had done courses on Excel multiple times but due to the large number of functions covered in those courses, I would end up forgetting the formula. Through this course, I have tried to minimize the content and have covered the functions that are most used in organizations for creating trackers, and dashboards, and analyzing the data.

The course is 1.5 hours long. I have added downloadable resources, exercises, quizzes, and a project to make the learning experience better.

The course has four sections covering the following topics:

1. Basics: How to create a spreadsheet. Understanding basic formulas such as count, sum, countifs, sumifs, etc.

2. The most used functions such as vlookup, left, right, pivot tables, etc.

3. Advanced functions such as importrange, filter, sort, etc.

4. Extra Tips: A few shortcuts and features that are frequently used.

After finishing this course you will have the skills to use spreadsheets with confidence.

Hope you will find the course useful. If you want more lectures to be added to the course, feel free to connect.

Goals

  • Managing Google Sheets.
  • Creating Dashboards.
  • Data Analysis.
  • Connecting Various Sheets.
  • Creating different views.

Prerequisites

  • Laptop.
  • Internet Connection.
Learn to Work with Google Sheets

Curriculum

Check out the detailed breakdown of what’s inside the course

Getting Started

7 Lectures
  • play icon Introduction - Course Curriculum
  • play icon How to create a Google Sheet 03:33 03:33
  • play icon SUM, COUNT, COUNTA 02:43 02:43
  • play icon SUMIFS 04:04 04:04
  • play icon COUNTIFS 02:57 02:57
  • play icon Countunique 01:49 01:49
  • play icon SUMPRODUCT 01:28 01:28

Must Know Functions

5 Lectures
Tutorialspoint

Advanced Functions

4 Lectures
Tutorialspoint

Extra Tips

5 Lectures
Tutorialspoint

Instructor Details

Soniya

Soniya

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515