589689.xyz

Lynda - Office 365 for Mac Essential Training: Excel

  • 收录时间:2018-05-05 04:35:16
  • 文件大小:894MB
  • 下载次数:47
  • 最近下载:2021-01-22 22:50:01
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 019 Restricting input using validation rules.mp4 17MB
  2. 044 Managing scenarios.mp4 16MB
  3. 054 Defining data bar, color scale, and icon set conditional formats.mp4 16MB
  4. 025 Splitting and freezing rows and columns.mp4 15MB
  5. 085 Filtering a PivotTable report.mp4 15MB
  6. 016 Creating named ranges.mp4 15MB
  7. 037 Summarizing data using SUMIF and other conditional functions.mp4 14MB
  8. 018 Locating and changing data using Find and Replace.mp4 14MB
  9. 051 Managing Office themes.mp4 14MB
  10. 031 Using relative and absolute cell references.mp4 13MB
  11. 072 Adding and adjusting images.mp4 13MB
  12. 071 Creating and formatting shapes.mp4 13MB
  13. 015 Inserting symbols and special characters.mp4 12MB
  14. 077 Aligning and layering objects.mp4 12MB
  15. 047 Applying number and date formats to cells.mp4 12MB
  16. 074 Cropping, compressing, and removing image backgrounds.mp4 12MB
  17. 056 Creating bar and column charts.mp4 12MB
  18. 083 Changing the data field summary operation.mp4 12MB
  19. 046 Applying fonts, background colors, and borders.mp4 12MB
  20. 004 Exploring the Excel 2016 program window.mp4 12MB
  21. 026 Managing worksheets.mp4 11MB
  22. 022 Creating a custom sort order.mp4 11MB
  23. 053 Defining top 10 conditional formats.mp4 11MB
  24. 036 Summarizing data using an IF function.mp4 11MB
  25. 052 Creating rule-based conditional formats.mp4 11MB
  26. 048 Managing text alignment.mp4 11MB
  27. 050 Managing cell styles.mp4 11MB
  28. 017 Creating an Excel table.mp4 10MB
  29. 032 Controlling how Excel copies and pastes formulas.mp4 10MB
  30. 006 Setting program preferences.mp4 10MB
  31. 043 Managing Excel formula error indicators.mp4 10MB
  32. 088 Setting AutoCorrect and automatic Replace options.mp4 10MB
  33. 030 Introducing arithmetic operators.mp4 10MB
  34. 013 Copying and pasting cell data.mp4 10MB
  35. 090 Tracking and reviewing changes.mp4 10MB
  36. 012 Selecting cells and groups of cells.mp4 10MB
  37. 065 Creating sparkline charts.mp4 10MB
  38. 024 Inserting, moving, and deleting cells and cell ranges.mp4 10MB
  39. 005 Introducing the Ribbon for the Mac.mp4 10MB
  40. 055 Editing, ordering, and deleting conditional formats.mp4 10MB
  41. 068 Using hyperlinks.mp4 10MB
  42. 075 Creating SmartArt graphics.mp4 10MB
  43. 034 Creating an AUTOSUM formula.mp4 9MB
  44. 039 Rounding cell values.mp4 9MB
  45. 029 Adding a formula to a cell.mp4 9MB
  46. 066 Importing data from comma-separated value (CSV) or text files.mp4 9MB
  47. 014 Entering data using AutoFill and other techniques.mp4 9MB
  48. 023 Filtering worksheet data.mp4 9MB
  49. 010 Creating and modifying workbook templates.mp4 9MB
  50. 008 Opening, creating, and saving workbooks.mp4 8MB
  51. 033 Referring to Excel table data in formulas.mp4 8MB
  52. 027 Creating, editing, and deleting headers and footers.mp4 8MB
  53. 040 Joining text in cells with concatenation.mp4 8MB
  54. 069 Including an Excel workbook in another Office document.mp4 8MB
  55. 062 Changing the appearance of chart elements.mp4 8MB
  56. 007 Getting help in Excel.mp4 8MB
  57. 049 Copying cell formats.mp4 8MB
  58. 064 Adding trendlines to charts.mp4 8MB
  59. 073 Manipulating text boxes.mp4 8MB
  60. 095 Running an existing macro.mp4 8MB
  61. 081 Managing subtotals and grand totals.mp4 8MB
  62. 041 Finding data using VLOOKUP and HLOOKUP.mp4 8MB
  63. 099 Turning off screen updating in a macro.mp4 8MB
  64. 094 Protecting a workbook.mp4 8MB
  65. 079 Creating a PivotTable report.mp4 7MB
  66. 058 Creating line charts.mp4 7MB
  67. 089 Managing workbook comments.mp4 7MB
  68. 021 Sorting worksheet data.mp4 7MB
  69. 080 Pivoting a PivotTable report.mp4 7MB
  70. 020 Using lists to limit data entered into a cell.mp4 7MB
  71. 011 Managing workbooks across multiple versions of Excel.mp4 7MB
  72. 042 Auditing formulas by identifying precedents and dependents.mp4 7MB
  73. 063 Managing chart axes and numbering.mp4 7MB
  74. 028 Introducing Excel formulas and functions.mp4 7MB
  75. 091 Printing a worksheet or workbook.mp4 7MB
  76. 078 Introducing PivotTable reports.mp4 7MB
  77. 045 Performing Goal Seek analysis.mp4 7MB
  78. 093 Exporting to other formats.mp4 7MB
  79. 087 Checking spelling.mp4 6MB
  80. 003 What you can do with Excel 2016.mp4 6MB
  81. 096 Recording a macro.mp4 6MB
  82. 086 Applying a PivotTable style.mp4 6MB
  83. 076 Creating WordArt.mp4 6MB
  84. 009 Setting workbook properties.mp4 6MB
  85. 097 Renaming, viewing, and deleting macros.mp4 6MB
  86. 092 Setting and removing print areas.mp4 6MB
  87. 038 Creating formulas to count cells.mp4 6MB
  88. 060 Creating stock charts.mp4 6MB
  89. 001 Welcome.mp4 6MB
  90. 061 Changing chart types and layouts.mp4 6MB
  91. 070 Linking to an Excel chart from another Office program.mp4 6MB
  92. 098 Adding comments to a macro.mp4 6MB
  93. 059 Creating XY (scatter) charts.mp4 6MB
  94. 057 Creating pie charts.mp4 6MB
  95. 035 Summarizing data on the status bar.mp4 5MB
  96. 084 Changing the data field number format.mp4 5MB
  97. 082 Summarizing more than one data field.mp4 5MB
  98. 067 Connecting to an external data source.mp4 3MB
  99. 100 Next steps.mp4 3MB
  100. 002 Using the exercise files.mp4 1003KB
  101. Exercise Files/Chapter10/Aligning.xlsx 64KB
  102. Exercise Files/Chapter13/ManageMacros.xlsm 40KB
  103. Exercise Files/Chapter13/NoFlash.xlsm 40KB
  104. Exercise Files/Chapter10/ManageImages.xlsx 37KB
  105. Exercise Files/Chapter07/CellStyle.xlsx 34KB
  106. Exercise Files/Chapter03/ManageCells.xlsx 34KB
  107. Exercise Files/Chapter07/CopyFormat.xlsx 33KB
  108. Exercise Files/Chapter07/CellFormats.xlsx 31KB
  109. Exercise Files/Chapter07/NewConds.xlsx 31KB
  110. Exercise Files/Chapter07/MngConds.xlsx 29KB
  111. Exercise Files/Chapter07/BasicFormatting.xlsx 29KB
  112. Exercise Files/Chapter12/AutoCorrect.xlsx 28KB
  113. Exercise Files/Chapter07/Themes.xlsx 28KB
  114. Exercise Files/Chapter03/Symbols.xlsx 28KB
  115. Exercise Files/Chapter13/Comments.xlsm 28KB
  116. Exercise Files/Chapter07/Conditional.xlsx 27KB
  117. Exercise Files/Chapter07/NumberFormats.xlsx 27KB
  118. Exercise Files/Chapter07/Alignment.xlsx 26KB
  119. Exercise Files/Chapter07/TopTen.xlsx 25KB
  120. Exercise Files/Chapter13/Record.xlsx 24KB
  121. Exercise Files/Chapter13/Relative.xlsm 23KB
  122. Exercise Files/Chapter13/Relative.xlsx 22KB
  123. Exercise Files/Chapter10/London.jpg 21KB
  124. Exercise Files/Chapter09/LinkToWeb.xlsx 19KB
  125. Exercise Files/Chapter11/Styles.xlsx 18KB
  126. Exercise Files/Chapter09/PivotReport.xlsx 18KB
  127. Exercise Files/Chapter11/Filters.xlsx 18KB
  128. Exercise Files/Chapter11/DataFormat.xlsx 18KB
  129. Exercise Files/Chapter11/MultipleDataFields.xlsx 17KB
  130. Exercise Files/Chapter11/Totals.xlsx 17KB
  131. Exercise Files/Chapter11/PivotIntro.xlsx 17KB
  132. Exercise Files/Chapter11/SummaryOperation.xlsx 17KB
  133. Exercise Files/Chapter09/WebData.htm 17KB
  134. Exercise Files/Chapter10/WestEnd.jpg 16KB
  135. Exercise Files/Chapter11/Pivoting.xlsx 16KB
  136. Exercise Files/Chapter10/WomanShopping.jpg 16KB
  137. Exercise Files/Chapter04/MoveTarget.xlsx 15KB
  138. Exercise Files/Chapter13/RunAMacro.xlsm 15KB
  139. Exercise Files/Chapter08/ChartElements.xlsx 15KB
  140. Exercise Files/Chapter08/ChartLayout.xlsx 15KB
  141. Exercise Files/Chapter08/ChartAxes.xlsx 15KB
  142. Exercise Files/Chapter08/Trendline.xlsx 14KB
  143. Exercise Files/Chapter04/RegentStreet.jpg 14KB
  144. Exercise Files/Chapter01/WhatToDo.xlsx 13KB
  145. Exercise Files/Chapter01/RibbonTour.xlsx 13KB
  146. Exercise Files/Chapter09/ChartLink.xlsx 13KB
  147. Exercise Files/Chapter04/Freeze.xlsx 12KB
  148. Exercise Files/Chapter10/TextBox.xlsx 12KB
  149. Exercise Files/Chapter03/ManageWorksheets.xlsx 12KB
  150. Exercise Files/Chapter04/ManageWorksheets.xlsx 12KB
  151. Exercise Files/Chapter02/FileManagement.xlsx 12KB
  152. Exercise Files/Chapter09/Summary.docx 12KB
  153. Exercise Files/Chapter09/Chart.docx 12KB
  154. Exercise Files/Chapter11/CreatePivot.xlsx 11KB
  155. Exercise Files/Chapter12/Print.xlsx 11KB
  156. Exercise Files/Chapter03/FreezeSplit.xlsx 11KB
  157. Exercise Files/Chapter03/CopyPaste.xlsx 11KB
  158. Exercise Files/Chapter03/EnterData.xlsx 11KB
  159. Exercise Files/Chapter03/Headers.xlsx 11KB
  160. Exercise Files/Chapter04/Headers.xlsx 11KB
  161. Exercise Files/Chapter03/NamedRanges.xlsx 11KB
  162. Exercise Files/Chapter04/ExcelTables.xlsx 11KB
  163. Exercise Files/Chapter03/Select.xlsx 11KB
  164. Exercise Files/Chapter12/NewFormat.xlsx 11KB
  165. Exercise Files/Chapter01/Preferences.xlsx 11KB
  166. Exercise Files/Chapter01/GettingHelp.xlsx 10KB
  167. Exercise Files/Chapter06/Tracing.xlsx 10KB
  168. Exercise Files/Chapter02/SalesReport.xlsx 10KB
  169. Exercise Files/Chapter08/XYChart.xlsx 10KB
  170. Exercise Files/Chapter12/Protect.xlsx 10KB
  171. Exercise Files/Chapter12/PrintAreas.xlsx 10KB
  172. Exercise Files/Chapter08/StockChart.xlsx 10KB
  173. Exercise Files/Chapter02/Versions.xlsx 10KB
  174. Exercise Files/Chapter06/ErrorIndicators.xlsx 10KB
  175. Exercise Files/Chapter03/Validation.xlsx 10KB
  176. Exercise Files/Chapter05/ExcelTables.xlsx 10KB
  177. Exercise Files/Chapter04/Sort.xlsx 10KB
  178. Exercise Files/Chapter04/CustomSort.xlsx 10KB
  179. Exercise Files/Chapter09/Include.xlsx 10KB
  180. Exercise Files/Chapter06/GoalSeek.xlsx 10KB
  181. Exercise Files/Chapter08/Sparkline.xlsx 10KB
  182. Exercise Files/Chapter03/ValidList.xlsx 10KB
  183. Exercise Files/Chapter02/Properties.xlsx 10KB
  184. Exercise Files/Chapter12/Comments.xlsx 10KB
  185. Exercise Files/Chapter12/Changes.xlsx 10KB
  186. Exercise Files/Chapter03/ExcelTables.xlsx 10KB
  187. Exercise Files/Chapter08/PieChart.xlsx 10KB
  188. Exercise Files/Chapter04/Filter.xlsx 10KB
  189. Exercise Files/Chapter04/ManageCells.xlsx 10KB
  190. Exercise Files/Chapter08/LineChart.xlsx 10KB
  191. Exercise Files/Chapter08/ColumnChart.xlsx 10KB
  192. Exercise Files/Chapter06/Concatenate.xlsx 10KB
  193. Exercise Files/Chapter03/Find.xlsx 10KB
  194. Exercise Files/Chapter12/Spelling.xlsx 10KB
  195. Exercise Files/Chapter05/CopyFormulas.xlsx 10KB
  196. Exercise Files/Chapter09/Hyperlinks.xlsx 10KB
  197. Exercise Files/Chapter06/Counting.xlsx 9KB
  198. Exercise Files/Chapter05/CreatingFormulas.xlsx 9KB
  199. Exercise Files/Chapter06/Rounding.xlsx 9KB
  200. Exercise Files/Chapter06/VLookup.xlsx 9KB
  201. Exercise Files/Chapter05/AutoSum.xlsx 9KB
  202. Exercise Files/Chapter10/Shapes.xlsx 9KB
  203. Exercise Files/Chapter10/Images.xlsx 9KB
  204. Exercise Files/Chapter05/Conditional.xlsx 9KB
  205. Exercise Files/Chapter10/SmartArt.xlsx 9KB
  206. Exercise Files/Chapter10/WordArt.xlsx 9KB
  207. Exercise Files/Chapter05/CellRefs.xlsx 9KB
  208. Exercise Files/Chapter09/ImportTarget.xlsx 9KB
  209. Exercise Files/Chapter06/ManageScenarios.xlsx 9KB
  210. Exercise Files/Chapter05/StatusBar.xlsx 9KB
  211. Exercise Files/Chapter05/IfFormulas.xlsx 8KB
  212. Exercise Files/Chapter05/FormulaIntro.xlsx 8KB
  213. Exercise Files/Chapter05/Operators.xlsx 8KB
  214. Exercise Files/Chapter03/landon_final.png 5KB
  215. Exercise Files/Chapter09/ImportCSV.csv 1KB