Everyday Excel Specialization

Files Included :

01 welcome-to-everyday-excel.mp4 (7.46 MB)
MP4
02 what-will-i-learn-in-the-course.mp4 (17.5 MB)
MP4
09 how-to-switch-sessions-of-the-course.mp4 (1.23 MB)
MP4
01 week-1-preview.mp4 (11.33 MB)
MP4
02 basic-features-of-excel.mp4 (19.91 MB)
MP4
03 saving-and-opening-files.mp4 (5.22 MB)
MP4
04 sheets-cells-rows-and-columns-part-1.mp4 (12.27 MB)
MP4
05 sheets-cells-rows-and-columns-part-2.mp4 (19.28 MB)
MP4
07 moving-around-the-worksheet.mp4 (21.33 MB)
MP4
08 editing-the-worksheet.mp4 (11.27 MB)
MP4
09 cell-formatting-and-conditional-formatting.mp4 (23.7 MB)
MP4
10 auto-fill-and-fill-series.mp4 (22.59 MB)
MP4
11 optional-example-gantt-chart.mp4 (27.39 MB)
MP4
12 formats-for-numbers-dates-and-times.mp4 (21.07 MB)
MP4
13 cell-addressing-modes.mp4 (12.52 MB)
MP4
14 naming-cells-and-cell-ranges.mp4 (18.25 MB)
MP4
15 introduction-to-vba-macros.mp4 (22.13 MB)
MP4
16 excel-is-smart-quick-analysis-tool-and-ideas-tool.mp4 (9.97 MB)
MP4
17 setting-preferences-in-excel.mp4 (16.6 MB)
MP4
18 customizing-excel-to-english-formats.mp4 (2.98 MB)
MP4
02 assignment-1-preview-and-instructions.mp4 (4.39 MB)
MP4
01 week-2-preview.mp4 (3.46 MB)
MP4
02 excel-syntax-and-order-of-operations.mp4 (15.35 MB)
MP4
03 troubleshooting-excel-formulas.mp4 (13.74 MB)
MP4
04 introduction-to-functions-in-excel.mp4 (17.64 MB)
MP4
05 counting-summing-and-averaging-in-excel-part-1.mp4 (21.95 MB)
MP4
06 counting-summing-and-averaging-in-excel-part-2.mp4 (19.92 MB)
MP4
07 rounding-and-remainders.mp4 (15.02 MB)
MP4
08 examples-rounding-and-remainders.mp4 (13.06 MB)
MP4
09 random-numbers-combinations-and-permutations.mp4 (14.52 MB)
MP4
10 the-choose-function.mp4 (7.48 MB)
MP4
11 optional-the-convert-function-for-engineers-and-scientists.mp4 (6.17 MB)
MP4
02 assignment-2-preview-and-instructions.mp4 (8.84 MB)
MP4
01 week-3-preview.mp4 (4.33 MB)
MP4
02 making-named-ranges-dynamic.mp4 (14.35 MB)
MP4
03 previewing-compatibility-with-earlier-versions.mp4 (10.18 MB)
MP4
04 if-and-and-or.mp4 (15.41 MB)
MP4
05 advanced-logical-functions-in-excel.mp4 (31.36 MB)
MP4
06 flash-fill-advantages-and-disadvantages.mp4 (14.91 MB)
MP4
07 text-functions-in-excel-part-1.mp4 (16.58 MB)
MP4
08 text-functions-in-excel-part-2.mp4 (15.96 MB)
MP4
09 excels-financial-functions.mp4 (17.71 MB)
MP4
10 introduction-to-array-formulas.mp4 (14.09 MB)
MP4
11 introduction-to-vba-user-defined-functions.mp4 (12 MB)
MP4
02 assignment-3-preview-and-instructions.mp4 (4.76 MB)
MP4
01 week-4-preview.mp4 (5.58 MB)
MP4
02 applying-a-filter.mp4 (22.97 MB)
MP4
03 using-the-filter-function-office-365.mp4 (15.32 MB)
MP4
04 creating-an-excel-table.mp4 (28.49 MB)
MP4
05 data-validation-and-drop-down-lists.mp4 (30.38 MB)
MP4
06 sorting-data-in-excel.mp4 (20.11 MB)
MP4
07 the-sort-and-sortby-functions-office-365.mp4 (4.09 MB)
MP4
08 example-sorting-by-columns.mp4 (10.3 MB)
MP4
09 cleaning-your-data.mp4 (20.3 MB)
MP4
10 removing-duplicates.mp4 (16.86 MB)
MP4
11 consolidating-data.mp4 (13.54 MB)
MP4
12 one-way-lookup-functions-part-1.mp4 (14.95 MB)
MP4
13 one-way-lookup-functions-part-2.mp4 (14.11 MB)
MP4
14 the-xlookup-function.mp4 (6 MB)
MP4
02 assignment-4-preview-and-instructions.mp4 (7.24 MB)
MP4
01 week-5-preview.mp4 (6.21 MB)
MP4
02 scatter-plots-in-excel-part-1.mp4 (28.21 MB)
MP4
03 scatter-plots-in-excel-part-2.mp4 (15.16 MB)
MP4
04 column-and-pie-charts-in-excel.mp4 (14.82 MB)
MP4
05 dynamic-charts.mp4 (29.8 MB)
MP4
06 introduction-to-pivot-tables.mp4 (18.63 MB)
MP4
07 slicers.mp4 (12.46 MB)
MP4
08 sparklines.mp4 (11.08 MB)
MP4
09 sharing-worksheets-and-charts-in-word-and-powerpoint.mp4 (38.45 MB)
MP4
10 printing-excel-worksheets.mp4 (10.74 MB)
MP4
11 example-sales-invoice-as-pdf-file.mp4 (14.35 MB)
MP4
12 for-fun-importing-geographic-information.mp4 (17.33 MB)
MP4
02 assignment-5-preview-and-instructions.mp4 (4.39 MB)
MP4
07 how-to-switch-sessions-of-the-course.mp4 (1.23 MB)
MP4
01 week-1-preview.mp4 (8.85 MB)
MP4
02 optional-review-of-vlookup-match-index-and-offset-functions.mp4 (17.98 MB)
MP4
03 two-way-lookups-in-excel.mp4 (21.11 MB)
MP4
04 two-way-conditional-lookups.mp4 (27.18 MB)
MP4
05 finding-the-location-of-a-maximum.mp4 (25.21 MB)
MP4
06 conditional-drop-down-lists-data-validation.mp4 (27.84 MB)
MP4
07 conditional-formatting-based-on-formula.mp4 (27.35 MB)
MP4
08 example-conditional-formatting-to-identify-errors.mp4 (22.86 MB)
MP4
09 comparing-lists.mp4 (19.05 MB)
MP4
10 example-who-hasn-t-signed-up.mp4 (14.51 MB)
MP4
11 managing-duplicates-part-1.mp4 (22.24 MB)
MP4
12 managing-duplicates-part-2.mp4 (32.41 MB)
MP4
13 example-expiry-dates.mp4 (20.03 MB)
MP4
14 most-frequent-text.mp4 (6.47 MB)
MP4
01 assignment-1-preview-and-instructions.mp4 (6.39 MB)
MP4
02 more-about-the-offset-function.mp4 (11.34 MB)
MP4
01 week-2-preview.mp4 (4.77 MB)
MP4
02 customizing-excel-for-financial-applications.mp4 (9.6 MB)
MP4
03 time-value-of-money.mp4 (4.54 MB)
MP4
04 simple-and-compound-interest-part-1.mp4 (12.29 MB)
MP4
05 simple-and-compound-interest-part-2.mp4 (16.49 MB)
MP4
06 amortized-loans.mp4 (7 MB)
MP4
07 using-excel-to-create-an-amortization-schedule.mp4 (30.25 MB)
MP4
08 amortization-schedule-with-extra-payments.mp4 (15.09 MB)
MP4
09 effective-vs-nominal-interest-rate.mp4 (17.03 MB)
MP4
10 savings-accounts-with-payments-and-disbursements.mp4 (16.51 MB)
MP4
11 interest-only-loans.mp4 (8.32 MB)
MP4
12 lines-of-credit.mp4 (21.61 MB)
MP4
02 assignment-2-preview-and-instructions.mp4 (2.95 MB)
MP4
01 week-3-preview.mp4 (6.23 MB)
MP4
02 depreciation.mp4 (12.34 MB)
MP4
03 common-depreciation-methods-part-1.mp4 (20.36 MB)
MP4
04 common-depreciation-methods-part-2.mp4 (18.4 MB)
MP4
05 cash-flows-and-net-present-value-part-1.mp4 (11.96 MB)
MP4
06 cash-flows-and-net-present-value-part-2.mp4 (21.84 MB)
MP4
07 comparing-alternatives.mp4 (17.21 MB)
MP4
08 internal-rate-of-return-irr.mp4 (18.74 MB)
MP4
02 more-about-the-offset-function.mp4 (11.34 MB)
MP4
03 assignment-3-preview-and-instructions.mp4 (5.34 MB)
MP4
01 week-4-preview.mp4 (5.08 MB)
MP4
02 introduction-to-case-studies.mp4 (15.08 MB)
MP4
03 one-way-data-tables-part-1.mp4 (12.41 MB)
MP4
04 one-way-data-tables-part-2.mp4 (16.43 MB)
MP4
05 two-way-data-tables.mp4 (17.12 MB)
MP4
06 example-two-way-data-table.mp4 (7.94 MB)
MP4
07 goal-seek-and-solver-for-targeting-problems-part-1.mp4 (18.94 MB)
MP4
08 goal-seek-and-solver-for-targeting-problems-part-2.mp4 (14.56 MB)
MP4
09 solver-for-optimization-problems.mp4 (7.32 MB)
MP4
10 using-the-solver-with-constraints-part-1.mp4 (13.06 MB)
MP4
11 using-solver-with-constraints-part-2.mp4 (12.89 MB)
MP4
02 assignment-4-preview-and-instructions.mp4 (4.32 MB)
MP4
01 week-5-preview.mp4 (9 MB)
MP4
02 trendlines-part-1.mp4 (19.28 MB)
MP4
03 trendlines-part-2.mp4 (11.16 MB)
MP4
04 linear-interpolation.mp4 (21.25 MB)
MP4
05 model-building-part-1-simple-linear-regression.mp4 (21.91 MB)
MP4
06 model-building-part-2-general-linear-regression.mp4 (33.65 MB)
MP4
07 model-building-part-3-multilinear-regression.mp4 (23.85 MB)
MP4
08 optional-why-use-adjusted-r-squared-and-not-r-squared.mp4 (9.85 MB)
MP4
09 introduction-to-nonlinear-regression-logisitic-regression.mp4 (30.62 MB)
MP4
02 assignment-5-preview-and-instructions.mp4 (4.62 MB)
MP4
01 course-overview-and-introduction.mp4 (13.62 MB)
MP4
09 how-to-switch-sessions-of-the-course.mp4 (1.23 MB)
MP4
02 nearest-eighth-of-an-inch-preview.mp4 (1.74 MB)
MP4
02 world-bank-lookup-preview.mp4 (3.29 MB)
MP4
02 dynamic-amortization-schedule-hints-and-preview.mp4 (30.09 MB)
MP4
03 introduction-to-dynamic-array-functions.mp4 (25.78 MB)
MP4
02 longest-ladder-around-the-corner-preview.mp4 (3.85 MB)
MP4
02 dynamic-temperature-lookup-preview.mp4 (2.78 MB)
MP4
03 introduction-to-dynamic-array-functions.mp4 (25.88 MB)
MP4
02 how-to-perform-a-sensitivity-analysis.mp4 (35.68 MB)
MP4
03 sensitivity-analysis-hints-and-preview.mp4 (7.46 MB)
MP4
02 friday-the-13th-preview.mp4 (3.87 MB)
MP4
02 dynamic-data-cleaning-preview-and-hints.mp4 (26.29 MB)
MP4
03 introduction-to-dynamic-array-functions.mp4 (25.78 MB)
MP4
02 filtering-for-multiple-criteria.mp4 (15.76 MB)
MP4
03 historical-weather-lookup-part-a-preview.mp4 (7.31 MB)
MP4
02 bakery-shopping-list-preview.mp4 (4.48 MB)
MP4
02 dinner-sign-up-preview.mp4 (7.31 MB)
MP4
03 an-introduction-to-dynamic-array-functions.mp4 (25.78 MB)
MP4
02 distance-calculator-preview.mp4 (7.51 MB)
MP4
03 dealing-with-multiple-table-lookups.mp4 (25.75 MB)
MP4
04 how-to-reset-conditional-drop-down-lists.mp4 (28.83 MB)
MP4
02 rental-center-inventory-preview.mp4 (16.92 MB)
MP4
03 an-introduction-to-dynamic-array-functions.mp4 (25.78 MB)
MP4
04 dynamic-filtering-for-multiple-constraints.mp4 (37.09 MB)
MP4
05 how-to-reset-conditional-drop-down-lists.mp4 (28.83 MB)
MP4
02 matrix-approach-to-regression-part-1.mp4 (8.8 MB)
MP4
03 matrix-approach-to-regression-part-2.mp4 (13.82 MB)
MP4
04 real-time-regression-preview.mp4 (4.6 MB)
MP4
05 dynamic-array-hints-for-real-time-regression.mp4 (18.46 MB)
MP4
06 how-to-calculate-standard-error-and-adjusted-r-squared.mp4 (13.71 MB)
MP4
02 amortization-schedule-with-extra-payments-part-1.mp4 (38.12 MB)
MP4
03 amortization-schedule-with-extra-payments-part-2.mp4 (27.59 MB)
MP4
04 amortization-schedule-with-extra-payments-preview.mp4 (3.62 MB)
MP4
02 historical-weather-lookup-part-b-preview.mp4 (5.03 MB)
MP4
01 to-get-you-pumped-up-for-vba-preview-for-my-specialization-excel-vba-for.mp4 (11.41 MB)
MP4
03 francescas-french-bakery-preview.mp4 (11.12 MB)
MP4
05 top-hat-consolidator-preview.mp4 (15.49 MB)
MP4
06 how-to-calculate-column-averages-of-dynamic-arrays.mp4 (13.63 MB)
MP4