Course Information
Course Overview
Master Google Sheets, Docs, Slides & Forms with practical tasks, formulas, formatting, charts, and data handling
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.
Course Content
- 4 section(s)
- 71 lecture(s)
- Section 1 Google Sheets
- Section 2 Google Docs
- Section 3 Google Slides
- Section 4 Google Forms
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
Skills covered in this course
Reviews
-
JJosette Harry
I'm disappointed in the course, there was a barrier in terms of the language and I don't think its beginner friendly. I will have to go through it again and slow it down. I did consider asking for a refund, but i found the lesson plan layout to be interesting but the execution, mainly based on my inability to understand the instructor to be less than desired. I did turn on the captions. I'll go through the training again until I get the desire learning results.
-
MMohammad Yosuf Haidary
Very helpful.
-
KKela J Plamper
I love how thorough and not rushing
-
BBri Allen
So far so good!