Tutorialsplanet NET Udemy - Microsoft Excel - Excel from Beginner to Advanced

1. 1. Microsoft Excel 101 Course Introduction/1. Ask Questions.mp436.36MB
2. 1. Microsoft Excel 101 Course Introduction/2. Course Exercise Files.mp427.4MB
3. 1. Microsoft Excel 101 Course Introduction/3. Certificate of Completion.mp423.34MB
4. 10. Working with Excel Templates/1. Intro to Excel Templates.mp417.54MB
5. 10. Working with Excel Templates/2. Opening an Existing Template.mp467.92MB
6. 10. Working with Excel Templates/3. Creating a Custom Template.mp452.5MB
7. 11. Congratulations! You've Built a Solid Microsoft Excel Foundation/1. Congratulations!.mp442.88MB
8. 12. Microsoft Excel 102 Course Introduction/1. Excel 102 Course Exercise Files -- DOWNLOAD.mp422.7MB
9. 13. Working with an Excel List/1. Understanding Excel List Structure.mp452.97MB
10. 13. Working with an Excel List/2. Sorting a List Using Single Level Sort.mp436.51MB
11. 13. Working with an Excel List/3. Sorting a List Using Multi-Level Sorts.mp436.39MB
12. 13. Working with an Excel List/4. Using Custom Sorts in an Excel List.mp437.96MB
13. 13. Working with an Excel List/5. Filter an Excel List Using the AutoFilter Tool.mp437.37MB
14. 13. Working with an Excel List/6. Creating Subtotals in a List.mp468.7MB
15. 13. Working with an Excel List/7. Format a List as a Table.mp475.28MB
16. 13. Working with an Excel List/8. Using Conditional Formatting to Find Duplicates.mp440.67MB
17. 13. Working with an Excel List/9. Removing Duplicates.mp440.82MB
18. 14. Excel List Functions/1. Introduction to Excels Function DSUM().mp4110.95MB
19. 14. Excel List Functions/2. Excel DSUM Function Single Criteria Continued.mp495.38MB
20. 14. Excel List Functions/3. Excel DSUM Function with OR Criteria.mp450.3MB
21. 14. Excel List Functions/4. Excel DSUM Function with AND Criteria.mp4108.68MB
22. 14. Excel List Functions/5. Excel Function DAVERAGE().mp497.72MB
23. 14. Excel List Functions/6. Excel Function DCOUNT().mp4128.25MB
24. 14. Excel List Functions/7. Excel Function SUBTOTAL().mp4153.56MB
25. 15. Excel Data Validation/1. Understanding the Need for Excel Data Validation.mp4103.16MB
26. 15. Excel Data Validation/2. Creating an Excel Data Validation List.mp4112.54MB
27. 15. Excel Data Validation/3. Excel Decimal Data Validation.mp488.77MB
28. 15. Excel Data Validation/4. Adding a Custom Excel Data Validation Error.mp499.58MB
29. 15. Excel Data Validation/5. Dynamic Formulas by Using Excel Data Validation Techniques.mp492.75MB
30. 16. Importing and Exporting Data/1. Importing Data Into Microsoft Excel.mp435.6MB
31. 16. Importing and Exporting Data/2. Importing Data from Text Files.mp434.52MB
32. 16. Importing and Exporting Data/3. Importing Data from Microsoft Access.mp430.79MB
33. 16. Importing and Exporting Data/4. NEW VERSION -- Import Data From Text Files into Excel.mp4162.93MB
34. 16. Importing and Exporting Data/5. NEW VERSION -- Import Data From a Database into Excel.mp4119.67MB
35. 16. Importing and Exporting Data/6. Microsoft Excel Legacy Import Options for New Excel Versions.mp436.82MB
36. 16. Importing and Exporting Data/7. Exporting Data to a Text File.mp4116.15MB
37. 17. Excel PivotTables/1. Understanding Excel PivotTables.mp439.75MB
38. 17. Excel PivotTables/2. Creating an Excel PivotTable.mp452.55MB
39. 17. Excel PivotTables/3. Modifying Excel PivotTable Calculations.mp449.67MB
40. 17. Excel PivotTables/4. Grouping PivotTable Data.mp431.5MB
41. 17. Excel PivotTables/5. Formatting PivotTable Data.mp435.67MB
42. 17. Excel PivotTables/6. Drilling Down into PivotTable Data.mp436.53MB
43. 17. Excel PivotTables/7. Creating PivotCharts.mp440.28MB
44. 17. Excel PivotTables/8. Filtering PivotTable Data.mp431.93MB
45. 17. Excel PivotTables/9. Filtering with the Slicer Tool.mp433.76MB
46. 18. Working with Excel's PowerPivot Tools/1. Why PowerPivot.mp456.15MB
47. 18. Working with Excel's PowerPivot Tools/2. Activating the Excel PowerPivot AddIn.mp413.87MB
48. 18. Working with Excel's PowerPivot Tools/3. Creating Data Models with PowerPivot.mp478.03MB
49. 18. Working with Excel's PowerPivot Tools/4. Creating PivotTables based on Data Models.mp435.22MB
50. 18. Working with Excel's PowerPivot Tools/5. PowerPivot Calculated Fields.mp442.63MB
51. 18. Working with Excel's PowerPivot Tools/6. PowerPivot KPIs.mp466.62MB
52. 19. Working with Large Sets of Excel Data/1. Using the Freeze Panes Tool.mp437.58MB
53. 19. Working with Large Sets of Excel Data/2. Grouping Data (Columns andor Rows).mp447.86MB
54. 19. Working with Large Sets of Excel Data/3. Print Options for Large Sets of Data.mp463.93MB
55. 19. Working with Large Sets of Excel Data/4. Linking Worksheets (3D Formulas).mp422.05MB
56. 19. Working with Large Sets of Excel Data/5. Consolidating Data from Multiple Worksheets.mp435.78MB
57. 2. Microsoft Excel Fundamentals/1. Launching Excel.mp433.71MB
58. 2. Microsoft Excel Fundamentals/2. Microsoft Excel Startup Screen.mp462.59MB
59. 2. Microsoft Excel Fundamentals/3. Introduction to the Excel Interface.mp4116.4MB
60. 2. Microsoft Excel Fundamentals/4. Customizing the Excel Quick Access Toolbar.mp455.15MB
61. 2. Microsoft Excel Fundamentals/5. More on the Excel Interface.mp454.7MB
62. 2. Microsoft Excel Fundamentals/6. Understanding the Structure of an Excel Workbook.mp478.54MB
63. 2. Microsoft Excel Fundamentals/7. Saving an Excel Document.mp474.78MB
64. 2. Microsoft Excel Fundamentals/8. Opening an Existing Excel Document.mp429.19MB
65. 2. Microsoft Excel Fundamentals/9. Common Excel Shortcut Keys.mp449.19MB
66. 20. Congratulations! You're an Intermediate Excel User/1. Congratulations!.mp434.41MB
67. 21. Microsoft Excel 103 Course Introduction/1. Excel 103 Course Exercise Files -- DOWNLOAD.mp426.22MB
68. 22. Working with Excel's Conditional Functions/1. Working with Excel Name Ranges.mp474.37MB
69. 22. Working with Excel's Conditional Functions/10. Using Excel's IFERROR() Function.mp493.83MB
70. 22. Working with Excel's Conditional Functions/2. Advantages and Disadvantages of Excel Name Ranges.mp496.07MB
71. 22. Working with Excel's Conditional Functions/3. Editing an Excel Name Range.mp444.44MB
72. 22. Working with Excel's Conditional Functions/4. Using Excel's IF() Function.mp490.38MB
73. 22. Working with Excel's Conditional Functions/5. Excel's IF() Function with a Name Range.mp491.24MB
74. 22. Working with Excel's Conditional Functions/6. Nesting Functions with Excel.mp4156.76MB
75. 22. Working with Excel's Conditional Functions/7. Nesting Excels AND() Function within the IF() Function.mp482.37MB
76. 22. Working with Excel's Conditional Functions/8. Using Excel's COUNTIF() Function.mp443.35MB
77. 22. Working with Excel's Conditional Functions/9. Using Excel's SUMIF() Function.mp4120.49MB
78. 23. Working with Excel's Lookup Functions/1. Microsoft Excel VLOOKUP() Function.mp4170.38MB
79. 23. Working with Excel's Lookup Functions/2. Microsoft Excel HLOOKUP() Function.mp494.91MB
80. 23. Working with Excel's Lookup Functions/3. Microsoft Excel INDEX() Function.mp4168.08MB
81. 23. Working with Excel's Lookup Functions/4. Microsoft Excel MATCH() Function.mp481.3MB
82. 23. Working with Excel's Lookup Functions/5. Microsoft Excel INDEX() and MATCH() Function Combined.mp4120.49MB
83. 23. Working with Excel's Lookup Functions/6. Microsoft Excel INDEX() and MATCH() Function Combined Continued.mp4154.53MB
84. 23. Working with Excel's Lookup Functions/7. Creating a Dynamic HLOOKUP() with the MATCH() Function.mp4130.35MB
85. 24. Working with Excel's Text Based Functions/1. Using Excel's LEFT(), RIGHT() and MID() Functions.mp453.23MB
86. 24. Working with Excel's Text Based Functions/2. Using Excel's LEN() Function.mp461.29MB
87. 24. Working with Excel's Text Based Functions/3. Using Excel's SEARCH() Function.mp476.01MB
88. 24. Working with Excel's Text Based Functions/4. Using Excel's CONCATENATE() Function.mp421.48MB
89. 25. Auditing an Excel Worksheet/1. Tracing Precendents in Excel Formulas.mp435.37MB
90. 25. Auditing an Excel Worksheet/2. Tracing Dependents in Excel Formulas.mp425.43MB
91. 25. Auditing an Excel Worksheet/3. Working with the Watch Window.mp427.39MB
92. 25. Auditing an Excel Worksheet/4. Showing Formulas.mp423.06MB
93. 26. Protecting Excel Worksheets and Workbooks/1. Protecting Specific Cells in a Worksheet.mp471.24MB
94. 26. Protecting Excel Worksheets and Workbooks/2. Protecting the Structure of a Workbook.mp422.34MB
95. 26. Protecting Excel Worksheets and Workbooks/3. Adding a Workbook Password.mp425.79MB
96. 27. Mastering Excel's What If Tools/1. Working with Excel's Goal Seek Tool.mp443.75MB
97. 27. Mastering Excel's What If Tools/2. Working with Excel's Solver Tool.mp4188.79MB
98. 27. Mastering Excel's What If Tools/3. Building Effective Data Tables in Excel.mp434.21MB
99. 27. Mastering Excel's What If Tools/4. Creating Scenarios in Excel.mp463.77MB
100. 28. Automating Repetitive Tasks in Excel with Macros/1. Understanding Excel Macros.mp439.51MB
101. 28. Automating Repetitive Tasks in Excel with Macros/2. Activating the Developer Tab in Excel.mp417.78MB
102. 28. Automating Repetitive Tasks in Excel with Macros/3. Creating a Macro with the Macro Recorder.mp479.06MB
103. 28. Automating Repetitive Tasks in Excel with Macros/4. Editing a Macro with VBA.mp444.28MB
104. 28. Automating Repetitive Tasks in Excel with Macros/5. Creating Buttons to Run Macros.mp434.13MB
105. 29. Congratulations!/1. Congratulations on Completing the Microsoft Excel 103.mp436.9MB
106. 3. Entering and Editing Text and Formulas/1. Entering Text to Create Spreadsheet Titles.mp4148.1MB
107. 3. Entering and Editing Text and Formulas/2. Working with Numeric Data in Excel.mp4150.64MB
108. 3. Entering and Editing Text and Formulas/3. Entering Date Values in Excel.mp4150.7MB
109. 3. Entering and Editing Text and Formulas/4. Working with Cell References.mp4101.61MB
110. 3. Entering and Editing Text and Formulas/5. Creating Basic Formulas in Excel.mp4146.34MB
111. 3. Entering and Editing Text and Formulas/6. Relative Versus Absolute Cell References in Formulas.mp4212.7MB
112. 3. Entering and Editing Text and Formulas/7. Understanding the Order of Operation (DOWNLOAD EXERCISE FILE).mp4173.34MB
113. 30. Microsoft Excel Macros and VBA Course Introduction/1. Welcome to the Course.mp432.2MB
114. 30. Microsoft Excel Macros and VBA Course Introduction/2. Understanding the Why and How Behind Excel Macros.mp414.88MB
115. 31. Project #1 Using Excel's Macro Recorder Tool/1. Introduction to Project #1 Inserting and Formatting Text.mp413.09MB
116. 31. Project #1 Using Excel's Macro Recorder Tool/2. Project #1 Start Recording!.mp449.22MB
117. 31. Project #1 Using Excel's Macro Recorder Tool/3. Running A Macro.mp48.58MB
118. 31. Project #1 Using Excel's Macro Recorder Tool/4. Project #1 Running a Macro with a Button.mp421.77MB
119. 31. Project #1 Using Excel's Macro Recorder Tool/5. Project #1 Oops! I Need to Edit My Macro.mp427.86MB
120. 31. Project #1 Using Excel's Macro Recorder Tool/6. Practical Uses of Excel Macros.mp441.21MB
121. 32. Excel VBA Concepts/1. Excel VBA Concepts.mp422.16MB
122. 32. Excel VBA Concepts/2. The Visual Basic Editor (VBE).mp49.43MB
123. 32. Excel VBA Concepts/3. Excel VBA Modules.mp45.38MB
124. 32. Excel VBA Concepts/4. Creating an Excel VBA Procedure.mp443.03MB
125. 32. Excel VBA Concepts/5. Adding Code to a VBA Procedure.mp423.2MB
126. 32. Excel VBA Concepts/6. Understanding Excel VBA Variables.mp437.37MB
127. 32. Excel VBA Concepts/7. Building Logic with an IF Statement.mp435.39MB
128. 32. Excel VBA Concepts/8. Working with Excel VBA Loops to Repeat Blocks of Code.mp427.66MB
129. 33. Project #2 Moving Beyond the Basics and into VBA/1. Introduction to Project #2 Interacting with the User.mp418.13MB
130. 33. Project #2 Moving Beyond the Basics and into VBA/2. Project #2 Breaking Down the VBA Code.mp411.97MB
131. 33. Project #2 Moving Beyond the Basics and into VBA/3. Project #2 Prompting the User for Information.mp420.59MB
132. 33. Project #2 Moving Beyond the Basics and into VBA/4. Continue Excel VBA InputBox.mp438.86MB
133. 33. Project #2 Moving Beyond the Basics and into VBA/5. Project #2 Building Logic into Your Macros.mp414.77MB
134. 33. Project #2 Moving Beyond the Basics and into VBA/6. Project #2 Alerting the User of Errors.mp433.72MB
135. 33. Project #2 Moving Beyond the Basics and into VBA/7. Other Practical Uses of Message and Input Boxes.mp452.1MB
136. 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/1. Introduction to Project #3 Cleaning Up and Formatting Data.mp410.71MB
137. 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/2. Project #3 Preparing to the Use the Macro Recorder.mp49.51MB
138. 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/3. Project #3 Inserting the Headers.mp422.11MB
139. 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/4. Project #3 Formatting the Headers.mp47.46MB
140. 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/5. Project #3 Putting it all Together with a Little VBA.mp435.84MB
141. 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/6. Running the Loop.mp418.94MB
142. 35. Project #4 Using VBA to Automate Excel Formulas/1. Introduction to Project #4 Automate Excel Formulas.mp47.47MB
143. 35. Project #4 Using VBA to Automate Excel Formulas/2. Project #4 Automate the SUM() Function through Code.mp425.55MB
144. 35. Project #4 Using VBA to Automate Excel Formulas/3. Continue Automate SUM Function.mp417.54MB
145. 35. Project #4 Using VBA to Automate Excel Formulas/4. Test the SUM Function.mp412.36MB
146. 35. Project #4 Using VBA to Automate Excel Formulas/5. Project #4 Loop the SUM() Function Over Multiple Worksheets.mp420.08MB
147. 36. Project #5 Bringing it All Together and a Weekly Report/1. Introduction to Project #5 Creating the Final Report.mp410.99MB
148. 36. Project #5 Bringing it All Together and a Weekly Report/2. Project #5 Creating the Final Report Loop.mp447.28MB
149. 36. Project #5 Bringing it All Together and a Weekly Report/3. Project #5 - Copying and Pasting Data with VBA.mp454.76MB
150. 36. Project #5 Bringing it All Together and a Weekly Report/4. Project #5 - Running the Final Report Procedure.mp419.95MB
151. 37. Project #6 Working with Excel VBA User Forms/1. Introduction to Project #6 Working with Excel VBA User Forms.mp48.8MB
152. 37. Project #6 Working with Excel VBA User Forms/2. Project #6 Creating an Excel User Form.mp415.06MB
153. 37. Project #6 Working with Excel VBA User Forms/3. Project #6 Adding Controls to the Form.mp411.65MB
154. 37. Project #6 Working with Excel VBA User Forms/4. Project #6 Adding VBA Code to the Initialize Event.mp424.36MB
155. 37. Project #6 Working with Excel VBA User Forms/5. Project #6 Adding VBA Code to the ComboBox Change Event.mp424.22MB
156. 37. Project #6 Working with Excel VBA User Forms/6. Project #6 Adding VBA Code to the Add Worksheet Button.mp410.12MB
157. 37. Project #6 Working with Excel VBA User Forms/7. Change Worksheet Name.mp411.71MB
158. 37. Project #6 Working with Excel VBA User Forms/8. Project #6 Adding VBA Code to the Create Report Button.mp427.43MB
159. 37. Project #6 Working with Excel VBA User Forms/9. Project #6 Showing the Form.mp412.39MB
160. 38. Project #7 Importing Data from Text Files/1. Project #7 Opening a Text File for Import.mp426.04MB
161. 38. Project #7 Importing Data from Text Files/2. Project #7 Opening a Text File for Import.mp442.26MB
162. 38. Project #7 Importing Data from Text Files/3. Project #7 Get Data from Text File.mp432.65MB
163. 38. Project #7 Importing Data from Text Files/4. Project #7 Importing Multiple Text Files with the GetOpenFilename Method.mp465.63MB
164. 38. Project #7 Importing Data from Text Files/5. Project #7 Creating a Loop to Read Each File.mp456.87MB
165. 38. Project #7 Importing Data from Text Files/6. Project #7 Adding a New Sheet for Imported Data.mp423.82MB
166. 38. Project #7 Importing Data from Text Files/7. Project #7 Clear the Clipboard.mp432.07MB
167. 38. Project #7 Importing Data from Text Files/8. Project #7 Working with the ScreenUpdating Property.mp434.5MB
168. 38. Project #7 Importing Data from Text Files/9. Project #7 Creating Reusable Code with a VBA Function.mp461.05MB
169. 39. Course Wrap Up/1. Congratulations! You're an Excel MacroVBA Master.mp418.1MB
170. 4. Working with Basic Excel Functions/1. The structure of an Excel Function.mp4161.97MB
171. 4. Working with Basic Excel Functions/2. Working with the SUM() Function.mp4113.76MB
172. 4. Working with Basic Excel Functions/3. Working with the MIN() and MAX() Functions.mp4101.82MB
173. 4. Working with Basic Excel Functions/4. Working with the AVERAGE() Function.mp447.21MB
174. 4. Working with Basic Excel Functions/5. Working with the COUNT() Function.mp447.57MB
175. 4. Working with Basic Excel Functions/6. Adjacent Cells Error in Excel Calculations.mp460.08MB
176. 4. Working with Basic Excel Functions/7. Using the AutoSum Command.mp4111.97MB
177. 4. Working with Basic Excel Functions/8. Excel's AutoSum Shortcut Key.mp436.8MB
178. 4. Working with Basic Excel Functions/9. Using the AutoFill Command to Copy Formulas.mp473.03MB
179. 5. Modifying an Excel Worksheet/1. Moving and Copying Data in an Excel Worksheet.mp4111.68MB
180. 5. Modifying an Excel Worksheet/2. Inserting and Deleting Rows and Columns.mp4119.79MB
181. 5. Modifying an Excel Worksheet/3. Changing the Width and Height of Cells.mp484.73MB
182. 5. Modifying an Excel Worksheet/4. Hiding and Unhiding Excel Rows and Columns.mp485.99MB
183. 5. Modifying an Excel Worksheet/5. Renaming an Excel Worksheet.mp446.67MB
184. 5. Modifying an Excel Worksheet/6. Deleting an Excel Worksheet.mp478.95MB
185. 5. Modifying an Excel Worksheet/7. Moving and Copying an Excel Worksheet.mp489.62MB
186. 6. Formatting Data in an Excel Worksheet/1. Working with Font Formatting Commands.mp441.4MB
187. 6. Formatting Data in an Excel Worksheet/2. Changing the Background Color of a Cell.mp430.03MB
188. 6. Formatting Data in an Excel Worksheet/3. Adding Borders to Cells.mp436.64MB
189. 6. Formatting Data in an Excel Worksheet/4. Formatting Data as Currency Values.mp456.35MB
190. 6. Formatting Data in an Excel Worksheet/5. Formatting Percentages.mp424.1MB
191. 6. Formatting Data in an Excel Worksheet/6. Using Excel's Format Painter.mp430.45MB
192. 6. Formatting Data in an Excel Worksheet/7. Creating Styles to Format Data.mp494.52MB
193. 6. Formatting Data in an Excel Worksheet/8. Merging and Centering Cells.mp433.21MB
194. 6. Formatting Data in an Excel Worksheet/9. Using Conditional Formatting.mp452.17MB
195. 7. Inserting Images and Shapes into an Excel Worksheet/1. Inserting Images.mp447.64MB
196. 7. Inserting Images and Shapes into an Excel Worksheet/2. Inserting Excel Shapes.mp444.91MB
197. 7. Inserting Images and Shapes into an Excel Worksheet/3. Formatting Excel Shapes.mp450.67MB
198. 7. Inserting Images and Shapes into an Excel Worksheet/4. Working with Excel SmartArt.mp470.76MB
199. 8. Creating Basic Charts in Excel/1. Creating an Excel Column Chart.mp456.12MB
200. 8. Creating Basic Charts in Excel/2. Working with the Excel Chart Ribbon.mp457.1MB
201. 8. Creating Basic Charts in Excel/3. Adding and Modifying Data on an Excel Chart.mp437.19MB
202. 8. Creating Basic Charts in Excel/4. Formatting an Excel Chart.mp449.02MB
203. 8. Creating Basic Charts in Excel/5. Moving a Chart to another Worksheet.mp427.52MB
204. 8. Creating Basic Charts in Excel/6. Working with Excel Pie Charts.mp455.75MB
205. 9. Printing an Excel Worksheet/1. Viewing your Document in Print Preview.mp421.44MB
206. 9. Printing an Excel Worksheet/2. Changing the Margins, Scaling and Orientation.mp473.51MB
207. 9. Printing an Excel Worksheet/3. Working with Page Layout View.mp443.1MB
208. 9. Printing an Excel Worksheet/4. Adding Header and Footer Content.mp450.29MB
209. 9. Printing an Excel Worksheet/5. Printing a Specific Range of Cells.mp434.27MB