Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Google Sheets Bootcamp Boost Productivity Expert in Cloud
Rating: 4.3 out of 5(297 ratings)
34,401 students

Google Sheets Bootcamp Boost Productivity Expert in Cloud

Conquer Spreadsheets: Automate Tasks and Analyze Data with Google Sheets
Created bySayman Creative Institute
Last updated 4/2026
English
English [Auto],

What you'll learn

  • Introduction, Workspace and Interface
  • Basics to know about working in Google Spreadsheet
  • Fundamentals of using Formula
  • Calculating the percentage and locking the cell
  • Locking rows, columns and ranges
  • Cell Referencing and Referencing to a Different Sheet
  • Sorting Data by Number, Date and Multiple Columns
  • Linking working data between sheets

Course content

1 section • 14 lectures • 4h 17m total length

  • Introduction2:02

    Master data management and data storage in google spreadsheets, from basics to advanced techniques, including workspace interface, cell referencing to sheets, linking data between sheets, sorting data, and version control.

  • Introduction, Workspace and Interface15:24

    Explore the Google Sheets workspace and interface, learn rows, columns, and cells, and master basic navigation, file access, editing, and sharing options.

  • Basics to know about working in Google Spreadsheet21:06

    Learn the basics of working in Google Sheets, including data entry, summing totals, autofill patterns, basic formulas like sum and average, and essential formatting and merging.

  • Basics to know about working in Google Spreadsheet 218:39

    Master core Google Sheets basics, including formatting, alignment, borders, and color; manage currency, decimals, and number formats, insert charts, handle text wrapping, merging, and printing for clean data presentation.

  • Fundamentals of Using Formula New update25:55
  • Calculating the percentage and locking the cell30:00

    Learn how to calculate percentage discounts in Google Sheets, lock cells with dollar signs, and compute total price after discount using absolute references.

  • Locking Rows, Columns and Ranges25:04

    Lock rows, columns, and ranges in Google Sheets to keep formulas intact as you copy them. Learn formatting, absolute references with dollar signs, and calculating discounts.

  • Cell Referencing and Referencing to a different sheet part 125:02

    Learn practical cell referencing in Google Sheets, including referencing cells across sheets, building dynamic sums with ranges, and using absolute references to keep totals stable as you add items.

  • Cell Referencing and Referencing to a different sheet part 223:53

    Master cell referencing in Google Sheets by locking rows and columns with dollar signs, creating open-ended ranges, and linking data across sheets with sumifs and ifs.

  • Sorting Data by Number, Date and Multiple Columns New Update21:31

    Sort data by number, date, and multiple columns in Google Sheets using sort range and advanced range options, including header handling, A to Z, and Z to A.

  • Linking Working Data Between Sheets29:28

    Learn to link working data between sheets and across worksheets in Google Sheets, using sum, array formulas, and import range for cross sheet totals.

  • Class Project-16:35

    Learn to calculate a 5% discount in Google Sheets for class project 1, using sum and multiplication formulas, cell references, then drag down and download as Excel.

  • Class Project-28:35

    Link data across tabs in a single Google spreadsheet using sheet names and cell references. Create the formula, autofill, and download the file to upload it in our project panel.

  • Use Google Sheet More Effectively4:30

    Learn to use Google Sheets more effectively with practical tips and cloud-based workflows to boost productivity.

Requirements

  • Basic computer knowledge

Description

Hello everyone welcome to our class of Google Sheet for learning data management and data storage easily so if you are planning to learn data management and data storage from a beginner level to an advanced level than you are in right place because we will cover from basic to advanced. This is a beginner level class so if you have no previous experience than also you can join our class.

Lets take a look what you will learn from this class:

  1. Introduction, Workspace and Interface

  2. Basics to know about working in Google Spreadsheet- Part 1

  3. Basics to know about working in Google Spreadsheet- Part 2

  4. Fundamentals of using Formula

  5. Calculating the percentage and locking the cell

  6. Locking rows, columns and ranges

  7. Cell Referencing and Referencing to a Different Sheet- Part 1

  8. Cell Referencing and Referencing to a different sheet-Part 2

  9. Sorting Data by Number, Date and Multiple Columns

  10. Linking working data between sheets


After complete this class you will be able to

- Easy Collaboration

- Built in version Control

- Working at Scale

- Analyzing very large data sets

- Connecting to External Data Sources

- Connecting to the entire google workspace

This is a project based class so during learning you will have class project so what you learned you will be able to participate in class project so you can do practice while you are learning. You will have supporting resource in this class so it will be easier for you to learn.


During learning if you face any issue or if you have any question than feel free to ask me I am always there for you to help you. So lets start Google Spreadsheet for learning data management together.

Who this course is for:

  • Beginner who want to learn Google sheets

Report abuse