SUBTOTAL: The Excel Function You Didn’t Know You Needed!

SUBTOTAL function in Excel full tutorial. 👉 Take our Excel Course: https://www.careerprinciples.com/courses/excel-for-business-finance 🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/bwpubfpfau The SUBTOTAL function in Excel is a better alternative to functions like SUM, AVERAGE, and MIN, which can return incorrect results when working with filtered data, hidden formulas, or hidden rows. Unlike SUM, which ignores filters, SUBTOTAL dynamically adjusts to display only visible data. It offers 11 built-in functions, with additional options (101-111) that account for hidden rows. When working with tables, Excel’s Total Row feature automatically uses SUBTOTAL for accurate calculations. SUBTOTAL also has a feature under the data ribbon, in outline, which enables automatic grouping of data, making it easy to generate subtotals and grand totals without duplication errors. Additionally, the AGGREGATE function extends SUBTOTAL’s capabilities, offering 19 functions and the ability to ignore errors, hidden rows, or other specific conditions. LEARN: 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance 📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course 🔥 Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics 🚀 All our courses: https://www.careerprinciples.com/all-courses ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00​ -​ SUBTOTAL vs SUM 2:45​ - Using Tables 3:34​ - Totals Row 4:06 - Function Number: 101-111 5:18​ - Secret Subtotal Feature 8:13​ - Grand Total 9:11​ - Bonus Function