Excel: Groups and Subtotals

preview_player
Показать описание

This video includes information on:
• Adding and editing headers, which appear in the top margin
• Adding and editing footers, which appear in the bottom margin
• Adding and editing page numbers to a document
• Restarting page numbering

We hope you enjoy!
  1. LearnFree
  2. Microsoft Excel (Software)
  3. Excel 2016
  4. Groups
  5. Subtotals
  6. MS Excel 2016
Рекомендации по теме
Excel: Groups and 0:04:24

Excel: Groups and Subtotals

Group and Outline 0:04:32

Group and Outline and Subtotal in Excel

Excel 2013: Groups 0:03:52

Excel 2013: Groups and Subtotals

Group Rows and 0:09:35

Group Rows and Columns in Excel With Expand & Collapse Buttons | Include Summary and Subtotals

How to Create 0:03:00

How to Create Automatic Subtotals in Excel | Nested (Multiple) Subtotals | Group Rows & Subtotal

Grouping Rows and 0:05:47

Grouping Rows and Columns in Excel

Excel Group Rows 0:03:36

Excel Group Rows and Sum Automatically - 3 methods (2020)

Excel Group & 0:06:45

Excel Group & Outline Buttons | Easiest way to Hide & Unhide Rows & Columns

Groups And Subtotals 0:02:37

Groups And Subtotals in Microsoft Excel Tutorial 2020

Excel: Data Subtotal 0:02:41

Excel: Data Subtotal & Grouping

Excel Groups and 0:04:11

Excel Groups and Subtotals

Subtotal & Groups 0:10:33

Subtotal & Groups in Excel | Nested Subtotal

19 Excel Groups 0:04:41

19 Excel Groups and Subtotals

Subtotals within Subtotals 0:01:38

Subtotals within Subtotals in Excel by Chris Menard

MS Excel 2013 0:02:59

MS Excel 2013 Lessons 19 Groups and Subtotals

How to Use 0:05:06

How to Use Excel Group Ungroup Subtotal in Hindi - MIS tutorial

09 Groups 0:04:40

09 Groups & Subtotals with Pivot Tables using Microsoft Excel

How to Sort 0:12:14

How to Sort and Subtotal in Excel

Excel - Grouping 0:02:57

Excel - Grouping Rows and Columns and Subtotals

Hide/Unhide Columns & 0:06:37

Hide/Unhide Columns & Rows FAST in Microsoft Excel | Groups & Subtotals | TutelaGeek

Calculating Subtotals in 0:03:54

Calculating Subtotals in Excel

Grouping in Excel 0:09:28

Grouping in Excel (Subtotals & Column & Row)

Multiple Level Sub-Total 0:05:54

Multiple Level Sub-Total in Excel

CIS-110 - Excel 0:00:39

CIS-110 - Excel - Groups & Subtotals

Комментарии
Автор

Excellent and to the point. I definitely plan on using this feature on data in the future. Thank you!

janicefranklin
Автор

Outstanding video! I conduct web-based learning for a living, and I think your delivery and pace are superb. The content was relevant and uncluttered. Well done!

jendotcohen
Автор

Thanks for making these videos, they are very helpful!

bethlectic
Автор

Excellent. So clearly explained you made it an effortless task. Thanks.

pauls
Автор

Very good tutorial for Excel Grouping and Subtotals. Thanks.

murshed
Автор

i want formula for adding the column figures and substracting the rows figure and the total must be same .

TriPletSTripplE
Автор

thanks for the Video, but I have an issue with the Third level Group. if I highlight the 3rd level for grouping it is not working as I need. I cannot explain it here but the idea is like this :

(A)in row then (ABCD 123) in Row, then (A.1-A1B1C1 123) in Row, then A.1.1-A12B12C12) in Row
(B) in Row then (ABCD 456) in Row, then (B.1-B1B1C1 456) in Row, then B.1.1-B12B12C12) in Row
(C) in Row then (ABCD 789) in Row, then (C.1-C1B1C1 789) in Row, then C.1.1-C12B12C12) in Row
I need A and B and C to appear First in group.
then (ABCD 123) and (ABCD 456) and (ABCD 789) in another Group.
then (A.1-A1B1C1 123) then (B.1-B1B1C1 456) then (C.1-C1B1C1 789) in another group.

How ?

AamerAli
Автор

I have a doubt regarding SUBTOTAL function. I have a data in which four columns are there namely Year (contains 2013, 2014, 2015, 2016), Region (Contains East, West, North, South), Shoe size (Contains 6, 7, 8, 9, 10) and Sales (In dollars).
I have used SUBTOTAL function to see the Year wise sales or Year wise Shoe size count. But I wanted to calculate Year wise count of Shoe sizes separately for each size. I hope you got my query. How to do this?

nileshpawar
Автор

Excellent video! I have my own YouYube channel tutorials. And you did a much better job than I did. Congrats.

floydjaywinters
Автор

WHY the "subtotal" button is NOT active with me ??? Please help

twolanguagesjourney
Автор

I'm getting my subtotals correctly, but it's not grouping them so that I can collapse/expand - ??

boorayin
Автор

did not say your grouped data to start

jimburford