AboutTeamsPricing
New content added weeklyLive

Master Excel with Adaptive AI.

Master Excel across 20 topics - Foundations, Intermediate, and Advanced - guided by Leyaa's adaptive intelligence.

3Parts
20Topics
161Patterns
40hEst. duration
Start Learning Free
Excel
Excel Course
3 - part learning journey
Beginner
Foundations
6 topics · 49 patterns
Beginner
Intermediate
Intermediate
7 topics · 58 patterns
Intermediate
Advanced
Advanced
7 topics · 54 patterns
Advanced
Begin Part 1: Foundations
✦ Course Structure

Your Excel Journey in 3 Parts

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

Beginner
Beginner
Part 1: Foundations
Covers Excel Basics and Interface, Cell Formatting, Basic Formulas and 3 more topics.
6Topics
49Patterns
View topics
Intermediate
Intermediate
Part 2: Intermediate
Covers Logical Functions, Lookup Functions, Text Functions and 4 more topics.
7Topics
58Patterns
View topics
Advanced
Advanced
Part 3: Advanced
Covers Advanced Charts, Advanced Formulas, Conditional Formatting Advanced and 4 more topics.
7Topics
54Patterns
View topics
Curriculum

Everything You'll Learn

Explore every topic and pattern in the course.

Excel

3 parts · 20 topics · 161 patterns
Beginner
Part 1: Foundations6 topics · 49 patterns
Beginner
01
Excel Basics and Interface
8 patterns
Why Excel is essential for data work
Excel vs Google Sheets comparison
Workbook, worksheet, and cell structure
Navigating the ribbon and menus
Selecting cells, rows, and columns
Entering and editing data
Saving and file formats (xlsx, csv)
Keyboard shortcuts for efficiency
02
Cell Formatting
8 patterns
Why formatting improves readability
Number formats (currency, percentage, date)
Font styling (bold, italic, color)
Cell alignment and wrapping
Borders and shading
Merge and center cells
Format painter for consistency
Conditional formatting basics
03
Basic Formulas
9 patterns
Why formulas automate calculations
Formula structure (=, cell references)
SUM function
AVERAGE function
MIN and MAX functions
COUNT and COUNTA functions
Arithmetic operators in formulas
AutoSum shortcut
Formula bar and cell preview
04
Cell References
7 patterns
Why reference types matter
Relative references (A1)
Absolute references ($A$1)
Mixed references ($A1, A$1)
Referencing other worksheets
Named ranges
Reference errors and troubleshooting
05
Data Entry and Management
9 patterns
Why clean data entry prevents errors
Data validation rules
Dropdown lists from validation
AutoFill and Flash Fill
Find and replace
Sorting data (single and multi-level)
Filtering data with AutoFilter
Removing duplicates
Text to columns
06
Basic Charts
8 patterns
Why charts visualize data clearly
Column and bar charts
Line charts
Pie and doughnut charts
Selecting data for charts
Chart elements (title, legend, axis labels)
Formatting chart appearance
Moving and resizing charts
Intermediate
Part 2: Intermediate7 topics · 58 patterns
Intermediate
01
Logical Functions
9 patterns
Why logical functions enable decision-making
IF function
Nested IF functions
AND function
OR function
NOT function
IFS function (multiple conditions)
IFERROR for error handling
SWITCH function
02
Lookup Functions
8 patterns
Why lookups connect related data
VLOOKUP function
HLOOKUP function
INDEX function
MATCH function
INDEX-MATCH combination
XLOOKUP function
Approximate vs exact match
03
Text Functions
9 patterns
Why text manipulation cleans data
CONCATENATE and CONCAT
LEFT, RIGHT, MID extraction
LEN function
UPPER, LOWER, PROPER
TRIM and CLEAN
FIND and SEARCH
SUBSTITUTE and REPLACE
TEXT function for formatting
04
Date and Time Functions
8 patterns
Why date handling is common in business
TODAY and NOW functions
YEAR, MONTH, DAY extraction
DATE function construction
DATEDIF for date differences
EDATE and EOMONTH
WEEKDAY and WORKDAY
TEXT formatting for dates
05
Statistical and Math Functions
8 patterns
Why statistical functions summarize data
SUMIF and SUMIFS
COUNTIF and COUNTIFS
AVERAGEIF and AVERAGEIFS
LARGE and SMALL
RANK function
ROUND, ROUNDUP, ROUNDDOWN
ABS and MOD
06
Data Organization
8 patterns
Why structured data enables analysis
Tables (Insert Table) and benefits
Table references in formulas
Subtotals
Grouping and outlining
Custom sorting rules
Advanced filtering criteria
Consolidating data from multiple sheets
07
PivotTables Basics
8 patterns
Why PivotTables summarize large datasets
Creating a PivotTable
Row and column fields
Value fields and aggregation
Filtering PivotTable data
Refreshing PivotTable data
PivotTable layouts
Calculated fields
Advanced
Part 3: Advanced7 topics · 54 patterns
Advanced
01
Advanced Charts
8 patterns
Why advanced charts tell better stories
Combo charts
Sparklines
Scatter plots
Waterfall charts
Treemap and sunburst
Dynamic charts with data ranges
Chart templates
02
Advanced Formulas
8 patterns
Why advanced formulas solve complex problems
INDIRECT for dynamic references
OFFSET for dynamic ranges
Array formulas basics
Dynamic arrays (SORT, FILTER, UNIQUE)
SEQUENCE function
LET function for named calculations
LAMBDA for custom functions
03
Conditional Formatting Advanced
7 patterns
Why rules-based formatting highlights patterns
Color scales
Data bars
Icon sets
Formula-based rules
Managing multiple rules
Conditional formatting with dates
04
Data Analysis Tools
7 patterns
Why built-in tools accelerate analysis
Goal Seek
Scenario Manager
Data Tables (What-If)
Solver for optimization
Descriptive statistics (Analysis ToolPak)
Histogram and frequency analysis
05
Macros and VBA Basics
8 patterns
Why automation saves hours
Recording macros
Running macros
Macro security settings
VBA editor basics
Simple VBA procedures
Variables and loops in VBA
UserForm basics
06
Power Query
8 patterns
Why Power Query transforms messy data
Getting data from sources
Query Editor interface
Column transformations
Filtering and sorting in queries
Merging queries (joins)
Appending queries
Loading to worksheet or data model
07
Collaboration and Protection
8 patterns
Why protecting data prevents mistakes
Sheet protection
Workbook protection
Cell locking
Sharing workbooks
Track changes and comments
Excel on the web
Co-authoring in real time
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 161 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.
Excel

Ready to master Excel?
Start your journey today

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

20 Topics
161 Patterns
Personalized roadmap
Leyaa Swift Bird