1 Keyboards 0:32
2 Jump: Ctrl + Arrow 0:15
3 Go To Cell A1: Ctrl + Home 1:03
4 Format Cells dialog box or in a chart Format Chart dialog box: Ctrl + 1 0:27
5 Currency Number Format: Ctrl + Shift + 4 0:11
6 Highlight column: Ctrl + Shift + Arrow 0:39
7 Currency Vs Accounting Number Format 0:46
8 Alt keys:
9 PivotTable: Alt, N, V, T
10 PivotTable 2003: Alt, D, P
11 Page Setup: Alt, P, S, P
12 SUM: Alt + = 0:56
13 "Put thing in cell and move selected cell up": Shift + Enter
14 "Put thing in cell and keep cell selected": Ctrl + Enter
15 Select sheet to right: Ctrl + PageDown
16 Select sheet to left: Ctrl + PageUp
17 Number Formatting As Façade: 0:45
18 Decimal Number Format 1:17
19 Date Number Format
20 Keyboard for today's hard caded date:
21 Time Number Format 4:14
22 Percentage Number Format 3:35
23 Efficient Formula Creation
24 Excel's Golden Rule: If a formula input can vary, put it in a cell and refer to it in the formula with a cell reference
25 Formula elements, types of formulas, types of data
26 Monthly Allocation Formula: illustrate formula input that can be hard coded into formula 0:34
27 Tax inefficient formula: illustrate formula input that can should NOT hard coded into formula
28 Tax efficient formula: illustrate Golden Rule
29 Net Cash In formula: illustrate Golden Rule
30 Net Income formula: illustrate formula with built-in function within a larger formula 0:39
31 In Balance? formula: illustrate Logical formula 1:13
32 First & Last Name Join Formula: illustrate Text formula 1:34
33 COUNTIF formula: illustrate counting with criteria 0:49
34 COUNTIF & Label formula: illustrate counting with criteria and how the join symbol is used with criteria 1:30
35 Clear Formatting 0:30
36 SUMIFS to add with two criteria 1:46
37 SUMIFS to add between 2 dates 3:37
38 Count workdays formula to illustrate new Excel 2010 function NETWORKDAYS.INTL
39 Relative and Absolute Cell References
40 Mixed cell references in budget formula 5:51
41 Lookup Formulas
42 VLOOKUP to lookup product price: illustrate Exact Match lookup
43 Data Validation List: 2:02
44 VLOOKUP and IFERROR 1:31
45 VLOOKUP to lookup commission rate: illustrate Approximate Match lookup 3:07
46 Retrieve record 2-way lookup with VLOOKUP and MATCH 3:44
47 MATCH, ISNA and ISNUMBER functions to compare 2 lists 3:21
48 INDEX and MATCH to lookup Left 3:01
49 Pivot Tables
50 Proper Data Set
51 PivotTables Pivot Tables are Easy
52 Visualize Table First
53 Adding with One or Two Conditions Criteria
54 Report Layout 0:45
55 Number Formatting 1:20
56 Style Formatting, Create Your Own 2:15
57 Pivoting
58 Listing Two Fields in Row Labels
59 Collapsing Pivot Table Row 0:42
60 Changing Calculation: SUM to AVERAGE 0:46
61 Adding with Three Criteria 1:16
62 Filtering a Row Show Top Two Regions, Clear Filter 1:08
63 Filter whole report with Report Filter 1:59
64 Show Report Filter Pages 30 PivotTables with 1 click 0:34
65 Filter whole report with Report Filter or Slicer 1:42
66 Compare Formulas and PivotTables 3:28
67 Grouping Dates in PivotTables 1:58
68 Difference between Grouping Integers and Grouping Decimals 3:18
69 Pivot Chart 1:44
70 Show Values As: 0:57
71 Copy PivotTable 0:16
72 Running Totals & % Running Totals 1:00
73 % of Grand Totals, % of Column Total, % of Row Total 1:15
74 Difference From, % Difference From 2:08
75 Multiple Calculation in one PivotTable 1:27
76 Creating Second PivotTable from Second Cache of data using Excel 2003 keyboard shortcut for 3-step Wizard 1:35
77 Blank in number field causes PivotTable to Count by Default 0:38
78 Text in Date field prohibits Grouping of Dates 0:55
79 Basic Recorded Macro 4:04
80 Absolute References and save in Personal Workbook 5:40
81 How to trick the Macro Recorder into seeing a variable height report using Relative References 8:09
82 Rearrange records from vertical orientation to proper table using Relative References 4:33
83 Charts
84 Chart Types
85 Column Chart and How The Chart Wizard Interprets Data From Cells 0:21
86 Chart keyboards Create Default Chart 2:19
87 Select Data Source Dialog Box 2:38
88 Linking Chart Title to Cells 2:33
89 Saving Chart Templates 1:04
90 Setting Default Charts 0:56
91 Copy Charts 0:11
92 Bar and Stacked Bar charts 3:41
93 Line Chart & Change Source Data 3:12
94 Number Formatting to show "K" or "M" 1:00
95 Line Chart vs. X Y Chart 0:51
96 X Y Scatter 4:42
97 X Y Scatter Line Break Even Analysis Chart 1:13
98 Multiple chart types