589689.xyz

Lynda - Office 365: Excel Essential Training

  • 收录时间:2018-03-20 04:12:31
  • 文件大小:977MB
  • 下载次数:150
  • 最近下载:2021-01-23 17:34:08
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 13. Database Features/13_02-Inserting subtotals in a sorted list.mp4 36MB
  2. 05. Formatting/05_08-Creating and using tables.mp4 30MB
  3. 16. Introduction to Macros/16_03-Running a macro.mp4 25MB
  4. 07. Printing/07_01-Exploring the Page Layout tab and view.mp4 25MB
  5. 14. PivotTables/14_02-Manipulating PivotTable data.mp4 22MB
  6. 14. PivotTables/14_01-Creating PivotTables.mp4 21MB
  7. 07. Printing/07_02-Previewing page breaks.mp4 19MB
  8. 13. Database Features/13_01-Sorting data.mp4 19MB
  9. 16. Introduction to Macros/16_01-Definition and examples.mp4 19MB
  10. 08. Introduction to Charting/08_02-Exploring chart types.mp4 19MB
  11. 12. Security and Sharing/12_01-Unlocking cells and protecting worksheets.mp4 18MB
  12. 09. Adjusting Worksheet Views/09_03-Showing necessary information with the Outlining feature.mp4 18MB
  13. 16. Introduction to Macros/16_02-Creating a simple macro.mp4 18MB
  14. 05. Formatting/05_05-Exploring numeric and special formatting.mp4 17MB
  15. 06. Adjusting Worksheet Layout and Data/06_04-Finding and replacing data.mp4 17MB
  16. 05. Formatting/05_09-Inserting shapes, arrows, and other visual features.mp4 17MB
  17. 09. Adjusting Worksheet Views/09_02-Splitting screens horizontally and vertically.mp4 17MB
  18. 04. Creating Formulas and Functions/04_07-Using other common functions.mp4 17MB
  19. 08. Introduction to Charting/08_05-Creating incell charts with sparklines.mp4 16MB
  20. 15. Data Analysis Tools/15_03-Using Scenario Manager.mp4 16MB
  21. 13. Database Features/13_03-Using filters.mp4 16MB
  22. 06. Adjusting Worksheet Layout and Data/06_03-Moving, copying, and inserting data.mp4 15MB
  23. 11. IF, VLOOKUP, and Power Functions/11_02-Getting approximate table data with the VLOOKUP function.mp4 15MB
  24. 07. Printing/07_03-Working with Page Setup and printing controls.mp4 15MB
  25. 10. Multiple Worksheets and Workbooks/10_05-Locating and maintaining links.mp4 14MB
  26. 14. PivotTables/14_03-Grouping by date and time.mp4 14MB
  27. 06. Adjusting Worksheet Layout and Data/06_01-Inserting and deleting rows and columns.mp4 14MB
  28. 02. Getting Started with Excel 2013/02_03-The Quick Access Toolbar.mp4 14MB
  29. 15. Data Analysis Tools/15_02-Using Solver.mp4 14MB
  30. 08. Introduction to Charting/08_03-Formatting charts.mp4 13MB
  31. 13. Database Features/13_04-Splitting data into multiple columns.mp4 13MB
  32. 02. Getting Started with Excel 2013/02_02-Using the menu system.mp4 12MB
  33. 11. IF, VLOOKUP, and Power Functions/11_04-Using the COUNTIF family of functions.mp4 12MB
  34. 10. Multiple Worksheets and Workbooks/10_04-Using formulas to link worksheets and workbooks.mp4 12MB
  35. 11. IF, VLOOKUP, and Power Functions/11_03-Getting exact table data with the VLOOKUP function.mp4 12MB
  36. 15. Data Analysis Tools/15_01-Using Goal Seek.mp4 12MB
  37. 15. Data Analysis Tools/15_04-Using Data Tables.mp4 12MB
  38. 05. Formatting/05_06-Formatting numbers and dates.mp4 12MB
  39. 08. Introduction to Charting/08_04-Working with axes labels gridlines and other chart elements.mp4 11MB
  40. 05. Formatting/05_07-Conditional formatting.mp4 11MB
  41. 06. Adjusting Worksheet Layout and Data/06_02-Hiding and unhiding rows and columns.mp4 11MB
  42. 09. Adjusting Worksheet Views/09_01-Freezing and unfreezing panes.mp4 11MB
  43. 12. Security and Sharing/12_03-Assigning passwords to workbooks.mp4 11MB
  44. 08. Introduction to Charting/08_01-Creating charts.mp4 10MB
  45. 12. Security and Sharing/12_05-Tracking changes.mp4 10MB
  46. 14. PivotTables/14_06-Using PivotCharts.mp4 10MB
  47. 10. Multiple Worksheets and Workbooks/10_01-Displaying multiple worksheets and workbooks.mp4 10MB
  48. 05. Formatting/05_01-Exploring font styles and effects.mp4 10MB
  49. 12. Security and Sharing/12_04-Sharing workbooks.mp4 9MB
  50. 04. Creating Formulas and Functions/04_01-Creating simple formulas Totals and averages.mp4 9MB
  51. 14. PivotTables/14_05-Using slicers to clarify and manipulate fields.mp4 9MB
  52. 05. Formatting/05_04-Designing borders.mp4 9MB
  53. 05. Formatting/05_03-Working with alignment and Wrap Text.mp4 8MB
  54. 04. Creating Formulas and Functions/04_05-Working with relative, absolute, and mixed references.mp4 8MB
  55. 02. Getting Started with Excel 2013/02_04-The structure of a worksheet or workbook.mp4 8MB
  56. 03. Entering Data/03_04-Using Undo and Redo.mp4 8MB
  57. 01. Introduction/01_01-Welcome.mp4 8MB
  58. 05. Formatting/05_02-Adjusting row heights and column widths.mp4 8MB
  59. 13. Database Features/13_05-Removing duplicate records.mp4 8MB
  60. 11. IF, VLOOKUP, and Power Functions/11_01-Using IF functions and relational operators.mp4 8MB
  61. 04. Creating Formulas and Functions/04_04-Creating a percentageincrease formula.mp4 7MB
  62. 03. Entering Data/03_01-Exploring data entry and editing techniques.mp4 7MB
  63. 02. Getting Started with Excel 2013/02_06-Using the Status bar.mp4 7MB
  64. 03. Entering Data/03_02-Entering data with AutoFill.mp4 7MB
  65. 02. Getting Started with Excel 2013/02_08-Shortcut menus and the Mini toolbar.mp4 7MB
  66. 10. Multiple Worksheets and Workbooks/10_03-Moving, copying, and grouping sheets.mp4 7MB
  67. 04. Creating Formulas and Functions/04_06-Using SUM and AVERAGE.mp4 7MB
  68. 02. Getting Started with Excel 2013/02_09-Using the builtin help.mp4 7MB
  69. 03. Entering Data/03_06-Using Save or Save As.mp4 7MB
  70. 12. Security and Sharing/12_02-Protecting workbooks.mp4 6MB
  71. 02. Getting Started with Excel 2013/02_10-Creating new files.mp4 6MB
  72. 02. Getting Started with Excel 2013/02_07-Navigation and mouse pointers.mp4 6MB
  73. 04. Creating Formulas and Functions/04_03-Calculating yeartodate profits.mp4 6MB
  74. 03. Entering Data/03_03-Working with dates and times.mp4 5MB
  75. 02. Getting Started with Excel 2013/02_01-What is Excel used for.mp4 5MB
  76. 10. Multiple Worksheets and Workbooks/10_02-Renaming, inserting, and deleting sheets.mp4 5MB
  77. 14. PivotTables/14_04-Grouping by other factors.mp4 5MB
  78. 04. Creating Formulas and Functions/04_02-Copying a formula for adjacent cells.mp4 5MB
  79. 03. Entering Data/03_05-Adding comments.mp4 5MB
  80. 02. Getting Started with Excel 2013/02_05-Using the Formula bar.mp4 3MB
  81. 01. Introduction/01_02-Using the exercise files.mp4 2MB
  82. 17. Conclusion/17_01-Next steps.mp4 1MB
  83. Exercice Files/Ex_Files_Office365_Excel_EssT.zip 2KB