filmov
tv
How to use Nested SUBTOTALs in Excel?
Показать описание
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
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