589689.xyz

Lynda - Excel for Mac 2016 Essential Training

  • 收录时间:2018-04-15 04:07:28
  • 文件大小:893MB
  • 下载次数:55
  • 最近下载:2021-01-16 12:04:36
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 04. Working with Worksheets, Cells, and Cell Data/04_08-Restricting input using validation rules.mp4 17MB
  2. 07. Analyzing Data and Formulas/07_07-Managing scenarios.mp4 16MB
  3. 08. Formatting Worksheet Elements/08_09-Defining data bar, color scale, and icon set conditional formats.mp4 16MB
  4. 05. Sorting, Filtering, and Managing Worksheets/05_05-Splitting and freezing rows and columns.mp4 15MB
  5. 12. Exploring PivotTables/12_08-Filtering a PivotTable report.mp4 15MB
  6. 04. Working with Worksheets, Cells, and Cell Data/04_05-Creating named ranges.mp4 15MB
  7. 06. Summarizing Data Using Formulas and Functions/06_10-Summarizing data using SUMIF and other conditional functions.mp4 14MB
  8. 04. Working with Worksheets, Cells, and Cell Data/04_07-Locating and changing data using Find and Replace.mp4 14MB
  9. 08. Formatting Worksheet Elements/08_06-Managing Office themes.mp4 14MB
  10. 06. Summarizing Data Using Formulas and Functions/06_04-Using relative and absolute cell references.mp4 13MB
  11. 11. Working with Objects/11_02-Adding and adjusting images.mp4 13MB
  12. 11. Working with Objects/11_01-Creating and formatting shapes.mp4 13MB
  13. 04. Working with Worksheets, Cells, and Cell Data/04_04-Inserting symbols and special characters.mp4 12MB
  14. 11. Working with Objects/11_07-Aligning and layering objects.mp4 12MB
  15. 11. Working with Objects/11_04-Cropping, compressing, and removing image backgrounds.mp4 12MB
  16. 09. Working with Charts/09_01-Creating bar and column charts.mp4 12MB
  17. 08. Formatting Worksheet Elements/08_02-Applying number and date formats to cells.mp4 12MB
  18. 12. Exploring PivotTables/12_06-Changing the data field summary operation.mp4 12MB
  19. 08. Formatting Worksheet Elements/08_01-Applying fonts, background colors, and borders.mp4 12MB
  20. 02. Getting Started with Excel/02_02-Exploring the Excel 2016 program window.mp4 12MB
  21. 05. Sorting, Filtering, and Managing Worksheets/05_06-Managing worksheets.mp4 11MB
  22. 05. Sorting, Filtering, and Managing Worksheets/05_02-Creating a custom sort order.mp4 11MB
  23. 08. Formatting Worksheet Elements/08_08-Defining top 10 conditional formats.mp4 11MB
  24. 06. Summarizing Data Using Formulas and Functions/06_09-Summarizing data using an IF function.mp4 11MB
  25. 08. Formatting Worksheet Elements/08_07-Creating rulebased conditional formats.mp4 11MB
  26. 08. Formatting Worksheet Elements/08_03-Managing text alignment.mp4 11MB
  27. 08. Formatting Worksheet Elements/08_05-Managing cell styles.mp4 11MB
  28. 04. Working with Worksheets, Cells, and Cell Data/04_06-Creating an Excel table.mp4 10MB
  29. 06. Summarizing Data Using Formulas and Functions/06_05-Controlling how Excel copies and pastes formulas.mp4 10MB
  30. 02. Getting Started with Excel/02_04-Setting program preferences.mp4 10MB
  31. 07. Analyzing Data and Formulas/07_06-Managing Excel formula error indicators.mp4 10MB
  32. 13. Reviewing and Sharing Your Spreadsheets/13_02-Setting AutoCorrect and automatic Replace options.mp4 10MB
  33. 06. Summarizing Data Using Formulas and Functions/06_03-Introducing arithmetic operators.mp4 10MB
  34. 04. Working with Worksheets, Cells, and Cell Data/04_02-Copying and pasting cell data.mp4 10MB
  35. 13. Reviewing and Sharing Your Spreadsheets/13_04-Tracking and reviewing changes.mp4 10MB
  36. 04. Working with Worksheets, Cells, and Cell Data/04_01-Selecting cells and groups of cells.mp4 10MB
  37. 09. Working with Charts/09_10-Creating sparkline charts.mp4 10MB
  38. 05. Sorting, Filtering, and Managing Worksheets/05_04-Inserting, moving, and deleting cells and cell ranges.mp4 10MB
  39. 02. Getting Started with Excel/02_03-Introducing the Ribbon for the Mac.mp4 10MB
  40. 08. Formatting Worksheet Elements/08_10-Editing, ordering, and deleting conditional formats.mp4 10MB
  41. 11. Working with Objects/11_05-Creating SmartArt graphics.mp4 10MB
  42. 10. Working with External Data/10_03-Using hyperlinks.mp4 9MB
  43. 06. Summarizing Data Using Formulas and Functions/06_07-Creating an AutoSum formula.mp4 9MB
  44. 07. Analyzing Data and Formulas/07_02-Rounding cell values.mp4 9MB
  45. 06. Summarizing Data Using Formulas and Functions/06_02-Adding a formula to a cell.mp4 9MB
  46. 10. Working with External Data/10_01-Importing data from commaseparated value CSV or text files.mp4 9MB
  47. 04. Working with Worksheets, Cells, and Cell Data/04_03-Entering data using AutoFill and other techniques.mp4 9MB
  48. 05. Sorting, Filtering, and Managing Worksheets/05_03-Filtering worksheet data.mp4 9MB
  49. 03. Managing Workbooks/03_03-Creating and modifying workbook templates.mp4 9MB
  50. 06. Summarizing Data Using Formulas and Functions/06_06-Referring to Excel table data in formulas.mp4 8MB
  51. 03. Managing Workbooks/03_01-Opening, creating, and saving workbooks.mp4 8MB
  52. 05. Sorting, Filtering, and Managing Worksheets/05_07-Creating, editing, and deleting headers and footers.mp4 8MB
  53. 07. Analyzing Data and Formulas/07_03-Joining text in cells with concatenation.mp4 8MB
  54. 09. Working with Charts/09_07-Changing the appearance of chart elements.mp4 8MB
  55. 10. Working with External Data/10_04-Including an Excel workbook in another Office document.mp4 8MB
  56. 02. Getting Started with Excel/02_05-Getting help in Excel.mp4 8MB
  57. 08. Formatting Worksheet Elements/08_04-Copying cell formats.mp4 8MB
  58. 11. Working with Objects/11_03-Manipulating text boxes.mp4 8MB
  59. 09. Working with Charts/09_09-Adding trendlines to charts.mp4 8MB
  60. 14. Automating Workbooks Using Macros/14_01-Running an existing macro.mp4 8MB
  61. 12. Exploring PivotTables/12_04-Managing subtotals and grand totals.mp4 8MB
  62. 07. Analyzing Data and Formulas/07_04-Finding data using VLOOKUP and HLOOKUP.mp4 8MB
  63. 14. Automating Workbooks Using Macros/14_05-Turning off screen updating in a macro.mp4 8MB
  64. 13. Reviewing and Sharing Your Spreadsheets/13_08-Protecting a workbook.mp4 8MB
  65. 12. Exploring PivotTables/12_02-Creating a PivotTable report.mp4 7MB
  66. 05. Sorting, Filtering, and Managing Worksheets/05_01-Sorting worksheet data.mp4 7MB
  67. 13. Reviewing and Sharing Your Spreadsheets/13_03-Managing workbook comments.mp4 7MB
  68. 09. Working with Charts/09_03-Creating line charts.mp4 7MB
  69. 12. Exploring PivotTables/12_03-Pivoting a PivotTable report.mp4 7MB
  70. 04. Working with Worksheets, Cells, and Cell Data/04_09-Using lists to limit data entered into a cell.mp4 7MB
  71. 03. Managing Workbooks/03_04-Managing workbooks across multiple versions of Excel.mp4 7MB
  72. 07. Analyzing Data and Formulas/07_05-Auditing formulas by identifying precedents and dependents.mp4 7MB
  73. 09. Working with Charts/09_08-Managing chart axes and numbering.mp4 7MB
  74. 06. Summarizing Data Using Formulas and Functions/06_01-Introducing Excel formulas and functions.mp4 7MB
  75. 13. Reviewing and Sharing Your Spreadsheets/13_05-Printing a worksheet or workbook.mp4 7MB
  76. 12. Exploring PivotTables/12_01-Introducing PivotTable reports.mp4 7MB
  77. 07. Analyzing Data and Formulas/07_08-Performing Goal Seek analysis.mp4 7MB
  78. 13. Reviewing and Sharing Your Spreadsheets/13_07-Exporting to other formats.mp4 7MB
  79. 13. Reviewing and Sharing Your Spreadsheets/13_01-Checking spelling.mp4 6MB
  80. 02. Getting Started with Excel/02_01-What you can do with Excel 2016.mp4 6MB
  81. 14. Automating Workbooks Using Macros/14_02-Recording a macro.mp4 6MB
  82. 12. Exploring PivotTables/12_09-Applying a PivotTable style.mp4 6MB
  83. 11. Working with Objects/11_06-Creating WordArt.mp4 6MB
  84. 03. Managing Workbooks/03_02-Setting workbook properties.mp4 6MB
  85. 14. Automating Workbooks Using Macros/14_03-Renaming, viewing, and deleting macros.mp4 6MB
  86. 13. Reviewing and Sharing Your Spreadsheets/13_06-Setting and removing print areas.mp4 6MB
  87. 07. Analyzing Data and Formulas/07_01-Creating formulas to count cells.mp4 6MB
  88. 09. Working with Charts/09_05-Creating stock charts.mp4 6MB
  89. 09. Working with Charts/09_06-Changing chart types and layouts.mp4 6MB
  90. 10. Working with External Data/10_05-Linking to an Excel chart from another Office program.mp4 6MB
  91. 14. Automating Workbooks Using Macros/14_04-Adding comments to a macro.mp4 6MB
  92. 09. Working with Charts/09_04-Creating XY scatter charts.mp4 6MB
  93. 09. Working with Charts/09_02-Creating pie charts.mp4 6MB
  94. 06. Summarizing Data Using Formulas and Functions/06_08-Summarizing data on the status bar.mp4 5MB
  95. 01. Introduction/01_01-Welcome.mp4 5MB
  96. 12. Exploring PivotTables/12_07-Changing the data field number format.mp4 5MB
  97. 12. Exploring PivotTables/12_05-Summarizing more than one data field.mp4 5MB
  98. 10. Working with External Data/10_02-Connecting to an external data source.mp4 3MB
  99. 15. Conclusion/15_01-Next steps.mp4 3MB
  100. Exercice Files/Ex_Files_ExcelMac2016_EssT.zip 1MB
  101. 01. Introduction/01_02-Using the exercise files.mp4 1005KB