Google Workspace Masterclass 2025 — From Beginner To Pro

Master Docs, Sheets & Slides: Boost Productivity, Create Documents, Analyze Data, and Build Presentations Like a Pro.

What you'll learn

Create, edit, and format professional documents in Google Docs

Build engaging and impactful presentations in Google Slides

Manage and analyze data effectively in Google Sheets

Use formulas, functions, charts, and pivot tables like a pro

Insert and format images, tables, drawings, and media across all apps

Export, share, and collaborate in real-time within Google Workspace

Requirements

A Google account (free to create)

An internet connection

Basic computer skills (typing, navigating, saving files)

Description

Google Workspace has become the gold standard for modern productivity. Whether you’re a student, professional, entrepreneur, or freelancer, mastering Google Docs, Sheets, and Slides can save you countless hours, elevate your efficiency, and open new opportunities.In this Google Workspace Masterclass, we combine three power-packed courses into one seamless learning journey — giving you everything you need to become a confident and skilled user of Google’s most important tools.You’ll start with Google Docs, learning how to create, format, and design professional documents. From text formatting, styles, headers, and footers to inserting tables, images, charts, and exporting in multiple formats — you’ll master every essential feature.Next, we dive into Google Slides, where you’ll learn to build visually stunning presentations. Discover how to apply themes, customize slide layouts, insert media, add transitions and animations, and present confidently with Google’s built-in tools.Finally, we move to Google Sheets, the powerhouse of data management. You’ll gain hands-on experience with formulas, functions, charts, pivot tables, data sorting, filters, and more. By the end, you’ll not only know how to enter data but also how to analyze and present it effectively.This course is practical, step-by-step, and beginner-friendly, yet packed with tips and tricks professionals use every day. Each lesson builds on the previous one so you can progress smoothly without feeling overwhelmed.By the end of this Masterclass, you’ll have the confidence and ability to use Google Workspace to handle real-world tasks — whether it’s writing a report, presenting at a meeting, or managing a spreadsheet full of data.If you want to work smarter, faster, and better, this course is your all-in-one toolkit.

Overview

Section 1: Google Docs: Getting Started

Lecture 1 Introduction to Google Docs

Lecture 2 Exploring Google Docs Editors

Lecture 3 Understanding Google Docs Pricing

Section 2: Google Docs: The Basics

Lecture 4 Setting Up Google Docs

Lecture 5 Google Docs vs Microsoft Word

Lecture 6 First Impressions: Navigating Google Docs

Lecture 7 Creating Your First Document

Lecture 8 Understanding Unique Document URLs

Lecture 9 Renaming & Deleting Documents

Lecture 10 Auto-Save in Action

Lecture 11 Full Interface Walkthrough

Section 3: Google Docs: Formatting Text

Lecture 12 Adding and Editing Text

Lecture 13 Zoom Controls in Google Docs

Lecture 14 Adjusting Font Size

Lecture 15 Choosing Font Families

Lecture 16 Working with Text Styles

Lecture 17 Applying Text Color

Lecture 18 Formatting Text Professionally

Lecture 19 Highlighting Key Information

Lecture 20 Inserting Hyperlinks

Section 4: Google Docs: Paragraph Settings

Lecture 21 Aligning Text Options

Lecture 22 Justify Text for Clean Layouts

Lecture 23 Shortcuts for Align & Justify

Lecture 24 Line and Paragraph Spacing

Section 5: Google Docs: Lists

Lecture 25 Creating Checklists

Lecture 26 Designing Bullet Lists

Lecture 27 Building Numbered Lists

Lecture 28 Nested Lists Explained

Section 6: Google Docs: Advanced Formatting

Lecture 29 Increasing & Decreasing Indents

Lecture 30 Clearing Formatting

Section 7: Google Docs: Undo & Redo Commands

Lecture 31 Introduction to Undo & Redo

Lecture 32 Undo in Google Docs

Lecture 33 Redo in Google Docs

Section 8: Google Docs: Clipboard Tools

Lecture 34 Cut & Paste Functions

Lecture 35 Copy & Paste Functions

Lecture 36 Using the Paint Format Tool

Section 9: Google Docs: Editing Features

Lecture 37 Finding Content in Google Docs

Lecture 38 Using Replace Tool

Section 10: Google Docs: Page Settings

Lecture 39 Setting Page Orientation

Lecture 40 Adding Page Numbers

Lecture 41 Working with Headers & Footers

Lecture 42 Configuring Page Setup

Section 11: Google Docs: Working with Images

Lecture 43 Adding Images to Documents

Lecture 44 Image Wrapping Options

Lecture 45 Replacing Images Quickly

Lecture 46 Styling and Adjusting Images

Section 12: Google Docs: Tables

Lecture 47 Inserting Tables

Lecture 48 Table Options Explained

Lecture 49 Styling Tables Professionally

Section 13: Google Docs: Drawings & Shapes

Lecture 50 Inserting Drawings

Lecture 51 Using Shapes

Lecture 52 Adding Lines & Text Boxes

Section 14: Google Docs: Charts

Lecture 53 Inserting Charts

Lecture 54 Editing Chart Data

Section 15: Google Docs: Advanced Inserting Features

Lecture 55 Adding Horizontal Lines

Lecture 56 Using Emojis in Documents

Lecture 57 Creating Dropdowns

Lecture 58 Adding Footnotes

Lecture 59 Inserting Watermarks

Lecture 60 Page Breaks Explained

Section 16: Google Docs: Exporting & Printing

Lecture 61 Introduction to Exporting

Lecture 62 Saving vs Exporting

Lecture 63 Exporting as DOCX

Lecture 64 Exporting as PDF

Lecture 65 Printing Documents

Section 17: Google Slides: Getting Started

Lecture 66 Introduction to Google Slides

Lecture 67 What Are Presentation Programs?

Lecture 68 Understanding Google Docs Editors

Lecture 69 Google Slides vs. Microsoft PowerPoint

Section 18: Google Slides: Basics

Lecture 70 Setting Up Google Slides

Lecture 71 First Impressions with Google Slides

Lecture 72 Creating Your First Presentation

Lecture 73 Renaming & Removing Presentations

Lecture 74 Navigating the Google Slides Interface

Section 19: Google Slides: Working with Slides

Lecture 75 Adding New Slides

Lecture 76 Choosing Slide Layouts

Lecture 77 Applying Slide Themes

Lecture 78 Setting a Background Color

Lecture 79 Using a Background Image

Lecture 80 Resetting Backgrounds

Section 20: Google Slides: Navigation Tools

Lecture 81 Zoom In

Lecture 82 Zoom Out

Lecture 83 Adjusting Zoom Percentage

Section 21: Google Slides: Typography Essentials

Lecture 84 Using Text Boxes

Lecture 85 Selecting Text Efficiently

Lecture 86 Choosing Font Families

Lecture 87 Font Differences: PowerPoint vs Slides

Lecture 88 Adding More Fonts

Lecture 89 Adjusting Font Size

Section 22: Google Slides: Text Formatting

Lecture 90 Applying Bold Text

Lecture 91 Using Italics

Lecture 92 Underlining Text

Lecture 93 Changing Text Color

Lecture 94 Highlighting Text

Section 23: Google Slides: Paragraph Formatting

Lecture 95 Horizontal Alignment

Lecture 96 Vertical Alignment

Lecture 97 Line & Paragraph Spacing

Lecture 98 Indents

Section 24: Google Slides: Lists

Lecture 99 List Types Overview

Lecture 100 Creating Bullet Lists

Lecture 101 Creating Numbered Lists

Lecture 102 Creating Nested Lists

Section 25: Google Slides: Working with Text Boxes

Lecture 103 Adding Backgrounds to Text Boxes

Lecture 104 Adding Borders to Text Boxes

Section 26: Google Slides: Undo & Redo

Lecture 105 Introduction to Undo & Redo

Lecture 106 Using Undo

Lecture 107 Using Redo

Section 27: Google Slides: Basic Commands

Lecture 108 Cutting Content

Lecture 109 Pasting Content

Lecture 110 Copying Content

Lecture 111 Using Paint Format

Section 28: Google Slides: Links

Lecture 112 Adding Links

Section 29: Google Slides: Shapes & Lines

Lecture 113 Inserting Shapes

Lecture 114 Shape Formatting Options

Lecture 115 Adding Text to Shapes

Lecture 116 Drawing Polylines

Lecture 117 Drawing Lines

Section 30: Google Slides: Working with Images

Lecture 118 Inserting Images

Lecture 119 Image Settings & Adjustments

Section 31: Google Slides: Advanced Inserting

Lecture 120 Adding Diagrams

Lecture 121 Creating Tables

Lecture 122 Adding Word Art

Lecture 123 Inserting Charts

Lecture 124 Adding Slide Numbers

Lecture 125 Embedding Videos

Section 32: Google Slides: Transitions & Animations

Lecture 126 Transitions vs Animations

Lecture 127 Applying Slide Transitions

Lecture 128 Applying Animations

Section 33: Google Slides: Presentation Tools

Lecture 0 Using Presentation Tool

Lecture 129 Using the Laser Pointer

Lecture 130 Using the Pen Tool

Lecture 131 Using the Eraser Tool

Section 34: Google Slides: Exporting Presentations

Lecture 132 Saving in Google Slides

Lecture 133 Exporting as PPTX

Lecture 134 Exporting as JPG & PNG

Lecture 135 Exporting as PDF

Section 35: Google Sheets: Getting Started

Lecture 136 Introduction to Google Sheets

Lecture 137 Google Sheets vs Microsoft Excel

Lecture 138 What Are Spreadsheets?

Section 36: Google Sheets: Basics

Lecture 139 Setting Up Google Sheets

Lecture 140 Navigating Between Google Workspace Apps

Lecture 141 First Look at Google Sheets

Lecture 142 Creating Your First Spreadsheet

Lecture 143 Google Sheets Basics Explained

Lecture 144 Adding, Renaming & Deleting Sheets

Lecture 145 Zooming In and Out

Lecture 146 Entering Data in Google Sheets

Lecture 147 Exploring the Top Menu Bar

Lecture 148 Managing & Renaming Projects

Lecture 149 How Auto-Save Works

Section 37: Google Sheets: Typography & Text Styles

Lecture 150 Selecting Cells in Google Sheets

Lecture 151 Adjusting Font Size

Lecture 152 Changing Font Family

Lecture 153 Using More Fonts in Google Sheets

Section 38: Google Sheets: Text Formatting

Lecture 154 Bold Text

Lecture 155 Italic Text

Lecture 156 Strikethrough Text

Section 39: Google Sheets: Cell Formatting

Lecture 157 Changing Text Color

Lecture 158 Applying Fill Colors

Lecture 159 Adding Borders

Lecture 160 Merging Cells

Section 40: Google Sheets: Text Alignment & Rotation

Lecture 161 Horizontal Alignment Options

Lecture 162 Vertical Alignment Options

Lecture 163 Rotating Text in Google Sheets

Section 41: Google Sheets: Working with Links

Lecture 164 Adding Links to Google Sheets

Section 42: Google Sheets: Selecting Cells & Ranges

Lecture 165 Selecting a Single Cell

Lecture 166 Selecting a Range

Lecture 167 Selecting Columns

Lecture 168 Selecting Rows

Section 43: Google Sheets: Undo & Redo

Lecture 169 Basic Commands in Google Sheets

Lecture 170 Undo & Redo Explained

Lecture 171 Using Undo

Lecture 172 Using Redo

Section 44: Google Sheets: Clipboard Tools

Lecture 173 Cut in Google Sheets

Lecture 174 Paste in Google Sheets

Lecture 175 Copy in Google Sheets

Lecture 176 Paste Specials in Google Sheets

Section 45: Google Sheets: Formatting Tools & Themes

Lecture 177 Applying Themes

Lecture 178 Format Menu Walkthrough

Lecture 179 Clearing Formatting

Section 46: Google Sheets: Inserting Cells & Structures

Lecture 180 Introduction to the Insert Tab

Lecture 181 Inserting Cells

Lecture 182 Inserting Rows

Lecture 183 Inserting Columns

Section 47: Google Sheets: Inserting Visuals

Lecture 184 Inserting Tables

Lecture 185 Inserting Images in Cells

Lecture 186 Inserting Images Over Cells

Lecture 187 Inserting Drawings

Lecture 188 Inserting Emojis

Section 48: Google Sheets: Inserting Inputs

Lecture 189 Inserting Checkboxes

Lecture 190 Inserting Dropdowns

Section 49: Google Sheets: Charts

Lecture 191 Inserting Dara

Lecture 192 Inserting Charts

Lecture 193 Using the Chart Editor

Section 50: Google Sheets: Pivot Tables

Lecture 194 Introduction to Pivot Tables

Lecture 195 Inserting Pivot Tables

Lecture 196 Mastering Pivot Tables

Section 51: Google Sheets: Data Arrangement

Lecture 197 Sorting Sheets

Lecture 198 Sorting Ranges

Lecture 199 Filters in Google Sheets

Lecture 200 Protecting Sheets & Ranges

Section 52: Google Sheets: Addressing

Lecture 201 Introduction to Functions & Formulas

Lecture 202 Why Addressing Matters

Lecture 203 Basics of Addressing

Lecture 204 Cell Addressing

Lecture 205 Range Addressing

Section 53: Google Sheets: Functions & Formulas

Lecture 206 Functions List

Lecture 207 Preparing Sample Data for Functions

Lecture 208 Mirroring Cells

Lecture 209 Mathematical Calculations

Lecture 210 Complex Math

Lecture 211 Getting Started with Functions

Lecture 212 ADD Function

Lecture 213 SUM Function

Lecture 214 MIN Function

Lecture 215 MAX Function

Lecture 216 COUNT Function

Lecture 217 COUNTA Function

Lecture 218 AVERAGE Function

Lecture 219 MEDIAN Function

Lecture 220 NOW Function

Lecture 221 Advanced Functions

Section 54: Google Sheets: Exporting & Sharing

Lecture 222 Saving in Google Sheets

Lecture 223 Printing in Google Sheets

Lecture 224 Exporting as XLSX

Lecture 225 Exporting as PDF

Lecture 226 Exporting as CSV

Students who want to create professional documents, projects, and presentations,Office professionals who use Google Workspace for daily tasks and collaboration,Entrepreneurs & freelancers who need efficient tools to manage work,Teachers & educators who prepare lessons, worksheets, and presentations,Anyone new to Google Workspace who wants to gain complete mastery