Master programming syntax, solve interactive challenges & run live code in Syntaxis Explore Arena →
menu_book Course Curriculum (Excel Fundamentals) expand_more
Workbook Basics
workbooks and worksheets cells and ranges relative references absolute references mixed references named ranges tables structured references freeze panes data types
Core Formulas
SUM AVERAGE MIN and MAX COUNT and COUNTA ROUND IF IFS AND and OR IFERROR LET
Text Functions
CONCAT TEXTJOIN LEFT RIGHT MID LEN TRIM SUBSTITUTE TEXT VALUE
Lookup Functions
XLOOKUP VLOOKUP HLOOKUP INDEX MATCH INDEX MATCH XMATCH FILTER SORT UNIQUE
Date & Time
TODAY NOW DATE YEAR MONTH DAY EDATE EOMONTH WORKDAY NETWORKDAYS DATEDIF date formatting
Analysis
SUMIF SUMIFS COUNTIF COUNTIFS AVERAGEIF SUBTOTAL AGGREGATE conditional formatting data validation remove duplicates
Pivot & Charts
PivotTable creation PivotTable grouping calculated fields slicers PivotChart column chart line chart scatter chart chart secondary axis sparklines
Modern & Advanced
dynamic arrays spill ranges SEQUENCE TAKE DROP CHOOSECOLS TEXTSPLIT Power Query import Goal Seek formula auditing
Excel Fundamentals / Workbook Basics

workbooks and worksheets

Learn workbooks and worksheets in Excel Fundamentals with a dedicated explanation, a topic-specific example, edge guidance, and a mastery check.

12 min read • Beginner
excel-001.txt
excel 
Workbook: Billing.xlsx
Sheets: Invoices | Customers | Dashboard
# Separate raw data, lookup data, and presentation.
What to watch
Content source & attribution
Original Syntaxis Content · Original Syntaxis Content

Lesson quizzes

workbooks and worksheets Mastery Check →
NEXT →
cells and ranges