种子简介

种子名称： [FreeTutorials.Us] microsoft-excel-2013-from-beginner-to-advanced-and-beyond
文件类型： 视频
文件数目： 169个文件
文件大小： 3.33 GB
收录时间： 2019-9-17 16:51
已经下载： 3次
资源热度： 113
最近下载： 2024-5-20 00:18

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:98de43f63556bf98a835e186b2f835a8308ee838&dn=[FreeTutorials.Us] microsoft-excel-2013-from-beginner-to-advanced-and-beyond 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

[FreeTutorials.Us] microsoft-excel-2013-from-beginner-to-advanced-and-beyond.torrent

01-microsoft-excel-course-introduction/001-welcome-to-the-ultimate-microsoft-excel-course.mp423.41MB

02-microsoft-excel-101-course-introduction/002-course-exercise-files.mp42.32MB

03-microsoft-excel-fundamentals/003-launching-excel.mp411.32MB

03-microsoft-excel-fundamentals/004-introduction-to-the-excel-interface.mp412.34MB

03-microsoft-excel-fundamentals/005-customizing-the-excel-quick-access-toolbar.mp49.91MB

03-microsoft-excel-fundamentals/006-understanding-the-structure-of-an-excel-workbook.mp413.74MB

03-microsoft-excel-fundamentals/007-saving-an-excel-document.mp47.26MB

03-microsoft-excel-fundamentals/008-opening-an-existing-excel-document.mp46.19MB

04-entering-and-editing-text-and-formulas/010-entering-text-to-create-spreadsheet-titles.mp411.69MB

04-entering-and-editing-text-and-formulas/011-working-with-numeric-data-in-excel.mp48.24MB

04-entering-and-editing-text-and-formulas/012-entering-date-values-in-excel.mp411.75MB

04-entering-and-editing-text-and-formulas/013-working-with-cell-references.mp49.59MB

04-entering-and-editing-text-and-formulas/014-creating-basic-formulas-in-excel.mp417.58MB

04-entering-and-editing-text-and-formulas/015-relative-versus-absolute-cell-references-in-formulas.mp429.02MB

04-entering-and-editing-text-and-formulas/016-understanding-the-order-of-operation.mp46.5MB

05-working-with-basic-excel-functions/017-the-structure-of-an-excel-function.mp48.11MB

05-working-with-basic-excel-functions/018-working-with-the-sum-function.mp413.88MB

05-working-with-basic-excel-functions/019-working-with-the-min-and-max-functions.mp411.61MB

05-working-with-basic-excel-functions/020-working-with-the-average-function.mp47.82MB

05-working-with-basic-excel-functions/021-working-with-the-count-function.mp46.72MB

05-working-with-basic-excel-functions/022-using-the-autosum-command.mp415.01MB

05-working-with-basic-excel-functions/023-using-the-autofill-command-to-copy-formulas.mp49.51MB

06-modifying-an-excel-worksheet/024-moving-and-copying-data-in-an-excel-worksheet.mp410.9MB

06-modifying-an-excel-worksheet/025-inserting-and-deleting-rows-and-columns.mp417.35MB

06-modifying-an-excel-worksheet/026-changing-the-width-and-height-of-cells.mp416.37MB

06-modifying-an-excel-worksheet/027-hiding-and-unhiding-excel-rows-and-columns.mp48.5MB

06-modifying-an-excel-worksheet/028-deleting-an-excel-worksheet.mp48.11MB

06-modifying-an-excel-worksheet/029-renaming-an-excel-worksheet.mp45.33MB

06-modifying-an-excel-worksheet/030-moving-and-copying-and-excel-worksheet.mp412.78MB

07-formatting-data-in-an-excel-worksheet/031-working-with-font-formatting-commands.mp411.78MB

07-formatting-data-in-an-excel-worksheet/032-changing-the-background-color-of-a-cell.mp48.63MB

07-formatting-data-in-an-excel-worksheet/033-adding-borders-to-cells.mp410.49MB

07-formatting-data-in-an-excel-worksheet/034-formatting-data-as-currency-values.mp416.45MB

07-formatting-data-in-an-excel-worksheet/035-formatting-percentages.mp47.02MB

07-formatting-data-in-an-excel-worksheet/036-using-excels-format-painter.mp48.95MB

07-formatting-data-in-an-excel-worksheet/037-creating-styles-to-format-data.mp429.07MB

07-formatting-data-in-an-excel-worksheet/038-merging-and-centering-cells.mp49.86MB

07-formatting-data-in-an-excel-worksheet/039-using-conditional-formatting.mp415.27MB

08-inserting-images-and-shapes-into-an-excel-worksheet/040-inserting-images.mp414.2MB

08-inserting-images-and-shapes-into-an-excel-worksheet/041-inserting-excel-shapes.mp413.24MB

08-inserting-images-and-shapes-into-an-excel-worksheet/042-formatting-excel-shapes.mp415.35MB

08-inserting-images-and-shapes-into-an-excel-worksheet/043-working-with-excel-smartart.mp419.24MB

09-creating-basic-charts-in-excel/044-creating-an-excel-column-chart.mp416.95MB

09-creating-basic-charts-in-excel/045-working-with-the-excel-chart-ribbon.mp415.68MB

09-creating-basic-charts-in-excel/046-adding-and-modifying-data-on-an-excel-chart.mp412.29MB

09-creating-basic-charts-in-excel/047-formatting-an-excel-chart.mp413.81MB

09-creating-basic-charts-in-excel/048-moving-a-chart-to-another-worksheet.mp47.42MB

09-creating-basic-charts-in-excel/049-working-with-excel-pie-charts.mp416.89MB

10-printing-an-excel-worksheet/050-viewing-your-document-in-print-preview.mp45.91MB

10-printing-an-excel-worksheet/051-changing-the-margins-scaling-and-orientation.mp421MB

10-printing-an-excel-worksheet/052-working-with-page-layout-view.mp413.95MB

10-printing-an-excel-worksheet/053-adding-header-and-footer-content.mp414.38MB

10-printing-an-excel-worksheet/054-printing-a-specific-range-of-cells.mp410.52MB

11-working-with-excel-templates/055-intro-to-excel-templates.mp45.39MB

11-working-with-excel-templates/056-opening-an-existing-template.mp422.27MB

11-working-with-excel-templates/057-creating-a-custom-template.mp416.34MB

12-congratulations-youve-built-a-solid-microsoft-excel-foundation/058-congratulations.mp45.55MB

14-working-with-an-excel-list/060-understanding-excel-list-structure.mp429.38MB

14-working-with-an-excel-list/061-sorting-a-list-using-single-level-sort.mp420.27MB

14-working-with-an-excel-list/062-sorting-a-list-using-multilevel-sorts.mp420.4MB

14-working-with-an-excel-list/063-using-custom-sorts-in-an-excel-list.mp420.46MB

14-working-with-an-excel-list/064-filter-an-excel-list-using-the-autofilter-tool.mp420.78MB

14-working-with-an-excel-list/065-creating-subtotals-in-a-list.mp439.64MB

14-working-with-an-excel-list/066-format-a-list-as-a-table.mp442.73MB

14-working-with-an-excel-list/067-using-conditional-formatting-to-find-duplicates.mp422.83MB

14-working-with-an-excel-list/068-removing-duplicates.mp422.86MB

15-excel-list-functions/069-excel-function-dsum.mp439.62MB

15-excel-list-functions/070-excel-function-daverage.mp417.58MB

15-excel-list-functions/071-excel-function-dcount.mp419.3MB

15-excel-list-functions/072-excel-function-subtotal.mp440.63MB

16-excel-data-validation/073-understanding-the-need-for-data-validation.mp422.72MB

16-excel-data-validation/074-creating-a-validation-list.mp425.96MB

16-excel-data-validation/075-adding-a-custom-validation-error.mp420.63MB

16-excel-data-validation/076-dynamic-formulas-by-using-validation-techniques.mp422.5MB

17-importing-and-exporting-data/077-importing-data-from-text-files.mp419.08MB

17-importing-and-exporting-data/078-importing-data-from-microsoft-access.mp416.91MB

17-importing-and-exporting-data/079-exporting-data-to-a-text-file.mp422.48MB

18-excel-pivottables/080-understanding-excel-pivottables.mp423.29MB

18-excel-pivottables/081-creating-an-excel-pivottable.mp430MB

18-excel-pivottables/082-modifying-excel-pivottable-calculations.mp426.56MB

18-excel-pivottables/083-grouping-pivottable-data.mp417.15MB

18-excel-pivottables/084-formatting-pivottable-data.mp419.5MB

18-excel-pivottables/085-drilling-down-into-pivottable-data.mp421.07MB

18-excel-pivottables/086-creating-pivotcharts.mp422.53MB

18-excel-pivottables/087-filtering-pivottable-data.mp417.17MB

18-excel-pivottables/088-filtering-with-the-slicer-tool.mp418.06MB

19-working-with-excels-powerpivot-tools/089-why-powerpivot.mp432.62MB

19-working-with-excels-powerpivot-tools/090-activating-the-excel-powerpivot-addin.mp48.08MB

19-working-with-excels-powerpivot-tools/091-creating-data-models-with-powerpivot.mp445.84MB

19-working-with-excels-powerpivot-tools/092-creating-pivottables-based-on-data-models.mp420.42MB

19-working-with-excels-powerpivot-tools/093-powerpivot-calculated-fields.mp424.02MB

19-working-with-excels-powerpivot-tools/094-powerpivot-kpis.mp435.88MB

20-working-with-large-sets-of-excel-data/095-using-the-freeze-panes-tool.mp422.39MB

20-working-with-large-sets-of-excel-data/096-grouping-data-columns-andor-rows.mp427.53MB

20-working-with-large-sets-of-excel-data/097-print-options-for-large-sets-of-data.mp440.97MB

20-working-with-large-sets-of-excel-data/098-linking-worksheets-3d-formulas.mp411.98MB

20-working-with-large-sets-of-excel-data/099-consolidating-data-from-multiple-worksheets.mp418.14MB

21-congratulations-youre-an-intermediate-excel-user/100-congratulations.mp48.63MB

23-working-with-excels-conditional-functions/102-working-with-excel-name-ranges.mp422.31MB

23-working-with-excels-conditional-functions/103-using-excels-if-function.mp426.93MB

23-working-with-excels-conditional-functions/104-nesting-functions.mp434.94MB

23-working-with-excels-conditional-functions/105-using-excels-countif-function.mp419.11MB

23-working-with-excels-conditional-functions/106-using-excels-sumif-function.mp429.18MB

23-working-with-excels-conditional-functions/107-using-excels-iferror-function.mp423MB

24-working-with-excels-lookup-functions/108-using-excels-vlookup-function.mp435.73MB

24-working-with-excels-lookup-functions/109-using-excels-hlookup-function.mp417.73MB

24-working-with-excels-lookup-functions/110-using-excels-index-and-match-functions.mp463.96MB

25-working-with-excels-text-based-functions/111-using-excels-left-right-and-mid-functions.mp430.36MB

25-working-with-excels-text-based-functions/112-using-excels-len-function.mp437.15MB

25-working-with-excels-text-based-functions/113-using-excels-search-function.mp441.86MB

25-working-with-excels-text-based-functions/114-using-excels-concatenate-function.mp411.86MB

26-auditing-an-excel-worksheet/115-tracing-precendents-in-excel-formulas.mp419.62MB

26-auditing-an-excel-worksheet/116-tracing-dependents-in-excel-formuals.mp414.12MB

26-auditing-an-excel-worksheet/117-working-with-the-watch-window.mp415.25MB

26-auditing-an-excel-worksheet/118-showing-formulas.mp412.9MB

27-protecting-excel-worksheets-and-workbooks/119-protecting-specific-cells-in-a-worksheet.mp439.54MB

27-protecting-excel-worksheets-and-workbooks/120-protecting-the-structure-of-a-workbook.mp412.34MB

27-protecting-excel-worksheets-and-workbooks/121-adding-a-workbook-password.mp414.33MB

28-mastering-excels-what-if-tools/122-working-with-excels-goal-seek-tool.mp423.93MB

28-mastering-excels-what-if-tools/123-working-with-excels-solver-tool.mp444.76MB

28-mastering-excels-what-if-tools/124-building-effective-data-tables-in-excel.mp419.38MB

28-mastering-excels-what-if-tools/125-creating-scenarios-in-excel.mp435.53MB

29-automating-repetitive-tasks-in-excel-with-macros/126-understanding-excel-macros.mp422.97MB

29-automating-repetitive-tasks-in-excel-with-macros/127-activating-the-developer-tab-in-excel.mp410.33MB

29-automating-repetitive-tasks-in-excel-with-macros/128-creating-a-macro-with-the-macro-recorder.mp446.39MB

29-automating-repetitive-tasks-in-excel-with-macros/129-editing-a-macro-with-vba.mp425.39MB

29-automating-repetitive-tasks-in-excel-with-macros/130-creating-buttons-to-run-macros.mp419.75MB

30-congratualtions/131-congratulations-on-competing-the-microsoft-excel-103.mp43.4MB

31-microsoft-excel-macros-and-vba-course-introduction/132-welcome-to-the-course.mp417.42MB

31-microsoft-excel-macros-and-vba-course-introduction/133-understanding-the-why-and-how-behind-excel-macros.mp413.58MB

32-project-1-using-excels-macro-recorder-tool/135-introduction-to-project-1-inserting-and-formatting-text.mp410.87MB

32-project-1-using-excels-macro-recorder-tool/136-project-1-start-recording.mp434.62MB

32-project-1-using-excels-macro-recorder-tool/137-project-1-running-a-macro-with-a-button.mp413.89MB

32-project-1-using-excels-macro-recorder-tool/138-project-1-opps-i-need-to-edit-my-macro.mp426.55MB

32-project-1-using-excels-macro-recorder-tool/139-practical-uses-of-excel-macros.mp418.54MB

33-excel-vba-concepts/140-excel-vba-concpets.mp42.93MB

33-excel-vba-concepts/141-the-visual-basic-editor-vbe.mp410.39MB

33-excel-vba-concepts/142-excel-vba-modules.mp45.54MB

33-excel-vba-concepts/143-creating-an-excel-vba-procedure.mp410.16MB

33-excel-vba-concepts/144-understanding-excel-vba-variables.mp421.51MB

33-excel-vba-concepts/145-working-with-excel-vba-loops-to-repeat-blocks-of-code.mp416.47MB

33-excel-vba-concepts/146-building-logic-with-an-if-statement.mp412.81MB

34-project-2-moving-beyond-the-basics-and-into-vba/147-introduction-to-project-2-interacting-with-the-user.mp420.46MB

34-project-2-moving-beyond-the-basics-and-into-vba/148-project-2-breaking-down-the-vba-code.mp420.4MB

34-project-2-moving-beyond-the-basics-and-into-vba/149-project-2-prompting-the-user-for-information.mp426.65MB

34-project-2-moving-beyond-the-basics-and-into-vba/150-project-2-building-logic-into-your-macros.mp422.33MB

34-project-2-moving-beyond-the-basics-and-into-vba/151-project-2-alerting-the-user-of-errors.mp430.92MB

34-project-2-moving-beyond-the-basics-and-into-vba/152-other-practical-uses-of-message-and-input-boxes.mp424.42MB

35-project-3-preparing-and-cleaning-up-data-with-a-little-vba/153-introduction-to-project-3-cleaning-up-and-formatting-data.mp425.56MB

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

35-project-3-preparing-and-cleaning-up-data-with-a-little-vba/155-project-3-preparing-to-the-use-the-macro-recorder.mp417.64MB

35-project-3-preparing-and-cleaning-up-data-with-a-little-vba/156-project-3-inserting-the-headers.mp421.42MB

35-project-3-preparing-and-cleaning-up-data-with-a-little-vba/157-project-3-formatting-the-headers.mp440.35MB

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

36-project-4-using-vba-to-automate-excel-formulas/159-introduction-to-project-4-automate-excel-formulas.mp418.87MB

36-project-4-using-vba-to-automate-excel-formulas/160-project-4-automate-the-sum-function-through-code.mp449.3MB

36-project-4-using-vba-to-automate-excel-formulas/161-project-4-loop-the-sum-function-over-multiple-worksheets.mp428.44MB

37-project-5-bringing-it-all-together-and-a-weekly-report/162-introduction-to-project-5-creating-the-final-report.mp423.91MB

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

38-project-6-working-with-excel-vba-user-forms/164-introduction-to-project-6-working-with-excel-vba-user-forms.mp417.46MB

38-project-6-working-with-excel-vba-user-forms/165-project-6-creating-an-excel-user-form.mp415.87MB

38-project-6-working-with-excel-vba-user-forms/166-project-6-adding-controls-to-the-form.mp415.47MB

38-project-6-working-with-excel-vba-user-forms/167-project-6-changing-control-and-form-properties.mp428.35MB

38-project-6-working-with-excel-vba-user-forms/168-project-6-adding-vba-code-to-the-initialize-event.mp436.79MB

38-project-6-working-with-excel-vba-user-forms/169-project-6-adding-vba-code-to-the-combobox-change-event.mp425.82MB

38-project-6-working-with-excel-vba-user-forms/170-project-6-adding-vba-code-to-the-add-worksheet-button.mp421.64MB

38-project-6-working-with-excel-vba-user-forms/171-project-6-adding-vba-code-to-the-create-report-button.mp411.41MB

38-project-6-working-with-excel-vba-user-forms/172-project-6-showing-the-form.mp417.75MB

39-course-wrap-up/173-congratulations-youre-an-excel-macrovba-master.mp437.06MB