Udemy Full Microsoft Excel Course With Formulas VBA | 9101C27ED979C346A316226FDBD10077EC73B096

Udemy Full Microsoft Excel Course With Formulas VBA

Name	[Udemy] Full Microsoft Excel Course With Formulas & VBA	DOWNLOAD Copy Link
Total Size	25.2 GB
Total Files	920
Hash	9101C27ED979C346A316226FDBD10077EC73B096

/.../1. Excel Advanced Tutorial - Welcome To Excel World/
1. Accessing Ribbon Commands With The Keyboard_(new).mp4	46.4 MB
1. Accessing Ribbon Commands With The Keyboard_(new).vtt	6.4 KB
10. Creating A Table_(new).mp4	42.1 MB
10. Creating A Table_(new).vtt	4.0 KB
100. Paper Size, Orientation, Margins, And Scaling Options.mp4	91.5 MB
100. Paper Size, Orientation, Margins, And Scaling Options.vtt	9.0 KB
101. Password Protecting The Whole Workbook.mp4	45.1 MB
101. Password Protecting The Whole Workbook.vtt	6.1 KB
102. Printing A Range Of Cells.mp4	26.6 MB
102. Printing A Range Of Cells.vtt	3.0 KB
103. Protecting Part Of A Worksheet To Aid Data Entry.mp4	32.0 MB
103. Protecting Part Of A Worksheet To Aid Data Entry.vtt	4.2 KB
104. Removing Duplicate Entries In The Data.mp4	36.5 MB
104. Removing Duplicate Entries In The Data.vtt	3.0 KB
105. Renaming Copying And Moving Worksheets.mp4	38.1 MB
105. Renaming Copying And Moving Worksheets.vtt	5.7 KB
106. Running The Spell Checker.mp4	62.7 MB
106. Running The Spell Checker.vtt	6.0 KB
107. Saving And Opening SkyDrive Files.mp4	19.2 MB
107. Saving And Opening SkyDrive Files.vtt	3.0 KB
108. Searching For Values In A Workbook.mp4	43.3 MB
108. Searching For Values In A Workbook.vtt	3.9 KB
109. Selecting Cells For Formatting.mp4	24.8 MB
109. Selecting Cells For Formatting.vtt	3.7 KB
11. Creating And Managing A Pick List_(new).mp4	72.6 MB
11. Creating And Managing A Pick List_(new).vtt	5.8 KB
110. Sorting Data In Excel.mp4	89.2 MB
110. Sorting Data In Excel.vtt	7.9 KB
111. Text Manipulation Using Functions.mp4	81.9 MB
111. Text Manipulation Using Functions.vtt	6.8 KB
112. The Fill Handle.mp4	64.8 MB
112. The Fill Handle.vtt	8.5 KB
113. The Format Painter.mp4	36.9 MB
113. The Format Painter.vtt	5.0 KB
114. The New Recommended Charts Option.mp4	49.1 MB
114. The New Recommended Charts Option.vtt	5.3 KB
115. The Pie Chart In Detail.mp4	94.4 MB
115. The Pie Chart In Detail.vtt	8.8 KB
116. The Stacking Order.mp4	53.3 MB
116. The Stacking Order.vtt	6.6 KB
117. The Sum Function.mp4	74.2 MB
117. The Sum Function.vtt	8.5 KB
118. Undo And Redo Actions.mp4	24.5 MB
118. Undo And Redo Actions.vtt	3.7 KB
119. Use Of Rank To Calculate Placings.mp4	44.5 MB
119. Use Of Rank To Calculate Placings.vtt	5.9 KB
12. Creating And Using Custom Views_(new).mp4	86.4 MB
12. Creating And Using Custom Views_(new).vtt	6.3 KB
120. Use Of The If Function To Hide Excel Error Messages.mp4	36.6 MB
120. Use Of The If Function To Hide Excel Error Messages.vtt	6.1 KB
121. Use The Text Function To Format Numbers.mp4	51.9 MB
121. Use The Text Function To Format Numbers.vtt	4.7 KB
122. Useful Count Functions.mp4	29.4 MB
122. Useful Count Functions.vtt	4.0 KB
123. Using An If Formula.mp4	52.6 MB
123. Using An If Formula.vtt	6.7 KB
124. Using Graphical Objects And Mathematical Formulas.mp4	36.7 MB
124. Using Graphical Objects And Mathematical Formulas.vtt	4.4 KB
125. Using Number Formats.mp4	56.3 MB
125. Using Number Formats.vtt	8.1 KB
126. Using Print Titles And Print Areas.mp4	76.6 MB
126. Using Print Titles And Print Areas.vtt	7.6 KB
127. Using SmartArt Graphics.mp4	61.9 MB
127. Using SmartArt Graphics.vtt	7.3 KB
128. Using Text To Columns Effectively.mp4	60.6 MB
128. Using Text To Columns Effectively.vtt	6.5 KB
129. Using The Templates.mp4	42.6 MB
129. Using The Templates.vtt	5.0 KB
13. Ctrl Keyboard Shortcuts_(new).mp4	98.0 MB
13. Ctrl Keyboard Shortcuts_(new).vtt	11.2 KB
130. Using The Page Break And The Page Layout Views.mp4	74.2 MB
130. Using The Page Break And The Page Layout Views.vtt	6.2 KB
131. Using Top And Bottom Rules For Formatting.mp4	37.5 MB
131. Using Top And Bottom Rules For Formatting.vtt	4.5 KB
132. Viewing And Scrolling Multiple Workbooks At The Same Time.mp4	44.7 MB
132. Viewing And Scrolling Multiple Workbooks At The Same Time.vtt	4.6 KB
133. Worksheet Navigation And Coloured Worksheet Tabs.mp4	44.6 MB
133. Worksheet Navigation And Coloured Worksheet Tabs.vtt	6.0 KB
14. Customize The Ribbons And Quick Access Toolbar_(new).mp4	63.3 MB
14. Customize The Ribbons And Quick Access Toolbar_(new).vtt	8.9 KB
15. Displaying File Path, File Name And Sheet Name_(new).mp4	65.6 MB
15. Displaying File Path, File Name And Sheet Name_(new).vtt	6.5 KB
16. Displaying The Formula In Use Formula Text_(new).mp4	34.6 MB
16. Displaying The Formula In Use Formula Text_(new).vtt	5.2 KB
17. Drilling Down Into Pivot Table Data_(new).mp4	62.9 MB
17. Drilling Down Into Pivot Table Data_(new).vtt	6.0 KB
18. Flash Fill In Action - Completing Data Columns_(new).mp4	79.5 MB
18. Flash Fill In Action - Completing Data Columns_(new).vtt	6.8 KB
19. How To Enter Numbers And Retain The Leading Zero_(new).mp4	38.7 MB
19. How To Enter Numbers And Retain The Leading Zero_(new).vtt	5.4 KB
2. Activating And Deactivating Interface Options.mp4	52.4 MB
2. Activating And Deactivating Interface Options.vtt	6.8 KB
20. Inserting The Date And Time As Static Or Dynamic_(new).mp4	38.1 MB
20. Inserting The Date And Time As Static Or Dynamic_(new).vtt	5.5 KB
21. Managing Cells With Large Text Content_(new).mp4	88.3 MB
21. Managing Cells With Large Text Content_(new).vtt	7.4 KB
22. Moving Swiftly Between Workbooks And Worksheets_(new).mp4	52.8 MB
22. Moving Swiftly Between Workbooks And Worksheets_(new).vtt	6.1 KB
23. Multiple Sheet Data Entry And Sheet Management_(new).mp4	57.3 MB
23. Multiple Sheet Data Entry And Sheet Management_(new).vtt	6.9 KB
24. Recommended And Quick Creation Charts_(new).mp4	49.4 MB
24. Recommended And Quick Creation Charts_(new).vtt	5.1 KB
25. Recommended Pivot Tables_(new).mp4	72.3 MB
25. Recommended Pivot Tables_(new).vtt	6.0 KB
26. Reference A Pivot Table Value In A Formula_(new).mp4	51.1 MB
26. Reference A Pivot Table Value In A Formula_(new).vtt	6.4 KB
27. Removing Duplicate Values_(new).mp4	51.0 MB
27. Removing Duplicate Values_(new).vtt	4.1 KB
28. Separate Worksheets From A Single Pivot Table_(new).mp4	55.2 MB
28. Separate Worksheets From A Single Pivot Table_(new).vtt	5.5 KB
29. Summarizing Data Using A Sparkline_(new).mp4	71.2 MB
29. Summarizing Data Using A Sparkline_(new).vtt	8.4 KB
3. Adding Comments To Formulas_(new).mp4	35.1 MB
3. Adding Comments To Formulas_(new).vtt	5.0 KB
30. Table Styles Of Your Own_(new).mp4	62.1 MB
30. Table Styles Of Your Own_(new).vtt	5.8 KB
31. Testing What Ifs With Goal Seek_(new).mp4	48.8 MB
31. Testing What Ifs With Goal Seek_(new).vtt	7.2 KB
32. Time Difference And Duration Particularly Over 24 Hours_(new).mp4	59.7 MB
32. Time Difference And Duration Particularly Over 24 Hours_(new).vtt	9.1 KB
33. Use Scenarios To Experiment With Different Values_(new).mp4	69.4 MB
33. Use Scenarios To Experiment With Different Values_(new).vtt	7.3 KB
34. Use Watch To Keep An Eye On A Cell Value_(new).mp4	57.0 MB
34. Use Watch To Keep An Eye On A Cell Value_(new).vtt	6.0 KB
35. Using The Fill Handle For Quick Data Patterns_(new).mp4	63.7 MB
35. Using The Fill Handle For Quick Data Patterns_(new).vtt	7.7 KB
36. Work Out Mortgage Repayments_(new).mp4	56.7 MB
36. Work Out Mortgage Repayments_(new).vtt	7.7 KB
37. 3D Referencing.mp4	69.5 MB
37. 3D Referencing.vtt	9.9 KB
38. Absolute Referencing Explained.mp4	76.8 MB
38. Absolute Referencing Explained.vtt	8.9 KB
39. Activating And Deactivating Worksheet Protection.mp4	40.9 MB
39. Activating And Deactivating Worksheet Protection.vtt	5.2 KB
4. Adding Formulas To Text Boxes_(new).mp4	50.6 MB
4. Adding Formulas To Text Boxes_(new).vtt	5.2 KB
40. Adding A Trendline.mp4	26.7 MB
40. Adding A Trendline.vtt	3.9 KB
41. Adding And Removing Borders From A Selection.mp4	43.9 MB
41. Adding And Removing Borders From A Selection.vtt	6.0 KB
42. Adding And Removing Worksheets.mp4	24.3 MB
42. Adding And Removing Worksheets.vtt	4.1 KB
43. Adding Subtotals To A Worksheet Of Data.mp4	68.9 MB
43. Adding Subtotals To A Worksheet Of Data.vtt	6.2 KB
44. Adding, Editing, And Deleting Comments.mp4	36.5 MB
44. Adding, Editing, And Deleting Comments.vtt	4.5 KB
45. Altering Cell Appearance Based On The Cell Value.mp4	42.2 MB
45. Altering Cell Appearance Based On The Cell Value.vtt	4.9 KB
46. Applying A Date Format To A Cell Or Range.mp4	52.5 MB
46. Applying A Date Format To A Cell Or Range.vtt	4.6 KB
47. Cell Content Alignment And Orientation.mp4	33.9 MB
47. Cell Content Alignment And Orientation.vtt	4.9 KB
48. Changing Column Widths And Row Heights.mp4	39.1 MB
48. Changing Column Widths And Row Heights.vtt	5.8 KB
49. Clearing Cell Contents Vs. Clearing Cell Formatting.mp4	50.4 MB
49. Clearing Cell Contents Vs. Clearing Cell Formatting.vtt	7.0 KB
5. Adding Hyperlinks To Excel Objects_(new).mp4	44.1 MB
5. Adding Hyperlinks To Excel Objects_(new).vtt	5.5 KB
50. Controlling Most Print Settings In One Place.mp4	62.4 MB
50. Controlling Most Print Settings In One Place.vtt	7.5 KB
51. Converting Data To A Table For Formatting.mp4	58.3 MB
51. Converting Data To A Table For Formatting.vtt	7.3 KB
52. Copying Formulas And Functions Chapter 4.mp4	54.1 MB
52. Copying Formulas And Functions Chapter 4.vtt	5.8 KB
53. Copying Formulas And Functions Chapter 8.mp4	64.9 MB
53. Copying Formulas And Functions Chapter 8.vtt	8.9 KB
54. Create A Chart Using The Long Or The Short Method.mp4	39.3 MB
54. Create A Chart Using The Long Or The Short Method.vtt	4.3 KB
55. Creating A Formatting Rule From Scratch.mp4	45.1 MB
55. Creating A Formatting Rule From Scratch.vtt	4.5 KB
56. Creating And Saving A New Workbook.mp4	22.8 MB
56. Creating And Saving A New Workbook.vtt	4.4 KB
57. Creating And Using Your Own Template.mp4	41.6 MB
57. Creating And Using Your Own Template.vtt	5.7 KB
58. Creating Headers and Footers.mp4	80.7 MB
58. Creating Headers and Footers.vtt	7.8 KB
59. Creating Your Own Autofill List.mp4	48.6 MB
59. Creating Your Own Autofill List.vtt	5.1 KB
6. Controlling Pages On Printing_(new).mp4	76.8 MB
6. Controlling Pages On Printing_(new).vtt	7.4 KB
60. Cut, Copy, And Paste.mp4	37.9 MB
60. Cut, Copy, And Paste.vtt	6.1 KB
61. Date Manipulation Functions.mp4	52.5 MB
61. Date Manipulation Functions.vtt	4.2 KB
62. Datedif A Useful But Hidden Formula.mp4	61.9 MB
62. Datedif A Useful But Hidden Formula.vtt	6.0 KB
63. Displaying Data Bars, Color Scales, Or Icon Sets.mp4	39.8 MB
63. Displaying Data Bars, Color Scales, Or Icon Sets.vtt	4.5 KB
64. Displaying Formulas On A Worksheet.mp4	50.5 MB
64. Displaying Formulas On A Worksheet.vtt	5.3 KB
65. Dragging And Dropping Cells.mp4	22.2 MB
65. Dragging And Dropping Cells.vtt	3.7 KB
66. Editing The Contents Of A Cell.mp4	22.8 MB
66. Editing The Contents Of A Cell.vtt	3.6 KB
67. Enhancing Worksheets Using Themes.mp4	50.0 MB
67. Enhancing Worksheets Using Themes.vtt	5.5 KB
68. Entering Numbers As Text.mp4	24.7 MB
68. Entering Numbers As Text.vtt	4.9 KB
69. Entering Text, Numbers, And Dates.mp4	24.6 MB
69. Entering Text, Numbers, And Dates.vtt	4.7 KB
7. Controlling The Quantity Of Worksheets_(new).mp4	29.1 MB
7. Controlling The Quantity Of Worksheets_(new).vtt	4.5 KB
70. Filtering Data To Reduce Dataset Size.mp4	91.5 MB
70. Filtering Data To Reduce Dataset Size.vtt	7.7 KB
71. Finding And Replacing Formats.mp4	75.9 MB
71. Finding And Replacing Formats.vtt	8.3 KB
72. Fixing On Screen Rows And Columns.mp4	87.1 MB
72. Fixing On Screen Rows And Columns.vtt	7.3 KB
73. Fixing Print Rows And Columns.mp4	37.0 MB
73. Fixing Print Rows And Columns.vtt	3.9 KB
74. Formatting A Chart With The 2013 Shortcut Options.mp4	38.1 MB
74. Formatting A Chart With The 2013 Shortcut Options.vtt	4.3 KB
75. Formatting Chart Elements.mp4	57.5 MB
75. Formatting Chart Elements.vtt	5.8 KB
76. Formatting Graphical Objects.mp4	73.3 MB
76. Formatting Graphical Objects.vtt	6.7 KB
77. Formulas Across Worksheets.mp4	69.5 MB
77. Formulas Across Worksheets.vtt	8.5 KB
78. Getting Started With Basic Math Formulas.mp4	41.2 MB
78. Getting Started With Basic Math Formulas.vtt	6.3 KB
79. Grouping Multiple Objects Together.mp4	46.7 MB
79. Grouping Multiple Objects Together.vtt	6.5 KB
8. Create A Chart With A Single Key_(new).mp4	46.3 MB
8. Create A Chart With A Single Key_(new).vtt	6.4 KB
80. Hiding And Un Hiding Columns And Rows.mp4	50.7 MB
80. Hiding And Un Hiding Columns And Rows.vtt	4.2 KB
81. Hiding And Un Hiding Sheets.mp4	26.3 MB
81. Hiding And Un Hiding Sheets.vtt	3.3 KB
82. Inserting And Deleting Cells Columns And Rows.mp4	36.4 MB
82. Inserting And Deleting Cells Columns And Rows.vtt	4.6 KB
83. Inserting Shapes And Screenshots.mp4	48.3 MB
83. Inserting Shapes And Screenshots.vtt	7.1 KB
84. Introducing Sumif, Countif, And Averageif.mp4	81.2 MB
84. Introducing Sumif, Countif, And Averageif.vtt	8.1 KB
85. Introduction To Basic Formulas.mp4	50.4 MB
85. Introduction To Basic Formulas.vtt	6.7 KB
86. Linking To Data On A Webpage.mp4	47.3 MB
86. Linking To Data On A Webpage.vtt	5.2 KB
87. Making Use Of Named Cells And Ranges.mp4	81.2 MB
87. Making Use Of Named Cells And Ranges.vtt	10.2 KB
88. Managing The Conditional Formatting Rules.mp4	50.8 MB
88. Managing The Conditional Formatting Rules.vtt	5.5 KB
89. Merging And Wrapping Cell Contents.mp4	51.6 MB
89. Merging And Wrapping Cell Contents.vtt	8.1 KB
9. Create Your Own Fill Handle Lists_(new).mp4	61.7 MB
9. Create Your Own Fill Handle Lists_(new).vtt	9.4 KB
90. Mini Graphs Sparklines.mp4	62.1 MB
90. Mini Graphs Sparklines.vtt	7.2 KB
91. Modifying More Than One Worksheet At A Time.mp4	50.5 MB
91. Modifying More Than One Worksheet At A Time.vtt	6.0 KB
92. Modifying The Chart Type.mp4	41.4 MB
92. Modifying The Chart Type.vtt	4.9 KB
93. Modifying Typeface Font, Size, And Colour.mp4	48.2 MB
93. Modifying Typeface Font, Size, And Colour.vtt	7.2 KB
94. Moving Or Copying Worksheets Within And Between Workbooks.mp4	34.0 MB
94. Moving Or Copying Worksheets Within And Between Workbooks.vtt	4.7 KB
95. Navigating An Excel Workbook.mp4	41.7 MB
95. Navigating An Excel Workbook.vtt	5.3 KB
96. Obtaining And Inserting Online Images.mp4	51.9 MB
96. Obtaining And Inserting Online Images.vtt	5.3 KB
97. Opening Workbooks And Save As Options.mp4	24.9 MB
97. Opening Workbooks And Save As Options.vtt	4.3 KB
98. Order Of Operation With BODMAS.mp4	34.5 MB
98. Order Of Operation With BODMAS.vtt	4.6 KB
99. Other Mathematical Functions Average, Min, And Max.mp4	70.8 MB
99. Other Mathematical Functions Average, Min, And Max.vtt	7.6 KB
/.../2. Excel Shortcut Guide/
1. Accessing Ribbon Commands With The Keyboard_(new).mp4	46.3 MB
1. Accessing Ribbon Commands With The Keyboard_(new).vtt	6.2 KB
10. Creating A Table_(new).mp4	42.1 MB
10. Creating A Table_(new).vtt	4.0 KB
11. Creating And Managing A Pick List_(new).mp4	72.6 MB
11. Creating And Managing A Pick List_(new).vtt	5.8 KB
12. Creating And Using Custom Views_(new).mp4	86.4 MB
12. Creating And Using Custom Views_(new).vtt	6.3 KB
13. Ctrl Keyboard Shortcuts_(new).mp4	98.1 MB
13. Ctrl Keyboard Shortcuts_(new).vtt	11.2 KB
14. Customize The Ribbons And Quick Access Toolbar_(new).mp4	63.4 MB
14. Customize The Ribbons And Quick Access Toolbar_(new).vtt	8.9 KB
15. Displaying File Path, File Name And Sheet Name_(new).mp4	65.6 MB
15. Displaying File Path, File Name And Sheet Name_(new).vtt	6.5 KB
16. Displaying The Formula In Use Formula Text_(new).mp4	34.7 MB
16. Displaying The Formula In Use Formula Text_(new).vtt	5.2 KB
17. Drilling Down Into Pivot Table Data_(new).mp4	62.9 MB
17. Drilling Down Into Pivot Table Data_(new).vtt	6.0 KB
18. Flash Fill In Action - Completing Data Columns_(new).mp4	79.5 MB
18. Flash Fill In Action - Completing Data Columns_(new).vtt	6.8 KB
19. How To Enter Numbers And Retain The Leading Zero_(new).mp4	38.7 MB
19. How To Enter Numbers And Retain The Leading Zero_(new).vtt	5.4 KB
2. Activating And Deactivating Interface Options_(new).mp4	52.3 MB
2. Activating And Deactivating Interface Options_(new).vtt	6.8 KB
20. Inserting The Date And Time As Static Or Dynamic_(new).mp4	38.1 MB
20. Inserting The Date And Time As Static Or Dynamic_(new).vtt	5.5 KB
21. Managing Cells With Large Text Content_(new).mp4	88.3 MB
21. Managing Cells With Large Text Content_(new).vtt	7.4 KB
22. Moving Swiftly Between Workbooks And Worksheets_(new).mp4	52.8 MB
22. Moving Swiftly Between Workbooks And Worksheets_(new).vtt	6.1 KB
23. Multiple Sheet Data Entry And Sheet Management_(new).mp4	57.3 MB
23. Multiple Sheet Data Entry And Sheet Management_(new).vtt	6.9 KB
24. Recommended And Quick Creation Charts_(new).mp4	49.5 MB
24. Recommended And Quick Creation Charts_(new).vtt	5.1 KB
25. Recommended Pivot Tables_(new).mp4	72.4 MB
25. Recommended Pivot Tables_(new).vtt	6.0 KB
26. Reference A Pivot Table Value In A Formula_(new).mp4	51.0 MB
26. Reference A Pivot Table Value In A Formula_(new).vtt	6.4 KB
27. Removing Duplicate Values_(new).mp4	51.0 MB
27. Removing Duplicate Values_(new).vtt	4.1 KB
28. Separate Worksheets From A Single Pivot Table_(new).mp4	55.2 MB
28. Separate Worksheets From A Single Pivot Table_(new).vtt	5.5 KB
29. Summarizing Data Using A Sparkline_(new).mp4	71.2 MB
29. Summarizing Data Using A Sparkline_(new).vtt	8.4 KB
3. Adding Comments To Formulas_(new).mp4	35.1 MB
3. Adding Comments To Formulas_(new).vtt	5.0 KB
30. Table Styles Of Your Own_(new).mp4	62.1 MB
30. Table Styles Of Your Own_(new).vtt	5.8 KB
31. Testing What Ifs With Goal Seek_(new).mp4	48.9 MB
31. Testing What Ifs With Goal Seek_(new).vtt	7.2 KB
32. Time Difference And Duration Particularly Over 24 Hours_(new).mp4	59.8 MB
32. Time Difference And Duration Particularly Over 24 Hours_(new).vtt	9.1 KB
33. Use Scenarios To Experiment With Different Values_(new).mp4	69.4 MB
33. Use Scenarios To Experiment With Different Values_(new).vtt	7.3 KB
34. Use Watch To Keep An Eye On A Cell Value_(new).mp4	57.0 MB
34. Use Watch To Keep An Eye On A Cell Value_(new).vtt	6.0 KB
35. Using The Fill Handle For Quick Data Patterns_(new).mp4	63.7 MB
35. Using The Fill Handle For Quick Data Patterns_(new).vtt	7.7 KB
36. Work Out Mortgage Repayments_(new).mp4	56.8 MB
36. Work Out Mortgage Repayments_(new).vtt	7.7 KB
4. Adding Formulas To Text Boxes_(new).mp4	50.6 MB
4. Adding Formulas To Text Boxes_(new).vtt	5.2 KB
5. Adding Hyperlinks To Excel Objects_(new).mp4	44.1 MB
5. Adding Hyperlinks To Excel Objects_(new).vtt	5.5 KB
6. Controlling Pages On Printing_(new).mp4	76.7 MB
6. Controlling Pages On Printing_(new).vtt	7.4 KB
7. Controlling The Quantity Of Worksheets_(new).mp4	29.1 MB
7. Controlling The Quantity Of Worksheets_(new).vtt	4.5 KB
8. Create A Chart With A Single Key_(new).mp4	46.4 MB
8. Create A Chart With A Single Key_(new).vtt	6.4 KB
9. Create Your Own Fill Handle Lists_(new).mp4	61.6 MB
9. Create Your Own Fill Handle Lists_(new).vtt	9.4 KB
/.../3. Advanced Formulas And Functions/
1. 3D Referencing.mp4	106.7 MB
1. 3D Referencing.vtt	10.6 KB
10. EDate And EOMonth.mp4	50.7 MB
10. EDate And EOMonth.vtt	5.7 KB
11. Extracting Data With Left, Right And Mid.mp4	83.0 MB
11. Extracting Data With Left, Right And Mid.vtt	7.2 KB
12. Extracting Information With Cell And Info Functions.mp4	71.3 MB
12. Extracting Information With Cell And Info Functions.vtt	10.0 KB
13. Flipping Rows Or Columns With Transpose.mp4	32.1 MB
13. Flipping Rows Or Columns With Transpose.vtt	4.7 KB
14. Full Absolute Referencing.mp4	44.7 MB
14. Full Absolute Referencing.vtt	6.3 KB
15. Function Processing Order.mp4	103.6 MB
15. Function Processing Order.vtt	10.0 KB
16. How Does Excel Deal With Dates And Time.mp4	51.9 MB
16. How Does Excel Deal With Dates And Time.vtt	7.1 KB
17. Int And Mod For Integer And Remainder Values.mp4	38.2 MB
17. Int And Mod For Integer And Remainder Values.vtt	5.1 KB
18. Locating Data With Find, Search, Exact.mp4	107.4 MB
18. Locating Data With Find, Search, Exact.vtt	8.9 KB
19. MRound, Ceiling, And Floor For Rounding Also.mp4	47.8 MB
19. MRound, Ceiling, And Floor For Rounding Also.vtt	6.7 KB
2. A Choice Of Count Functions.mp4	54.9 MB
2. A Choice Of Count Functions.vtt	6.2 KB
20. Multiple Criteria With CountIfs, SumIfs, And AverageIfs.mp4	85.4 MB
20. Multiple Criteria With CountIfs, SumIfs, And AverageIfs.vtt	6.5 KB
21. Naming Cells To Improve Formula Appearance.mp4	84.6 MB
21. Naming Cells To Improve Formula Appearance.vtt	7.4 KB
22. Nearest Match With VLookup.mp4	63.9 MB
22. Nearest Match With VLookup.vtt	7.8 KB
23. Nested Lookup Functions.mp4	53.4 MB
23. Nested Lookup Functions.vtt	5.7 KB
24. Password Generating Workbooks.mp4	50.6 MB
24. Password Generating Workbooks.vtt	7.3 KB
25. Ranking Data Without Sorting.mp4	48.7 MB
25. Ranking Data Without Sorting.vtt	6.0 KB
26. Referencing Entire RowsColumns.mp4	61.6 MB
26. Referencing Entire RowsColumns.vtt	5.2 KB
27. The Middle Value With Median.mp4	45.5 MB
27. The Middle Value With Median.vtt	6.4 KB
28. The New IsFormula Function And FormulaText.mp4	35.6 MB
28. The New IsFormula Function And FormulaText.vtt	4.5 KB
29. Use An Array Formula To Count Unique Entries.mp4	48.4 MB
29. Use An Array Formula To Count Unique Entries.vtt	6.1 KB
3. Changing The Case Of Text Using Proper, Upper, And Lower.mp4	54.4 MB
3. Changing The Case Of Text Using Proper, Upper, And Lower.vtt	4.1 KB
30. Use Offset To Obtain Data From Related Cells.mp4	72.6 MB
30. Use Offset To Obtain Data From Related Cells.vtt	10.1 KB
31. Use Trim And Clean To Remove Unwanted Gaps.mp4	53.6 MB
31. Use Trim And Clean To Remove Unwanted Gaps.vtt	6.4 KB
32. Using IsBlank, IsOdd, IsEven, IsText, And IsNumber.mp4	36.8 MB
32. Using IsBlank, IsOdd, IsEven, IsText, And IsNumber.vtt	5.4 KB
33. Varying Rounding Functions.mp4	69.5 MB
33. Varying Rounding Functions.vtt	9.6 KB
34. What Day Of The Week Is It.mp4	65.0 MB
34. What Day Of The Week Is It.vtt	5.1 KB
35. What Is An Array Formula.mp4	72.9 MB
35. What Is An Array Formula.vtt	10.1 KB
36. When Is A Formula A Function.mp4	36.0 MB
36. When Is A Formula A Function.vtt	5.1 KB
37. Generating Random Numbers And Values In Excel.mp4	55.9 MB
37. Generating Random Numbers And Values In Excel.vtt	6.2 KB
38. Index And Match Functions For Retrieving Data.mp4	105.1 MB
38. Index And Match Functions For Retrieving Data.vtt	9.2 KB
39. IsErr, IsError, IfError, IsNA, And IfNA For Error Checking.mp4	64.2 MB
39. IsErr, IsError, IfError, IsNA, And IfNA For Error Checking.vtt	9.2 KB
4. Choose And Match Functions For Locating Data.mp4	58.2 MB
4. Choose And Match Functions For Locating Data.vtt	6.1 KB
40. Large And Small For Retrieving Biggest And Smallest Values.mp4	62.3 MB
40. Large And Small For Retrieving Biggest And Smallest Values.vtt	5.3 KB
41. Replace And Substitute In Action.mp4	47.9 MB
41. Replace And Substitute In Action.vtt	6.1 KB
42. The If Logical Test.mp4	66.0 MB
42. The If Logical Test.vtt	9.9 KB
43. Accessing Unknown Function Syntax Within Excel.mp4	74.1 MB
43. Accessing Unknown Function Syntax Within Excel.vtt	9.4 KB
44. Combine Data From Different Cells.mp4	90.8 MB
44. Combine Data From Different Cells.vtt	7.4 KB
45. DateValue And TimeValue Functions.mp4	81.7 MB
45. DateValue And TimeValue Functions.vtt	9.2 KB
46. Format Number Content Within Strings With Text.mp4	82.1 MB
46. Format Number Content Within Strings With Text.vtt	6.4 KB
47. HLookup.mp4	46.8 MB
47. HLookup.vtt	4.4 KB
48. InDirect And Its Uses.mp4	64.1 MB
48. InDirect And Its Uses.vtt	9.1 KB
49. Looking Up Information With VLookup.mp4	95.2 MB
49. Looking Up Information With VLookup.vtt	10.1 KB
5. Convert Formulas To Values In A Split Second.mp4	60.3 MB
5. Convert Formulas To Values In A Split Second.vtt	5.2 KB
50. Making Only Part Absolute Formula.mp4	58.7 MB
50. Making Only Part Absolute Formula.vtt	7.0 KB
51. Nested If Statements.mp4	36.5 MB
51. Nested If Statements.vtt	4.7 KB
52. Sum And Count Syntax.mp4	77.4 MB
52. Sum And Count Syntax.vtt	7.3 KB
53. Using The And, Or, And Not Functions Within If.mp4	73.9 MB
53. Using The And, Or, And Not Functions Within If.vtt	8.3 KB
54. Using Today And Now Functions.mp4	29.9 MB
54. Using Today And Now Functions.vtt	3.9 KB
6. CountIf, SumIf, And AverageIf.mp4	129.3 MB
6. CountIf, SumIf, And AverageIf.vtt	11.1 KB
7. DatedIf For Time Differences.mp4	75.0 MB
7. DatedIf For Time Differences.vtt	8.7 KB
8. Difference Between Network Days And Work Day.mp4	70.7 MB
8. Difference Between Network Days And Work Day.vtt	8.6 KB
9. Display Different Number Types With Roman And Arabic.mp4	51.5 MB
9. Display Different Number Types With Roman And Arabic.vtt	5.5 KB
/.../4. Advanced Microsoft Excel/
1. Add Quick Access To Custom Views.mp4	40.2 MB
1. Add Quick Access To Custom Views.vtt	4.4 KB
10. CONCATENATE Building Strings From Multiple Cells.mp4	74.5 MB
10. CONCATENATE Building Strings From Multiple Cells.vtt	5.9 KB
100. SUMIF For Selective Adding Up.mp4	76.1 MB
100. SUMIF For Selective Adding Up.vtt	7.2 KB
101. The CELL Function And Determining File Or Sheet Names.mp4	75.5 MB
101. The CELL Function And Determining File Or Sheet Names.vtt	9.8 KB
102. The CHOOSE Lookup Function.mp4	42.6 MB
102. The CHOOSE Lookup Function.vtt	3.9 KB
103. Use Of Outlining To Help Setup Custom Views.mp4	40.7 MB
103. Use Of Outlining To Help Setup Custom Views.vtt	4.9 KB
104. Useful Time And Date Functions.mp4	48.3 MB
104. Useful Time And Date Functions.vtt	5.5 KB
105. Using The Watch Window In Troubleshooting.mp4	52.8 MB
105. Using The Watch Window In Troubleshooting.vtt	4.8 KB
106. Working With Time In Excel.mp4	102.4 MB
106. Working With Time In Excel.vtt	12.6 KB
11. Conditional Evaluation With No IFs.mp4	79.9 MB
11. Conditional Evaluation With No IFs.vtt	8.7 KB
12. Controlling Grand Totals And Subtotals.mp4	59.3 MB
12. Controlling Grand Totals And Subtotals.vtt	6.6 KB
13. Creating A PivotChart.mp4	43.6 MB
13. Creating A PivotChart.vtt	4.7 KB
14. Creating A Sparkline.mp4	55.3 MB
14. Creating A Sparkline.vtt	6.0 KB
15. Creating And Using Calculated Fields.mp4	48.9 MB
15. Creating And Using Calculated Fields.vtt	5.1 KB
16. Creating Multiple PivotTables On The Same Dataset.mp4	63.4 MB
16. Creating Multiple PivotTables On The Same Dataset.vtt	6.1 KB
17. Creating Your Own PivotTable Styles.mp4	64.3 MB
17. Creating Your Own PivotTable Styles.vtt	5.5 KB
18. Custom Views Explained.mp4	33.6 MB
18. Custom Views Explained.vtt	3.7 KB
19. Dealing With Empty Cells.mp4	27.1 MB
19. Dealing With Empty Cells.vtt	3.2 KB
2. Adding And Removing Tracer Arrows.mp4	36.3 MB
2. Adding And Removing Tracer Arrows.vtt	4.2 KB
20. Dealing With Missing Data In A Lookup.mp4	54.5 MB
20. Dealing With Missing Data In A Lookup.vtt	5.9 KB
21. Display Cell Formulas In Another Cell.mp4	46.4 MB
21. Display Cell Formulas In Another Cell.vtt	4.8 KB
22. Displaying And Editing The Different Scenarios.mp4	37.7 MB
22. Displaying And Editing The Different Scenarios.vtt	4.1 KB
23. Drilling Down Behind The Pivot Numbers.mp4	38.3 MB
23. Drilling Down Behind The Pivot Numbers.vtt	3.6 KB
24. Editing And Deleting Custom Views.mp4	45.3 MB
24. Editing And Deleting Custom Views.vtt	5.2 KB
25. Error Checking Using ISERR, ISERROR, And IFERROR.mp4	67.7 MB
25. Error Checking Using ISERR, ISERROR, And IFERROR.vtt	8.1 KB
26. Filtering A PivotChart.mp4	41.5 MB
26. Filtering A PivotChart.vtt	5.1 KB
27. Formatting Numeric And Date Values Using TEXT.mp4	67.1 MB
27. Formatting Numeric And Date Values Using TEXT.vtt	5.8 KB
28. Formatting The PivotChart.mp4	69.5 MB
28. Formatting The PivotChart.vtt	7.1 KB
29. Generate And Use A Random Number.mp4	55.8 MB
29. Generate And Use A Random Number.vtt	6.7 KB
3. Adding And Using The Data Slicer.mp4	74.1 MB
3. Adding And Using The Data Slicer.vtt	7.4 KB
30. Handling Out Of Range Index Requests.mp4	38.6 MB
30. Handling Out Of Range Index Requests.vtt	3.9 KB
31. How To Work Out Which Scenario You Are Displaying.mp4	50.2 MB
31. How To Work Out Which Scenario You Are Displaying.vtt	4.7 KB
32. Introducing IS Functions.mp4	34.9 MB
32. Introducing IS Functions.vtt	4.0 KB
33. Keeping The Values Created By String Manipulation.mp4	44.8 MB
33. Keeping The Values Created By String Manipulation.vtt	4.1 KB
34. LEFT And RIGHT Text Manipulation.mp4	62.7 MB
34. LEFT And RIGHT Text Manipulation.vtt	5.1 KB
35. Loan And Investment Calculations.mp4	58.6 MB
35. Loan And Investment Calculations.vtt	7.3 KB
36. Managing The External Connection To SQL Server.mp4	34.5 MB
36. Managing The External Connection To SQL Server.vtt	3.9 KB
37. Managing The Lookup Table.mp4	61.3 MB
37. Managing The Lookup Table.vtt	5.9 KB
38. Multiple Fields In Row, Column, Or Data Sections.mp4	65.4 MB
38. Multiple Fields In Row, Column, Or Data Sections.vtt	6.4 KB
39. Nesting The IF Statement.mp4	73.2 MB
39. Nesting The IF Statement.vtt	8.4 KB
4. Altering The Design Of Sparklines.mp4	48.8 MB
4. Altering The Design Of Sparklines.vtt	5.8 KB
40. OFFSET Function Creating A Dynamic Named Range.mp4	61.6 MB
40. OFFSET Function Creating A Dynamic Named Range.vtt	6.0 KB
41. OFFSET Function Syntax.mp4	45.5 MB
41. OFFSET Function Syntax.vtt	4.9 KB
42. Producing A Summary Of Scenarios.mp4	44.8 MB
42. Producing A Summary Of Scenarios.vtt	4.9 KB
43. Refreshing A PivotTable.mp4	37.6 MB
43. Refreshing A PivotTable.vtt	3.4 KB
44. Removing Sparklines From A Worksheet.mp4	23.5 MB
44. Removing Sparklines From A Worksheet.vtt	2.9 KB
45. REPLACE And SUBSTITUTE Two More String Manipulation Functions.mp4	66.8 MB
45. REPLACE And SUBSTITUTE Two More String Manipulation Functions.vtt	5.6 KB
46. Rounding Decimal Places.mp4	45.8 MB
46. Rounding Decimal Places.vtt	5.8 KB
47. The Array-Only TRANSPOSE Function.mp4	61.5 MB
47. The Array-Only TRANSPOSE Function.vtt	7.6 KB
48. The Basic SUM, COUNT, MIN, And MAX.mp4	47.7 MB
48. The Basic SUM, COUNT, MIN, And MAX.vtt	4.2 KB
49. The New Recommended PivotTable Route.mp4	60.5 MB
49. The New Recommended PivotTable Route.vtt	6.0 KB
5. Array Formulas With IF Statements.mp4	67.8 MB
5. Array Formulas With IF Statements.vtt	5.7 KB
50. The NOT Operator Within AND And OR Statements.mp4	45.1 MB
50. The NOT Operator Within AND And OR Statements.vtt	4.8 KB
51. Use Of CHAR Function For More Obscure Characters.mp4	74.0 MB
51. Use Of CHAR Function For More Obscure Characters.vtt	6.9 KB
52. Use Of The AND Operator Within An IF.mp4	65.3 MB
52. Use Of The AND Operator Within An IF.vtt	6.9 KB
53. Use Of The OR Operator Within An IF.mp4	41.6 MB
53. Use Of The OR Operator Within An IF.vtt	4.3 KB
54. Using A Near Match In The Lookup.mp4	38.6 MB
54. Using A Near Match In The Lookup.vtt	4.2 KB
55. Using Data From An SQL Server In A PivotTable.mp4	52.4 MB
55. Using Data From An SQL Server In A PivotTable.vtt	5.8 KB
56. Using Solver To Complete A What-If.mp4	57.6 MB
56. Using Solver To Complete A What-If.vtt	7.1 KB
57. Using The MATCH Function.mp4	82.2 MB
57. Using The MATCH Function.vtt	8.5 KB
58. Using The New Timeline Filter Option.mp4	55.5 MB
58. Using The New Timeline Filter Option.vtt	5.8 KB
59. VLOOKUP In Live Action.mp4	68.8 MB
59. VLOOKUP In Live Action.vtt	7.1 KB
6. Calculations Using Time.mp4	44.9 MB
6. Calculations Using Time.vtt	4.6 KB
60. VLOOKUP Syntax And Usage.mp4	49.0 MB
60. VLOOKUP Syntax And Usage.vtt	5.6 KB
61. What Are Tracer Arrows.mp4	52.8 MB
61. What Are Tracer Arrows.vtt	5.8 KB
62. What Is A PivotTable.mp4	56.7 MB
62. What Is A PivotTable.vtt	5.6 KB
63. What-If Analysis Using Goal Seek.mp4	42.4 MB
63. What-If Analysis Using Goal Seek.vtt	4.8 KB
64. Activating The Solver Add-In.mp4	19.0 MB
64. Activating The Solver Add-In.vtt	2.3 KB
65. Adding An Outline Manually.mp4	38.9 MB
65. Adding An Outline Manually.vtt	3.8 KB
66. Adding Constraints To Solver.mp4	43.3 MB
66. Adding Constraints To Solver.vtt	4.6 KB
67. Area And Volume Calculations.mp4	38.6 MB
67. Area And Volume Calculations.vtt	4.6 KB
68. Arrays And Creating A New Array Formula.mp4	53.3 MB
68. Arrays And Creating A New Array Formula.vtt	6.2 KB
69. Auditing Tools Error Checking And Tracing.mp4	68.9 MB
69. Auditing Tools Error Checking And Tracing.vtt	8.5 KB
7. Changing Case Functions.mp4	54.0 MB
7. Changing Case Functions.vtt	4.8 KB
70. AVERAGE, MODE, MEAN, And MEDIAN.mp4	41.5 MB
70. AVERAGE, MODE, MEAN, And MEDIAN.vtt	4.5 KB
71. AVERAGEIF For The Mean Of Selected Cells.mp4	40.8 MB
71. AVERAGEIF For The Mean Of Selected Cells.vtt	3.9 KB
72. Changing The Fields Used In A PivotChart.mp4	46.0 MB
72. Changing The Fields Used In A PivotChart.vtt	6.3 KB
73. Changing The PivotChart Type.mp4	47.2 MB
73. Changing The PivotChart Type.vtt	5.0 KB
74. COUNTIF For Selective Counting.mp4	39.7 MB
74. COUNTIF For Selective Counting.vtt	3.3 KB
75. Create An Outline Automatically.mp4	41.2 MB
75. Create An Outline Automatically.vtt	4.8 KB
76. Creating Your Own PivotTables.mp4	73.5 MB
76. Creating Your Own PivotTables.vtt	8.2 KB
77. Dealing With Empty Cells And Other Additional Options.mp4	65.0 MB
77. Dealing With Empty Cells And Other Additional Options.vtt	6.6 KB
78. Dealing With INDIRECT Errors.mp4	40.8 MB
78. Dealing With INDIRECT Errors.vtt	4.2 KB
79. Editing And Removing Outlining.mp4	79.2 MB
79. Editing And Removing Outlining.vtt	8.1 KB
8. Changing The Formatting And Formulas In PivotTable Summaries.mp4	55.3 MB
8. Changing The Formatting And Formulas In PivotTable Summaries.vtt	4.8 KB
80. FIND And MID Text Functions Working Together.mp4	93.4 MB
80. FIND And MID Text Functions Working Together.vtt	8.5 KB
81. Hiding The PivotChart Buttons.mp4	22.6 MB
81. Hiding The PivotChart Buttons.vtt	3.0 KB
82. HLOOKUP Variation On A Theme.mp4	56.5 MB
82. HLOOKUP Variation On A Theme.vtt	4.8 KB
83. How The INDEX Function Works.mp4	60.7 MB
83. How The INDEX Function Works.vtt	6.3 KB
84. IF Syntax And Uses.mp4	74.6 MB
84. IF Syntax And Uses.vtt	9.5 KB
85. INDIRECT Function To Build Dynamic Formulas.mp4	50.1 MB
85. INDIRECT Function To Build Dynamic Formulas.vtt	4.7 KB
86. LEN And TRIM String Extractions.mp4	83.4 MB
86. LEN And TRIM String Extractions.vtt	7.9 KB
87. Loan Calculation Elements And Functions.mp4	41.8 MB
87. Loan Calculation Elements And Functions.vtt	5.2 KB
88. Lookups Nested Within Lookups.mp4	74.0 MB
88. Lookups Nested Within Lookups.vtt	7.4 KB
89. Making Use Of The Report Filter Options.mp4	58.3 MB
89. Making Use Of The Report Filter Options.vtt	6.6 KB
9. Comparing Sparklines Within A Sparkline Group.mp4	46.4 MB
9. Comparing Sparklines Within A Sparkline Group.vtt	5.7 KB
90. MATCH And INDEX Functions Working Together.mp4	61.6 MB
90. MATCH And INDEX Functions Working Together.vtt	5.7 KB
91. Merging And Deleting Scenarios.mp4	44.1 MB
91. Merging And Deleting Scenarios.vtt	4.8 KB
92. MOD And INT Functions And Uses.mp4	48.7 MB
92. MOD And INT Functions And Uses.vtt	5.8 KB
93. Moving And Deleting PivotCharts.mp4	52.8 MB
93. Moving And Deleting PivotCharts.vtt	6.0 KB
94. Moving And Deleting PivotTables.mp4	46.6 MB
94. Moving And Deleting PivotTables.vtt	5.1 KB
95. Multiple Criteria Within SUMIF, COUNTIF, And AVERAGEIF.mp4	84.2 MB
95. Multiple Criteria Within SUMIF, COUNTIF, And AVERAGEIF.vtt	8.0 KB
96. PivotTable Styles.mp4	75.3 MB
96. PivotTable Styles.vtt	6.8 KB
97. Setting Up A Set Of Scenarios.mp4	83.6 MB
97. Setting Up A Set Of Scenarios.vtt	8.4 KB
98. Sorting The PivotTable Columns.mp4	65.5 MB
98. Sorting The PivotTable Columns.vtt	6.2 KB
99. Step-By-Step Formula Processing.mp4	42.8 MB
99. Step-By-Step Formula Processing.vtt	4.5 KB
/.../5. Charts In Detail/
1. Add WordArt And Use Of WordArt Styles_(new).mp4	57.5 MB
1. Add WordArt And Use Of WordArt Styles_(new).vtt	7.7 KB
10. Chart Templates.mp4	28.6 MB
10. Chart Templates.vtt	4.5 KB
11. Charting Stock Movements_(new).mp4	89.1 MB
11. Charting Stock Movements_(new).vtt	8.7 KB
12. Copying And Linking Charts To Other Office Applications_(new).mp4	62.2 MB
12. Copying And Linking Charts To Other Office Applications_(new).vtt	8.8 KB
13. Creating Charts From Multiple Data Sources_(new).mp4	69.1 MB
13. Creating Charts From Multiple Data Sources_(new).vtt	7.8 KB
14. Creating Charts Quickly_(new).mp4	61.1 MB
14. Creating Charts Quickly_(new).vtt	7.2 KB
15. Dealing With Hidden Or Empty Cells_(new).mp4	61.0 MB
15. Dealing With Hidden Or Empty Cells_(new).vtt	7.1 KB
16. Deciding On The Data To Be Used In A Chart_(new).mp4	49.1 MB
16. Deciding On The Data To Be Used In A Chart_(new).vtt	6.1 KB
17. Dynamic Titles_(new).mp4	35.9 MB
17. Dynamic Titles_(new).vtt	4.8 KB
18. Filtering An Existing Chart_(new).mp4	38.8 MB
18. Filtering An Existing Chart_(new).vtt	4.6 KB
19. How To Print Charts_(new).mp4	26.2 MB
19. How To Print Charts_(new).vtt	4.9 KB
2. Adding And Manipulating Shapes_(new).mp4	51.8 MB
2. Adding And Manipulating Shapes_(new).vtt	8.2 KB
20. Managing Data Labels_(new).mp4	56.6 MB
20. Managing Data Labels_(new).vtt	8.1 KB
21. Moving Charts And Switching Rows And Columns_(new).mp4	61.7 MB
21. Moving Charts And Switching Rows And Columns_(new).vtt	9.3 KB
22. Multiple Chart Types In The Same Chart_(new).mp4	51.3 MB
22. Multiple Chart Types In The Same Chart_(new).vtt	7.1 KB
23. Multiple Pie Charts In The Same Sheet_(new).mp4	75.8 MB
23. Multiple Pie Charts In The Same Sheet_(new).vtt	7.7 KB
24. Pie Of A Pie_(new).mp4	70.0 MB
24. Pie Of A Pie_(new).vtt	6.8 KB
25. Radar Charts In Action_(new).mp4	77.2 MB
25. Radar Charts In Action_(new).vtt	9.2 KB
26. Scatter Charts Explained_(new).mp4	68.7 MB
26. Scatter Charts Explained_(new).vtt	8.6 KB
27. The Chart Sub Ribbons And Properties Box_(new).mp4	61.6 MB
27. The Chart Sub Ribbons And Properties Box_(new).vtt	7.1 KB
28. The Right Chart Type Matters_(new).mp4	54.1 MB
28. The Right Chart Type Matters_(new).vtt	6.0 KB
29. Trend Lines Used To Help Analyze Data_(new).mp4	71.1 MB
29. Trend Lines Used To Help Analyze Data_(new).vtt	9.8 KB
3. Adding And Removing Chart Elements_(new).mp4	70.4 MB
3. Adding And Removing Chart Elements_(new).vtt	8.5 KB
30. Use Sparklines To Create Inline Charts_(new).mp4	59.8 MB
30. Use Sparklines To Create Inline Charts_(new).vtt	6.3 KB
31. Using Pictures Or Textures As Chart Element Backgrounds_(new).mp4	69.2 MB
31. Using Pictures Or Textures As Chart Element Backgrounds_(new).vtt	7.4 KB
32. What Happens When I Copy Sheets With Charts_(new).mp4	69.4 MB
32. What Happens When I Copy Sheets With Charts_(new).vtt	6.0 KB
4. Adding Static And Dynamic Text Boxes_(new).mp4	51.2 MB
4. Adding Static And Dynamic Text Boxes_(new).vtt	7.7 KB
5. Altering Axis Formatting And Plotting_(new).mp4	71.9 MB
5. Altering Axis Formatting And Plotting_(new).vtt	10.3 KB
6. Changing A Charts Date Source_(new).mp4	49.5 MB
6. Changing A Charts Date Source_(new).vtt	6.3 KB
7. Changing The Default Chart Type_(new).mp4	27.6 MB
7. Changing The Default Chart Type_(new).vtt	3.6 KB
8. 186-Chart Areas Plot Chart Legends_(new).mp4	56.2 MB
8. 186-Chart Areas Plot Chart Legends_(new).vtt	7.9 KB
9. Chart Layouts Styles And Colors_(new).mp4	49.4 MB
9. Chart Layouts Styles And Colors_(new).vtt	7.6 KB
/.../6. EXCEL MACRO VISUAL BASIC (VBA)/
1. Add An Are You Sure Box To Macros.mp4	86.5 MB
1. Add An Are You Sure Box To Macros.vtt	9.7 KB
10. A Number Of Read Only RANGE Properties.mp4	78.0 MB
10. A Number Of Read Only RANGE Properties.vtt	9.9 KB
11. Add Formulas To Cells Through VBA Code.mp4	59.7 MB
11. Add Formulas To Cells Through VBA Code.vtt	6.7 KB
12. Adding A Keyboard Shortcut Trigger.mp4	25.5 MB
12. Adding A Keyboard Shortcut Trigger.vtt	3.3 KB
13. Adding Buttons To Sheets.mp4	37.5 MB
13. Adding Buttons To Sheets.vtt	4.1 KB
14. Adding Code To The PERSONAL File.mp4	82.6 MB
14. Adding Code To The PERSONAL File.vtt	8.9 KB
15. Adding ELSEIF To Speed Up Execution.mp4	35.5 MB
15. Adding ELSEIF To Speed Up Execution.vtt	5.1 KB
16. Adding Option Buttons In A Frame.mp4	59.5 MB
16. Adding Option Buttons In A Frame.vtt	5.3 KB
17. Allowing The User To Highlight A Range.mp4	43.8 MB
17. Allowing The User To Highlight A Range.vtt	4.5 KB
18. An Intrinsic Constant.mp4	24.7 MB
18. An Intrinsic Constant.vtt	3.9 KB
19. Arrays.mp4	33.1 MB
19. Arrays.vtt	6.4 KB
2. Assigning Macros To Ribbon Icons.mp4	52.4 MB
2. Assigning Macros To Ribbon Icons.vtt	6.7 KB
20. Common METHODS Of The RANGE Object.mp4	108.4 MB
20. Common METHODS Of The RANGE Object.vtt	12.6 KB
21. Controlling The Program Flow With IF THEN ELSE.mp4	34.2 MB
21. Controlling The Program Flow With IF THEN ELSE.vtt	4.9 KB
22. Creating A Sub Procedure Manually.mp4	22.9 MB
22. Creating A Sub Procedure Manually.vtt	4.3 KB
23. Creating A UserForm.mp4	48.9 MB
23. Creating A UserForm.vtt	5.1 KB
24. Customizing The Ribbons.mp4	55.3 MB
24. Customizing The Ribbons.vtt	6.0 KB
25. Debugging Techniques.mp4	57.7 MB
25. Debugging Techniques.vtt	6.6 KB
26. Declaring Variables And Data Types.mp4	43.8 MB
26. Declaring Variables And Data Types.vtt	7.1 KB
27. Determining File Sizes Using FILELEN.mp4	23.9 MB
27. Determining File Sizes Using FILELEN.vtt	2.7 KB
28. Formatting Numeric Values.mp4	29.0 MB
28. Formatting Numeric Values.vtt	3.7 KB
29. How To Call A Function.mp4	27.6 MB
29. How To Call A Function.vtt	3.5 KB
3. Create Your Own Ribbon.mp4	32.7 MB
3. Create Your Own Ribbon.vtt	4.4 KB
30. How To Create An Event.mp4	63.3 MB
30. How To Create An Event.vtt	8.3 KB
31. Images On UserForms.mp4	60.2 MB
31. Images On UserForms.vtt	6.6 KB
32. Labels And Text Boxes.mp4	56.7 MB
32. Labels And Text Boxes.vtt	6.2 KB
33. Multi-Dimensional Arrays.mp4	20.6 MB
33. Multi-Dimensional Arrays.vtt	4.2 KB
34. Multiple Criteria Plus Nested IFs.mp4	49.1 MB
34. Multiple Criteria Plus Nested IFs.vtt	6.8 KB
35. Quick Tour Of The Visual Basic Editor.mp4	42.9 MB
35. Quick Tour Of The Visual Basic Editor.vtt	8.0 KB
36. Recording And Running A Simple Macro.mp4	36.7 MB
36. Recording And Running A Simple Macro.vtt	5.0 KB
37. SELECT CASE As An Alternative To IF.mp4	41.0 MB
37. SELECT CASE As An Alternative To IF.vtt	5.0 KB
38. Selecting A Range With The INPUT Box.mp4	36.0 MB
38. Selecting A Range With The INPUT Box.vtt	4.1 KB
39. Setup And Use A Watch.mp4	52.3 MB
39. Setup And Use A Watch.vtt	5.7 KB
4. Creating And Running Your First Macro.mp4	48.2 MB
4. Creating And Running Your First Macro.vtt	6.5 KB
40. Speeding Up The VBA Tips.mp4	129.0 MB
40. Speeding Up The VBA Tips.vtt	13.9 KB
41. Text Manipulation With VBA Functions.mp4	32.0 MB
41. Text Manipulation With VBA Functions.vtt	4.7 KB
42. The OFFSET Property.mp4	20.5 MB
42. The OFFSET Property.vtt	3.0 KB
43. The Scope Of A Variable.mp4	37.2 MB
43. The Scope Of A Variable.vtt	5.7 KB
44. The VALUE Of Ranges.mp4	65.5 MB
44. The VALUE Of Ranges.vtt	8.7 KB
45. Trigger A Procedure From The Quick Access Toolbar.mp4	49.2 MB
45. Trigger A Procedure From The Quick Access Toolbar.vtt	6.0 KB
46. User Defined Functions.mp4	38.9 MB
46. User Defined Functions.vtt	5.0 KB
47. UserForm Controls - The CheckBox.mp4	83.7 MB
47. UserForm Controls - The CheckBox.vtt	8.9 KB
48. Using Application Events.mp4	117.6 MB
48. Using Application Events.vtt	13.0 KB
49. Using Command Buttons.mp4	56.2 MB
49. Using Command Buttons.vtt	6.1 KB
5. Customizing Form Buttons And Other Shape Triggers.mp4	62.3 MB
5. Customizing Form Buttons And Other Shape Triggers.vtt	7.5 KB
50. Using Comments Within Your VBA Code.mp4	26.8 MB
50. Using Comments Within Your VBA Code.vtt	5.4 KB
51. Using GOTO And Labels.mp4	34.1 MB
51. Using GOTO And Labels.vtt	5.1 KB
52. Using MSGBOX To Interact With Users.mp4	84.0 MB
52. Using MSGBOX To Interact With Users.vtt	9.7 KB
53. Workbook Events - Closing And Saving.mp4	79.3 MB
53. Workbook Events - Closing And Saving.vtt	7.7 KB
54. WorkBook Events - Open.mp4	82.3 MB
54. WorkBook Events - Open.vtt	8.2 KB
55. Deleting Macros.mp4	28.7 MB
55. Deleting Macros.vtt	4.3 KB
56. Saving Workbooks With Macros.mp4	19.0 MB
56. Saving Workbooks With Macros.vtt	2.5 KB
57. The Personal Macro Workbook.mp4	28.8 MB
57. The Personal Macro Workbook.vtt	5.4 KB
58. Trigger A Macro With A Keyboard Shortcut.mp4	24.3 MB
58. Trigger A Macro With A Keyboard Shortcut.vtt	4.3 KB
59. Use Of Relative Or Absolute Referencing.mp4	29.3 MB
59. Use Of Relative Or Absolute Referencing.vtt	4.9 KB
6. Formatting With A Macro.mp4	44.2 MB
6. Formatting With A Macro.vtt	5.6 KB
60. Use Of Worksheet Buttons To Trigger Macros.mp4	65.0 MB
60. Use Of Worksheet Buttons To Trigger Macros.vtt	8.2 KB
61. What Is A Macro.mp4	17.9 MB
61. What Is A Macro.vtt	2.3 KB
62. Adding The Code That Makes The Form Work.mp4	79.9 MB
62. Adding The Code That Makes The Form Work.vtt	7.9 KB
63. An Introduction To UserForms.mp4	40.5 MB
63. An Introduction To UserForms.vtt	4.8 KB
64. Built In VBA Date Functions.mp4	19.8 MB
64. Built In VBA Date Functions.vtt	2.9 KB
65. Calling Your UserForm And Validating Content.mp4	84.3 MB
65. Calling Your UserForm And Validating Content.vtt	8.8 KB
66. Constants Instead Of Variables.mp4	26.0 MB
66. Constants Instead Of Variables.vtt	4.6 KB
67. Controlling Tab Order And Aligning Controls.mp4	109.7 MB
67. Controlling Tab Order And Aligning Controls.vtt	10.3 KB
68. Creating A Function Procedure.mp4	20.3 MB
68. Creating A Function Procedure.vtt	3.8 KB
69. DO WHILE Loop.mp4	58.1 MB
69. DO WHILE Loop.vtt	7.5 KB
7. Macro Security Settings For Workbooks With Macros.mp4	34.6 MB
7. Macro Security Settings For Workbooks With Macros.vtt	5.3 KB
70. Dynamic Arrays.mp4	20.1 MB
70. Dynamic Arrays.vtt	4.7 KB
71. Editing An Existing Macro In The Visual Basic Editor.mp4	38.1 MB
71. Editing An Existing Macro In The Visual Basic Editor.vtt	5.3 KB
72. Error Trapping the Easy Way.mp4	69.6 MB
72. Error Trapping the Easy Way.vtt	8.9 KB
73. FOR NEXT With A VBA Collection.mp4	56.9 MB
73. FOR NEXT With A VBA Collection.vtt	6.7 KB
74. How To Call A Sub Procedure.mp4	25.5 MB
74. How To Call A Sub Procedure.vtt	3.6 KB
75. Interact With The User When An Error Occurs.mp4	48.4 MB
75. Interact With The User When An Error Occurs.vtt	5.9 KB
76. Make The VBA Ignore Errors.mp4	38.4 MB
76. Make The VBA Ignore Errors.vtt	4.8 KB
77. Making Use Of The ERR Object.mp4	40.7 MB
77. Making Use Of The ERR Object.vtt	4.3 KB
78. Multiple Tabs On A UserForm.mp4	88.6 MB
78. Multiple Tabs On A UserForm.vtt	8.0 KB
79. Other Useful Worksheet Triggers.mp4	97.6 MB
79. Other Useful Worksheet Triggers.vtt	10.6 KB
8. Switch Scenarios And Views With Macros.mp4	62.7 MB
8. Switch Scenarios And Views With Macros.vtt	6.8 KB
80. Referencing Cells Using The Range Object.mp4	38.9 MB
80. Referencing Cells Using The Range Object.vtt	6.3 KB
81. Scrollbar And Spin Controls.mp4	88.2 MB
81. Scrollbar And Spin Controls.vtt	9.4 KB
82. String And Date Types Expanded.mp4	41.9 MB
82. String And Date Types Expanded.vtt	7.5 KB
83. The CELLS Property.mp4	23.5 MB
83. The CELLS Property.vtt	3.5 KB
84. The FONT Property And Colors.mp4	71.3 MB
84. The FONT Property And Colors.vtt	9.5 KB
85. The FOR NEXT Loop.mp4	80.0 MB
85. The FOR NEXT Loop.vtt	11.0 KB
86. The New Macro Enabled File Type.mp4	24.6 MB
86. The New Macro Enabled File Type.vtt	2.7 KB
87. The Static Declaration And Variable Expiry.mp4	36.5 MB
87. The Static Declaration And Variable Expiry.vtt	6.7 KB
88. The TEXT Object Of The RANGE.mp4	25.9 MB
88. The TEXT Object Of The RANGE.vtt	3.5 KB
89. Use INPUTBOX For Accepting Values From Users.mp4	65.0 MB
89. Use INPUTBOX For Accepting Values From Users.vtt	7.9 KB
9. View And Edit Macro Code.mp4	70.0 MB
9. View And Edit Macro Code.vtt	8.7 KB
90. UserForm Controls - ListBox AndOr Combo Box.mp4	105.9 MB
90. UserForm Controls - ListBox AndOr Combo Box.vtt	10.1 KB
91. Using Breakpoints To Help Debug.mp4	55.2 MB
91. Using Breakpoints To Help Debug.vtt	6.5 KB
92. Using Worksheet Excel Functions In VBA Code.mp4	71.2 MB
92. Using Worksheet Excel Functions In VBA Code.vtt	9.2 KB
93. VBA Operators.mp4	62.6 MB
93. VBA Operators.vtt	9.4 KB
94. Watch A Macro Write Your VBA.mp4	34.8 MB
94. Watch A Macro Write Your VBA.vtt	3.8 KB
95. What Is A Function.mp4	13.5 MB
95. What Is A Function.vtt	2.0 KB
96. What Is A Module.mp4	24.8 MB
96. What Is A Module.vtt	4.6 KB
97. Where To Store Your VBA Code.mp4	70.6 MB
97. Where To Store Your VBA Code.vtt	9.6 KB
98. Workbook Triggers - Activate And Deactivate.mp4	56.8 MB
98. Workbook Triggers - Activate And Deactivate.vtt	5.2 KB
99. Worksheet Triggers - Activate And Deactivate.mp4	42.3 MB
99. Worksheet Triggers - Activate And Deactivate.vtt	4.1 KB
Total files 920