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

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

Name	Microsoft Excel 2013 Tutorial by UDEMY (From beginner to advanced and beyond	DOWNLOAD Copy Link
Total Size	3.6 GB
Total Files	204
Hash	2F16787760ACA848F6AB4B836069A6EF8A5DC5E3

/31-microsoft-excel-macros-and-vba-course-introduction/
134-course-exercise-files-download-these-first.html	0.7 KB
133-understanding-the-why-and-how-behind-excel-macros.mp4	14.2 MB
132-welcome-to-the-course.mp4	18.3 MB
/22-microsoft-excel-103-course-introduction/
101-course-excerise-files-download-this-excel-file-first.html	0.7 KB
/39-course-wrap-up/
174-bonus-special-offer-discount-on-any-of-my-courses.html	2.5 KB
173-congratulations-youre-an-excel-macrovba-master.mp4	38.9 MB
/13-microsoft-excel-102-course-introduction/
059-course-exercise-files-download-these-first.html	3.0 KB
/quizzes/
006-working-with-excel-charts-quiz.html	3.5 KB
/quizzes/
003-basic-excel-functions-quiz.html	4.2 KB
/quizzes/
004-modifying-worksheets-quiz.html	4.4 KB
/quizzes/
007-printing-and-excel-worksheet-quiz.html	4.7 KB
/quizzes/
002-entering-and-editing-text-and-formulas-quiz.html	5.0 KB
/quizzes/
005-formatting-data-quiz.html	5.2 KB
/quizzes/
001-excel-fundamentals-quiz.html	6.6 KB
/03-microsoft-excel-fundamentals/
009-common-excel-shortcut-keys.html	8.6 KB
008-opening-an-existing-excel-document.mp4	6.5 MB
007-saving-an-excel-document.mp4	7.6 MB
005-customizing-the-excel-quick-access-toolbar.mp4	10.4 MB
003-launching-excel.mp4	11.9 MB
004-introduction-to-the-excel-interface.mp4	12.9 MB
006-understanding-the-structure-of-an-excel-workbook.mp4	14.4 MB
/.../002-course-exercise-files/
MonthlyBudget-ReferenceTypes-01.xlsx	14.0 KB
MonthlyBudget-Headers-01.xlsx	14.0 KB
MonthlyBudget-BasicFormulas-01.xlsx	14.0 KB
MonthlyBudget-SUMFunction-01.xlsx	14.1 KB
MonthlyBudget-AutoFill-01.xlsx	14.2 KB
MonthlyBudget-MIN-MAXFunctions-01.xlsx	14.4 KB
MonthlyBudget-AverageFunction-01.xlsx	14.4 KB
MonthlyBudget-AutoSUM-01.xlsx	14.5 KB
MonthlyBudget-01.xlsx	14.6 KB
MonthlyBudget-Count-01.xlsx	14.6 KB
MonthlyBudget-Template-01.xlsx	14.9 KB
/.../134-course-exercise-files-download-these-first/
SortingRecords.xlsx	16.9 KB
InsertingAndFormattingText.xlsx	17.8 KB
AutomateFormulas.xlsx	19.3 KB
AutomateSumFunction.xlsx	20.3 KB
CleaningUpData.xlsx	21.3 KB
SortingRecords.xlsm	22.3 KB
QuarterlyReport.xlsm	27.1 KB
QuarterlyReportForm-01.xlsm	30.4 KB
/.../059-course-exercise-files-download-these-first/
Excel102Exercises.txt	26.5 KB
Excel102Exercises.xlsx	135.5 KB
NorthwindDB.zip	401.7 KB
/.../101-course-excerise-files-download-this-excel-file-first/
Excel103-AdvancedExercises.xlsx	64.5 KB
/02-microsoft-excel-101-course-introduction/
002-course-exercise-files.mp4	2.4 MB
/33-excel-vba-concepts/
140-excel-vba-concpets.mp4	3.1 MB
142-excel-vba-modules.mp4	5.8 MB
143-creating-an-excel-vba-procedure.mp4	10.7 MB
141-the-visual-basic-editor-vbe.mp4	10.9 MB
146-building-logic-with-an-if-statement.mp4	13.4 MB
145-working-with-excel-vba-loops-to-repeat-blocks-of-code.mp4	17.3 MB
144-understanding-excel-vba-variables.mp4	22.6 MB
/30-congratualtions/
131-congratulations-on-competing-the-microsoft-excel-103.mp4	3.6 MB
/06-modifying-an-excel-worksheet/
029-renaming-an-excel-worksheet.mp4	5.6 MB
028-deleting-an-excel-worksheet.mp4	8.5 MB
027-hiding-and-unhiding-excel-rows-and-columns.mp4	8.9 MB
024-moving-and-copying-data-in-an-excel-worksheet.mp4	11.4 MB
030-moving-and-copying-and-excel-worksheet.mp4	13.4 MB
026-changing-the-width-and-height-of-cells.mp4	17.2 MB
025-inserting-and-deleting-rows-and-columns.mp4	18.2 MB
/11-working-with-excel-templates/
055-intro-to-excel-templates.mp4	5.6 MB
057-creating-a-custom-template.mp4	17.1 MB
056-opening-an-existing-template.mp4	23.4 MB
/12-congratulations-youve-built-a-solid-microsoft-excel-foundation/
058-congratulations.mp4	5.8 MB
/10-printing-an-excel-worksheet/
050-viewing-your-document-in-print-preview.mp4	6.2 MB
054-printing-a-specific-range-of-cells.mp4	11.0 MB
052-working-with-page-layout-view.mp4	14.6 MB
053-adding-header-and-footer-content.mp4	15.1 MB
051-changing-the-margins-scaling-and-orientation.mp4	22.0 MB
/04-entering-and-editing-text-and-formulas/
016-understanding-the-order-of-operation.mp4	6.8 MB
011-working-with-numeric-data-in-excel.mp4	8.6 MB
013-working-with-cell-references.mp4	10.1 MB
010-entering-text-to-create-spreadsheet-titles.mp4	12.3 MB
012-entering-date-values-in-excel.mp4	12.3 MB
014-creating-basic-formulas-in-excel.mp4	18.4 MB
015-relative-versus-absolute-cell-references-in-formulas.mp4	30.4 MB
/05-working-with-basic-excel-functions/
021-working-with-the-count-function.mp4	7.0 MB
020-working-with-the-average-function.mp4	8.2 MB
017-the-structure-of-an-excel-function.mp4	8.5 MB
023-using-the-autofill-command-to-copy-formulas.mp4	10.0 MB
019-working-with-the-min-and-max-functions.mp4	12.2 MB
018-working-with-the-sum-function.mp4	14.6 MB
022-using-the-autosum-command.mp4	15.7 MB
/07-formatting-data-in-an-excel-worksheet/
035-formatting-percentages.mp4	7.4 MB
032-changing-the-background-color-of-a-cell.mp4	9.0 MB
036-using-excels-format-painter.mp4	9.4 MB
038-merging-and-centering-cells.mp4	10.3 MB
033-adding-borders-to-cells.mp4	11.0 MB
031-working-with-font-formatting-commands.mp4	12.3 MB
039-using-conditional-formatting.mp4	16.0 MB
034-formatting-data-as-currency-values.mp4	17.3 MB
037-creating-styles-to-format-data.mp4	30.5 MB
/09-creating-basic-charts-in-excel/
048-moving-a-chart-to-another-worksheet.mp4	7.8 MB
046-adding-and-modifying-data-on-an-excel-chart.mp4	12.9 MB
047-formatting-an-excel-chart.mp4	14.5 MB
045-working-with-the-excel-chart-ribbon.mp4	16.4 MB
049-working-with-excel-pie-charts.mp4	17.7 MB
044-creating-an-excel-column-chart.mp4	17.8 MB
/19-working-with-excels-powerpivot-tools/
090-activating-the-excel-powerpivot-addin.mp4	8.5 MB
092-creating-pivottables-based-on-data-models.mp4	21.4 MB
093-powerpivot-calculated-fields.mp4	25.2 MB
089-why-powerpivot.mp4	34.2 MB
094-powerpivot-kpis.mp4	37.6 MB
091-creating-data-models-with-powerpivot.mp4	48.1 MB
/21-congratulations-youre-an-intermediate-excel-user/
100-congratulations.mp4	9.1 MB
/29-automating-repetitive-tasks-in-excel-with-macros/
127-activating-the-developer-tab-in-excel.mp4	10.8 MB
130-creating-buttons-to-run-macros.mp4	20.7 MB
126-understanding-excel-macros.mp4	24.1 MB
129-editing-a-macro-with-vba.mp4	26.6 MB
128-creating-a-macro-with-the-macro-recorder.mp4	48.6 MB
/32-project-1-using-excels-macro-recorder-tool/
135-introduction-to-project-1-inserting-and-formatting-text.mp4	11.4 MB
137-project-1-running-a-macro-with-a-button.mp4	14.6 MB
139-practical-uses-of-excel-macros.mp4	19.4 MB
138-project-1-opps-i-need-to-edit-my-macro.mp4	27.8 MB
136-project-1-start-recording.mp4	36.3 MB
/38-project-6-working-with-excel-vba-user-forms/
171-project-6-adding-vba-code-to-the-create-report-button.mp4	12.0 MB
166-project-6-adding-controls-to-the-form.mp4	16.2 MB
165-project-6-creating-an-excel-user-form.mp4	16.6 MB
164-introduction-to-project-6-working-with-excel-vba-user-forms.mp4	18.3 MB
172-project-6-showing-the-form.mp4	18.6 MB
170-project-6-adding-vba-code-to-the-add-worksheet-button.mp4	22.7 MB
169-project-6-adding-vba-code-to-the-combobox-change-event.mp4	27.1 MB
167-project-6-changing-control-and-form-properties.mp4	29.7 MB
168-project-6-adding-vba-code-to-the-initialize-event.mp4	38.6 MB
/25-working-with-excels-text-based-functions/
114-using-excels-concatenate-function.mp4	12.4 MB
111-using-excels-left-right-and-mid-functions.mp4	31.8 MB
112-using-excels-len-function.mp4	39.0 MB
113-using-excels-search-function.mp4	43.9 MB
/20-working-with-large-sets-of-excel-data/
098-linking-worksheets-3d-formulas.mp4	12.6 MB
099-consolidating-data-from-multiple-worksheets.mp4	19.0 MB
095-using-the-freeze-panes-tool.mp4	23.5 MB
096-grouping-data-columns-andor-rows.mp4	28.9 MB
097-print-options-for-large-sets-of-data.mp4	43.0 MB
/27-protecting-excel-worksheets-and-workbooks/
120-protecting-the-structure-of-a-workbook.mp4	12.9 MB
121-adding-a-workbook-password.mp4	15.0 MB
119-protecting-specific-cells-in-a-worksheet.mp4	41.5 MB
/26-auditing-an-excel-worksheet/
118-showing-formulas.mp4	13.5 MB
116-tracing-dependents-in-excel-formuals.mp4	14.8 MB
117-working-with-the-watch-window.mp4	16.0 MB
115-tracing-precendents-in-excel-formulas.mp4	20.6 MB
/08-inserting-images-and-shapes-into-an-excel-worksheet/
041-inserting-excel-shapes.mp4	13.9 MB
040-inserting-images.mp4	14.9 MB
042-formatting-excel-shapes.mp4	16.1 MB
043-working-with-excel-smartart.mp4	20.2 MB
/35-project-3-preparing-and-cleaning-up-data-with-a-little-vba/
154-project-3-using-the-macro-recorder-to-lay-the-foundation.mp4	15.4 MB
155-project-3-preparing-to-the-use-the-macro-recorder.mp4	18.5 MB
156-project-3-inserting-the-headers.mp4	22.5 MB
153-introduction-to-project-3-cleaning-up-and-formatting-data.mp4	26.8 MB
157-project-3-formatting-the-headers.mp4	42.3 MB
158-project-3-putting-it-all-together-with-a-little-vba.mp4	60.4 MB
/17-importing-and-exporting-data/
078-importing-data-from-microsoft-access.mp4	17.7 MB
077-importing-data-from-text-files.mp4	20.0 MB
079-exporting-data-to-a-text-file.mp4	23.6 MB
/18-excel-pivottables/
083-grouping-pivottable-data.mp4	18.0 MB
087-filtering-pivottable-data.mp4	18.0 MB
088-filtering-with-the-slicer-tool.mp4	18.9 MB
084-formatting-pivottable-data.mp4	20.5 MB
085-drilling-down-into-pivottable-data.mp4	22.1 MB
086-creating-pivotcharts.mp4	23.6 MB
080-understanding-excel-pivottables.mp4	24.4 MB
082-modifying-excel-pivottable-calculations.mp4	27.8 MB
081-creating-an-excel-pivottable.mp4	31.5 MB
/15-excel-list-functions/
070-excel-function-daverage.mp4	18.4 MB
071-excel-function-dcount.mp4	20.2 MB
069-excel-function-dsum.mp4	41.5 MB
072-excel-function-subtotal.mp4	42.6 MB
/24-working-with-excels-lookup-functions/
109-using-excels-hlookup-function.mp4	18.6 MB
108-using-excels-vlookup-function.mp4	37.5 MB
110-using-excels-index-and-match-functions.mp4	67.1 MB
/36-project-4-using-vba-to-automate-excel-formulas/
159-introduction-to-project-4-automate-excel-formulas.mp4	19.8 MB
161-project-4-loop-the-sum-function-over-multiple-worksheets.mp4	29.8 MB
160-project-4-automate-the-sum-function-through-code.mp4	51.7 MB
/23-working-with-excels-conditional-functions/
105-using-excels-countif-function.mp4	20.0 MB
102-working-with-excel-name-ranges.mp4	23.4 MB
107-using-excels-iferror-function.mp4	24.1 MB
103-using-excels-if-function.mp4	28.2 MB
106-using-excels-sumif-function.mp4	30.6 MB
104-nesting-functions.mp4	36.6 MB
/28-mastering-excels-what-if-tools/
124-building-effective-data-tables-in-excel.mp4	20.3 MB
122-working-with-excels-goal-seek-tool.mp4	25.1 MB
125-creating-scenarios-in-excel.mp4	37.3 MB
123-working-with-excels-solver-tool.mp4	46.9 MB
/14-working-with-an-excel-list/
061-sorting-a-list-using-single-level-sort.mp4	21.3 MB
062-sorting-a-list-using-multilevel-sorts.mp4	21.4 MB
063-using-custom-sorts-in-an-excel-list.mp4	21.5 MB
064-filter-an-excel-list-using-the-autofilter-tool.mp4	21.8 MB
067-using-conditional-formatting-to-find-duplicates.mp4	23.9 MB
068-removing-duplicates.mp4	24.0 MB
060-understanding-excel-list-structure.mp4	30.8 MB
065-creating-subtotals-in-a-list.mp4	41.6 MB
066-format-a-list-as-a-table.mp4	44.8 MB
/34-project-2-moving-beyond-the-basics-and-into-vba/
148-project-2-breaking-down-the-vba-code.mp4	21.4 MB
147-introduction-to-project-2-interacting-with-the-user.mp4	21.5 MB
150-project-2-building-logic-into-your-macros.mp4	23.4 MB
152-other-practical-uses-of-message-and-input-boxes.mp4	25.6 MB
149-project-2-prompting-the-user-for-information.mp4	27.9 MB
151-project-2-alerting-the-user-of-errors.mp4	32.4 MB
/16-excel-data-validation/
075-adding-a-custom-validation-error.mp4	21.6 MB
076-dynamic-formulas-by-using-validation-techniques.mp4	23.6 MB
073-understanding-the-need-for-data-validation.mp4	23.8 MB
074-creating-a-validation-list.mp4	27.2 MB
/01-microsoft-excel-course-introduction/
001-welcome-to-the-ultimate-microsoft-excel-course.mp4	24.5 MB
/37-project-5-bringing-it-all-together-and-a-weekly-report/
162-introduction-to-project-5-creating-the-final-report.mp4	25.1 MB
163-project-5-putting-it-all-together-to-create-a-final-report.mp4	44.3 MB
Total files 204