589689.xyz

[] Udemy - Microsoft Excel - Excel from Beginner to Advanced

  • 收录时间:2019-03-24 13:18:48
  • 文件大小:4GB
  • 下载次数:116
  • 最近下载:2021-01-19 07:25:34
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 38. Project #7 Importing Data from Text Files/4. Project #7 Importing Multiple Text Files with the GetOpenFilename Method.mp4 66MB
  2. 23. Working with Excel's Lookup Functions/3. Using Excel's INDEX() and MATCH() Functions.mp4 64MB
  3. 38. Project #7 Importing Data from Text Files/9. Project #7 Creating Reusable Code with a VBA Function.mp4 61MB
  4. 38. Project #7 Importing Data from Text Files/5. Project #7 Creating a Loop to Read Each File.mp4 57MB
  5. 36. Project #5 Bringing it All Together and a Weekly Report/3. Project #5 - Copying and Pasting Data with VBA.mp4 55MB
  6. 31. Project #1 Using Excel's Macro Recorder Tool/2. Project #1 Start Recording!.mp4 49MB
  7. 36. Project #5 Bringing it All Together and a Weekly Report/2. Project #5 Creating the Final Report Loop.mp4 47MB
  8. 28. Automating Repetitive Tasks in Excel with Macros/3. Creating a Macro with the Macro Recorder.mp4 46MB
  9. 18. Working with Excel's PowerPivot Tools/3. Creating Data Models with PowerPivot.mp4 46MB
  10. 27. Mastering Excel's What If Tools/2. Working with Excel's Solver Tool.mp4 45MB
  11. 32. Excel VBA Concepts/4. Creating an Excel VBA Procedure.mp4 43MB
  12. 13. Working with an Excel List/7. Format a List as a Table.mp4 43MB
  13. 38. Project #7 Importing Data from Text Files/2. Project #7 Opening a Text File for Import.mp4 42MB
  14. 24. Working with Excel's Text Based Functions/3. Using Excel's SEARCH() Function.mp4 42MB
  15. 19. Working with Large Sets of Excel Data/3. Print Options for Large Sets of Data.mp4 41MB
  16. 14. Excel List Functions/4. Excel Function SUBTOTAL().mp4 41MB
  17. 13. Working with an Excel List/6. Creating Subtotals in a List.mp4 40MB
  18. 14. Excel List Functions/1. Excel Function DSUM().mp4 40MB
  19. 26. Protecting Excel Worksheets and Workbooks/1. Protecting Specific Cells in a Worksheet.mp4 40MB
  20. 33. Project #2 Moving Beyond the Basics and into VBA/4. Continue Excel VBA InputBox.mp4 39MB
  21. 32. Excel VBA Concepts/6. Understanding Excel VBA Variables.mp4 37MB
  22. 24. Working with Excel's Text Based Functions/2. Using Excel's LEN() Function.mp4 37MB
  23. 18. Working with Excel's PowerPivot Tools/6. PowerPivot KPIs.mp4 36MB
  24. 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/5. Project #3 Putting it all Together with a Little VBA.mp4 36MB
  25. 23. Working with Excel's Lookup Functions/1. Using Excel's VLOOKUP() Function.mp4 36MB
  26. 27. Mastering Excel's What If Tools/4. Creating Scenarios in Excel.mp4 36MB
  27. 32. Excel VBA Concepts/7. Building Logic with an IF Statement.mp4 35MB
  28. 22. Working with Excel's Conditional Functions/3. Nesting Functions.mp4 35MB
  29. 38. Project #7 Importing Data from Text Files/8. Project #7 Working with the ScreenUpdating Property.mp4 35MB
  30. 33. Project #2 Moving Beyond the Basics and into VBA/6. Project #2 Alerting the User of Errors.mp4 34MB
  31. 38. Project #7 Importing Data from Text Files/3. Project #7 Get Data from Text File.mp4 33MB
  32. 18. Working with Excel's PowerPivot Tools/1. Why PowerPivot.mp4 33MB
  33. 30. Microsoft Excel Macros and VBA Course Introduction/1. Welcome to the Course.mp4 32MB
  34. 38. Project #7 Importing Data from Text Files/7. Project #7 Clear the Clipboard.mp4 32MB
  35. 24. Working with Excel's Text Based Functions/1. Using Excel's LEFT(), RIGHT() and MID() Functions.mp4 30MB
  36. 17. Excel PivotTables/2. Creating an Excel PivotTable.mp4 30MB
  37. 13. Working with an Excel List/1. Understanding Excel List Structure.mp4 29MB
  38. 22. Working with Excel's Conditional Functions/5. Using Excel's SUMIF() Function.mp4 29MB
  39. 6. Formatting Data in an Excel Worksheet/7. Creating Styles to Format Data.mp4 29MB
  40. 3. Entering and Editing Text and Formulas/6. Relative Versus Absolute Cell References in Formulas.mp4 29MB
  41. 31. Project #1 Using Excel's Macro Recorder Tool/5. Project #1 Opps! I Need to Edit My Macro.mp4 28MB
  42. 32. Excel VBA Concepts/8. Working with Excel VBA Loops to Repeat Blocks of Code.mp4 28MB
  43. 19. Working with Large Sets of Excel Data/2. Grouping Data (Columns andor Rows).mp4 28MB
  44. 37. Project #6 Working with Excel VBA User Forms/8. Project #6 Adding VBA Code to the Create Report Button.mp4 27MB
  45. 22. Working with Excel's Conditional Functions/2. Using Excel's IF() Function.mp4 27MB
  46. 17. Excel PivotTables/3. Modifying Excel PivotTable Calculations.mp4 27MB
  47. 38. Project #7 Importing Data from Text Files/1. Project #7 Opening a Text File for Import.mp4 26MB
  48. 15. Excel Data Validation/2. Creating a Validation List.mp4 26MB
  49. 35. Project #4 Using VBA to Automate Excel Formulas/2. Project #4 Automate the SUM() Function through Code.mp4 26MB
  50. 28. Automating Repetitive Tasks in Excel with Macros/4. Editing a Macro with VBA.mp4 25MB
  51. 33. Project #2 Moving Beyond the Basics and into VBA/7. Other Practical Uses of Message and Input Boxes.mp4 24MB
  52. 37. Project #6 Working with Excel VBA User Forms/4. Project #6 Adding VBA Code to the Initialize Event.mp4 24MB
  53. 37. Project #6 Working with Excel VBA User Forms/5. Project #6 Adding VBA Code to the ComboBox Change Event.mp4 24MB
  54. 18. Working with Excel's PowerPivot Tools/5. PowerPivot Calculated Fields.mp4 24MB
  55. 27. Mastering Excel's What If Tools/1. Working with Excel's Goal Seek Tool.mp4 24MB
  56. 38. Project #7 Importing Data from Text Files/6. Project #7 Adding a New Sheet for Imported Data.mp4 24MB
  57. 17. Excel PivotTables/1. Understanding Excel PivotTables.mp4 23MB
  58. 32. Excel VBA Concepts/5. Adding Code to a VBA Procedure.mp4 23MB
  59. 22. Working with Excel's Conditional Functions/6. Using Excel's IFERROR() Function.mp4 23MB
  60. 28. Automating Repetitive Tasks in Excel with Macros/1. Understanding Excel Macros.mp4 23MB
  61. 13. Working with an Excel List/9. Removing Duplicates.mp4 23MB
  62. 13. Working with an Excel List/8. Using Conditional Formatting to Find Duplicates.mp4 23MB
  63. 15. Excel Data Validation/1. Understanding the Need for Data Validation.mp4 23MB
  64. 17. Excel PivotTables/7. Creating PivotCharts.mp4 23MB
  65. 15. Excel Data Validation/4. Dynamic Formulas by Using Validation Techniques.mp4 23MB
  66. 16. Importing and Exporting Data/3. Exporting Data to a Text File.mp4 22MB
  67. 19. Working with Large Sets of Excel Data/1. Using the Freeze Panes Tool.mp4 22MB
  68. 22. Working with Excel's Conditional Functions/1. Working with Excel Name Ranges.mp4 22MB
  69. 10. Working with Excel Templates/2. Opening an Existing Template.mp4 22MB
  70. 32. Excel VBA Concepts/1. Excel VBA Concepts.mp4 22MB
  71. 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/3. Project #3 Inserting the Headers.mp4 22MB
  72. 31. Project #1 Using Excel's Macro Recorder Tool/4. Project #1 Running a Macro with a Button.mp4 22MB
  73. 17. Excel PivotTables/6. Drilling Down into PivotTable Data.mp4 21MB
  74. 9. Printing an Excel Worksheet/2. Changing the Margins, Scaling and Orientation.mp4 21MB
  75. 13. Working with an Excel List/5. Filter an Excel List Using the AutoFilter Tool.mp4 21MB
  76. 15. Excel Data Validation/3. Adding a Custom Validation Error.mp4 21MB
  77. 33. Project #2 Moving Beyond the Basics and into VBA/3. Project #2 Prompting the User for Information.mp4 21MB
  78. 13. Working with an Excel List/4. Using Custom Sorts in an Excel List.mp4 20MB
  79. 18. Working with Excel's PowerPivot Tools/4. Creating PivotTables based on Data Models.mp4 20MB
  80. 13. Working with an Excel List/3. Sorting a List Using Multi-Level Sorts.mp4 20MB
  81. 13. Working with an Excel List/2. Sorting a List Using Single Level Sort.mp4 20MB
  82. 35. Project #4 Using VBA to Automate Excel Formulas/5. Project #4 Loop the SUM() Function Over Multiple Worksheets.mp4 20MB
  83. 36. Project #5 Bringing it All Together and a Weekly Report/4. Project #5 - Running the Final Report Procedure.mp4 20MB
  84. 28. Automating Repetitive Tasks in Excel with Macros/5. Creating Buttons to Run Macros.mp4 20MB
  85. 25. Auditing an Excel Worksheet/1. Tracing Precendents in Excel Formulas.mp4 20MB
  86. 17. Excel PivotTables/5. Formatting PivotTable Data.mp4 20MB
  87. 27. Mastering Excel's What If Tools/3. Building Effective Data Tables in Excel.mp4 19MB
  88. 14. Excel List Functions/3. Excel Function DCOUNT().mp4 19MB
  89. 7. Inserting Images and Shapes into an Excel Worksheet/4. Working with Excel SmartArt.mp4 19MB
  90. 22. Working with Excel's Conditional Functions/4. Using Excel's COUNTIF() Function.mp4 19MB
  91. 16. Importing and Exporting Data/1. Importing Data from Text Files.mp4 19MB
  92. 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/6. Running the Loop.mp4 19MB
  93. 31. Project #1 Using Excel's Macro Recorder Tool/6. Practical Uses of Excel Macros.mp4 19MB
  94. 19. Working with Large Sets of Excel Data/5. Consolidating Data from Multiple Worksheets.mp4 18MB
  95. 33. Project #2 Moving Beyond the Basics and into VBA/1. Introduction to Project #2 Interacting with the User.mp4 18MB
  96. 39. Course Wrap Up/1. Congratulations! You're an Excel MacroVBA Master.mp4 18MB
  97. 17. Excel PivotTables/9. Filtering with the Slicer Tool.mp4 18MB
  98. 23. Working with Excel's Lookup Functions/2. Using Excel's HLOOKUP() Function.mp4 18MB
  99. 14. Excel List Functions/2. Excel Function DAVERAGE().mp4 18MB
  100. 3. Entering and Editing Text and Formulas/5. Creating Basic Formulas in Excel.mp4 18MB
  101. 35. Project #4 Using VBA to Automate Excel Formulas/3. Continue Automate SUM Function.mp4 18MB
  102. 5. Modifying an Excel Worksheet/2. Inserting and Deleting Rows and Columns.mp4 17MB
  103. 17. Excel PivotTables/8. Filtering PivotTable Data.mp4 17MB
  104. 17. Excel PivotTables/4. Grouping PivotTable Data.mp4 17MB
  105. 8. Creating Basic Charts in Excel/1. Creating an Excel Column Chart.mp4 17MB
  106. 16. Importing and Exporting Data/2. Importing Data from Microsoft Access.mp4 17MB
  107. 8. Creating Basic Charts in Excel/6. Working with Excel Pie Charts.mp4 17MB
  108. 6. Formatting Data in an Excel Worksheet/4. Formatting Data as Currency Values.mp4 16MB
  109. 5. Modifying an Excel Worksheet/3. Changing the Width and Height of Cells.mp4 16MB
  110. 10. Working with Excel Templates/3. Creating a Custom Template.mp4 16MB
  111. 8. Creating Basic Charts in Excel/2. Working with the Excel Chart Ribbon.mp4 16MB
  112. 7. Inserting Images and Shapes into an Excel Worksheet/3. Formatting Excel Shapes.mp4 15MB
  113. 6. Formatting Data in an Excel Worksheet/9. Using Conditional Formatting.mp4 15MB
  114. 25. Auditing an Excel Worksheet/3. Working with the Watch Window.mp4 15MB
  115. 37. Project #6 Working with Excel VBA User Forms/2. Project #6 Creating an Excel User Form.mp4 15MB
  116. 4. Working with Basic Excel Functions/6. Using the AutoSum Command.mp4 15MB
  117. 30. Microsoft Excel Macros and VBA Course Introduction/2. Understanding the Why and How Behind Excel Macros.mp4 15MB
  118. 33. Project #2 Moving Beyond the Basics and into VBA/5. Project #2 Building Logic into Your Macros.mp4 15MB
  119. 9. Printing an Excel Worksheet/4. Adding Header and Footer Content.mp4 14MB
  120. 26. Protecting Excel Worksheets and Workbooks/3. Adding a Workbook Password.mp4 14MB
  121. 7. Inserting Images and Shapes into an Excel Worksheet/1. Inserting Images.mp4 14MB
  122. 25. Auditing an Excel Worksheet/2. Tracing Dependents in Excel Formulas.mp4 14MB
  123. 9. Printing an Excel Worksheet/3. Working with Page Layout View.mp4 14MB
  124. 4. Working with Basic Excel Functions/2. Working with the SUM() Function.mp4 14MB
  125. 8. Creating Basic Charts in Excel/4. Formatting an Excel Chart.mp4 14MB
  126. 2. Microsoft Excel Fundamentals/4. Understanding the Structure of an Excel Workbook.mp4 14MB
  127. 7. Inserting Images and Shapes into an Excel Worksheet/2. Inserting Excel Shapes.mp4 13MB
  128. 31. Project #1 Using Excel's Macro Recorder Tool/1. Introduction to Project #1 Inserting and Formatting Text.mp4 13MB
  129. 25. Auditing an Excel Worksheet/4. Showing Formulas.mp4 13MB
  130. 5. Modifying an Excel Worksheet/7. Moving and Copying and Excel Worksheet.mp4 13MB
  131. 37. Project #6 Working with Excel VBA User Forms/9. Project #6 Showing the Form.mp4 12MB
  132. 35. Project #4 Using VBA to Automate Excel Formulas/4. Test the SUM Function.mp4 12MB
  133. 2. Microsoft Excel Fundamentals/2. Introduction to the Excel Interface.mp4 12MB
  134. 26. Protecting Excel Worksheets and Workbooks/2. Protecting the Structure of a Workbook.mp4 12MB
  135. 8. Creating Basic Charts in Excel/3. Adding and Modifying Data on an Excel Chart.mp4 12MB
  136. 19. Working with Large Sets of Excel Data/4. Linking Worksheets (3D Formulas).mp4 12MB
  137. 33. Project #2 Moving Beyond the Basics and into VBA/2. Project #2 Breaking Down the VBA Code.mp4 12MB
  138. 24. Working with Excel's Text Based Functions/4. Using Excel's CONCATENATE() Function.mp4 12MB
  139. 6. Formatting Data in an Excel Worksheet/1. Working with Font Formatting Commands.mp4 12MB
  140. 3. Entering and Editing Text and Formulas/3. Entering Date Values in Excel.mp4 12MB
  141. 37. Project #6 Working with Excel VBA User Forms/7. Change Worksheet Name.mp4 12MB
  142. 3. Entering and Editing Text and Formulas/1. Entering Text to Create Spreadsheet Titles.mp4 12MB
  143. 37. Project #6 Working with Excel VBA User Forms/3. Project #6 Adding Controls to the Form.mp4 12MB
  144. 4. Working with Basic Excel Functions/3. Working with the MIN() and MAX() Functions.mp4 12MB
  145. 2. Microsoft Excel Fundamentals/1. Launching Excel.mp4 11MB
  146. 36. Project #5 Bringing it All Together and a Weekly Report/1. Introduction to Project #5 Creating the Final Report.mp4 11MB
  147. 5. Modifying an Excel Worksheet/1. Moving and Copying Data in an Excel Worksheet.mp4 11MB
  148. 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/1. Introduction to Project #3 Cleaning Up and Formatting Data.mp4 11MB
  149. 9. Printing an Excel Worksheet/5. Printing a Specific Range of Cells.mp4 11MB
  150. 6. Formatting Data in an Excel Worksheet/3. Adding Borders to Cells.mp4 10MB
  151. 28. Automating Repetitive Tasks in Excel with Macros/2. Activating the Developer Tab in Excel.mp4 10MB
  152. 37. Project #6 Working with Excel VBA User Forms/6. Project #6 Adding VBA Code to the Add Worksheet Button.mp4 10MB
  153. 2. Microsoft Excel Fundamentals/3. Customizing the Excel Quick Access Toolbar.mp4 10MB
  154. 6. Formatting Data in an Excel Worksheet/8. Merging and Centering Cells.mp4 10MB
  155. 3. Entering and Editing Text and Formulas/4. Working with Cell References.mp4 10MB
  156. 4. Working with Basic Excel Functions/7. Using the AutoFill Command to Copy Formulas.mp4 10MB
  157. 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/2. Project #3 Preparing to the Use the Macro Recorder.mp4 9MB
  158. 32. Excel VBA Concepts/2. The Visual Basic Editor (VBE).mp4 9MB
  159. 6. Formatting Data in an Excel Worksheet/6. Using Excel's Format Painter.mp4 9MB
  160. 37. Project #6 Working with Excel VBA User Forms/1. Introduction to Project #6 Working with Excel VBA User Forms.mp4 9MB
  161. 20. Congratulations! You're an Intermediate Excel User/1. Congratulations!.mp4 9MB
  162. 6. Formatting Data in an Excel Worksheet/2. Changing the Background Color of a Cell.mp4 9MB
  163. 31. Project #1 Using Excel's Macro Recorder Tool/3. Running A Macro.mp4 9MB
  164. 5. Modifying an Excel Worksheet/4. Hiding and Unhiding Excel Rows and Columns.mp4 8MB
  165. 3. Entering and Editing Text and Formulas/2. Working with Numeric Data in Excel.mp4 8MB
  166. 4. Working with Basic Excel Functions/1. The structure of an Excel Function.mp4 8MB
  167. 5. Modifying an Excel Worksheet/5. Deleting an Excel Worksheet.mp4 8MB
  168. 18. Working with Excel's PowerPivot Tools/2. Activating the Excel PowerPivot AddIn.mp4 8MB
  169. 4. Working with Basic Excel Functions/4. Working with the AVERAGE() Function.mp4 8MB
  170. 35. Project #4 Using VBA to Automate Excel Formulas/1. Introduction to Project #4 Automate Excel Formulas.mp4 7MB
  171. 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/4. Project #3 Formatting the Headers.mp4 7MB
  172. 8. Creating Basic Charts in Excel/5. Moving a Chart to another Worksheet.mp4 7MB
  173. 2. Microsoft Excel Fundamentals/5. Saving an Excel Document.mp4 7MB
  174. 6. Formatting Data in an Excel Worksheet/5. Formatting Percentages.mp4 7MB
  175. 4. Working with Basic Excel Functions/5. Working with the COUNT() Function.mp4 7MB
  176. 3. Entering and Editing Text and Formulas/7. Understanding the Order of Operation.mp4 6MB
  177. 2. Microsoft Excel Fundamentals/6. Opening an Existing Excel Document.mp4 6MB
  178. 9. Printing an Excel Worksheet/1. Viewing your Document in Print Preview.mp4 6MB
  179. 11. Congratulations! You've Built a Solid Microsoft Excel Foundation/1. Congratulations!.mp4 6MB
  180. 10. Working with Excel Templates/1. Intro to Excel Templates.mp4 5MB
  181. 32. Excel VBA Concepts/3. Excel VBA Modules.mp4 5MB
  182. 5. Modifying an Excel Worksheet/6. Renaming an Excel Worksheet.mp4 5MB
  183. 29. Congratualtions!/1. Congratulations on Competing the Microsoft Excel 103.mp4 3MB
  184. 1. Microsoft Excel 101 Course Introduction/1. Course Exercise Files.mp4 2MB
  185. 12. Microsoft Excel 102 Course Introduction/1.3 NorthwindDB.zip.zip 392KB
  186. 12. Microsoft Excel 102 Course Introduction/1.1 Excel102Exercises.xlsx.xlsx 136KB
  187. 21. Microsoft Excel 103 Course Introduction/1.1 Excel103-AdvancedExercises.xlsx.xlsx 63KB
  188. 30. Microsoft Excel Macros and VBA Course Introduction/3.7 QuarterlyReportForm-01.xlsm.xlsm 30KB
  189. 30. Microsoft Excel Macros and VBA Course Introduction/3.5 QuarterlyReport.xlsm.xlsm 26KB
  190. 12. Microsoft Excel 102 Course Introduction/1.2 Excel102Exercises.txt.txt 26KB
  191. 37. Project #6 Working with Excel VBA User Forms/1.1 QuarterlyReportForm-01.xlsm.xlsm 24KB
  192. 30. Microsoft Excel Macros and VBA Course Introduction/3.8 SortingRecords.xlsm.xlsm 22KB
  193. 30. Microsoft Excel Macros and VBA Course Introduction/3.6 CleaningUpData.xlsx.xlsx 21KB
  194. 30. Microsoft Excel Macros and VBA Course Introduction/3.4 AutomateSumFunction.xlsx.xlsx 20KB
  195. 35. Project #4 Using VBA to Automate Excel Formulas/2.1 AutomateSumFunction.xlsx.xlsx 20KB
  196. 30. Microsoft Excel Macros and VBA Course Introduction/3.1 AutomateFormulas.xlsx.xlsx 19KB
  197. 30. Microsoft Excel Macros and VBA Course Introduction/3.2 InsertingAndFormattingText.xlsx.xlsx 17KB
  198. 31. Project #1 Using Excel's Macro Recorder Tool/2.1 InsertingAndFormattingText.xlsx.xlsx 17KB
  199. 23. Working with Excel's Lookup Functions/3. Using Excel's INDEX() and MATCH() Functions.vtt 17KB
  200. 33. Project #2 Moving Beyond the Basics and into VBA/2.1 SortingRecords.xlsm.xlsm 17KB
  201. 30. Microsoft Excel Macros and VBA Course Introduction/3.3 SortingRecords.xlsx.xlsx 16KB
  202. 24. Working with Excel's Text Based Functions/3. Using Excel's SEARCH() Function.vtt 16KB
  203. 1. Microsoft Excel 101 Course Introduction/1.10 MonthlyBudget-Template-01.xlsx.xlsx 15KB
  204. 1. Microsoft Excel 101 Course Introduction/1.3 MonthlyBudget-Count-01.xlsx.xlsx 14KB
  205. 1. Microsoft Excel 101 Course Introduction/1.4 MonthlyBudget-01.xlsx.xlsx 14KB
  206. 1. Microsoft Excel 101 Course Introduction/1.2 MonthlyBudget-AutoSUM-01.xlsx.xlsx 14KB
  207. 1. Microsoft Excel 101 Course Introduction/1.11 MonthlyBudget-AverageFunction-01.xlsx.xlsx 14KB
  208. 1. Microsoft Excel 101 Course Introduction/1.7 MonthlyBudget-MIN-MAXFunctions-01.xlsx.xlsx 14KB
  209. 1. Microsoft Excel 101 Course Introduction/1.1 MonthlyBudget-AutoFill-01.xlsx.xlsx 14KB
  210. 1. Microsoft Excel 101 Course Introduction/1.8 MonthlyBudget-SUMFunction-01.xlsx.xlsx 14KB
  211. 1. Microsoft Excel 101 Course Introduction/1.5 MonthlyBudget-BasicFormulas-01.xlsx.xlsx 14KB
  212. 1. Microsoft Excel 101 Course Introduction/1.9 MonthlyBudget-Headers-01.xlsx.xlsx 14KB
  213. 1. Microsoft Excel 101 Course Introduction/1.6 MonthlyBudget-ReferenceTypes-01.xlsx.xlsx 14KB
  214. 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/5. Project #3 Putting it all Together with a Little VBA.vtt 13KB
  215. 3. Entering and Editing Text and Formulas/6. Relative Versus Absolute Cell References in Formulas.vtt 13KB
  216. 9. Printing an Excel Worksheet/2. Changing the Margins, Scaling and Orientation.vtt 12KB
  217. 27. Mastering Excel's What If Tools/2. Working with Excel's Solver Tool.vtt 12KB
  218. 33. Project #2 Moving Beyond the Basics and into VBA/6. Project #2 Alerting the User of Errors.vtt 12KB
  219. 32. Excel VBA Concepts/8. Working with Excel VBA Loops to Repeat Blocks of Code.vtt 12KB
  220. 38. Project #7 Importing Data from Text Files/4. Project #7 Importing Multiple Text Files with the GetOpenFilename Method.vtt 12KB
  221. 36. Project #5 Bringing it All Together and a Weekly Report/3. Project #5 - Copying and Pasting Data with VBA.vtt 11KB
  222. 37. Project #6 Working with Excel VBA User Forms/8. Project #6 Adding VBA Code to the Create Report Button.vtt 11KB
  223. 6. Formatting Data in an Excel Worksheet/7. Creating Styles to Format Data.vtt 11KB
  224. 37. Project #6 Working with Excel VBA User Forms/4. Project #6 Adding VBA Code to the Initialize Event.vtt 10KB
  225. 36. Project #5 Bringing it All Together and a Weekly Report/2. Project #5 Creating the Final Report Loop.vtt 10KB
  226. 28. Automating Repetitive Tasks in Excel with Macros/3. Creating a Macro with the Macro Recorder.vtt 10KB
  227. 13. Working with an Excel List/7. Format a List as a Table.vtt 10KB
  228. 26. Protecting Excel Worksheets and Workbooks/1. Protecting Specific Cells in a Worksheet.vtt 10KB
  229. 27. Mastering Excel's What If Tools/1. Working with Excel's Goal Seek Tool.vtt 10KB
  230. 19. Working with Large Sets of Excel Data/3. Print Options for Large Sets of Data.vtt 10KB
  231. 27. Mastering Excel's What If Tools/4. Creating Scenarios in Excel.vtt 10KB
  232. 31. Project #1 Using Excel's Macro Recorder Tool/2. Project #1 Start Recording!.vtt 10KB
  233. 23. Working with Excel's Lookup Functions/1. Using Excel's VLOOKUP() Function.vtt 10KB
  234. 32. Excel VBA Concepts/4. Creating an Excel VBA Procedure.vtt 10KB
  235. 38. Project #7 Importing Data from Text Files/5. Project #7 Creating a Loop to Read Each File.vtt 10KB
  236. 38. Project #7 Importing Data from Text Files/9. Project #7 Creating Reusable Code with a VBA Function.vtt 10KB
  237. 35. Project #4 Using VBA to Automate Excel Formulas/2. Project #4 Automate the SUM() Function through Code.vtt 10KB
  238. 22. Working with Excel's Conditional Functions/3. Nesting Functions.vtt 9KB
  239. 13. Working with an Excel List/6. Creating Subtotals in a List.vtt 9KB
  240. 18. Working with Excel's PowerPivot Tools/6. PowerPivot KPIs.vtt 9KB
  241. 17. Excel PivotTables/3. Modifying Excel PivotTable Calculations.vtt 9KB
  242. 3. Entering and Editing Text and Formulas/5. Creating Basic Formulas in Excel.vtt 9KB
  243. 33. Project #2 Moving Beyond the Basics and into VBA/3. Project #2 Prompting the User for Information.vtt 9KB
  244. 7. Inserting Images and Shapes into an Excel Worksheet/4. Working with Excel SmartArt.vtt 9KB
  245. 18. Working with Excel's PowerPivot Tools/3. Creating Data Models with PowerPivot.vtt 8KB
  246. 38. Project #7 Importing Data from Text Files/2. Project #7 Opening a Text File for Import.vtt 8KB
  247. 14. Excel List Functions/1. Excel Function DSUM().vtt 8KB
  248. 2. Microsoft Excel Fundamentals/7. Common Excel Shortcut Keys.html 8KB
  249. 17. Excel PivotTables/2. Creating an Excel PivotTable.vtt 8KB
  250. 14. Excel List Functions/4. Excel Function SUBTOTAL().vtt 8KB
  251. 33. Project #2 Moving Beyond the Basics and into VBA/4. Continue Excel VBA InputBox.vtt 8KB
  252. 32. Excel VBA Concepts/6. Understanding Excel VBA Variables.vtt 8KB
  253. 24. Working with Excel's Text Based Functions/1. Using Excel's LEFT(), RIGHT() and MID() Functions.vtt 8KB
  254. 22. Working with Excel's Conditional Functions/2. Using Excel's IF() Function.vtt 8KB
  255. 24. Working with Excel's Text Based Functions/2. Using Excel's LEN() Function.vtt 8KB
  256. 5. Modifying an Excel Worksheet/2. Inserting and Deleting Rows and Columns.vtt 8KB
  257. 10. Working with Excel Templates/2. Opening an Existing Template.vtt 8KB
  258. 30. Microsoft Excel Macros and VBA Course Introduction/1. Welcome to the Course.vtt 8KB
  259. 35. Project #4 Using VBA to Automate Excel Formulas/5. Project #4 Loop the SUM() Function Over Multiple Worksheets.vtt 8KB
  260. 22. Working with Excel's Conditional Functions/6. Using Excel's IFERROR() Function.vtt 8KB
  261. 13. Working with an Excel List/1. Understanding Excel List Structure.vtt 8KB
  262. 38. Project #7 Importing Data from Text Files/3. Project #7 Get Data from Text File.vtt 7KB
  263. 3. Entering and Editing Text and Formulas/1. Entering Text to Create Spreadsheet Titles.vtt 7KB
  264. 37. Project #6 Working with Excel VBA User Forms/2. Project #6 Creating an Excel User Form.vtt 7KB
  265. 16. Importing and Exporting Data/1. Importing Data from Text Files.vtt 7KB
  266. 22. Working with Excel's Conditional Functions/5. Using Excel's SUMIF() Function.vtt 7KB
  267. 27. Mastering Excel's What If Tools/3. Building Effective Data Tables in Excel.vtt 7KB
  268. 35. Project #4 Using VBA to Automate Excel Formulas/3. Continue Automate SUM Function.vtt 7KB
  269. 15. Excel Data Validation/2. Creating a Validation List.vtt 7KB
  270. 32. Excel VBA Concepts/7. Building Logic with an IF Statement.vtt 7KB
  271. 6. Formatting Data in an Excel Worksheet/4. Formatting Data as Currency Values.vtt 7KB
  272. 8. Creating Basic Charts in Excel/2. Working with the Excel Chart Ribbon.vtt 7KB
  273. 5. Modifying an Excel Worksheet/3. Changing the Width and Height of Cells.vtt 7KB
  274. 28. Automating Repetitive Tasks in Excel with Macros/4. Editing a Macro with VBA.vtt 7KB
  275. 8. Creating Basic Charts in Excel/6. Working with Excel Pie Charts.vtt 7KB
  276. 19. Working with Large Sets of Excel Data/5. Consolidating Data from Multiple Worksheets.vtt 7KB
  277. 30. Microsoft Excel Macros and VBA Course Introduction/2. Understanding the Why and How Behind Excel Macros.vtt 7KB
  278. 7. Inserting Images and Shapes into an Excel Worksheet/3. Formatting Excel Shapes.vtt 7KB
  279. 8. Creating Basic Charts in Excel/4. Formatting an Excel Chart.vtt 7KB
  280. 15. Excel Data Validation/1. Understanding the Need for Data Validation.vtt 7KB
  281. 4. Working with Basic Excel Functions/2. Working with the SUM() Function.vtt 7KB
  282. 4. Working with Basic Excel Functions/6. Using the AutoSum Command.vtt 7KB
  283. 22. Working with Excel's Conditional Functions/1. Working with Excel Name Ranges.vtt 7KB
  284. 8. Creating Basic Charts in Excel/1. Creating an Excel Column Chart.vtt 7KB
  285. 13. Working with an Excel List/5. Filter an Excel List Using the AutoFilter Tool.vtt 7KB
  286. 17. Excel PivotTables/4. Grouping PivotTable Data.vtt 6KB
  287. 9. Printing an Excel Worksheet/4. Adding Header and Footer Content.vtt 6KB
  288. 2. Microsoft Excel Fundamentals/2. Introduction to the Excel Interface.vtt 6KB
  289. 17. Excel PivotTables/5. Formatting PivotTable Data.vtt 6KB
  290. 5. Modifying an Excel Worksheet/1. Moving and Copying Data in an Excel Worksheet.vtt 6KB
  291. 10. Working with Excel Templates/3. Creating a Custom Template.vtt 6KB
  292. 3. Entering and Editing Text and Formulas/3. Entering Date Values in Excel.vtt 6KB
  293. 17. Excel PivotTables/7. Creating PivotCharts.vtt 6KB
  294. 2. Microsoft Excel Fundamentals/4. Understanding the Structure of an Excel Workbook.vtt 6KB
  295. 7. Inserting Images and Shapes into an Excel Worksheet/1. Inserting Images.vtt 6KB
  296. 13. Working with an Excel List/4. Using Custom Sorts in an Excel List.vtt 6KB
  297. 18. Working with Excel's PowerPivot Tools/1. Why PowerPivot.vtt 6KB
  298. 6. Formatting Data in an Excel Worksheet/9. Using Conditional Formatting.vtt 6KB
  299. 15. Excel Data Validation/3. Adding a Custom Validation Error.vtt 6KB
  300. 37. Project #6 Working with Excel VBA User Forms/5. Project #6 Adding VBA Code to the ComboBox Change Event.vtt 6KB
  301. 9. Printing an Excel Worksheet/3. Working with Page Layout View.vtt 6KB
  302. 5. Modifying an Excel Worksheet/7. Moving and Copying and Excel Worksheet.vtt 6KB
  303. 31. Project #1 Using Excel's Macro Recorder Tool/5. Project #1 Opps! I Need to Edit My Macro.vtt 6KB
  304. 16. Importing and Exporting Data/3. Exporting Data to a Text File.vtt 6KB
  305. 16. Importing and Exporting Data/2. Importing Data from Microsoft Access.vtt 6KB
  306. 6. Formatting Data in an Excel Worksheet/1. Working with Font Formatting Commands.vtt 5KB
  307. 33. Project #2 Moving Beyond the Basics and into VBA/5. Project #2 Building Logic into Your Macros.vtt 5KB
  308. 19. Working with Large Sets of Excel Data/2. Grouping Data (Columns andor Rows).vtt 5KB
  309. 15. Excel Data Validation/4. Dynamic Formulas by Using Validation Techniques.vtt 5KB
  310. 13. Working with an Excel List/9. Removing Duplicates.vtt 5KB
  311. 23. Working with Excel's Lookup Functions/2. Using Excel's HLOOKUP() Function.vtt 5KB
  312. 25. Auditing an Excel Worksheet/3. Working with the Watch Window.vtt 5KB
  313. 37. Project #6 Working with Excel VBA User Forms/7. Change Worksheet Name.vtt 5KB
  314. 25. Auditing an Excel Worksheet/1. Tracing Precendents in Excel Formulas.vtt 5KB
  315. 7. Inserting Images and Shapes into an Excel Worksheet/2. Inserting Excel Shapes.vtt 5KB
  316. 17. Excel PivotTables/8. Filtering PivotTable Data.vtt 5KB
  317. 26. Protecting Excel Worksheets and Workbooks/2. Protecting the Structure of a Workbook.vtt 5KB
  318. 2. Microsoft Excel Fundamentals/3. Customizing the Excel Quick Access Toolbar.vtt 5KB
  319. 18. Working with Excel's PowerPivot Tools/4. Creating PivotTables based on Data Models.vtt 5KB
  320. 19. Working with Large Sets of Excel Data/1. Using the Freeze Panes Tool.vtt 5KB
  321. 13. Working with an Excel List/2. Sorting a List Using Single Level Sort.vtt 5KB
  322. 19. Working with Large Sets of Excel Data/4. Linking Worksheets (3D Formulas).vtt 5KB
  323. 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/3. Project #3 Inserting the Headers.vtt 5KB
  324. 37. Project #6 Working with Excel VBA User Forms/3. Project #6 Adding Controls to the Form.vtt 5KB
  325. 13. Working with an Excel List/8. Using Conditional Formatting to Find Duplicates.vtt 5KB
  326. 22. Working with Excel's Conditional Functions/4. Using Excel's COUNTIF() Function.vtt 5KB
  327. 37. Project #6 Working with Excel VBA User Forms/9. Project #6 Showing the Form.vtt 5KB
  328. 4. Working with Basic Excel Functions/3. Working with the MIN() and MAX() Functions.vtt 5KB
  329. 18. Working with Excel's PowerPivot Tools/5. PowerPivot Calculated Fields.vtt 5KB
  330. 3. Entering and Editing Text and Formulas/4. Working with Cell References.vtt 5KB
  331. 35. Project #4 Using VBA to Automate Excel Formulas/4. Test the SUM Function.vtt 5KB
  332. 31. Project #1 Using Excel's Macro Recorder Tool/4. Project #1 Running a Macro with a Button.vtt 5KB
  333. 38. Project #7 Importing Data from Text Files/7. Project #7 Clear the Clipboard.vtt 5KB
  334. 28. Automating Repetitive Tasks in Excel with Macros/1. Understanding Excel Macros.vtt 5KB
  335. 17. Excel PivotTables/1. Understanding Excel PivotTables.vtt 5KB
  336. 6. Formatting Data in an Excel Worksheet/3. Adding Borders to Cells.vtt 5KB
  337. 32. Excel VBA Concepts/5. Adding Code to a VBA Procedure.vtt 5KB
  338. 13. Working with an Excel List/3. Sorting a List Using Multi-Level Sorts.vtt 5KB
  339. 4. Working with Basic Excel Functions/1. The structure of an Excel Function.vtt 5KB
  340. 32. Excel VBA Concepts/2. The Visual Basic Editor (VBE).vtt 5KB
  341. 38. Project #7 Importing Data from Text Files/8. Project #7 Working with the ScreenUpdating Property.vtt 5KB
  342. 37. Project #6 Working with Excel VBA User Forms/6. Project #6 Adding VBA Code to the Add Worksheet Button.vtt 4KB
  343. 3. Entering and Editing Text and Formulas/2. Working with Numeric Data in Excel.vtt 4KB
  344. 17. Excel PivotTables/9. Filtering with the Slicer Tool.vtt 4KB
  345. 33. Project #2 Moving Beyond the Basics and into VBA/2. Project #2 Breaking Down the VBA Code.vtt 4KB
  346. 17. Excel PivotTables/6. Drilling Down into PivotTable Data.vtt 4KB
  347. 32. Excel VBA Concepts/1. Excel VBA Concepts.vtt 4KB
  348. 33. Project #2 Moving Beyond the Basics and into VBA/7. Other Practical Uses of Message and Input Boxes.vtt 4KB
  349. 4. Working with Basic Excel Functions/7. Using the AutoFill Command to Copy Formulas.vtt 4KB
  350. 8. Creating Basic Charts in Excel/3. Adding and Modifying Data on an Excel Chart.vtt 4KB
  351. 3. Entering and Editing Text and Formulas/7. Understanding the Order of Operation.vtt 4KB
  352. 36. Project #5 Bringing it All Together and a Weekly Report/1. Introduction to Project #5 Creating the Final Report.vtt 4KB
  353. 28. Automating Repetitive Tasks in Excel with Macros/5. Creating Buttons to Run Macros.vtt 4KB
  354. 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/1. Introduction to Project #3 Cleaning Up and Formatting Data.vtt 4KB
  355. 6. Formatting Data in an Excel Worksheet/2. Changing the Background Color of a Cell.vtt 4KB
  356. 36. Project #5 Bringing it All Together and a Weekly Report/4. Project #5 - Running the Final Report Procedure.vtt 4KB
  357. 9. Printing an Excel Worksheet/5. Printing a Specific Range of Cells.vtt 4KB
  358. 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/6. Running the Loop.vtt 4KB
  359. 5. Modifying an Excel Worksheet/5. Deleting an Excel Worksheet.vtt 4KB
  360. 37. Project #6 Working with Excel VBA User Forms/1. Introduction to Project #6 Working with Excel VBA User Forms.vtt 4KB
  361. 26. Protecting Excel Worksheets and Workbooks/3. Adding a Workbook Password.vtt 4KB
  362. 14. Excel List Functions/3. Excel Function DCOUNT().vtt 4KB
  363. 5. Modifying an Excel Worksheet/4. Hiding and Unhiding Excel Rows and Columns.vtt 4KB
  364. 25. Auditing an Excel Worksheet/4. Showing Formulas.vtt 4KB
  365. 24. Working with Excel's Text Based Functions/4. Using Excel's CONCATENATE() Function.vtt 4KB
  366. 6. Formatting Data in an Excel Worksheet/6. Using Excel's Format Painter.vtt 4KB
  367. 2. Microsoft Excel Fundamentals/5. Saving an Excel Document.vtt 4KB
  368. 31. Project #1 Using Excel's Macro Recorder Tool/3. Running A Macro.vtt 4KB
  369. 38. Project #7 Importing Data from Text Files/1. Project #7 Opening a Text File for Import.vtt 4KB
  370. 4. Working with Basic Excel Functions/4. Working with the AVERAGE() Function.vtt 4KB
  371. 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/2. Project #3 Preparing to the Use the Macro Recorder.vtt 4KB
  372. 14. Excel List Functions/2. Excel Function DAVERAGE().vtt 4KB
  373. 33. Project #2 Moving Beyond the Basics and into VBA/1. Introduction to Project #2 Interacting with the User.vtt 4KB
  374. 25. Auditing an Excel Worksheet/2. Tracing Dependents in Excel Formulas.vtt 4KB
  375. 6. Formatting Data in an Excel Worksheet/8. Merging and Centering Cells.vtt 3KB
  376. 2. Microsoft Excel Fundamentals/1. Launching Excel.vtt 3KB
  377. 8. Creating Basic Charts in Excel/5. Moving a Chart to another Worksheet.vtt 3KB
  378. 34. Project #3 Preparing and Cleaning Up Data with a Little VBA/4. Project #3 Formatting the Headers.vtt 3KB
  379. 38. Project #7 Importing Data from Text Files/6. Project #7 Adding a New Sheet for Imported Data.vtt 3KB
  380. 18. Working with Excel's PowerPivot Tools/2. Activating the Excel PowerPivot AddIn.vtt 3KB
  381. 9. Printing an Excel Worksheet/1. Viewing your Document in Print Preview.vtt 3KB
  382. 6. Formatting Data in an Excel Worksheet/5. Formatting Percentages.vtt 3KB
  383. 31. Project #1 Using Excel's Macro Recorder Tool/6. Practical Uses of Excel Macros.vtt 3KB
  384. 4. Working with Basic Excel Functions/5. Working with the COUNT() Function.vtt 3KB
  385. 5. Modifying an Excel Worksheet/6. Renaming an Excel Worksheet.vtt 3KB
  386. 2. Microsoft Excel Fundamentals/6. Opening an Existing Excel Document.vtt 3KB
  387. 35. Project #4 Using VBA to Automate Excel Formulas/1. Introduction to Project #4 Automate Excel Formulas.vtt 3KB
  388. 31. Project #1 Using Excel's Macro Recorder Tool/1. Introduction to Project #1 Inserting and Formatting Text.vtt 3KB
  389. 32. Excel VBA Concepts/3. Excel VBA Modules.vtt 2KB
  390. 39. Course Wrap Up/2. BONUS! - Special Offer! Discount on Any of my Courses!.html 2KB
  391. 28. Automating Repetitive Tasks in Excel with Macros/2. Activating the Developer Tab in Excel.vtt 2KB
  392. 10. Working with Excel Templates/1. Intro to Excel Templates.vtt 2KB
  393. 38. Project #7 Importing Data from Text Files/1.4 April2015Sales.txt.txt 2KB
  394. 1. Microsoft Excel 101 Course Introduction/1. Course Exercise Files.vtt 2KB
  395. 29. Congratualtions!/1. Congratulations on Competing the Microsoft Excel 103.vtt 1KB
  396. 38. Project #7 Importing Data from Text Files/1.7 Nov2015Sales.txt.txt 1KB
  397. 38. Project #7 Importing Data from Text Files/1.3 Jan2015Sales.txt.txt 1KB
  398. 38. Project #7 Importing Data from Text Files/1.1 May2015Sales.txt.txt 1KB
  399. 38. Project #7 Importing Data from Text Files/1.2 Mar2015Sales.txt.txt 1KB
  400. 11. Congratulations! You've Built a Solid Microsoft Excel Foundation/1. Congratulations!.vtt 1KB
  401. 38. Project #7 Importing Data from Text Files/1.5 Feb2015Sales.txt.txt 1KB
  402. 39. Course Wrap Up/1. Congratulations! You're an Excel MacroVBA Master.vtt 1KB
  403. 38. Project #7 Importing Data from Text Files/1.6 Dec2015Sales.txt.txt 1KB
  404. 20. Congratulations! You're an Intermediate Excel User/1. Congratulations!.vtt 828B
  405. 21. Microsoft Excel 103 Course Introduction/1. Course Excerise Files - Download this Excel File First!.html 387B
  406. 30. Microsoft Excel Macros and VBA Course Introduction/3. Course Exercise Files - Download these First!.html 387B
  407. 12. Microsoft Excel 102 Course Introduction/1. Course Exercise Files - Download these First!.html 281B
  408. 2. Microsoft Excel Fundamentals/8. Excel Fundamentals Quiz.html 163B
  409. 3. Entering and Editing Text and Formulas/8. Entering and Editing Text and Formulas Quiz.html 163B
  410. 4. Working with Basic Excel Functions/8. Basic Excel Functions Quiz.html 163B
  411. 5. Modifying an Excel Worksheet/8. Modifying Worksheets Quiz.html 163B
  412. 6. Formatting Data in an Excel Worksheet/10. Formatting Data Quiz.html 163B
  413. 8. Creating Basic Charts in Excel/7. Working with Excel Charts Quiz.html 163B
  414. 9. Printing an Excel Worksheet/6. Printing and Excel Worksheet Quiz.html 163B
  415. [FCS Forum].url 133B
  416. [FreeCourseSite.com].url 127B
  417. [CourseClub.NET].url 123B