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 Tutorial: A to Z Google Sheets Full Course
Role Play
Rating: 4.0 out of 5(27 ratings)
51 students

Google Sheets Tutorial: A to Z Google Sheets Full Course

Complete Google Sheets Tutorial: Learn Google Sheets Online from A to Z: Learn Formulas, Logic, and Reports with AI
Role Play
Created byBeing Commerce, Being Commerce
Last updated 1/2026
English
English [Auto],

What you'll learn

  • Use Google Sheets from beginner to advanced level
  • Write formulas with confidence
  • Apply IF and condition-based logic
  • Clean and format text data
  • Filter, sort, and highlight data
  • Create pivot tables and charts
  • Use lookup functions correctly
  • Handle date, time, and financial data
  • Share and protect online spreadsheets
  • Google Gemini for Google sheets & Excel!

Course content

1 section • 24 lectures • 6h 30m total length

  • Google Sheets A to Z: Best Online Excel Spreadsheet Editor (Promo)1:39

    Master Google Sheets from basics to advanced functions, including Bodmas and PMT, IPMT, and PV. Explore logical and if functions, filter and replace, and share charts with lifetime support.

  • 1 Basics of Google Sheets21:58

    Learn the basics of Google Sheets: set up with Chrome and a Google account, access via Google Drive, create and name files, share and collaborate, and work offline.

  • 2 BODMAS & Basic Functions31:07

    Explore autofill and smart fill in Google Sheets, apply bodmas rules for calculations, and master basic functions and formulas in a practical classroom example.

  • 3 Advanced Maths Functions24:13

    Explore advanced google sheets functions for sum, average, count, counta, count blank, max, min, and large/small to analyze data ranges.

  • 4 Using Wild Card Functions32:12

    Learn to apply wild card and multi-criteria functions in Google Sheets, using sumif/sumifs, averageif/averageifs, and countifs for patterns like starts with, ends with, and domain checks (Gmail, Yahoo).

  • 5 Logical Functions (IF)13:36

    Master the IF function in Google Sheets. Use logical operators to perform boolean tests and compare values with greater than, less than, and equals, labeling outcomes as pass or fail.

  • 6 IF Related Functions16:50

    Learn how to apply if functions in Google Sheets to evaluate scholarship eligibility, compute amounts using (score-70)*1000, and use nested if with max, min, topper, lowest, and pass/fail logic.

  • 7 IF Related Functions Task8:38

    Learn to combine multiple score conditions in Google Sheets using the and and or functions with the if function to decide pass or fail for unit test and final scores.

  • 8 Upper Lower Proper Function5:38

    Learn to transform text in Google Sheets using upper, lower, and proper functions, and trim to remove extra spaces, with practical in-cell demonstrations.

  • 9 Left Right Find Function9:46

    Master left and right functions to extract characters from a cell, counting spaces and exact lengths. Use the find function to locate substrings and positions for dynamic text analysis.

  • 10 Left & Right more examples10:34

    Master Google Sheets techniques to extract names and mobile numbers using left, right, and find functions, including handling dots and common patterns for clean results.

  • 11 Concatenate Function8:45

    Master the concatenate function in Google Sheets to build formatted phone numbers using left, mid, and right logic with practical country code and prefix examples.

  • 12 Replace & Substitue Function10:31

    Learn to use the replace and substitute functions in Google Sheets, including finding text, writing formulas, and performing precise replacements such as updating pin codes.

  • 13 Split Function one Column3:24

    Learn how to split a single column in Google Sheets using the split text to column feature, with options for comma, space, dash, full stop, and custom delimiters.

  • 14 Filters Function in Google Sheets12:40

    Learn to filter data in Google Sheets with filter views and the filter button, apply conditions, sort by color or value, use slicers, and apply conditional formatting for analysis.

  • 15 Named Ranges & Links7:06

    Create and manage named ranges in Google Sheets by selecting cells, naming them (for example sales), and using them in formulas such as =sum(sales).

  • 16 Data Validation & Charts21:03

    Explore data validation in google sheets with text, numbers, lists, date rules, checkboxes, and email validation; also learn to create and customize pivot tables and charts.

  • 17 Hlook & Vlook Function7:45

    Explore vlookup and hlookup in Google Sheets to fetch contact, location, and email data from other sheets using a unique search key and fixed ranges.

  • 18 Other Functions8:41

    Explore date and time functions in Google Sheets, including year, month, and day. Understand US and India formats and how to convert values into a single date.

  • 19 PMT, PPMT, IPMT & PV16:43

    Explore using PMT to calculate monthly emi, IPMT for monthly interest, and PV to determine loan eligibility in Google Sheets.

  • 20 Sharing & Protection in Sheet6:57

    Learn to share a Google Sheet, set permissions, invite collaborators, and protect specific sheets or ranges with restricted access.

  • Watch Free Courses9:36

    Discover free, easy access to a growing library of courses with no signup or fees, including ai and tech topics, from the cuckoo courses platform.

  • Google Gemini (Optional)1:40:33

    Explore Google Gemini basics, prompt engineering, and large language models, and learn to use Gemini across Gmail, docs, sheets, and images with advanced prompts and gems.

  • Quiz
  • Role Play
  • Bonus0:13

Requirements

  • A Google account
  • Internet connection
  • Basic computer usage knowledge
  • No spreadsheet background needed

Description

This Google Sheets tutorial is created for anyone who wants full control over online spreadsheets without feeling confused or stuck. Many people use Google Sheets daily but only scratch the surface. They enter data, copy formulas from others, and hope everything works. This course changes that habit.

In this course, you will learn Google Sheets from start to finish, using clear examples and real tasks. Every lesson is based on how Google Sheets is actually used in offices, small businesses, freelance work, and daily reporting. You do not need any past experience with spreadsheets.

The course starts with the basics so you feel comfortable right away. You will understand how Google Sheets works online, how cells behave, how to move fast inside sheets, and how to avoid common mistakes. This foundation helps you work smoothly in later lessons.

Next, you move into formulas and functions. You will learn how Auto Fill and Smart Fill save time, how math formulas work, and how to apply correct calculation order. You will practice core functions like SUM, AVERAGE, COUNT, MAX, and MIN, which are used in almost every online spreadsheet.

Logical functions are covered in detail. You will learn how IF works, how to apply conditions, and how to handle multiple rules in a single formula. These skills help you create sheets that show results based on marks, status, limits, or values. Many learners find this topic difficult, but here it is explained step by step.

Text handling is another key part of this Google Sheets tutorial. You will learn how to clean messy data using TRIM, change text format using UPPER, LOWER, and PROPER, and extract or join text using LEFT, RIGHT, MID, FIND, and CONCATENATE. These skills are very useful when working with imported data or customer lists.

You will also learn how to use wildcards, nesting methods, and combined formulas. This helps you write stronger formulas that handle real-life data instead of perfect examples.

Filtering, sorting, slicers, and conditional formatting are explained with clear use cases. You will learn how to highlight important values, filter large data quickly, and make sheets easier to read for others.

The course also covers named ranges, linking sheets, data validation, pivot tables, and charts. These topics help you turn raw data into summaries and visuals that are easy to understand. These skills are often expected in office roles and freelance work.

Lookup functions like VLOOKUP and HLOOKUP are explained in simple language with clear examples. You will understand how data is searched and matched, which removes fear around these commonly asked functions.

Date and time handling, along with financial functions like PMT, PPMT, IPMT, and Present Value, are included to support payment tracking, loan sheets, and planning tasks.

Finally, you will learn how to share Google Sheets online, control access, and protect data from unwanted changes.

If you skip this course, you may keep using Google Sheets in a slow and limited way. You may depend on others for formulas, feel unsure during work tasks, or miss chances that require spreadsheet skills.

After finishing this Google Sheets course, you will work with confidence. You will understand what you are doing, why it works, and how to fix issues on your own. This is the real change students experience after completing the course.

Who this course is for:

  • Beginners starting with Google Sheets
  • Students preparing for office work
  • Freelancers handling reports or data
  • Business owners managing records
  • Anyone using online spreadsheets

Report abuse