Highline Excel 2013 Class Video 34

Excel Subtotals, Add Subtotals based on One or Two Columns

DESCRIPTION

Topics in this video:
1. Subtotals.
2. Alternatives to Subtotal: SUMIFS Formulas and PivotTables.
3. Sort First!!!!!!!!!!!!!!!
4. Add Subtotals based on One Column (Field).
5. Outline.
6. Copy and Paste Subtotal Report Trouble.
7. Select Visible Cells Only, then Copy and Paste Subtotal Report.
8. Go To dialog Box.
9. Select Visible Cells Only Keyboard: Alt + ;
10. Revert Subtotals back to original data set.
11. Add Subtotals based on Two Columns (Fields).

WORKBOOKS

Download “Highline Excel 2013 Workbooks” Highline-Excel-2013-Video-Workbooks.zip – Downloaded 169 times – 21 MB




Be the first to comment

Leave a Reply