Microsoft Excel from Beginner to Advanced Udemy | 1C147F2D69C405EB0529E3CAC8A88501089707D7

Microsoft Excel from Beginner to Advanced Udemy

Name	Microsoft Excel - Excel from Beginner to Advanced [Udemy]	DOWNLOAD Copy Link
Total Size	3.6 GB
Total Files	205
Hash	1C147F2D69C405EB0529E3CAC8A88501089707D7

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