AboutTeamsPricing
New content added weeklyLive

Master Google Sheets with Adaptive AI.

Master Google Sheets across 19 topics - Foundations, Intermediate, and Advanced - guided by Leyaa's adaptive intelligence.

3Parts
19Topics
149Patterns
35hEst. duration
Start Learning Free
Google Sheets
Google Sheets Course
3 - part learning journey
Beginner
Foundations
6 topics · 48 patterns
Beginner
Intermediate
Intermediate
7 topics · 56 patterns
Intermediate
Advanced
Advanced
6 topics · 45 patterns
Advanced
Begin Part 1: Foundations
✦ Course Structure

Your Google Sheets Journey in 3 Parts

Each part builds on the last - a deliberate progression from beginner to advanced.

Beginner
Beginner
Part 1: Foundations
Covers Google Sheets Basics and Interface, Cell Formatting, Basic Formulas and 3 more topics.
6Topics
48Patterns
View topics
Intermediate
Intermediate
Part 2: Intermediate
Covers Logical Functions, Lookup Functions, Text Functions and 4 more topics.
7Topics
56Patterns
View topics
Advanced
Advanced
Part 3: Advanced
Covers Data Import and Connection, Apps Script Basics, Advanced Conditional Formatting and 3 more topics.
6Topics
45Patterns
View topics
Curriculum

Everything You'll Learn

Explore every topic and pattern in the course.

Google Sheets

3 parts · 19 topics · 149 patterns
Beginner
Part 1: Foundations6 topics · 48 patterns
Beginner
01
Google Sheets Basics and Interface
8 patterns
Why Google Sheets is essential for collaboration
Google Sheets vs Excel comparison
Creating and opening spreadsheets
Interface navigation (toolbar, formula bar, sheet tabs)
Selecting cells, rows, and columns
Entering and editing data
File sharing and permissions
Keyboard shortcuts
02
Cell Formatting
8 patterns
Why formatting communicates data meaning
Number formats (currency, percentage, date)
Font and text styling
Cell alignment and wrapping
Borders and background colors
Merge cells
Conditional formatting basics
Alternating row colors
03
Basic Formulas
8 patterns
Why formulas automate calculations
Formula structure and cell references
SUM function
AVERAGE function
MIN and MAX functions
COUNT and COUNTA functions
Arithmetic operators
AutoFill for formula copying
04
Cell References and Ranges
7 patterns
Why reference types affect formula behavior
Relative references
Absolute references ($)
Mixed references
Named ranges
Cross-sheet references
INDIRECT for dynamic references
05
Data Entry and Management
9 patterns
Why clean data enables analysis
Data validation rules
Dropdown menus
Find and replace
Sorting (single and multi-column)
Filtering with filter views
Removing duplicates
Split text to columns
Paste special options
06
Basic Charts
8 patterns
Why charts make data visual
Column and bar charts
Line charts
Pie charts
Chart customization (title, legend, colors)
Chart editor panel
Moving charts to separate sheets
Embedding charts in Docs and Slides
Intermediate
Part 2: Intermediate7 topics · 56 patterns
Intermediate
01
Logical Functions
7 patterns
Why logical functions handle conditions
IF function
Nested IF functions
AND and OR functions
IFS function
IFERROR and IFNA
SWITCH function
02
Lookup Functions
7 patterns
Why lookups connect datasets
VLOOKUP function
HLOOKUP function
INDEX and MATCH combination
XLOOKUP function
IMPORTRANGE for cross-spreadsheet data
Approximate vs exact match
03
Text Functions
10 patterns
Why text functions clean messy data
CONCATENATE and JOIN
LEFT, RIGHT, MID
LEN function
UPPER, LOWER, PROPER
TRIM and CLEAN
FIND and SEARCH
SUBSTITUTE and REPLACE
REGEXMATCH and REGEXEXTRACT
SPLIT function
04
Date and Time Functions
8 patterns
Why date calculations drive business logic
TODAY and NOW
YEAR, MONTH, DAY extraction
DATE function
DATEDIF for differences
EDATE and EOMONTH
WEEKDAY and WORKDAY
TEXT formatting for dates
05
Array Formulas and Advanced Functions
9 patterns
Why array formulas process ranges at once
ARRAYFORMULA function
SUMIF and SUMIFS
COUNTIF and COUNTIFS
AVERAGEIF and AVERAGEIFS
FILTER function
SORT and SORTN functions
UNIQUE function
QUERY function basics
06
QUERY Function Deep Dive
8 patterns
Why QUERY is Google Sheets' most powerful function
SELECT clause
WHERE clause for filtering
ORDER BY clause
GROUP BY with aggregation
LIMIT and OFFSET
LABEL for column headers
Combining clauses
07
PivotTables
7 patterns
Why PivotTables summarize data fast
Creating a PivotTable
Row and column grouping
Value aggregation (SUM, COUNT, AVG)
Filtering PivotTable data
Calculated fields
PivotTable formatting
Advanced
Part 3: Advanced6 topics · 45 patterns
Advanced
01
Data Import and Connection
7 patterns
Why external data expands analysis
IMPORTDATA for CSV/TSV
IMPORTHTML for web tables
IMPORTXML for structured data
IMPORTRANGE for other spreadsheets
IMPORTFEED for RSS
Connected Sheets (BigQuery)
02
Apps Script Basics
8 patterns
Why Apps Script automates Google Sheets
Script editor overview
Custom functions
Triggers (onEdit, onOpen)
Reading and writing cell values
Creating custom menus
Sending emails from Sheets
API calls from Apps Script
03
Advanced Conditional Formatting
6 patterns
Why advanced rules highlight patterns
Color scales
Custom formula-based rules
Date-based formatting
Cross-column conditional rules
Managing rule priority
04
Collaboration Features
8 patterns
Why collaboration is Sheets' superpower
Real-time co-editing
Comments and suggestions
Edit history and version control
Filter views vs filters
Protected sheets and ranges
Notification rules
Publishing to web
05
Data Visualization Advanced
8 patterns
Why advanced charts tell deeper stories
Combo charts
Sparklines (LINE, BAR, COLUMN)
Scatter plots
Geo charts and maps
Timeline charts
Org charts
Chart interactivity
06
Productivity and Integration
8 patterns
Why integration multiplies value
Linking Sheets with Docs
Linking Sheets with Slides
Google Forms to Sheets
Sheets with Google Data Studio (Looker)
Add-ons and extensions
Template gallery usage
Sheets API basics
Why Leyaa

Not just a course. A learning intelligence.

Leyaa doesn't just deliver content - it understands where you are, what you need, and how to get you there fastest.

Adaptive Diagnostics
Adaptive Diagnostics
Leyaa identifies which of the 149 patterns you've mastered and which need work - before you waste time on what you already know.
Pattern-Level Precision
Pattern-Level Precision
Every pattern gets a verdict - Learn, Practice, or Skip - so your study time goes exactly where it counts.
Intelligent Pacing
Intelligent Pacing
Leyaa reads your velocity across the whole course and adapts your focus list dynamically, keeping you in the optimal learning zone.
Before & After Visibility
Before & After Visibility
Every assessment creates a snapshot. Retake anytime to see exactly how much you've grown - topic by topic, pattern by pattern.
Learner Autonomy
Learner Autonomy
Leyaa recommends, never restricts. Override any suggestion and explore at your own pace - the system tracks everything regardless.
Clear Learning Path
Clear Learning Path
Foundations → Intermediate → Advanced - a structured journey where each part sets you up perfectly for the next.
Google Sheets

Ready to master Google Sheets?
Start your journey today

Start your diagnostic now. Build mastery across all 19 topics in under 15 minutes.

19 Topics
149 Patterns
Personalized roadmap
Leyaa Swift Bird