Before you begin
Unit 1 - Managing workbooks and worksheets
-
Topic A1: Freezing rows and columns and hiding (2:51)
-
Topic A2: Moving around a worksheet (3:06)
-
Topic A3: Summing up time (1:37)
-
Topic A4: Convert decimals to time (2:29)
-
Topic B1: Printing large worksheets (2:53)
-
Topic B2: Landscape printing (3:12)
-
Topic B3: Printing problems (2:44)
-
Topic B4: Printing headers and footers and gridlines (3:21)
-
Topic C1: 3D reference #1 (2:15)
-
Topic C2: Status bar calculations and Autofit (2:49)
-
Topic D1: 3D reference #2 and autofill options (2:58)
-
Topic E1: Linking and using workbooks (4:03)
Unit 2: Advanced formatting
-
Topic A: Using special number formats - leading zeros (2:53)
-
Topic B: Getting started with Countif (2:53)
-
Topic C: Accounting vs Currency / Percentages and Countif (3:04)
-
Topic D: Countif with Absolute reference (2:11)
-
Topic E: Entering text correctly and T function in Excel (3:41)
-
Topic F: Accounting - comma - indents and percentages with absolute ref. (2:38)
-
Topic G: Transpose Data (1:22)
-
Topic H: Hide zero values (1:03)
Unit 3: Outlining and subtotals
Unit 5 A: Sorting Data
-
Topic A: Right click and two ranges (3:32)
-
Topic B: Sorting by multiple columns (2:08)
-
Topic C: Sorting by fill color and font color (2:21)
-
Topic D: Creating a custom list for sorting (3:46)
-
Topic E: Fix data before sorting (4:14)
-
Topic F: Sort left to right and transpose (2:04)
-
Topic G: Sorting review (2:36)
Unit 5 B: Filtering Data
Unit 7: Documenting and auditing
