How to use Nested SUBTOTALs in Excel?

preview_player
Показать описание
Lesson 4 of SUBTOTAL

In the last lesson we learned about inserting subtotals in a list of data, in a worksheet. What we discussed there was about inserting subtotals at one level of grouping.
Now in this lesson, let’s understand how to insert more than one level of subtotals or nested subtotals, in a list of data. This means, that you can insert subtotals for more than one nested inner groups within their corresponding groups at the outer levels.

-----
Other Lessons on SUBTOTAL:

1. Excel SUBTOTAL Function: Understand the Basics & Syntax

2. SUM Vs SUBTOTAL

3. Work with SUBTOTAL: How to Insert SUBTOTAL in a Data Range in a Worksheet

4. How to use Nested SUBTOTALS?

---------------
My Other videos:

10 ways to Auto Fill in Excel

9 Examples to Fast-track Data Entry in EXCEL using 'FLASH FILL'

20 Different Ways to PASTE your Data in EXCEL

All about PIVOT TABLE in EXCEL

Learn to TRANSPOSE your Data in Excel

All about CTRL+A to CTRL+Z Shortcuts in Excel

Master the Basics of VLOOKUP in EXCEL

Excel VLOOKUP - When to use Approximate or Exact match?

Handling Errors in VLOOKUP in EXCEL

E010-Excel Shortcuts F1 to F6

E011-Excel Shortcuts F7 to F9

E012-Excel Shortcuts F10 to F12

E013-Analyze Data Instantly using Quick Analysis Tool

E014-Conditional Formatting in Excel

E015(a) - Excel SUBTOTAL Function: Understand the Basics & Syntax

---------------------
My Other YouTube Channel in Tamil Language:
---------------------------
#Excel
#MicrosoftExcel
#MSExcel
#Spreadsheet
#Spreadsheets
#MSOffice
#Office
#Microsoft
#OfficeOnTheWeb
#Microsoft365
#Office365
#SUM
#SUBTOTAL
Рекомендации по теме