Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Google Workspace Masterclass – Boost Productivity & Skills
Rating: 4.4 out of 5(88 ratings)
427 students

Google Workspace Masterclass – Boost Productivity & Skills

Learn Google Docs, Sheets, Slides, Calendar, Drive, Gmail, Forms, Sites & more with Google Workspace (G Suite)
Created byHimanshu Dhar
Last updated 8/2025
English

What you'll learn

  • Mastering Google Sheets at MIS level
  • Expertise in Text, Logical, Math, Financial, Lookup and Reference Functions
  • Understanding Date and Time Format and Functions
  • Mastery in Pivot Table and Chart Preparation
  • Learning Data Validation, Filter, Conditional Formatting, Named Ranges, Link and Record Macro
  • Sharing and Protection of data
  • Have a solid understanding of Google Docs functionality and how to use the program effectively
  • Learn to create professional looking presentations, as well as share and present them
  • Create Google Forms and surveys, as well as collect and analyze data from them
  • Learn better time management with Google Calendar
  • Learn to create Events, Task and Reminders in Google Calendar
  • Learn to Create New Calendar, Integrate Calendar, Import and Export Calendar
  • Learn Google Keep - one of the best note taking service
  • How to use Google Drive for File storage and synchronization service to increase efficiency and productivity
  • learn to use the Gmail more effectively and save plenty of hours with Labels, Archive, Filter, Snoozed Button, Mail Merge and many more options
  • Create a professional looking website with Google Sites

Course content

10 sections115 lectures14h 36m total length
  • Understanding Google Sheets9:29

    Learn the basics of Google Sheets, including its internet dependence, how to access and create sheets, save to Google Drive, work offline, and explore the template gallery.

  • Autofill and Smartfill Option8:27

    Master autofill and smart fill in Google Sheet to automatically extend patterns, dates, days, and months, and learn how to generate names and initials with suggested smart fills.

  • Operators Based Equation5:03

    Explore how to build formulas in Google Sheets using operators, brackets, and the order of operations to calculate profits and perform addition, subtraction, multiplication, and division.

  • Math Functions in Google Sheet13:31

    Learn to use Google Sheets math functions including sum, average, count, counta, countblank, max, min, large, and small, with text and blanks handled via nesting.

  • Advance Math Function12:43

    Explore advanced math functions such as sumif, sumifs, averageif, averageifs, countif, and countifs, using conditional ranges and criteria to analyze sales data.

  • Using of Wild Card in Math Function7:37

    Master wild cards in Excel with countif, using asterisks and question marks to build starting with and ending with patterns. Apply to names and email domains like Gmail and Yahoo.

  • Logical Function - IF()7:05

    Explore logical operators such as greater than, less than, equal to, and not equal to; apply the if function to produce true/false or pass/fail results based on a student score.

  • Nested IF Function5:11

    Learn to apply a nested if function in Google Sheets to classify scores into fail, compartment, or pass using thresholds less than 40, 40 to 60, and above 60.

  • IF Function related Task2:05

    Master the if function by calculating scholarship amounts for scores above 70 (score × 1000). Also identify topper and lowest scorer and apply pass/fail rules below 48 or above 40.

  • IF Function Task Solution9:08

    Learn to solve an if function task in google sheets for scholarships: check score over 70 and multiply by 1000; use max/min with absolute references to find toppers and lowest.

  • AND and OR Function4:57

    Explore and apply and/or logic functions in spreadsheets, using the if function to test multiple conditions and determine pass or fail based on true/false outcomes.

  • Upper, Lower, Proper and Trim Function5:48

    Explore text functions in a spreadsheet, including upper, lower, proper, and trim, and master nesting outputs, space handling, sentence case, and Google case.

  • Left, Right and Find Function10:33

    Learn how to use left, right, and find text functions to extract characters from the left or right and locate positions within strings.

  • Left, Right and Find Nesting Methodology7:15

    Master nesting methodology using left, find, and right text functions to extract a name and a mobile number from a sentence with dynamic character counts.

  • Mid Function3:15

    Master the mid function alongside left, right, and find to extract a mobile number from text. Set the start position and length for a dynamic 10-character result after a hyphen.

  • Concatenate Function3:57

    Demonstrate using the concatenate function to join text and prefix mobile numbers with 91, then format them with left, mid, and right to produce digits - digits - digits.

  • Replace Function4:36

    Master the replace function to standardize pin codes by using find, text, and right to locate digits and replace with 110011, with dynamic position and length.

  • Substitute and Len Function9:34

    Explore the substitute and replace functions to modify text in spreadsheets, including occurrence controls and case sensitivity, with practical examples like pin codes, plus using length to count occurrences.

  • Split Text to Column4:39

    Split text to column in Google Sheets splits a single column into multiple columns using separators like comma, space, hyphen, or custom options, and can extract phone numbers.

  • Filter in Google Sheets17:00

    Apply filters in Google Sheets to organize data, options such as is empty, is not empty, text contains, starts with, and explore custom formulas, filter views, and filter by color.

  • Slicer, Sort and Column Stat5:41

    Apply the slicer and sorting by selecting a column, filter data with the slicer options, and review column statistics to interpret qualification, course, and location data.

  • Conditional Formatting in Google Sheets10:37

    Learn how to apply conditional formatting in Google Sheets to highlight data with colors, using rules for text, values, custom formulas, and color scales.

  • Named Ranges in Google Sheets4:26

    Learn to create and manage named ranges in Google Sheets, including naming ranges without spaces or special characters, using them for navigation, and applying them in formulas like concatenate.

  • Creating Link in Google Sheets5:33

    Learn to create and manage links in google sheets, linking named ranges, destination cells, other sheets, and external websites, while editing or removing links for marketing cost and sales data.

  • Data Validation in Google Sheets16:48

    Explore data validation in Google Sheets, applying text rules, date constraints, list from range, valid email checks, checkboxes, and custom formulas to enforce accurate data entry.

  • Pivot Table in Google Sheet13:20

    Master pivot tables in Google Sheets to summarize data by rows, columns, values, and filters, using items, dates, clients, and numbers sold for clear, actionable reports.

  • Chart Preparation in Google Sheets24:45

    Learn chart preparation in Google Sheets by selecting data, choosing chart types such as column and pie, and refining axes, legends, and titles.

  • Vlookup Function10:47

    Learn how to use the vlookup function to retrieve exact matches from master data, including vertical and horizontal lookups, range selection, and handling across multiple sheets with import range.

  • Iferror with Vloookup Function7:03

    learn to handle vlookup errors with iferror, showing no data found instead of hash errors, and extend with nested vlookup across multiple sheets for missing matches.

  • Hlookup Function5:21

    Learn how to use the hlookup function for horizontal data in Google Sheets, including preparing data with transpose, selecting a master range, and specifying search key, index, and is_sorted.

  • Match and Index Function5:31

    Learn how to use match and index functions in tandem to lookup names and details from a master data sheet, with exact and approximate searches.

  • Match and Index Function Nested5:35

    Learn to use the match and index functions to retrieve names and qualifications from master data by matching a phone number in a data sheet.

  • Vlookup With Match - Advance8:47

    Learn to use vlookup with match and index to fetch course, contact, and location from a master data sheet by name, with absolute references for reliable drag-down results.

  • Vlookup TRUE - Amazing Technique3:23

    Demonstrate vlookup with approximate match to categorize scores into compartments, using exact (false or zero) and approximate (two or one) options across 0–39.99, 40–59.99, 60–89.99, and 90+ distinctions.

  • Array Function - Vlookup4:40

    Learn how to perform a multi-column vlookup using the array function in Google Sheets, applying the lookup across multiple columns with a single array formula.

  • Managing Date and Time in Google Sheets11:33

    Master date and time handling in Google Sheets by entering correct formats, using date and time functions (year, month, day, today, now), and applying versatile formatting.

  • Datedif and Networkdays Function9:36

    Learn to use the datedif function to calculate exact age in years, months, and days, and apply networkdays to count working days while excluding weekends and holidays.

  • Financial Function - PMT, PPMT, IPMT and PV10:01

    Learn to calculate emi and analyze loan details using pmt, ppmt, ipmt and pv functions, including rate per month, total payable, and principal versus interest breakdown.

  • Record Macro in Google Sheets8:18

    Learn how to record macros in Google Sheets to automate tasks, choosing absolute or relative references, save named macros with shortcuts, and apply formatting or IF-based scoring functions via buttons.

  • Sharing and Protection in Google Sheets10:16

    Learn how to share and protect Google Sheets by configuring link access, setting editor or viewer permissions, and applying sheet and range protections to safeguard data.

  • Google Sheets keyboard shortcuts0:02
  • Practice Test - Google Sheet

Requirements

  • Basic Computer Knowledge

Description

Master Google Workspace (G Suite) – Gmail, Docs, Drive, Sheets, Meet & More

Learn everything you need to work smarter with Google Workspace – from basics to advanced features. Boost productivity, improve collaboration, and manage your digital tasks with confidence.

This course is a complete step-by-step training program that helps you master all the essential Google apps used in both personal and professional environments. Whether you're a beginner or looking to sharpen your skills, this course is packed with practical lessons, real-world tips, downloadable resources, and hands-on practice.

Google Workspace (formerly G Suite) is the industry-leading suite of cloud tools used by businesses, schools, freelancers, and remote teams across the world. Learn how to use Gmail, Drive, Docs, Sheets, Slides, Forms, Calendar, Meet, Sites, Keep, Tasks, and more — all in one integrated platform.

What You Will Learn:

  1. How to use Gmail for professional communication, labels, filters, and smart email management

  2. Schedule and manage appointments with Google Calendar and integrate it with Gmail, Meet, and Drive

  3. Store, organize, and securely share files using Google Drive

  4. Create and collaborate on documents in real time with Google Docs

  5. Use Google Sheets to manage data, apply formulas, and build dashboards

  6. Design professional presentations using Google Slides

  7. Host virtual meetings and webinars with Google Meet

  8. Create internal or public websites using Google Sites without writing code

  9. Build forms, surveys, and quizzes with Google Forms and analyze responses

  10. Stay organized with Google Keep and manage tasks across devices with Google Tasks

Why Take This Course:

  • Suitable for beginners and experienced users

  • Covers both personal and business use of Google Workspace

  • Includes tips, shortcuts, and best practices to work faster and smarter

  • Hands-on training with downloadable resources and practice files

  • Learn how to integrate different Google apps to automate your workflow

  • Ideal for office workers, virtual assistants, freelancers, students, job seekers, and remote teams


    Who This Course is For:

  • Anyone using a Google account (personal or business)

  • Professionals and employees who want to improve workplace efficiency

  • Students, job seekers, and freelancers looking to improve digital skills

  • Small business owners and teams managing remote collaboration

  • Administrative professionals, virtual assistants, and project managers

Tools Covered:

  1. Gmail

  2. Google Calendar

  3. Google Drive

  4. Google Docs

  5. Google Sheets

  6. Google Slides

  7. Google Meet

  8. Google Forms

  9. Google Sites

  10. Google Keep

  11. Google Tasks

Whether you're transitioning from Microsoft Office or starting fresh with cloud tools, this course will help you make the most of what Google Workspace has to offer.

Enroll now and start working faster, smarter, and more confidently with Google Workspace.

Who this course is for:

  • Business professionals with a desire to increase efficiency and accessibility
  • High School and College Students