Chứng chỉ MOS Excel 2019 - Exam MO-200 Microsoft Excel
TS. Dang Xuan Tho
5.0 (500)·6h 10m · 91 lectures
$3.00$12–$199up to −98%
Loading course
Google Sheets Masterclass 2026
Master formulas, pivot tables, dashboards, data validation, smart features, and automation in Google Sheets
5.061 reviews1,250 learners
- All Levels
- 4h 4m video
- 41 lectures
- English
- Updated 2026
Taught by InspireEd Solutions
- 4h 4m of on-demand video
- 41 lectures across 1 sections
- One-off payment — no subscription
- Lifetime access on web and mobile
- English audio
Curriculum
1 sections41 lectures4h 4m total
- Getting Started and Accessing Google Sheets2:42
- Understanding Google Sheets Interface5:35
- Important Info1:29
- Working on Rows and Columns in Google Sheets4:25
- How to Fix Date and Currency Format Using Local1:29
- Working With Data in Cells7:47
- Resizing Cells Columns and Rows With Formatting7:25
- Grouping and Ungrouping2:51
- Freezing and Unfreezing Rows and Columns3:41
- Merging and Unmerging Cells in Sheets2:30
- Protecting Ranges in Google Sheets From Editing3:26
- Protecting Entire Sheet Except Certain Cells Permissions in Google Sheets3:24
- Adding New Sheet Tabs to Existing Google Sheet3:43
- Using Formula Basics - Working with Addition Multiplication and Subtraction (Fre7:54
- Generating Random Data In Sheets Using Special4:21
- How To Remove Formulas in Google Sheets and Keep Values1:41
- Multiplicative and Divisional Calculations in Sheets4:15
- Concept of Nested Formulas6:06
- Basics of Absolute and Relative Refrences in Google Sheets8:17
- Performing Quick Calculations in Sheets2:51
- Introduction to IF Conditions5:32
- Writing Basic Formulas5:44
- Introduction to Conditional Sum Count and Average6:16
- Using All Rounding Functions in Sheets8:09
- Introduction to Vlookup7:56
- Powerful Use of Data Validation for Drop Down List Using Advance Techniques8:13
- Remove Duplicates From Data4:07
- How To Use VLOOKUP Approximate Match with Data from Another Sheet6:08
- All Formatting Techniques in Google Sheets12:24
- Conditional Formatting5:55
- Adding Images Links Checkboxes and More in Google Sheets9:02
- Change Excel Spreadsheet into Google Sheets Format1:53
- Share Google Sheets with Anyone Using a Link1:53
- Pivot Table Basics in Google Sheets6:42
- Creating Multiple Type of Reports With Pivot Table9:44
- Creating Charts in Google Sheets14:15
- Create Interactive Dashboards in Google Sheets13:34
- Using Slicer to Filter Data2:57
- Filtering and Sorting Data in Google Sheets4:52
- Overview of Whats Covered So Far17:58
- Sharing and Collaborating in Google Sheets5:25
About this course
This Google Sheets Basic to Advanced Training Course is a complete, hands-on program designed to help you master Google Sheets for data analysis, reporting, automation, and collaboration—from absolute beginner to advanced user. You’ll start by learning the Google Sheets interface, working with rows, columns, cells, formats, and locale settings for dates and currency. The course builds a strong foundation by covering data entry, resizing, grouping, freezing panes, merging cells, and protecting ranges and sheets wit…
Before you start
- No prior Google Sheets experience required
- Basic computer and internet usage skills
- A free Google account to access Google Sheets
- Willingness to practice with real examples and exercises
Who it’s for
- Beginners who want to learn Google Sheets from scratch
- Office professionals working with reports, data, and spreadsheets
- Accountants, analysts, and business users using Google Sheets daily
- Freelancers and virtual assistants handling client data
- Students and job seekers looking to improve data analysis skills
- Anyone switching from Microsoft Excel to Google Sheets
Related
More in Office Productivity
Ôn thi Chứng chỉ MOS Word 2019 - Exam MO-100 Microsoft Word
TS. Dang Xuan Tho
5.0 (467)·5h 36m · 79 lectures$3.00$12–$199up to −98%The AI-Powered Business Writing & Communication Guide
Emmanuel Essien
5.0 (178)·1h 32m · 12 lectures$3.00$12–$199up to −98%Productivity Masterclass: Master GenAI Workflows
Emmanuel Essien
5.0 (157)·2h 51m · 18 lectures$3.00$12–$199up to −98%
$3.00$12–$199