Learners will understand how SUBTOTAL differs from traditional summary functions like SUM or AVERAGE. They will apply multiple statistical functions within SUBTOTAL and use features like grouping, ungrouping, and nested SUBTOTALS to analyze data with expand/collapse views and hidden rows.

• Introduction to SUBTOTAL and how it differs from regular summary functions
• Practical use of AVERAGE, COUNT, MAX, MIN, PRODUCT, STDEV, VAR, and SUM with SUBTOTAL
• Advanced Subtotal: Nested functions, Grouping, Ungrouping, Show/Hide data