|
|
001-excel-fundamentals-quiz.html
|
HTML
|
6.4 KB
|
|
|
001-welcome-to-the-ultimate-microsoft-excel-course.mp4
|
MP4
|
23.4 MB
|
|
|
002-course-exercise-files.mp4
|
MP4
|
2.3 MB
|
|
|
002-entering-and-editing-text-and-formulas-quiz.html
|
HTML
|
4.8 KB
|
|
|
003-basic-excel-functions-quiz.html
|
HTML
|
4 KB
|
|
|
003-launching-excel.mp4
|
MP4
|
11.3 MB
|
|
|
004-introduction-to-the-excel-interface.mp4
|
MP4
|
12.3 MB
|
|
|
004-modifying-worksheets-quiz.html
|
HTML
|
4.2 KB
|
|
|
005-customizing-the-excel-quick-access-toolbar.mp4
|
MP4
|
9.9 MB
|
|
|
005-formatting-data-quiz.html
|
HTML
|
5 KB
|
|
|
006-understanding-the-structure-of-an-excel-workbook.mp4
|
MP4
|
13.7 MB
|
|
|
006-working-with-excel-charts-quiz.html
|
HTML
|
3.4 KB
|
|
|
007-printing-and-excel-worksheet-quiz.html
|
HTML
|
4.5 KB
|
|
|
007-saving-an-excel-document.mp4
|
MP4
|
7.3 MB
|
|
|
008-opening-an-existing-excel-document.mp4
|
MP4
|
6.2 MB
|
|
|
009-common-excel-shortcut-keys.html
|
HTML
|
8.4 KB
|
|
|
010-entering-text-to-create-spreadsheet-titles.mp4
|
MP4
|
11.7 MB
|
|
|
011-working-with-numeric-data-in-excel.mp4
|
MP4
|
8.2 MB
|
|
|
012-entering-date-values-in-excel.mp4
|
MP4
|
11.8 MB
|
|
|
013-working-with-cell-references.mp4
|
MP4
|
9.6 MB
|
|
|
014-creating-basic-formulas-in-excel.mp4
|
MP4
|
17.6 MB
|
|
|
015-relative-versus-absolute-cell-references-in-formulas.mp4
|
MP4
|
29 MB
|
|
|
016-understanding-the-order-of-operation.mp4
|
MP4
|
6.5 MB
|
|
|
017-the-structure-of-an-excel-function.mp4
|
MP4
|
8.1 MB
|
|
|
018-working-with-the-sum-function.mp4
|
MP4
|
13.9 MB
|
|
|
019-working-with-the-min-and-max-functions.mp4
|
MP4
|
11.6 MB
|
|
|
020-working-with-the-average-function.mp4
|
MP4
|
7.8 MB
|
|
|
021-working-with-the-count-function.mp4
|
MP4
|
6.7 MB
|
|
|
022-using-the-autosum-command.mp4
|
MP4
|
15 MB
|
|
|
023-using-the-autofill-command-to-copy-formulas.mp4
|
MP4
|
9.5 MB
|
|
|
024-moving-and-copying-data-in-an-excel-worksheet.mp4
|
MP4
|
10.9 MB
|
|
|
025-inserting-and-deleting-rows-and-columns.mp4
|
MP4
|
17.4 MB
|
|
|
026-changing-the-width-and-height-of-cells.mp4
|
MP4
|
16.4 MB
|
|
|
027-hiding-and-unhiding-excel-rows-and-columns.mp4
|
MP4
|
8.5 MB
|
|
|
028-deleting-an-excel-worksheet.mp4
|
MP4
|
8.1 MB
|
|
|
029-renaming-an-excel-worksheet.mp4
|
MP4
|
5.3 MB
|
|
|
030-moving-and-copying-and-excel-worksheet.mp4
|
MP4
|
12.8 MB
|
|
|
031-working-with-font-formatting-commands.mp4
|
MP4
|
11.8 MB
|
|
|
032-changing-the-background-color-of-a-cell.mp4
|
MP4
|
8.6 MB
|
|
|
033-adding-borders-to-cells.mp4
|
MP4
|
10.5 MB
|
|
|
034-formatting-data-as-currency-values.mp4
|
MP4
|
16.5 MB
|
|
|
035-formatting-percentages.mp4
|
MP4
|
7 MB
|
|
|
036-using-excels-format-painter.mp4
|
MP4
|
8.9 MB
|
|
|
037-creating-styles-to-format-data.mp4
|
MP4
|
29.1 MB
|
|
|
038-merging-and-centering-cells.mp4
|
MP4
|
9.9 MB
|
|
|
039-using-conditional-formatting.mp4
|
MP4
|
15.3 MB
|
|
|
040-inserting-images.mp4
|
MP4
|
14.2 MB
|
|
|
041-inserting-excel-shapes.mp4
|
MP4
|
13.2 MB
|
|
|
042-formatting-excel-shapes.mp4
|
MP4
|
15.4 MB
|
|
|
043-working-with-excel-smartart.mp4
|
MP4
|
19.2 MB
|
|
|
044-creating-an-excel-column-chart.mp4
|
MP4
|
16.9 MB
|
|
|
045-working-with-the-excel-chart-ribbon.mp4
|
MP4
|
15.7 MB
|
|
|
046-adding-and-modifying-data-on-an-excel-chart.mp4
|
MP4
|
12.3 MB
|
|
|
047-formatting-an-excel-chart.mp4
|
MP4
|
13.8 MB
|
|
|
048-moving-a-chart-to-another-worksheet.mp4
|
MP4
|
7.4 MB
|
|
|
049-working-with-excel-pie-charts.mp4
|
MP4
|
16.9 MB
|
|
|
050-viewing-your-document-in-print-preview.mp4
|
MP4
|
5.9 MB
|
|
|
051-changing-the-margins-scaling-and-orientation.mp4
|
MP4
|
21 MB
|
|
|
052-working-with-page-layout-view.mp4
|
MP4
|
14 MB
|
|
|
053-adding-header-and-footer-content.mp4
|
MP4
|
14.4 MB
|
|
|
054-printing-a-specific-range-of-cells.mp4
|
MP4
|
10.5 MB
|
|
|
055-intro-to-excel-templates.mp4
|
MP4
|
5.4 MB
|
|
|
056-opening-an-existing-template.mp4
|
MP4
|
22.3 MB
|
|
|
057-creating-a-custom-template.mp4
|
MP4
|
16.3 MB
|
|
|
058-congratulations.mp4
|
MP4
|
5.5 MB
|
|
|
059-course-exercise-files-download-these-first.html
|
HTML
|
2.9 KB
|
|
|
060-understanding-excel-list-structure.mp4
|
MP4
|
29.4 MB
|
|
|
061-sorting-a-list-using-single-level-sort.mp4
|
MP4
|
20.3 MB
|
|
|
062-sorting-a-list-using-multilevel-sorts.mp4
|
MP4
|
20.4 MB
|
|
|
063-using-custom-sorts-in-an-excel-list.mp4
|
MP4
|
20.5 MB
|
|
|
064-filter-an-excel-list-using-the-autofilter-tool.mp4
|
MP4
|
20.8 MB
|
|
|
065-creating-subtotals-in-a-list.mp4
|
MP4
|
39.6 MB
|
|
|
066-format-a-list-as-a-table.mp4
|
MP4
|
42.7 MB
|
|
|
067-using-conditional-formatting-to-find-duplicates.mp4
|
MP4
|
22.8 MB
|
|
|
068-removing-duplicates.mp4
|
MP4
|
22.9 MB
|
|
|
069-excel-function-dsum.mp4
|
MP4
|
39.6 MB
|
|
|
070-excel-function-daverage.mp4
|
MP4
|
17.6 MB
|
|
|
071-excel-function-dcount.mp4
|
MP4
|
19.3 MB
|
|
|
072-excel-function-subtotal.mp4
|
MP4
|
40.6 MB
|
|
|
073-understanding-the-need-for-data-validation.mp4
|
MP4
|
22.7 MB
|
|
|
074-creating-a-validation-list.mp4
|
MP4
|
26 MB
|
|
|
075-adding-a-custom-validation-error.mp4
|
MP4
|
20.6 MB
|
|
|
076-dynamic-formulas-by-using-validation-techniques.mp4
|
MP4
|
22.5 MB
|
|
|
077-importing-data-from-text-files.mp4
|
MP4
|
19.1 MB
|
|
|
078-importing-data-from-microsoft-access.mp4
|
MP4
|
16.9 MB
|
|
|
079-exporting-data-to-a-text-file.mp4
|
MP4
|
22.5 MB
|
|
|
080-understanding-excel-pivottables.mp4
|
MP4
|
23.3 MB
|
|
|
081-creating-an-excel-pivottable.mp4
|
MP4
|
30 MB
|
|
|
082-modifying-excel-pivottable-calculations.mp4
|
MP4
|
26.6 MB
|
|
|
083-grouping-pivottable-data.mp4
|
MP4
|
17.2 MB
|
|
|
084-formatting-pivottable-data.mp4
|
MP4
|
19.5 MB
|
|
|
085-drilling-down-into-pivottable-data.mp4
|
MP4
|
21.1 MB
|
|
|
086-creating-pivotcharts.mp4
|
MP4
|
22.5 MB
|
|
|
087-filtering-pivottable-data.mp4
|
MP4
|
17.2 MB
|
|
|
088-filtering-with-the-slicer-tool.mp4
|
MP4
|
18.1 MB
|
|
|
089-why-powerpivot.mp4
|
MP4
|
32.6 MB
|
|
|
090-activating-the-excel-powerpivot-addin.mp4
|
MP4
|
8.1 MB
|
|
|
091-creating-data-models-with-powerpivot.mp4
|
MP4
|
45.8 MB
|
|
|
092-creating-pivottables-based-on-data-models.mp4
|
MP4
|
20.4 MB
|
|
|
093-powerpivot-calculated-fields.mp4
|
MP4
|
24 MB
|
|
|
094-powerpivot-kpis.mp4
|
MP4
|
35.9 MB
|
|
|
095-using-the-freeze-panes-tool.mp4
|
MP4
|
22.4 MB
|
|
|
096-grouping-data-columns-andor-rows.mp4
|
MP4
|
27.5 MB
|
|
|
097-print-options-for-large-sets-of-data.mp4
|
MP4
|
41 MB
|
|
|
098-linking-worksheets-3d-formulas.mp4
|
MP4
|
12 MB
|
|
|
099-consolidating-data-from-multiple-worksheets.mp4
|
MP4
|
18.1 MB
|
|
|
100-congratulations.mp4
|
MP4
|
8.6 MB
|
|
|
101-course-excerise-files-download-this-excel-file-first.html
|
HTML
|
716.8 B
|
|
|
102-working-with-excel-name-ranges.mp4
|
MP4
|
22.3 MB
|
|
|
103-using-excels-if-function.mp4
|
MP4
|
26.9 MB
|
|
|
104-nesting-functions.mp4
|
MP4
|
34.9 MB
|
|
|
105-using-excels-countif-function.mp4
|
MP4
|
19.1 MB
|
|
|
106-using-excels-sumif-function.mp4
|
MP4
|
29.2 MB
|
|
|
107-using-excels-iferror-function.mp4
|
MP4
|
23 MB
|
|
|
108-using-excels-vlookup-function.mp4
|
MP4
|
35.7 MB
|
|
|
109-using-excels-hlookup-function.mp4
|
MP4
|
17.7 MB
|
|
|
110-using-excels-index-and-match-functions.mp4
|
MP4
|
64 MB
|
|
|
111-using-excels-left-right-and-mid-functions.mp4
|
MP4
|
30.4 MB
|
|
|
112-using-excels-len-function.mp4
|
MP4
|
37.1 MB
|
|
|
113-using-excels-search-function.mp4
|
MP4
|
41.9 MB
|
|
|
114-using-excels-concatenate-function.mp4
|
MP4
|
11.9 MB
|
|
|
115-tracing-precendents-in-excel-formulas.mp4
|
MP4
|
19.6 MB
|
|
|
116-tracing-dependents-in-excel-formuals.mp4
|
MP4
|
14.1 MB
|
|
|
117-working-with-the-watch-window.mp4
|
MP4
|
15.3 MB
|
|
|
118-showing-formulas.mp4
|
MP4
|
12.9 MB
|
|
|
119-protecting-specific-cells-in-a-worksheet.mp4
|
MP4
|
39.5 MB
|
|
|
120-protecting-the-structure-of-a-workbook.mp4
|
MP4
|
12.3 MB
|
|
|
121-adding-a-workbook-password.mp4
|
MP4
|
14.3 MB
|
|
|
122-working-with-excels-goal-seek-tool.mp4
|
MP4
|
23.9 MB
|
|
|
123-working-with-excels-solver-tool.mp4
|
MP4
|
44.8 MB
|
|
|
124-building-effective-data-tables-in-excel.mp4
|
MP4
|
19.4 MB
|
|
|
125-creating-scenarios-in-excel.mp4
|
MP4
|
35.5 MB
|
|
|
126-understanding-excel-macros.mp4
|
MP4
|
23 MB
|
|
|
127-activating-the-developer-tab-in-excel.mp4
|
MP4
|
10.3 MB
|
|
|
128-creating-a-macro-with-the-macro-recorder.mp4
|
MP4
|
46.4 MB
|
|
|
129-editing-a-macro-with-vba.mp4
|
MP4
|
25.4 MB
|
|
|
130-creating-buttons-to-run-macros.mp4
|
MP4
|
19.7 MB
|
|
|
131-congratulations-on-competing-the-microsoft-excel-103.mp4
|
MP4
|
3.4 MB
|
|
|
132-welcome-to-the-course.mp4
|
MP4
|
17.4 MB
|
|
|
133-understanding-the-why-and-how-behind-excel-macros.mp4
|
MP4
|
13.6 MB
|
|
|
134-course-exercise-files-download-these-first.html
|
HTML
|
716.8 B
|
|
|
135-introduction-to-project-1-inserting-and-formatting-text.mp4
|
MP4
|
10.9 MB
|
|
|
136-project-1-start-recording.mp4
|
MP4
|
34.6 MB
|
|
|
137-project-1-running-a-macro-with-a-button.mp4
|
MP4
|
13.9 MB
|
|
|
138-project-1-opps-i-need-to-edit-my-macro.mp4
|
MP4
|
26.5 MB
|
|
|
139-practical-uses-of-excel-macros.mp4
|
MP4
|
18.5 MB
|
|
|
140-excel-vba-concpets.mp4
|
MP4
|
2.9 MB
|
|
|
141-the-visual-basic-editor-vbe.mp4
|
MP4
|
10.4 MB
|
|
|
142-excel-vba-modules.mp4
|
MP4
|
5.5 MB
|
|
|
143-creating-an-excel-vba-procedure.mp4
|
MP4
|
10.2 MB
|
|
|
144-understanding-excel-vba-variables.mp4
|
MP4
|
21.5 MB
|
|
|
145-working-with-excel-vba-loops-to-repeat-blocks-of-code.mp4
|
MP4
|
16.5 MB
|
|
|
146-building-logic-with-an-if-statement.mp4
|
MP4
|
12.8 MB
|
|
|
147-introduction-to-project-2-interacting-with-the-user.mp4
|
MP4
|
20.5 MB
|
|
|
148-project-2-breaking-down-the-vba-code.mp4
|
MP4
|
20.4 MB
|
|
|
149-project-2-prompting-the-user-for-information.mp4
|
MP4
|
26.6 MB
|
|
|
150-project-2-building-logic-into-your-macros.mp4
|
MP4
|
22.3 MB
|
|
|
151-project-2-alerting-the-user-of-errors.mp4
|
MP4
|
30.9 MB
|
|
|
152-other-practical-uses-of-message-and-input-boxes.mp4
|
MP4
|
24.4 MB
|
|
|
153-introduction-to-project-3-cleaning-up-and-formatting-data.mp4
|
MP4
|
25.6 MB
|
|
|
154-project-3-using-the-macro-recorder-to-lay-the-foundation.mp4
|
MP4
|
14.7 MB
|
|
|
155-project-3-preparing-to-the-use-the-macro-recorder.mp4
|
MP4
|
17.6 MB
|
|
|
156-project-3-inserting-the-headers.mp4
|
MP4
|
21.4 MB
|
|
|
157-project-3-formatting-the-headers.mp4
|
MP4
|
40.3 MB
|
|
|
158-project-3-putting-it-all-together-with-a-little-vba.mp4
|
MP4
|
57.6 MB
|
|
|
159-introduction-to-project-4-automate-excel-formulas.mp4
|
MP4
|
18.9 MB
|
|
|
160-project-4-automate-the-sum-function-through-code.mp4
|
MP4
|
49.3 MB
|
|
|
161-project-4-loop-the-sum-function-over-multiple-worksheets.mp4
|
MP4
|
28.4 MB
|
|
|
162-introduction-to-project-5-creating-the-final-report.mp4
|
MP4
|
23.9 MB
|
|
|
163-project-5-putting-it-all-together-to-create-a-final-report.mp4
|
MP4
|
42.2 MB
|
|
|
164-introduction-to-project-6-working-with-excel-vba-user-forms.mp4
|
MP4
|
17.5 MB
|
|
|
165-project-6-creating-an-excel-user-form.mp4
|
MP4
|
15.9 MB
|
|
|
166-project-6-adding-controls-to-the-form.mp4
|
MP4
|
15.5 MB
|
|
|
167-project-6-changing-control-and-form-properties.mp4
|
MP4
|
28.3 MB
|
|
|
168-project-6-adding-vba-code-to-the-initialize-event.mp4
|
MP4
|
36.8 MB
|
|
|
169-project-6-adding-vba-code-to-the-combobox-change-event.mp4
|
MP4
|
25.8 MB
|
|
|
170-project-6-adding-vba-code-to-the-add-worksheet-button.mp4
|
MP4
|
21.6 MB
|
|
|
171-project-6-adding-vba-code-to-the-create-report-button.mp4
|
MP4
|
11.4 MB
|
|
|
172-project-6-showing-the-form.mp4
|
MP4
|
17.7 MB
|
|
|
173-congratulations-youre-an-excel-macrovba-master.mp4
|
MP4
|
37.1 MB
|
|
|
174-bonus-special-offer-discount-on-any-of-my-courses.html
|
HTML
|
2.4 KB
|
|
|
AutomateFormulas.xlsx
|
XLSX
|
18.9 KB
|
|
|
AutomateSumFunction.xlsx
|
XLSX
|
19.8 KB
|
|
|
CleaningUpData.xlsx
|
XLSX
|
20.8 KB
|
|
|
Excel102Exercises.txt
|
TXT
|
25.5 KB
|
|
|
Excel102Exercises.xlsx
|
XLSX
|
132.3 KB
|
|
|
Excel103-AdvancedExercises.xlsx
|
XLSX
|
63 KB
|
|
|
InsertingAndFormattingText.xlsx
|
XLSX
|
17.4 KB
|
|
|
MonthlyBudget-01.xlsx
|
XLSX
|
14.3 KB
|
|
|
MonthlyBudget-AutoFill-01.xlsx
|
XLSX
|
13.8 KB
|
|
|
MonthlyBudget-AutoSUM-01.xlsx
|
XLSX
|
14.1 KB
|
|
|
MonthlyBudget-AverageFunction-01.xlsx
|
XLSX
|
14.1 KB
|
|
|
MonthlyBudget-BasicFormulas-01.xlsx
|
XLSX
|
13.7 KB
|
|
|
MonthlyBudget-Count-01.xlsx
|
XLSX
|
14.3 KB
|
|
|
MonthlyBudget-Headers-01.xlsx
|
XLSX
|
13.7 KB
|
|
|
MonthlyBudget-MIN-MAXFunctions-01.xlsx
|
XLSX
|
14 KB
|
|
|
MonthlyBudget-ReferenceTypes-01.xlsx
|
XLSX
|
13.7 KB
|
|
|
MonthlyBudget-SUMFunction-01.xlsx
|
XLSX
|
13.8 KB
|
|
|
MonthlyBudget-Template-01.xlsx
|
XLSX
|
14.5 KB
|
|
|
NorthwindDB.zip
|
ZIP
|
392.3 KB
|
|
|
QuarterlyReport.xlsm
|
XLSM
|
26.5 KB
|
|
|
QuarterlyReportForm-01.xlsm
|
XLSM
|
29.7 KB
|
|
|
SortingRecords.xlsm
|
XLSM
|
21.8 KB
|
|
|
SortingRecords.xlsx
|
XLSX
|
16.5 KB
|
|
|
[CourseClub.NET].txt
|
TXT
|
1.2 KB
|
|
|
[CourseClub.NET].url
|
URL
|
102.4 B
|
|
|
[FreeCourseSite.com].txt
|
TXT
|
1.1 KB
|
|
|
[FreeCourseSite.com].url
|
URL
|
102.4 B
|
