Highline Excel 2013 Class Video 34: Excel Subtotals, Add Subtotals based on One or Two Columns



Online Courses for microsoft excel :

Course updated 2013-11-15 02:09:23

Instructor : ExcelIsFun

Course Duration : 12:48

Rating : 4.92 / 5

Step by step & Descreption :
Download workbook:
This is the Highline Community College Class, Spreadsheet Construction taught by Michael Girvin: Basic To Advanced Excel.
Topics in this video:
1. Subtotals (00:11 min)
2. Alternatives to Subtotal: SUMIFS Formulas and PivotTables (00:45 and 04:13 min)
3. Sort First!!!!!!!!!!!!!!! (01:30 min)
4. Add Subtotals based on One Column (Field) (01:56 min)
5. Outline (03:12 min)
6. Copy and Paste Subtotal Report Trouble (05:18 min)
7. Select Visible Cells Only, then Copy and Paste Subtotal Report (05:57 min)
8. Go To dialog Box (06:43 min)
9. Select Visible Cells Only Keyboard: Alt + ; (07:11 min)
10. Revert Subtotals back to original data set (07:59 min)
11. Add Subtotals based on Two Columns (Fields) (08:32 min)
12.