|
|
1. Add Quick Access To Custom Views.mp4
|
MP4
|
38.37 MB
|
|
|
1. Add Quick Access To Custom Views.vtt
|
VTT
|
4.26 KB
|
|
|
10. CONCATENATE Building Strings From Multiple Cells.mp4
|
MP4
|
71.08 MB
|
|
|
10. CONCATENATE Building Strings From Multiple Cells.vtt
|
VTT
|
5.78 KB
|
|
|
100. SUMIF For Selective Adding Up.mp4
|
MP4
|
72.61 MB
|
|
|
100. SUMIF For Selective Adding Up.vtt
|
VTT
|
7.05 KB
|
|
|
101. The CELL Function And Determining File Or Sheet Names.mp4
|
MP4
|
72.01 MB
|
|
|
101. The CELL Function And Determining File Or Sheet Names.vtt
|
VTT
|
9.57 KB
|
|
|
102. The CHOOSE Lookup Function.mp4
|
MP4
|
40.67 MB
|
|
|
102. The CHOOSE Lookup Function.vtt
|
VTT
|
3.83 KB
|
|
|
103. Use Of Outlining To Help Setup Custom Views.mp4
|
MP4
|
38.84 MB
|
|
|
103. Use Of Outlining To Help Setup Custom Views.vtt
|
VTT
|
4.76 KB
|
|
|
104. Useful Time And Date Functions.mp4
|
MP4
|
46.03 MB
|
|
|
104. Useful Time And Date Functions.vtt
|
VTT
|
5.35 KB
|
|
|
105. Using The Watch Window In Troubleshooting.mp4
|
MP4
|
50.33 MB
|
|
|
105. Using The Watch Window In Troubleshooting.vtt
|
VTT
|
4.71 KB
|
|
|
106. Working With Time In Excel.mp4
|
MP4
|
97.67 MB
|
|
|
106. Working With Time In Excel.vtt
|
VTT
|
12.29 KB
|
|
|
11. Conditional Evaluation With No IFs.mp4
|
MP4
|
76.19 MB
|
|
|
11. Conditional Evaluation With No IFs.vtt
|
VTT
|
8.54 KB
|
|
|
12. Controlling Grand Totals And Subtotals.mp4
|
MP4
|
56.58 MB
|
|
|
12. Controlling Grand Totals And Subtotals.vtt
|
VTT
|
6.46 KB
|
|
|
13. Creating A PivotChart.mp4
|
MP4
|
41.57 MB
|
|
|
13. Creating A PivotChart.vtt
|
VTT
|
4.59 KB
|
|
|
14. Creating A Sparkline.mp4
|
MP4
|
52.72 MB
|
|
|
14. Creating A Sparkline.vtt
|
VTT
|
5.81 KB
|
|
|
15. Creating And Using Calculated Fields.mp4
|
MP4
|
46.59 MB
|
|
|
15. Creating And Using Calculated Fields.vtt
|
VTT
|
4.93 KB
|
|
|
16. Creating Multiple PivotTables On The Same Dataset.mp4
|
MP4
|
60.47 MB
|
|
|
16. Creating Multiple PivotTables On The Same Dataset.vtt
|
VTT
|
5.99 KB
|
|
|
17. Creating Your Own PivotTable Styles.mp4
|
MP4
|
61.34 MB
|
|
|
17. Creating Your Own PivotTable Styles.vtt
|
VTT
|
5.37 KB
|
|
|
18. Custom Views Explained.mp4
|
MP4
|
32.06 MB
|
|
|
18. Custom Views Explained.vtt
|
VTT
|
3.65 KB
|
|
|
19. Dealing With Empty Cells.mp4
|
MP4
|
25.84 MB
|
|
|
19. Dealing With Empty Cells.vtt
|
VTT
|
3.08 KB
|
|
|
2. Adding And Removing Tracer Arrows.mp4
|
MP4
|
34.59 MB
|
|
|
2. Adding And Removing Tracer Arrows.vtt
|
VTT
|
4.06 KB
|
|
|
20. Dealing With Missing Data In A Lookup.mp4
|
MP4
|
52.02 MB
|
|
|
20. Dealing With Missing Data In A Lookup.vtt
|
VTT
|
5.8 KB
|
|
|
21. Display Cell Formulas In Another Cell.mp4
|
MP4
|
44.21 MB
|
|
|
21. Display Cell Formulas In Another Cell.vtt
|
VTT
|
4.71 KB
|
|
|
22. Displaying And Editing The Different Scenarios.mp4
|
MP4
|
35.99 MB
|
|
|
22. Displaying And Editing The Different Scenarios.vtt
|
VTT
|
4 KB
|
|
|
23. Drilling Down Behind The Pivot Numbers.mp4
|
MP4
|
36.48 MB
|
|
|
23. Drilling Down Behind The Pivot Numbers.vtt
|
VTT
|
3.5 KB
|
|
|
24. Editing And Deleting Custom Views.mp4
|
MP4
|
43.21 MB
|
|
|
24. Editing And Deleting Custom Views.vtt
|
VTT
|
5.11 KB
|
|
|
25. Error Checking Using ISERR, ISERROR, And IFERROR.mp4
|
MP4
|
64.52 MB
|
|
|
25. Error Checking Using ISERR, ISERROR, And IFERROR.vtt
|
VTT
|
7.88 KB
|
|
|
26. Filtering A PivotChart.mp4
|
MP4
|
39.61 MB
|
|
|
26. Filtering A PivotChart.vtt
|
VTT
|
4.96 KB
|
|
|
27. Formatting Numeric And Date Values Using TEXT.mp4
|
MP4
|
63.98 MB
|
|
|
27. Formatting Numeric And Date Values Using TEXT.vtt
|
VTT
|
5.67 KB
|
|
|
28. Formatting The PivotChart.mp4
|
MP4
|
66.25 MB
|
|
|
28. Formatting The PivotChart.vtt
|
VTT
|
6.97 KB
|
|
|
29. Generate And Use A Random Number.mp4
|
MP4
|
53.24 MB
|
|
|
29. Generate And Use A Random Number.vtt
|
VTT
|
6.56 KB
|
|
|
3. Adding And Using The Data Slicer.mp4
|
MP4
|
70.67 MB
|
|
|
3. Adding And Using The Data Slicer.vtt
|
VTT
|
7.19 KB
|
|
|
30. Handling Out Of Range Index Requests.mp4
|
MP4
|
36.8 MB
|
|
|
30. Handling Out Of Range Index Requests.vtt
|
VTT
|
3.83 KB
|
|
|
31. How To Work Out Which Scenario You Are Displaying.mp4
|
MP4
|
47.91 MB
|
|
|
31. How To Work Out Which Scenario You Are Displaying.vtt
|
VTT
|
4.59 KB
|
|
|
32. Introducing IS Functions.mp4
|
MP4
|
33.28 MB
|
|
|
32. Introducing IS Functions.vtt
|
VTT
|
3.93 KB
|
|
|
33. Keeping The Values Created By String Manipulation.mp4
|
MP4
|
42.72 MB
|
|
|
33. Keeping The Values Created By String Manipulation.vtt
|
VTT
|
4.04 KB
|
|
|
34. LEFT And RIGHT Text Manipulation.mp4
|
MP4
|
59.76 MB
|
|
|
34. LEFT And RIGHT Text Manipulation.vtt
|
VTT
|
5 KB
|
|
|
35. Loan And Investment Calculations.mp4
|
MP4
|
55.86 MB
|
|
|
35. Loan And Investment Calculations.vtt
|
VTT
|
7.14 KB
|
|
|
36. Managing The External Connection To SQL Server.mp4
|
MP4
|
32.86 MB
|
|
|
36. Managing The External Connection To SQL Server.vtt
|
VTT
|
3.85 KB
|
|
|
37. Managing The Lookup Table.mp4
|
MP4
|
58.42 MB
|
|
|
37. Managing The Lookup Table.vtt
|
VTT
|
5.76 KB
|
|
|
38. Multiple Fields In Row, Column, Or Data Sections.mp4
|
MP4
|
62.36 MB
|
|
|
38. Multiple Fields In Row, Column, Or Data Sections.vtt
|
VTT
|
6.26 KB
|
|
|
39. Nesting The IF Statement.mp4
|
MP4
|
69.8 MB
|
|
|
39. Nesting The IF Statement.vtt
|
VTT
|
8.18 KB
|
|
|
4. Altering The Design Of Sparklines.mp4
|
MP4
|
46.57 MB
|
|
|
4. Altering The Design Of Sparklines.vtt
|
VTT
|
5.64 KB
|
|
|
40. OFFSET Function Creating A Dynamic Named Range.mp4
|
MP4
|
58.72 MB
|
|
|
40. OFFSET Function Creating A Dynamic Named Range.vtt
|
VTT
|
5.85 KB
|
|
|
41. OFFSET Function Syntax.mp4
|
MP4
|
43.43 MB
|
|
|
41. OFFSET Function Syntax.vtt
|
VTT
|
4.8 KB
|
|
|
42. Producing A Summary Of Scenarios.mp4
|
MP4
|
42.74 MB
|
|
|
42. Producing A Summary Of Scenarios.vtt
|
VTT
|
4.81 KB
|
|
|
43. Refreshing A PivotTable.mp4
|
MP4
|
35.88 MB
|
|
|
43. Refreshing A PivotTable.vtt
|
VTT
|
3.36 KB
|
|
|
44. Removing Sparklines From A Worksheet.mp4
|
MP4
|
22.45 MB
|
|
|
44. Removing Sparklines From A Worksheet.vtt
|
VTT
|
2.8 KB
|
|
|
45. REPLACE And SUBSTITUTE Two More String Manipulation Functions.mp4
|
MP4
|
63.74 MB
|
|
|
45. REPLACE And SUBSTITUTE Two More String Manipulation Functions.vtt
|
VTT
|
5.46 KB
|
|
|
46. Rounding Decimal Places.mp4
|
MP4
|
43.72 MB
|
|
|
46. Rounding Decimal Places.vtt
|
VTT
|
5.62 KB
|
|
|
47. The Array-Only TRANSPOSE Function.mp4
|
MP4
|
58.6 MB
|
|
|
47. The Array-Only TRANSPOSE Function.vtt
|
VTT
|
7.46 KB
|
|
|
48. The Basic SUM, COUNT, MIN, And MAX.mp4
|
MP4
|
45.47 MB
|
|
|
48. The Basic SUM, COUNT, MIN, And MAX.vtt
|
VTT
|
4.11 KB
|
|
|
49. The New Recommended PivotTable Route.mp4
|
MP4
|
57.69 MB
|
|
|
49. The New Recommended PivotTable Route.vtt
|
VTT
|
5.83 KB
|
|
|
5. Array Formulas With IF Statements.mp4
|
MP4
|
64.62 MB
|
|
|
5. Array Formulas With IF Statements.vtt
|
VTT
|
5.53 KB
|
|
|
50. The NOT Operator Within AND And OR Statements.mp4
|
MP4
|
43.06 MB
|
|
|
50. The NOT Operator Within AND And OR Statements.vtt
|
VTT
|
4.68 KB
|
|
|
51. Use Of CHAR Function For More Obscure Characters.mp4
|
MP4
|
70.59 MB
|
|
|
51. Use Of CHAR Function For More Obscure Characters.vtt
|
VTT
|
6.71 KB
|
|
|
52. Use Of The AND Operator Within An IF.mp4
|
MP4
|
62.25 MB
|
|
|
52. Use Of The AND Operator Within An IF.vtt
|
VTT
|
6.7 KB
|
|
|
53. Use Of The OR Operator Within An IF.mp4
|
MP4
|
39.67 MB
|
|
|
53. Use Of The OR Operator Within An IF.vtt
|
VTT
|
4.21 KB
|
|
|
54. Using A Near Match In The Lookup.mp4
|
MP4
|
36.84 MB
|
|
|
54. Using A Near Match In The Lookup.vtt
|
VTT
|
4.05 KB
|
|
|
55. Using Data From An SQL Server In A PivotTable.mp4
|
MP4
|
50 MB
|
|
|
55. Using Data From An SQL Server In A PivotTable.vtt
|
VTT
|
5.71 KB
|
|
|
56. Using Solver To Complete A What-If.mp4
|
MP4
|
54.9 MB
|
|
|
56. Using Solver To Complete A What-If.vtt
|
VTT
|
6.92 KB
|
|
|
57. Using The MATCH Function.mp4
|
MP4
|
78.41 MB
|
|
|
57. Using The MATCH Function.vtt
|
VTT
|
8.31 KB
|
|
|
58. Using The New Timeline Filter Option.mp4
|
MP4
|
52.93 MB
|
|
|
58. Using The New Timeline Filter Option.vtt
|
VTT
|
5.63 KB
|
|
|
59. VLOOKUP In Live Action.mp4
|
MP4
|
65.62 MB
|
|
|
59. VLOOKUP In Live Action.vtt
|
VTT
|
6.93 KB
|
|
|
6. Calculations Using Time.mp4
|
MP4
|
42.86 MB
|
|
|
6. Calculations Using Time.vtt
|
VTT
|
4.47 KB
|
|
|
60. VLOOKUP Syntax And Usage.mp4
|
MP4
|
46.77 MB
|
|
|
60. VLOOKUP Syntax And Usage.vtt
|
VTT
|
5.47 KB
|
|
|
61. What Are Tracer Arrows.mp4
|
MP4
|
50.35 MB
|
|
|
61. What Are Tracer Arrows.vtt
|
VTT
|
5.67 KB
|
|
|
62. What Is A PivotTable.mp4
|
MP4
|
54.12 MB
|
|
|
62. What Is A PivotTable.vtt
|
VTT
|
5.43 KB
|
|
|
63. What-If Analysis Using Goal Seek.mp4
|
MP4
|
40.43 MB
|
|
|
63. What-If Analysis Using Goal Seek.vtt
|
VTT
|
4.72 KB
|
|
|
64. Activating The Solver Add-In.mp4
|
MP4
|
18.1 MB
|
|
|
64. Activating The Solver Add-In.vtt
|
VTT
|
2.27 KB
|
|
|
65. Adding An Outline Manually.mp4
|
MP4
|
37.06 MB
|
|
|
65. Adding An Outline Manually.vtt
|
VTT
|
3.73 KB
|
|
|
66. Adding Constraints To Solver.mp4
|
MP4
|
41.3 MB
|
|
|
66. Adding Constraints To Solver.vtt
|
VTT
|
4.51 KB
|
|
|
67. Area And Volume Calculations.mp4
|
MP4
|
36.79 MB
|
|
|
67. Area And Volume Calculations.vtt
|
VTT
|
4.5 KB
|
|
|
68. Arrays And Creating A New Array Formula.mp4
|
MP4
|
50.87 MB
|
|
|
68. Arrays And Creating A New Array Formula.vtt
|
VTT
|
6.08 KB
|
|
|
69. Auditing Tools Error Checking And Tracing.mp4
|
MP4
|
65.73 MB
|
|
|
69. Auditing Tools Error Checking And Tracing.vtt
|
VTT
|
8.28 KB
|
|
|
7. Changing Case Functions.mp4
|
MP4
|
51.53 MB
|
|
|
7. Changing Case Functions.vtt
|
VTT
|
4.71 KB
|
|
|
70. AVERAGE, MODE, MEAN, And MEDIAN.mp4
|
MP4
|
39.59 MB
|
|
|
70. AVERAGE, MODE, MEAN, And MEDIAN.vtt
|
VTT
|
4.4 KB
|
|
|
71. AVERAGEIF For The Mean Of Selected Cells.mp4
|
MP4
|
38.91 MB
|
|
|
71. AVERAGEIF For The Mean Of Selected Cells.vtt
|
VTT
|
3.78 KB
|
|
|
72. Changing The Fields Used In A PivotChart.mp4
|
MP4
|
43.91 MB
|
|
|
72. Changing The Fields Used In A PivotChart.vtt
|
VTT
|
6.16 KB
|
|
|
73. Changing The PivotChart Type.mp4
|
MP4
|
44.99 MB
|
|
|
73. Changing The PivotChart Type.vtt
|
VTT
|
4.91 KB
|
|
|
74. COUNTIF For Selective Counting.mp4
|
MP4
|
37.82 MB
|
|
|
74. COUNTIF For Selective Counting.vtt
|
VTT
|
3.24 KB
|
|
|
75. Create An Outline Automatically.mp4
|
MP4
|
39.31 MB
|
|
|
75. Create An Outline Automatically.vtt
|
VTT
|
4.71 KB
|
|
|
76. Creating Your Own PivotTables.mp4
|
MP4
|
70.06 MB
|
|
|
76. Creating Your Own PivotTables.vtt
|
VTT
|
8.02 KB
|
|
|
77. Dealing With Empty Cells And Other Additional Options.mp4
|
MP4
|
61.95 MB
|
|
|
77. Dealing With Empty Cells And Other Additional Options.vtt
|
VTT
|
6.4 KB
|
|
|
78. Dealing With INDIRECT Errors.mp4
|
MP4
|
38.94 MB
|
|
|
78. Dealing With INDIRECT Errors.vtt
|
VTT
|
4.09 KB
|
|
|
79. Editing And Removing Outlining.mp4
|
MP4
|
75.5 MB
|
|
|
79. Editing And Removing Outlining.vtt
|
VTT
|
7.88 KB
|
|
|
8. Changing The Formatting And Formulas In PivotTable Summaries.mp4
|
MP4
|
52.7 MB
|
|
|
8. Changing The Formatting And Formulas In PivotTable Summaries.vtt
|
VTT
|
4.72 KB
|
|
|
80. FIND And MID Text Functions Working Together.mp4
|
MP4
|
89.03 MB
|
|
|
80. FIND And MID Text Functions Working Together.vtt
|
VTT
|
8.31 KB
|
|
|
81. Hiding The PivotChart Buttons.mp4
|
MP4
|
21.54 MB
|
|
|
81. Hiding The PivotChart Buttons.vtt
|
VTT
|
2.95 KB
|
|
|
82. HLOOKUP Variation On A Theme.mp4
|
MP4
|
53.91 MB
|
|
|
82. HLOOKUP Variation On A Theme.vtt
|
VTT
|
4.68 KB
|
|
|
83. How The INDEX Function Works.mp4
|
MP4
|
57.91 MB
|
|
|
83. How The INDEX Function Works.vtt
|
VTT
|
6.13 KB
|
|
|
84. IF Syntax And Uses.mp4
|
MP4
|
71.12 MB
|
|
|
84. IF Syntax And Uses.vtt
|
VTT
|
9.31 KB
|
|
|
85. INDIRECT Function To Build Dynamic Formulas.mp4
|
MP4
|
47.78 MB
|
|
|
85. INDIRECT Function To Build Dynamic Formulas.vtt
|
VTT
|
4.64 KB
|
|
|
86. LEN And TRIM String Extractions.mp4
|
MP4
|
79.57 MB
|
|
|
86. LEN And TRIM String Extractions.vtt
|
VTT
|
7.74 KB
|
|
|
87. Loan Calculation Elements And Functions.mp4
|
MP4
|
39.9 MB
|
|
|
87. Loan Calculation Elements And Functions.vtt
|
VTT
|
5.08 KB
|
|
|
88. Lookups Nested Within Lookups.mp4
|
MP4
|
70.61 MB
|
|
|
88. Lookups Nested Within Lookups.vtt
|
VTT
|
7.2 KB
|
|
|
89. Making Use Of The Report Filter Options.mp4
|
MP4
|
55.61 MB
|
|
|
89. Making Use Of The Report Filter Options.vtt
|
VTT
|
6.47 KB
|
|
|
9. Comparing Sparklines Within A Sparkline Group.mp4
|
MP4
|
44.3 MB
|
|
|
9. Comparing Sparklines Within A Sparkline Group.vtt
|
VTT
|
5.61 KB
|
|
|
90. MATCH And INDEX Functions Working Together.mp4
|
MP4
|
58.71 MB
|
|
|
90. MATCH And INDEX Functions Working Together.vtt
|
VTT
|
5.57 KB
|
|
|
91. Merging And Deleting Scenarios.mp4
|
MP4
|
42.02 MB
|
|
|
91. Merging And Deleting Scenarios.vtt
|
VTT
|
4.7 KB
|
|
|
92. MOD And INT Functions And Uses.mp4
|
MP4
|
46.43 MB
|
|
|
92. MOD And INT Functions And Uses.vtt
|
VTT
|
5.64 KB
|
|
|
93. Moving And Deleting PivotCharts.mp4
|
MP4
|
50.33 MB
|
|
|
93. Moving And Deleting PivotCharts.vtt
|
VTT
|
5.88 KB
|
|
|
94. Moving And Deleting PivotTables.mp4
|
MP4
|
44.4 MB
|
|
|
94. Moving And Deleting PivotTables.vtt
|
VTT
|
4.93 KB
|
|
|
95. Multiple Criteria Within SUMIF, COUNTIF, And AVERAGEIF.mp4
|
MP4
|
80.29 MB
|
|
|
95. Multiple Criteria Within SUMIF, COUNTIF, And AVERAGEIF.vtt
|
VTT
|
7.81 KB
|
|
|
96. PivotTable Styles.mp4
|
MP4
|
71.77 MB
|
|
|
96. PivotTable Styles.vtt
|
VTT
|
6.67 KB
|
|
|
97. Setting Up A Set Of Scenarios.mp4
|
MP4
|
79.71 MB
|
|
|
97. Setting Up A Set Of Scenarios.vtt
|
VTT
|
8.16 KB
|
|
|
98. Sorting The PivotTable Columns.mp4
|
MP4
|
62.43 MB
|
|
|
98. Sorting The PivotTable Columns.vtt
|
VTT
|
6.02 KB
|
|
|
99. Step-By-Step Formula Processing.mp4
|
MP4
|
40.82 MB
|
|
|
99. Step-By-Step Formula Processing.vtt
|
VTT
|
4.4 KB
|