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 / Pivot & Charts

PivotTable creation

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

12 min read • Advanced
excel-061.txt
excel 
Rows: Region
Columns: Status
Values: Sum of Total
Source: Excel Table Invoices
What to watch
Content source & attribution
Original Syntaxis Content · Original Syntaxis Content

Lesson quizzes

PivotTable creation Mastery Check →
← PREVIOUS
remove duplicates
NEXT →
PivotTable grouping