FreeTutorials Us microsoft-excel-2013-from-beginner-to-advanced-and-beyond

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