Google Sheets Masterclass 2025 — From Beginner To Pro

Master Google Sheets from Zero to Pro: Unlock the Full Power of Spreadsheets for Work, Business, and Data Analysis

What you'll learn

Confidently navigate the Google Slides interface and set up professional presentations from scratch.

Design engaging slides with text, images, shapes, charts, tables, diagrams, and multimedia.

Master typography, formatting, lists, and layout tools to create polished and consistent slides.

Apply animations, transitions, and advanced visual techniques to bring your presentations to life.

Collaborate in real time, use productivity shortcuts, and manage presentations seamlessly.

Export, share, and present your Google Slides with confidence in any professional or academic setting.

Requirements

A Google account (free).

A computer with internet access.

No prior spreadsheet knowledge required — we’ll start from the very basics.

Description

Google Sheets has become one of the most powerful and versatile spreadsheet tools in the world. Whether you’re managing personal budgets, analyzing business data, collaborating with teams, or building advanced dashboards, mastering Google Sheets is a skill that will set you apart in today’s digital workplace.In this Google Sheets Masterclass, you’ll go from absolute beginner to advanced user with step-by-step lessons designed to help you fully understand and harness the potential of this tool. We’ll start from the very basics — creating and formatting spreadsheets, entering and managing data — and gradually move into advanced topics like pivot tables, formulas, functions, data visualization, and collaboration.Every concept is explained clearly with practical examples, hands-on exercises, and real-world scenarios so you can apply what you learn immediately. By the end of this course, you won’t just “know” Google Sheets — you’ll be able to confidently use it for personal, academic, and professional projects.This course is designed with a structured, beginner-friendly approach, but it also dives deep enough to give advanced learners valuable insights. Whether you’re a student, entrepreneur, freelancer, or professional looking to boost your productivity and analytical skills, this masterclass will equip you with the tools you need to succeed.Join us now and let’s transform the way you work with data using Google Sheets!

Overview

Section 1: Getting Started with Google Sheets

Lecture 1 Introduction to Google Sheets

Lecture 2 Google Sheets vs Microsoft Excel

Lecture 3 What Are Spreadsheets?

Section 2: Basics of Google Sheets

Lecture 4 Setting Up Google Sheets

Lecture 5 Navigating Between Google Workspace Apps

Lecture 6 First Look at Google Sheets

Lecture 7 Creating Your First Spreadsheet

Lecture 8 Google Sheets Basics Explained

Lecture 9 Adding, Renaming & Deleting Sheets

Lecture 10 Zooming In and Out

Lecture 11 Entering Data in Google Sheets

Lecture 12 Exploring the Top Menu Bar

Lecture 13 Managing & Renaming Projects

Lecture 14 How Auto-Save Works

Section 3: Typography and Text Styles

Lecture 15 Selecting Cells in Google Sheets

Lecture 16 Adjusting Font Size

Lecture 17 Changing Font Family

Lecture 18 Using More Fonts in Google Sheets

Section 4: Text Formatting

Lecture 19 Bold Text

Lecture 20 Italic Text

Lecture 21 Strikethrough Text

Section 5: Cell Formatting

Lecture 22 Changing Text Color

Lecture 23 Applying Fill Colors

Lecture 24 Adding Borders

Lecture 25 Merging Cells

Section 6: Text Alignment & Rotation

Lecture 26 Horizontal Alignment Options

Lecture 27 Vertical Alignment Options

Lecture 28 Rotating Text in Google Sheets

Section 7: Working with Links

Lecture 29 Adding Links to Google Sheets

Section 8: Selecting Cells & Ranges

Lecture 30 Selecting a Single Cell

Lecture 31 Selecting a Range

Lecture 32 Selecting Columns

Lecture 33 Selecting Rows

Section 9: Undo & Redo

Lecture 34 Basic Commands in Google Sheets

Lecture 35 Undo & Redo Explained

Lecture 36 Using Undo

Lecture 37 Using Redo

Section 10: Clipboard Tools

Lecture 38 Cut in Google Sheets

Lecture 39 Paste in Google Sheets

Lecture 40 Copy in Google Sheets

Lecture 41 Paste Specials in Google Sheets

Section 11: Formatting Tools & Themes

Lecture 42 Applying Themes

Lecture 43 Format Menu Walkthrough

Lecture 44 Clearing Formatting

Section 12: Inserting Cells and Structures

Lecture 45 Introduction to the Insert Tab

Lecture 46 Inserting Cells

Lecture 47 Inserting Rows

Lecture 48 Inserting Columns

Section 13: Inserting Visuals

Lecture 49 Inserting Tables

Lecture 50 Inserting Images in Cells

Lecture 51 Inserting Images Over Cells

Lecture 52 Inserting Drawings

Lecture 53 Inserting Emojis

Section 14: Inserting Inputs

Lecture 54 Inserting Checkboxes

Lecture 55 Inserting Dropdowns

Section 15: Charts in Google Sheets

Lecture 56 Inserting Data

Lecture 57 Inserting Charts

Lecture 58 Using the Chart Editor

Section 16: Pivot Tables

Lecture 59 Introduction to Pivot Tables

Lecture 60 Inserting Pivot Tables

Lecture 61 Mastering Pivot Tables

Section 17: Data Arrangement

Lecture 62 Sorting Sheets

Lecture 63 Sorting Ranges

Lecture 64 Filters in Google Sheets

Lecture 65 Protecting Sheets & Ranges

Section 18: Addressing

Lecture 66 Introduction to Functions & Formulas

Lecture 67 Why Addressing Matters

Lecture 68 Basics of Addressing

Lecture 69 Cell Addressing

Lecture 70 Range Addressing

Section 19: Functions & Formulas

Lecture 71 Functions List

Lecture 72 Preparing Sample Data for Functions

Lecture 73 Mirroring Cells

Lecture 74 Mathematical Calculations

Lecture 75 Complex Math

Lecture 76 Getting Started with Functions

Lecture 77 ADD Function

Lecture 78 SUM Function

Lecture 79 MIN Function

Lecture 80 MAX Function

Lecture 81 COUNT Function

Lecture 82 COUNTA Function

Lecture 83 AVERAGE Function

Lecture 84 MEDIAN Function

Lecture 85 NOW Function

Lecture 86 Advanced Functions

Section 20: Exporting & Sharing

Lecture 87 Saving in Google Sheets

Lecture 88 Printing in Google Sheets

Lecture 89 Exporting as XLSX

Lecture 90 Exporting as PDF

Lecture 91 Exporting as CSV

Beginners who want to master Google Slides from the ground up.,Students and educators creating academic or classroom presentations.,Professionals who need to design impactful business or corporate slide decks.,Entrepreneurs, freelancers, and marketers who use presentations to pitch ideas and projects.,Anyone looking to replace PowerPoint and gain confidence using Google’s free presentation tool.