Google Workspace Course – Sheets, Docs, Slide and Forms

Name: Google Workspace Course – Sheets, Docs, Slide and Forms
Rating: 4.3 (47 reviews)

Master Google Sheets, Docs, Slides & Forms with practical tasks, formulas, formatting, charts, and data handling

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
Understand how to use Google Drive to increase efficiency and productivity

Course content

4 sections • 71 lectures • 9h 0m total length

Understanding Google Sheets9:29
Learn how Google Sheets differs from Excel, create and save blank sheets, organize them in Google Drive folders, and enable offline access while importing Excel files.
Autofill and Smartfill option8:27
Operators Based Equation5:03
Math Functions in Google sheet13:31
Advance Math Function12:43
Explore advanced math functions in Google Sheets, including sumif, averageif, countif and multi-criteria variants, with examples using sales above 100 across regions, cities, and employment.
Using of Wild Card in Math Function7:37
Logical Function - IF()7:05
Nested IF Function5:11
IF Function related Task2:05
IF Function Task Solution9:08
AND and OR Function4:57
Learn how to use the and and or functions in Google Sheets to evaluate multiple conditions and produce true or false results, including a pass or fail example.
Upper, Lower, Proper and Trim Function5:48
Left, Right and Find Function10:33
Master left, right, and find functions in Google Sheets to extract characters from the left or right and locate starting positions of substrings, including case sensitivity and offset tricks.
Left, Right and Find Nesting Methodology7:15
Explore left, right, and find nesting techniques in Google Sheets to dynamically extract names and mobile numbers from sentences using text functions.
Mid Function3:15
Concatenate Function3:57
Replace Function4:36
Substitute and Len Function9:34
Split Text to Column4:39
Filter in Google Sheets17:00
Learn to apply and customize filters in Google Sheets to isolate data by qualification and location, using text and number conditions, custom formulas, and filter views.
Slicer, Sort and Column Stat5:41
Learn how to use slicers to filter data by a specific column, apply sorting with proper header handling, and view column statistics to summarize data in Google Sheets.
Conditional Formatting in Google Sheets10:37
Named Ranges in Google Sheets4:26
Creating Link in Google Sheets5:33
Learn to create links in Google Sheets using insert link or right-click, covering four to five link types: named ranges, cells, other sheets, external sites, and another Google sheet.
Data Validation in Google Sheets16:48
Pivot Table in Google Sheet13:20
Learn to create pivot tables in Google Sheets, arranging data with rows, columns, values, and filters to produce quick, insightful reports.
Chart Preparation in Google Sheets24:45
Vlookup Function10:47
Iferror with Vloookup Function7:03
Learn to use iferror with vlookup in sheets to handle missing matches across multiple sheets, defaulting to no data found and retrieving data from master data.
Hlookup Function5:21
Match and Index Function5:31
Match and Index Function Nested5:35
Vlookup With Match - Advance8:47
Discover how to use vlookup with match to pull contacts and locations from a master data sheet, using absolute references to fix columns.
Vlookup TRUE - Amazing Technique3:23
Master vlookup with true for approximate matches by using the is_sorted argument. Map score ranges like 0–39.99, 40–59.99, 60–89.99, and 90+ to grades such as pass and distinction.
Array Function - Vlookup4:40
Managing Date and Time in Google Sheets11:33
Datedif and Networkdays Function9:36
Financial Function - PMT, PPMT, IPMT and PV10:01
Record Macro in Google Sheets8:18
Sharing and Protection in Google Sheets10:16
Explore how to share and protect Google Sheets, setting access by editors or viewers, and applying sheet and range protections to control who can edit or view.
Practice Test Part 1

Getting Started with Google Docs7:39
Format Options in Google Docs9:19
Bullets and Numbering5:29
Learn to create and customize bulleted and numbered lists, including sub bullets, checklists, and various bullet styles, while mastering indent controls and clearing formatting.
Styles in Docs- Heading Pattern5:28
Understanding File Tab in Docs8:13
Print Option in Docs8:58
Bookmark and Link in Docs4:49
Header, Footer and Page no in Docs8:31
Understanding Edit Tab in Docs6:53
View Tab and Page Break in Docs6:17
Table of Content3:08
Learn how to insert and customize a table of contents in a document by using heading styles, choosing page numbers or blue links, and updating links when headings change.
Footnote in Docs3:04
Line and Date in Docs2:49
Insert horizontal lines to separate sections, insert dynamic dates such as today, tomorrow, and yesterday, and access special characters in Google Docs using the insert menu, with quick undo options.
Image Format in Docs7:06
Insert images in Google Docs from computer, web, drive, or camera and apply text wrapping options. Adjust size, rotation, recolor, and basic edits like transparency, brightness, and contrast.
Creating Table in Docs9:14
Insert a table in Google Docs, choose rows and columns, and merge cells for a title. Adjust table properties such as vertical alignment, padding, width, height, color, borders, and alignment.
Charts in Docs2:45
Drawing Option in Docs4:59
Text Format and Column option4:19
Word Count, Translate and Voice Typing4:30
Comment and Citation in Docs5:09
Addons on Docs3:06
Mail Merge in Docs9:26

Getting started in Google Slides12:02
Quick Guide to Presentation9:14
Options in File Tab5:45
Options in View Tab3:27
Audio and Video Management in Slides11:08
Creating Diagram and slide number8:16
Format and Arrange option5:21
Slides Management3:58
Navigate Google Slides using right-click options to add, delete, duplicate, skip, or move slides. Manage background, layout, transitions, and themes to refine slides and adjust order during presentations.

Requirements

Basic Computer Knowledge

Description

Master Google Sheets, Docs, Slides & Forms – Complete 9-Hour Course

Unlock the full power of Google Workspace with this all-in-one practical training. From advanced spreadsheet formulas to professional document formatting, dynamic presentations, and effective form creation — this course teaches you everything you need to work smarter and faster.

Course Overview:

This complete course covers Google Sheets, Google Docs, Google Slides, and Google Forms in one structured 9-hour program. Whether you're a student, teacher, business professional, or freelancer, you'll gain job-ready skills to use these tools efficiently in real-life scenarios.

What You'll Learn

Google Sheets:

Essential and advanced formulas: Math, Logical, Text, Date
IF, Nested IF, VLOOKUP, HLOOKUP, INDEX, MATCH
Conditional formatting, Pivot Tables, Charts
Data validation, slicers, named ranges, filters
Financial calculations: PMT, IPMT, PV
Automate tasks using macros and manage protection settings

Google Docs:

Professional formatting, headings, bullets, styles
Tables, footnotes, bookmarks, citations, table of contents
Voice typing, translation, print and page setup
Add-ons, mail merge, comments, and citations

Google Slides:

Slide design, transitions, and media integration
Format and layout tools, diagrams, and content arrangement
Presentation settings and slide navigation

Google Forms:

Create and customize forms for surveys, quizzes, feedback
Configure input types, manage responses, share forms

Course Features

9 Hours of step-by-step video content
70+ focused lectures, divided by tool
Practical, task-based learning
Lifetime access and certificate of completion

Start today and become confident and efficient with Google’s most powerful productivity tools. This course will help you save time, improve accuracy, and boost your digital skills.

Who this course is for:

Office professionals and executives
Teachers, trainers, and students
Entrepreneurs, freelancers, and content creators
Anyone who wants to fully utilize Google Workspace tools

Google Workspace Course – Sheets, Docs, Slide and Forms

What you'll learn

Explore related topics

Course content

Google Sheets40 lectures • 5hr 34min

Google Docs22 lectures • 2hr 11min

Google Slides8 lectures • 59min

Google Forms1 lecture • 16min

Requirements

Description

Who this course is for: