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