Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Ultimate Guide to mastering Google Sheets in 14 days
1. Introduction
Introduction to Google Sheets (2:43)
What is Google Sheets (0:49)
Top 5 Google Sheets Features (6:42)
Chapter 1 Summary
2. Mastering the Basics for Powerful Data Management
2.1 Google Account (1:47)
2.2 Navigating the Interface (11:06)
2.3 Data Entry and Cells Navigation (12:23)
2.4 Import Data (23:26)
2.5 Records Formatting (18:19)
2.6 Data Types and Formatting (29:58)
2.7 Conclusion
3. Data Manipulation in Google Sheets
3.1 What is Formulas (5:36)
3.2 Use Formulas in Google Sheets (11:14)
3.3 Intermediate Formulas (45:37)
3.4 Putting all together
Useful Formulas
4. Data Visualization
4.1 Named Ranges (3:20)
4.2 Data Cleaning and Validation (23:09)
4.3 Sparklines (5:40)
4.4 Data Validation (7:17)
4.5 Analyzing Data with Conditional Formatting (6:44)
4.6 Working with Charts and Graphs
4.7 Pivot Tables
4.8 Filtering and Sorting
5. Advanced Features
5.2 Advanced Formulas
5.1 Protecting Your Data
Absolute References vs Relative References
Introduction to Macros
Utilizing Add-ons and Macros
Example using Macros
Add-ons with Supermetrics
Add-ons with Chatgpt
6. Collaboration and Sharing
Understanding the Structure of Google Drive and Google Sheets
Collaboration and Sharing
Working with Multiple Users
Protecting Your Data
Integration with Other Google Services
7. Essential Tips and Tricks
Using Shortcuts for Efficiency
Automating Google Sheets
Utilizing Spreadsheets to Simplify Tasks
Cross-Sheet Operations
8. Google Sheets with AI
Artificial Intelligence
Data Exploration with Explore Feature
Workflow automation with AI
Smart Clean Up
Predictive Analysis
External Database
9. Productivity with Google Sheets
How to Send Email
Send Notification when task status changed
10. Side Hustles with Google Sheets
Possible Ideas
High in Demand Dashboard / Templates
Resource Booking Sheet
11. Conclusion
Recap and Summary
Recap and Summary
Complete and Continue