589689.xyz

Microsoft Excel 2013 Tutorial by UDEMY (From beginner to advanced and beyond

  • 收录时间:2018-12-14 13:28:23
  • 文件大小:3GB
  • 下载次数:134
  • 最近下载:2020-11-23 02:20:00
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 24-working-with-excels-lookup-functions/110-using-excels-index-and-match-functions.mp4 64MB
  2. 35-project-3-preparing-and-cleaning-up-data-with-a-little-vba/158-project-3-putting-it-all-together-with-a-little-vba.mp4 58MB
  3. 36-project-4-using-vba-to-automate-excel-formulas/160-project-4-automate-the-sum-function-through-code.mp4 49MB
  4. 29-automating-repetitive-tasks-in-excel-with-macros/128-creating-a-macro-with-the-macro-recorder.mp4 46MB
  5. 19-working-with-excels-powerpivot-tools/091-creating-data-models-with-powerpivot.mp4 46MB
  6. 28-mastering-excels-what-if-tools/123-working-with-excels-solver-tool.mp4 45MB
  7. 14-working-with-an-excel-list/066-format-a-list-as-a-table.mp4 43MB
  8. 37-project-5-bringing-it-all-together-and-a-weekly-report/163-project-5-putting-it-all-together-to-create-a-final-report.mp4 42MB
  9. 25-working-with-excels-text-based-functions/113-using-excels-search-function.mp4 42MB
  10. 20-working-with-large-sets-of-excel-data/097-print-options-for-large-sets-of-data.mp4 41MB
  11. 15-excel-list-functions/072-excel-function-subtotal.mp4 41MB
  12. 35-project-3-preparing-and-cleaning-up-data-with-a-little-vba/157-project-3-formatting-the-headers.mp4 40MB
  13. 14-working-with-an-excel-list/065-creating-subtotals-in-a-list.mp4 40MB
  14. 15-excel-list-functions/069-excel-function-dsum.mp4 40MB
  15. 27-protecting-excel-worksheets-and-workbooks/119-protecting-specific-cells-in-a-worksheet.mp4 40MB
  16. 25-working-with-excels-text-based-functions/112-using-excels-len-function.mp4 37MB
  17. 39-course-wrap-up/173-congratulations-youre-an-excel-macrovba-master.mp4 37MB
  18. 38-project-6-working-with-excel-vba-user-forms/168-project-6-adding-vba-code-to-the-initialize-event.mp4 37MB
  19. 19-working-with-excels-powerpivot-tools/094-powerpivot-kpis.mp4 36MB
  20. 24-working-with-excels-lookup-functions/108-using-excels-vlookup-function.mp4 36MB
  21. 28-mastering-excels-what-if-tools/125-creating-scenarios-in-excel.mp4 36MB
  22. 23-working-with-excels-conditional-functions/104-nesting-functions.mp4 35MB
  23. 32-project-1-using-excels-macro-recorder-tool/136-project-1-start-recording.mp4 35MB
  24. 19-working-with-excels-powerpivot-tools/089-why-powerpivot.mp4 33MB
  25. 34-project-2-moving-beyond-the-basics-and-into-vba/151-project-2-alerting-the-user-of-errors.mp4 31MB
  26. 25-working-with-excels-text-based-functions/111-using-excels-left-right-and-mid-functions.mp4 30MB
  27. 18-excel-pivottables/081-creating-an-excel-pivottable.mp4 30MB
  28. 14-working-with-an-excel-list/060-understanding-excel-list-structure.mp4 29MB
  29. 23-working-with-excels-conditional-functions/106-using-excels-sumif-function.mp4 29MB
  30. 07-formatting-data-in-an-excel-worksheet/037-creating-styles-to-format-data.mp4 29MB
  31. 04-entering-and-editing-text-and-formulas/015-relative-versus-absolute-cell-references-in-formulas.mp4 29MB
  32. 36-project-4-using-vba-to-automate-excel-formulas/161-project-4-loop-the-sum-function-over-multiple-worksheets.mp4 28MB
  33. 38-project-6-working-with-excel-vba-user-forms/167-project-6-changing-control-and-form-properties.mp4 28MB
  34. 20-working-with-large-sets-of-excel-data/096-grouping-data-columns-andor-rows.mp4 28MB
  35. 23-working-with-excels-conditional-functions/103-using-excels-if-function.mp4 27MB
  36. 34-project-2-moving-beyond-the-basics-and-into-vba/149-project-2-prompting-the-user-for-information.mp4 27MB
  37. 18-excel-pivottables/082-modifying-excel-pivottable-calculations.mp4 27MB
  38. 32-project-1-using-excels-macro-recorder-tool/138-project-1-opps-i-need-to-edit-my-macro.mp4 27MB
  39. 16-excel-data-validation/074-creating-a-validation-list.mp4 26MB
  40. 38-project-6-working-with-excel-vba-user-forms/169-project-6-adding-vba-code-to-the-combobox-change-event.mp4 26MB
  41. 35-project-3-preparing-and-cleaning-up-data-with-a-little-vba/153-introduction-to-project-3-cleaning-up-and-formatting-data.mp4 26MB
  42. 29-automating-repetitive-tasks-in-excel-with-macros/129-editing-a-macro-with-vba.mp4 25MB
  43. 34-project-2-moving-beyond-the-basics-and-into-vba/152-other-practical-uses-of-message-and-input-boxes.mp4 24MB
  44. 19-working-with-excels-powerpivot-tools/093-powerpivot-calculated-fields.mp4 24MB
  45. 28-mastering-excels-what-if-tools/122-working-with-excels-goal-seek-tool.mp4 24MB
  46. 37-project-5-bringing-it-all-together-and-a-weekly-report/162-introduction-to-project-5-creating-the-final-report.mp4 24MB
  47. 01-microsoft-excel-course-introduction/001-welcome-to-the-ultimate-microsoft-excel-course.mp4 23MB
  48. 18-excel-pivottables/080-understanding-excel-pivottables.mp4 23MB
  49. 23-working-with-excels-conditional-functions/107-using-excels-iferror-function.mp4 23MB
  50. 29-automating-repetitive-tasks-in-excel-with-macros/126-understanding-excel-macros.mp4 23MB
  51. 14-working-with-an-excel-list/068-removing-duplicates.mp4 23MB
  52. 14-working-with-an-excel-list/067-using-conditional-formatting-to-find-duplicates.mp4 23MB
  53. 16-excel-data-validation/073-understanding-the-need-for-data-validation.mp4 23MB
  54. 18-excel-pivottables/086-creating-pivotcharts.mp4 23MB
  55. 16-excel-data-validation/076-dynamic-formulas-by-using-validation-techniques.mp4 23MB
  56. 17-importing-and-exporting-data/079-exporting-data-to-a-text-file.mp4 22MB
  57. 20-working-with-large-sets-of-excel-data/095-using-the-freeze-panes-tool.mp4 22MB
  58. 34-project-2-moving-beyond-the-basics-and-into-vba/150-project-2-building-logic-into-your-macros.mp4 22MB
  59. 23-working-with-excels-conditional-functions/102-working-with-excel-name-ranges.mp4 22MB
  60. 11-working-with-excel-templates/056-opening-an-existing-template.mp4 22MB
  61. 38-project-6-working-with-excel-vba-user-forms/170-project-6-adding-vba-code-to-the-add-worksheet-button.mp4 22MB
  62. 33-excel-vba-concepts/144-understanding-excel-vba-variables.mp4 22MB
  63. 35-project-3-preparing-and-cleaning-up-data-with-a-little-vba/156-project-3-inserting-the-headers.mp4 21MB
  64. 18-excel-pivottables/085-drilling-down-into-pivottable-data.mp4 21MB
  65. 10-printing-an-excel-worksheet/051-changing-the-margins-scaling-and-orientation.mp4 21MB
  66. 14-working-with-an-excel-list/064-filter-an-excel-list-using-the-autofilter-tool.mp4 21MB
  67. 16-excel-data-validation/075-adding-a-custom-validation-error.mp4 21MB
  68. 34-project-2-moving-beyond-the-basics-and-into-vba/147-introduction-to-project-2-interacting-with-the-user.mp4 20MB
  69. 14-working-with-an-excel-list/063-using-custom-sorts-in-an-excel-list.mp4 20MB
  70. 19-working-with-excels-powerpivot-tools/092-creating-pivottables-based-on-data-models.mp4 20MB
  71. 14-working-with-an-excel-list/062-sorting-a-list-using-multilevel-sorts.mp4 20MB
  72. 34-project-2-moving-beyond-the-basics-and-into-vba/148-project-2-breaking-down-the-vba-code.mp4 20MB
  73. 14-working-with-an-excel-list/061-sorting-a-list-using-single-level-sort.mp4 20MB
  74. 29-automating-repetitive-tasks-in-excel-with-macros/130-creating-buttons-to-run-macros.mp4 20MB
  75. 26-auditing-an-excel-worksheet/115-tracing-precendents-in-excel-formulas.mp4 20MB
  76. 18-excel-pivottables/084-formatting-pivottable-data.mp4 20MB
  77. 28-mastering-excels-what-if-tools/124-building-effective-data-tables-in-excel.mp4 19MB
  78. 15-excel-list-functions/071-excel-function-dcount.mp4 19MB
  79. 08-inserting-images-and-shapes-into-an-excel-worksheet/043-working-with-excel-smartart.mp4 19MB
  80. 23-working-with-excels-conditional-functions/105-using-excels-countif-function.mp4 19MB
  81. 17-importing-and-exporting-data/077-importing-data-from-text-files.mp4 19MB
  82. 36-project-4-using-vba-to-automate-excel-formulas/159-introduction-to-project-4-automate-excel-formulas.mp4 19MB
  83. 32-project-1-using-excels-macro-recorder-tool/139-practical-uses-of-excel-macros.mp4 19MB
  84. 20-working-with-large-sets-of-excel-data/099-consolidating-data-from-multiple-worksheets.mp4 18MB
  85. 18-excel-pivottables/088-filtering-with-the-slicer-tool.mp4 18MB
  86. 38-project-6-working-with-excel-vba-user-forms/172-project-6-showing-the-form.mp4 18MB
  87. 24-working-with-excels-lookup-functions/109-using-excels-hlookup-function.mp4 18MB
  88. 35-project-3-preparing-and-cleaning-up-data-with-a-little-vba/155-project-3-preparing-to-the-use-the-macro-recorder.mp4 18MB
  89. 15-excel-list-functions/070-excel-function-daverage.mp4 18MB
  90. 04-entering-and-editing-text-and-formulas/014-creating-basic-formulas-in-excel.mp4 18MB
  91. 38-project-6-working-with-excel-vba-user-forms/164-introduction-to-project-6-working-with-excel-vba-user-forms.mp4 17MB
  92. 31-microsoft-excel-macros-and-vba-course-introduction/132-welcome-to-the-course.mp4 17MB
  93. 06-modifying-an-excel-worksheet/025-inserting-and-deleting-rows-and-columns.mp4 17MB
  94. 18-excel-pivottables/087-filtering-pivottable-data.mp4 17MB
  95. 18-excel-pivottables/083-grouping-pivottable-data.mp4 17MB
  96. 09-creating-basic-charts-in-excel/044-creating-an-excel-column-chart.mp4 17MB
  97. 17-importing-and-exporting-data/078-importing-data-from-microsoft-access.mp4 17MB
  98. 09-creating-basic-charts-in-excel/049-working-with-excel-pie-charts.mp4 17MB
  99. 33-excel-vba-concepts/145-working-with-excel-vba-loops-to-repeat-blocks-of-code.mp4 16MB
  100. 07-formatting-data-in-an-excel-worksheet/034-formatting-data-as-currency-values.mp4 16MB
  101. 06-modifying-an-excel-worksheet/026-changing-the-width-and-height-of-cells.mp4 16MB
  102. 11-working-with-excel-templates/057-creating-a-custom-template.mp4 16MB
  103. 38-project-6-working-with-excel-vba-user-forms/165-project-6-creating-an-excel-user-form.mp4 16MB
  104. 09-creating-basic-charts-in-excel/045-working-with-the-excel-chart-ribbon.mp4 16MB
  105. 38-project-6-working-with-excel-vba-user-forms/166-project-6-adding-controls-to-the-form.mp4 15MB
  106. 08-inserting-images-and-shapes-into-an-excel-worksheet/042-formatting-excel-shapes.mp4 15MB
  107. 07-formatting-data-in-an-excel-worksheet/039-using-conditional-formatting.mp4 15MB
  108. 26-auditing-an-excel-worksheet/117-working-with-the-watch-window.mp4 15MB
  109. 05-working-with-basic-excel-functions/022-using-the-autosum-command.mp4 15MB
  110. 35-project-3-preparing-and-cleaning-up-data-with-a-little-vba/154-project-3-using-the-macro-recorder-to-lay-the-foundation.mp4 15MB
  111. 10-printing-an-excel-worksheet/053-adding-header-and-footer-content.mp4 14MB
  112. 27-protecting-excel-worksheets-and-workbooks/121-adding-a-workbook-password.mp4 14MB
  113. 08-inserting-images-and-shapes-into-an-excel-worksheet/040-inserting-images.mp4 14MB
  114. 26-auditing-an-excel-worksheet/116-tracing-dependents-in-excel-formuals.mp4 14MB
  115. 10-printing-an-excel-worksheet/052-working-with-page-layout-view.mp4 14MB
  116. 32-project-1-using-excels-macro-recorder-tool/137-project-1-running-a-macro-with-a-button.mp4 14MB
  117. 05-working-with-basic-excel-functions/018-working-with-the-sum-function.mp4 14MB
  118. 09-creating-basic-charts-in-excel/047-formatting-an-excel-chart.mp4 14MB
  119. 03-microsoft-excel-fundamentals/006-understanding-the-structure-of-an-excel-workbook.mp4 14MB
  120. 31-microsoft-excel-macros-and-vba-course-introduction/133-understanding-the-why-and-how-behind-excel-macros.mp4 14MB
  121. 08-inserting-images-and-shapes-into-an-excel-worksheet/041-inserting-excel-shapes.mp4 13MB
  122. 26-auditing-an-excel-worksheet/118-showing-formulas.mp4 13MB
  123. 33-excel-vba-concepts/146-building-logic-with-an-if-statement.mp4 13MB
  124. 06-modifying-an-excel-worksheet/030-moving-and-copying-and-excel-worksheet.mp4 13MB
  125. 03-microsoft-excel-fundamentals/004-introduction-to-the-excel-interface.mp4 12MB
  126. 27-protecting-excel-worksheets-and-workbooks/120-protecting-the-structure-of-a-workbook.mp4 12MB
  127. 09-creating-basic-charts-in-excel/046-adding-and-modifying-data-on-an-excel-chart.mp4 12MB
  128. 20-working-with-large-sets-of-excel-data/098-linking-worksheets-3d-formulas.mp4 12MB
  129. 25-working-with-excels-text-based-functions/114-using-excels-concatenate-function.mp4 12MB
  130. 07-formatting-data-in-an-excel-worksheet/031-working-with-font-formatting-commands.mp4 12MB
  131. 04-entering-and-editing-text-and-formulas/012-entering-date-values-in-excel.mp4 12MB
  132. 04-entering-and-editing-text-and-formulas/010-entering-text-to-create-spreadsheet-titles.mp4 12MB
  133. 05-working-with-basic-excel-functions/019-working-with-the-min-and-max-functions.mp4 12MB
  134. 38-project-6-working-with-excel-vba-user-forms/171-project-6-adding-vba-code-to-the-create-report-button.mp4 11MB
  135. 03-microsoft-excel-fundamentals/003-launching-excel.mp4 11MB
  136. 06-modifying-an-excel-worksheet/024-moving-and-copying-data-in-an-excel-worksheet.mp4 11MB
  137. 32-project-1-using-excels-macro-recorder-tool/135-introduction-to-project-1-inserting-and-formatting-text.mp4 11MB
  138. 10-printing-an-excel-worksheet/054-printing-a-specific-range-of-cells.mp4 11MB
  139. 07-formatting-data-in-an-excel-worksheet/033-adding-borders-to-cells.mp4 10MB
  140. 33-excel-vba-concepts/141-the-visual-basic-editor-vbe.mp4 10MB
  141. 29-automating-repetitive-tasks-in-excel-with-macros/127-activating-the-developer-tab-in-excel.mp4 10MB
  142. 33-excel-vba-concepts/143-creating-an-excel-vba-procedure.mp4 10MB
  143. 03-microsoft-excel-fundamentals/005-customizing-the-excel-quick-access-toolbar.mp4 10MB
  144. 07-formatting-data-in-an-excel-worksheet/038-merging-and-centering-cells.mp4 10MB
  145. 04-entering-and-editing-text-and-formulas/013-working-with-cell-references.mp4 10MB
  146. 05-working-with-basic-excel-functions/023-using-the-autofill-command-to-copy-formulas.mp4 10MB
  147. 07-formatting-data-in-an-excel-worksheet/036-using-excels-format-painter.mp4 9MB
  148. 21-congratulations-youre-an-intermediate-excel-user/100-congratulations.mp4 9MB
  149. 07-formatting-data-in-an-excel-worksheet/032-changing-the-background-color-of-a-cell.mp4 9MB
  150. 06-modifying-an-excel-worksheet/027-hiding-and-unhiding-excel-rows-and-columns.mp4 8MB
  151. 04-entering-and-editing-text-and-formulas/011-working-with-numeric-data-in-excel.mp4 8MB
  152. 05-working-with-basic-excel-functions/017-the-structure-of-an-excel-function.mp4 8MB
  153. 06-modifying-an-excel-worksheet/028-deleting-an-excel-worksheet.mp4 8MB
  154. 19-working-with-excels-powerpivot-tools/090-activating-the-excel-powerpivot-addin.mp4 8MB
  155. 05-working-with-basic-excel-functions/020-working-with-the-average-function.mp4 8MB
  156. 09-creating-basic-charts-in-excel/048-moving-a-chart-to-another-worksheet.mp4 7MB
  157. 03-microsoft-excel-fundamentals/007-saving-an-excel-document.mp4 7MB
  158. 07-formatting-data-in-an-excel-worksheet/035-formatting-percentages.mp4 7MB
  159. 05-working-with-basic-excel-functions/021-working-with-the-count-function.mp4 7MB
  160. 04-entering-and-editing-text-and-formulas/016-understanding-the-order-of-operation.mp4 6MB
  161. 03-microsoft-excel-fundamentals/008-opening-an-existing-excel-document.mp4 6MB
  162. 10-printing-an-excel-worksheet/050-viewing-your-document-in-print-preview.mp4 6MB
  163. 12-congratulations-youve-built-a-solid-microsoft-excel-foundation/058-congratulations.mp4 6MB
  164. 33-excel-vba-concepts/142-excel-vba-modules.mp4 6MB
  165. 11-working-with-excel-templates/055-intro-to-excel-templates.mp4 5MB
  166. 06-modifying-an-excel-worksheet/029-renaming-an-excel-worksheet.mp4 5MB
  167. 30-congratualtions/131-congratulations-on-competing-the-microsoft-excel-103.mp4 3MB
  168. 33-excel-vba-concepts/140-excel-vba-concpets.mp4 3MB
  169. 02-microsoft-excel-101-course-introduction/002-course-exercise-files.mp4 2MB
  170. 13-microsoft-excel-102-course-introduction/attached_files/059-course-exercise-files-download-these-first/NorthwindDB.zip 392KB
  171. 13-microsoft-excel-102-course-introduction/attached_files/059-course-exercise-files-download-these-first/Excel102Exercises.xlsx 132KB
  172. 22-microsoft-excel-103-course-introduction/attached_files/101-course-excerise-files-download-this-excel-file-first/Excel103-AdvancedExercises.xlsx 63KB
  173. 31-microsoft-excel-macros-and-vba-course-introduction/attached_files/134-course-exercise-files-download-these-first/QuarterlyReportForm-01.xlsm 30KB
  174. 31-microsoft-excel-macros-and-vba-course-introduction/attached_files/134-course-exercise-files-download-these-first/QuarterlyReport.xlsm 26KB
  175. 13-microsoft-excel-102-course-introduction/attached_files/059-course-exercise-files-download-these-first/Excel102Exercises.txt 26KB
  176. 31-microsoft-excel-macros-and-vba-course-introduction/attached_files/134-course-exercise-files-download-these-first/SortingRecords.xlsm 22KB
  177. 31-microsoft-excel-macros-and-vba-course-introduction/attached_files/134-course-exercise-files-download-these-first/CleaningUpData.xlsx 21KB
  178. 31-microsoft-excel-macros-and-vba-course-introduction/attached_files/134-course-exercise-files-download-these-first/AutomateSumFunction.xlsx 20KB
  179. 31-microsoft-excel-macros-and-vba-course-introduction/attached_files/134-course-exercise-files-download-these-first/AutomateFormulas.xlsx 19KB
  180. 31-microsoft-excel-macros-and-vba-course-introduction/attached_files/134-course-exercise-files-download-these-first/InsertingAndFormattingText.xlsx 17KB
  181. 31-microsoft-excel-macros-and-vba-course-introduction/attached_files/134-course-exercise-files-download-these-first/SortingRecords.xlsx 16KB
  182. 02-microsoft-excel-101-course-introduction/attached_files/002-course-exercise-files/MonthlyBudget-Template-01.xlsx 15KB
  183. 02-microsoft-excel-101-course-introduction/attached_files/002-course-exercise-files/MonthlyBudget-Count-01.xlsx 14KB
  184. 02-microsoft-excel-101-course-introduction/attached_files/002-course-exercise-files/MonthlyBudget-01.xlsx 14KB
  185. 02-microsoft-excel-101-course-introduction/attached_files/002-course-exercise-files/MonthlyBudget-AutoSUM-01.xlsx 14KB
  186. 02-microsoft-excel-101-course-introduction/attached_files/002-course-exercise-files/MonthlyBudget-AverageFunction-01.xlsx 14KB
  187. 02-microsoft-excel-101-course-introduction/attached_files/002-course-exercise-files/MonthlyBudget-MIN-MAXFunctions-01.xlsx 14KB
  188. 02-microsoft-excel-101-course-introduction/attached_files/002-course-exercise-files/MonthlyBudget-AutoFill-01.xlsx 14KB
  189. 02-microsoft-excel-101-course-introduction/attached_files/002-course-exercise-files/MonthlyBudget-SUMFunction-01.xlsx 14KB
  190. 02-microsoft-excel-101-course-introduction/attached_files/002-course-exercise-files/MonthlyBudget-BasicFormulas-01.xlsx 14KB
  191. 02-microsoft-excel-101-course-introduction/attached_files/002-course-exercise-files/MonthlyBudget-Headers-01.xlsx 14KB
  192. 02-microsoft-excel-101-course-introduction/attached_files/002-course-exercise-files/MonthlyBudget-ReferenceTypes-01.xlsx 14KB
  193. 03-microsoft-excel-fundamentals/009-common-excel-shortcut-keys.html 8KB
  194. 03-microsoft-excel-fundamentals/quizzes/001-excel-fundamentals-quiz.html 6KB
  195. 07-formatting-data-in-an-excel-worksheet/quizzes/005-formatting-data-quiz.html 5KB
  196. 04-entering-and-editing-text-and-formulas/quizzes/002-entering-and-editing-text-and-formulas-quiz.html 5KB
  197. 10-printing-an-excel-worksheet/quizzes/007-printing-and-excel-worksheet-quiz.html 5KB
  198. 06-modifying-an-excel-worksheet/quizzes/004-modifying-worksheets-quiz.html 4KB
  199. 05-working-with-basic-excel-functions/quizzes/003-basic-excel-functions-quiz.html 4KB
  200. 09-creating-basic-charts-in-excel/quizzes/006-working-with-excel-charts-quiz.html 3KB
  201. 13-microsoft-excel-102-course-introduction/059-course-exercise-files-download-these-first.html 3KB
  202. 39-course-wrap-up/174-bonus-special-offer-discount-on-any-of-my-courses.html 2KB
  203. 22-microsoft-excel-103-course-introduction/101-course-excerise-files-download-this-excel-file-first.html 725B
  204. 31-microsoft-excel-macros-and-vba-course-introduction/134-course-exercise-files-download-these-first.html 715B