Courses › The Google Sheets Mastery: Training and Certification

The Google Sheets Mastery: Training and Certification

The Google Sheets Mastery: Training and Certification course equips learners with advanced spreadsheet skills, automation techniques, and professional-level data management using Google Sheets. Topics include: Data Cleaning and Data Management Practices . Duplicate Removal . Vlookup True and False Variants . XLookup Functions . LEN, Left and Right Functions . Pivot Table Feature . Pivot Chart and Dashboards . Gemini AI Integration and Data Management . and many more...

📋 9 Parts 🎬 Video per part 📂 Exercise files included 🏆 Certificate on completion ♾️ Lifetime access
Offered by Keiba Tech IT Consultancy
₱499.00
💡 One-time payment · Lifetime access
Enroll Now
🎬 Video walkthrough per part
📂 Downloadable exercise files
📤 Submit your work per part
🏆 Certificate of completion
♾️ Lifetime access
What You'll Learn
✓Apply skills immediately at work
✓Follow along with exercise files
✓Learn at your own pace, anytime
✓Upload completed work per part
✓Get instructor-reviewed certificate
✓Lifetime access to all materials
Course Parts (9)
1
Data Cleaning
The Google Sheets Data Cleaning course teaches practical techniques to organize, correct, and prepare messy datasets for accurate analysis using Google Sheets.
📂 Exercise File 🎬 Video 📤 Submit Work
2
VLookup False Variant, Data Validation and Concatenate Functions
The Google Sheets VLOOKUP, Data Validation, and CONCATENATE Functions course teaches essential formulas and tools to efficiently search data, control input accuracy, and combine text using Google Sheets.
📂 Exercise File 🎬 Video 📤 Submit Work
3
Vlookup - True Variant, Constant Cell Values, Text Functions, Concatenate
The Google Sheets VLOOKUP - TRUE, Constant Cell Values, Text Functions, and CONCATENATE course teaches advanced lookup techniques, fixed references, and text manipulation to efficiently manage and analyze data in Google Sheets.
📂 Exercise File 🎬 Video 📤 Submit Work
4
Filler Discussion - Left, Right and LEN Functions (No Exercise File provided)
The Google Sheets LEFT, RIGHT, and LEN Functions course teaches how to extract and analyze text data efficiently using essential string functions in Google Sheets
🎬 Video 📤 Submit Work
5
If, Ifs and XLookup Functions
The Google Sheets IF, IFS, and XLOOKUP Functions course teaches logical formulas and advanced lookup techniques to analyze data and automate decision-making in Google Sheets
📂 Exercise File 🎬 Video 📤 Submit Work
6
WhatIf Analysis
The Google Sheets What-If Analysis course teaches how to forecast outcomes and evaluate different scenarios using data-driven tools in Google Sheets.
📂 Exercise File 🎬 Video 📤 Submit Work
7
Pivot Table
The Google Sheets Pivot Table teaches how to summarize, analyze, and visualize data effectively using dynamic reports in Google Sheets.
📂 Exercise File 🎬 Video 📤 Submit Work
8
Pivot Chart
The Google Sheets Pivot Chart course teaches how to create dynamic visual reports from summarized data, enabling clearer insights and better decision-making in Google Sheets
📂 Exercise File 🎬 Video 📤 Submit Work
9
Filler Discussion - Gemini for Google Sheets (No Exercise file provided)
The Gemini for Google Sheets course teaches how to leverage Google Sheets with Gemini to automate tasks, generate insights, and enhance data analysis using AI. The student can submit their generated file using Gemini if they have Google Workspace account. If none, leave it blank, this is an optional exercise.
🎬 Video 📤 Submit Work