It's a good course if you have some prior knowledge. For absolute beginners, some concepts might be a bit challenging. The structure is logical, though.
Google Sheets for Beginners: Build and Collaborate on Spreadsheets
Learn to build, format, and share professional spreadsheets in Google Sheets, mastering collaborative tools and essential formulas to organize your data.
-
💬
AI instructor
Ask about any lesson and get a clear answer instantly, anytime. -
🕐
Start anytime
No schedules or deadlines — learn at your own pace, whenever suits you. -
🌐
In English
Lessons, tasks and certificate — all fully in your language.
About this course
Course contents
6 modules · 29 lessons · 3h 5m
1
Introduction and Interface
Navigate the Google Sheets environment and create your first file.
- Why Google Sheets?
Understand the benefits of the cloud and collaboration compared to traditional software.6 min - Interface Tour and Terminology
Identify cells, rows, columns, menu bars, and worksheets.7 min - Creating a Sheet from Scratch
Learn how to start a new project and give your file an effective name.5 min - Working with Templates
Save time by using pre-built structures provided by Google.6 min
2
Data Entry and Formatting
Learn how to enter data correctly and make it visually clear.
- Data Entry: Text, Numbers, and Dates
Distinguish between data types and enter them correctly into cells.6 min - Selecting and Managing Ranges
Master the selection of individual cells, rows, columns, and entire sheets.5 min - Text and Cell Formatting
Change fonts, sizes, colors, and alignment to improve readability.7 min - Number and Currency Formatting
Transform simple numbers into currencies, percentages, or specific date formats.6 min - Borders and Fill Colors
Use graphic elements to visually separate different data sections.6 min
3
Essential Formulas and Functions
Perform automatic calculations and basic data analysis.
- Your First Formula
Understand how to start a formula with the equals sign and use cell references.6 min - Basic Arithmetic Operations
Perform addition, subtraction, multiplication, and division between cells.7 min - The SUM Function
Quickly and automatically sum large ranges of numbers.6 min - Average, Minimum, and Maximum
Use basic statistical functions to find key values in your data.7 min - Auto-fill
Drag formulas to quickly apply them to entire columns.6 min
4
Data Organization and Cleaning
Structure data neatly and prevent entry errors.
- Sorting Data
Organize rows in alphabetical, numerical, or chronological order.6 min - Using Filters
Temporarily isolate only the data that meets specific criteria.7 min - Data Cleaning: Duplicates
Identify and remove identical rows to keep data accurate.6 min - Data Validation
Set rules to limit what can be entered into a cell.7 min - Interactive Dropdown Menus
Create dropdowns to facilitate data entry and standardize responses.7 min
5
Collaboration and Management
Work in teams securely and efficiently on the same file.
- Sharing and Permissions
Configure who can view, comment on, or edit the spreadsheet.7 min - Collaboration and Comments
Work together in real-time and use comments to communicate in context.6 min - Version History
View past changes and restore previous versions of the file.7 min - Protecting Sheets and Ranges
Lock specific cells to prevent accidental changes by others.6 min - Edit Notifications
Set up email alerts to know when someone updates the sheet.5 min
6
Visualization and Modern Features
Transform data into visual information and use advanced tools.
- Conditional Formatting
Automatically change cell colors based on their value.7 min - Creating Clear Charts
Insert pie, bar, or line charts to visualize trends.8 min - Customizing Charts
Edit titles, colors, and legends to make charts look professional.7 min - Modern Smart Chips
Insert interactive chips for people, files, and dates directly into cells.6 min - Creating a Dynamic Tracker
Combine all skills to create a functional tracking system.7 min
Final Project: Collaborative Project Tracker
Create a spreadsheet to manage a team project. You will structure the data, use dropdown menus for status, smart chips for team members, formulas to calculate deadlines, and a chart to visualize progress.
What you'll get
-
📜
Certificate of completion
Add it to your LinkedIn profile -
💬
Personal AI tutor
Stuck on a lesson? Ask your built-in tutor anything, any time. -
♾️
Lifetime access
Come back anytime, no expiry -
📱
Phone or computer
Works anywhere, any device -
💸
14-day refund
No questions asked -
⚡
Short & focused
3h 5m of practical content
Certificate of completion
Every course you complete on PickAClass issues a credential like this — original, with its own code, verifiable by URL, and detailed about what was actually demonstrated.
Reviews (1)
Learners also took
Excel Essentials: Formulas, Functions, and Data Analysis
Excel and Copilot Foundations for Modern Data Work
XML and XSLT: Beginner's Guide to Data Transformation
Excel Payroll Management and Financial Modeling
Frequently asked
What do I need to take this course? +
Just a phone or computer with internet. No installs, no special hardware.
How do I pay? +
By card via Stripe. We don’t store card details — Stripe handles them securely.
Can I get a refund? +
Yes — full refund within 14 days, no questions asked.
How long will I have access? +
Forever. Once you purchase, the course is yours to revisit anytime.
Will I get a certificate? +
Yes. On completion you'll receive a certificate you can add to your LinkedIn profile.
Get 10 courses a month
Members get 10 courses of their choice every month for ₦0. No per-course charges — you pay only the subscription.
- ✓ 10 courses every month
- ✓ Cancel anytime
Renews monthly. Unused courses expire at the end of each billing month.