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 / Analysis

SUBTOTAL

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

12 min read • Advanced

excel-056.txt

excel

=SUBTOTAL(9,Invoices[Total])  # respects filtered-out rows

What to watch

Content source & attribution

Original Syntaxis Content · Original Syntaxis Content

Lesson quizzes

SUBTOTAL Mastery Check →