How To: Use Excel data analysis subtotals

Use Excel data analysis subtotals

How to Use Excel data analysis subtotals

1. The following instruction describes how to generate sub totals in Microsoft Excel Sheet. 2. Take Region as a Primary column and Sales Rep as a Secondary Column. 3. First method to sort: Select a cell in Region and goto Data select A to Z. 4. Second method to sort: Select a cell in Region and Right click and select Sort A to Z 5. Then click a cell in Region and select Data->OutLine->SubTotal 6. In the SubTotal Window select 1.Each Change in: Region 2.Use function:Sum 3.Add subTotal to:Sales 4.Click Ok 7. Click on the grouping feature 2 to look at the Region Subtotal 8. Then click a cell in Sales Rep and select Data->OutLine->SubTotal 9. In the SubTotal Window select 1.Each Change in: Sales Rep 2.Use function:Sum 3.Add subTotal to:Sales 4.Uncheck Replace current subtotal 4.Click Ok 10. Click on the grouping feature 4 to look at the Region cum SalesRep SubTotal Subtotal 11. To copy the SubTotal Cells to another Sheet follow the Below Steps. 12. Method 1: 13. HighLight Subtotal Cells. 14. Press F5 And Click Special in GoTo Window and select visible cell only. 15. Method 2: 16. HighLight Subtotal Cells. 17. In Home-> Find Button Click Go to Special and select visible cell only. 18. Method 3: 19. HighLight Subtotal Cells. 20. Press Ctrl+Semicolon. 21. After using any one method, copy the Cells and Paste in a new Sheet.

1 Comment

i have a test tomorrow . it was helpful, thank you.

Share Your Thoughts

  • Hot
  • Latest