589689.xyz

Mastering Microsoft Excel 2016 [204 Training Tutorial] CG

  • 收录时间:2018-03-05 06:37:48
  • 文件大小:1015MB
  • 下载次数:200
  • 最近下载:2021-01-21 15:07:04
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 24 What-If Analysis and Forecasts/002 Using Scenario Manager.mp4 17MB
  2. 08 Formatting Worksheets/002 The Format Cells Dialog Box.mp4 17MB
  3. 18 Auditing Worksheets/006 Cell Validation.mp4 16MB
  4. 20 Consolidating Worksheets/001 Consolidating Data.mp4 16MB
  5. 30 PivotTables and PivotCharts/001 Creating Recommended PivotTables.mp4 15MB
  6. 32 Power View/001 Starting Power View.mp4 14MB
  7. 16 Paste Special/001 Using Paste Special.mp4 14MB
  8. 25 Table-Related Functions/002 Using the IF, AND, and OR Functions.mp4 14MB
  9. 27 Creating Charts In Excel/006 Changing the Data Range.mp4 13MB
  10. 17 Sharing Workbooks/006 Using Comments.mp4 12MB
  11. 24 What-If Analysis and Forecasts/004 Forecast Sheets- 2016 Only.mp4 12MB
  12. 32 Power View/007 Filtering Power View Using the Filter Area.mp4 12MB
  13. 15 Conditional Formatting and Cell Styles/001 Conditional Formatting.mp4 11MB
  14. 29 Data Models/003 Relating Tables in a Data Model.mp4 10MB
  15. 31 Power Pivot/004 Measures.mp4 10MB
  16. 12 Helping Yourself/001 Using Excel Help.mp4 10MB
  17. 25 Table-Related Functions/001 The Hlookup and Vlookup Functions.mp4 10MB
  18. 23 Filtering Data/006 Using Complex Criteria.mp4 10MB
  19. 22 Sorting Data/002 Custom Sort Orders.mp4 10MB
  20. 29 Data Models/002 Creating a Data Model from Excel Tables.mp4 10MB
  21. 23 Filtering Data/005 Applying Multiple Criteria.mp4 10MB
  22. 17 Sharing Workbooks/003 Traditional Workbook Sharing.mp4 9MB
  23. 23 Filtering Data/004 Creating Advanced Filters.mp4 9MB
  24. 10 Setting Worksheet Layout/007 Sheet Settings.mp4 9MB
  25. 30 PivotTables and PivotCharts/002 Manually Creating a PivotTable.mp4 9MB
  26. 06 Copying Pasting Formulas/001 Relative References and Absolute References.mp4 9MB
  27. 21 Tables/001 Creating a Table.mp4 9MB
  28. 10 Setting Worksheet Layout/006 Creating Headers and Footers.mp4 9MB
  29. 29 Data Models/004 Managing a Data Model.mp4 9MB
  30. 06 Copying Pasting Formulas/002 Cutting, Copying, and Pasting Data.mp4 9MB
  31. 31 Power Pivot/005 Creating KPIs.mp4 9MB
  32. 18 Auditing Worksheets/004 Error Checking.mp4 9MB
  33. 27 Creating Charts In Excel/001 Creating Charts.mp4 9MB
  34. 31 Power Pivot/006 Creating and Managing Perspectives.mp4 8MB
  35. 30 PivotTables and PivotCharts/009 Sorting and Filtering Using Field Headers.mp4 8MB
  36. 23 Filtering Data/008 Using Database Functions.mp4 8MB
  37. 07 Columns Rows/004 Inserting and Deleting Columns and Rows.mp4 8MB
  38. 03 File Management/004 Opening Workbooks.mp4 8MB
  39. 23 Filtering Data/003 Applying a Custom AutoFilter.mp4 8MB
  40. 24 What-If Analysis and Forecasts/001 Using Data Tables.mp4 8MB
  41. 11 Printing Worksheets/001 Previewing and Printing Worksheets.mp4 8MB
  42. 05 Creating Formulas/003 Writing Formulas.mp4 8MB
  43. 04 Data Entry/007 Selecting Ranges.mp4 8MB
  44. 30 PivotTables and PivotCharts/004 Manipulating a PivotTable or PivotChart.mp4 8MB
  45. 34 Security Features/001 Unlocking Cells.mp4 8MB
  46. 05 Creating Formulas/005 Inserting Functions.mp4 8MB
  47. 33 Slicers and Timelines/001 Inserting and Deleting Slicers.mp4 7MB
  48. 03 File Management/014 Working with Excel File Formats.mp4 7MB
  49. 08 Formatting Worksheets/001 Formatting Cells.mp4 7MB
  50. 17 Sharing Workbooks/007 Compare and Merge Workbooks.mp4 7MB
  51. 31 Power Pivot/001 Starting Power Pivot.mp4 7MB
  52. 17 Sharing Workbooks/002 Simplified Workbook Sharing in Excel 2016.mp4 7MB
  53. 01 Course Introduction/001 Course Introduction.mp4 7MB
  54. 30 PivotTables and PivotCharts/006 Formatting PivotTables.mp4 7MB
  55. 04 Data Entry/006 Flash Fill.mp4 7MB
  56. 36 Conclusion/001 Course Conclusion.mp4 6MB
  57. 27 Creating Charts In Excel/002 Selecting Charts and Chart Elements.mp4 6MB
  58. 30 PivotTables and PivotCharts/003 Creating a PivotChart.mp4 6MB
  59. 18 Auditing Worksheets/002 Tracing Precedent and Dependent Cells.mp4 6MB
  60. 14 Named Ranges/001 Naming Ranges.mp4 6MB
  61. 26 Sparklines/002 Modifying Sparklines.mp4 6MB
  62. 26 Sparklines/001 Inserting and Deleting Sparklines.mp4 6MB
  63. 28 Formatting Charts in Excel/018 Saving Custom Chart Templates.mp4 6MB
  64. 22 Sorting Data/001 Sorting Data.mp4 6MB
  65. 16 Paste Special/002 Pasting Linked Formulas.mp4 6MB
  66. 32 Power View/002 Adding Report Visualizations.mp4 6MB
  67. 31 Power Pivot/003 Calculated Columns.mp4 6MB
  68. 29 Data Models/001 Creating a Data Model from External Relational Data.mp4 6MB
  69. 04 Data Entry/009 Using AutoFill.mp4 6MB
  70. 17 Sharing Workbooks/004 Highlighting Changes.mp4 6MB
  71. 03 File Management/008 Freeze Panes.mp4 6MB
  72. 27 Creating Charts In Excel/004 Moving and Resizing Charts.mp4 6MB
  73. 35 Making Macros/001 Recording Macros.mp4 5MB
  74. 12 Helping Yourself/003 Smart Lookup and Insights- 2016 Only.mp4 5MB
  75. 02 Getting Acquainted with Excel/007 The Quick Access Toolbar.mp4 5MB
  76. 03 File Management/002 Saving Workbooks.mp4 5MB
  77. 32 Power View/005 Formatting the Power View Sheet.mp4 5MB
  78. 23 Filtering Data/001 Using AutoFilters.mp4 5MB
  79. 33 Slicers and Timelines/003 Inserting and Deleting Timelines.mp4 5MB
  80. 31 Power Pivot/002 Managing the Data Model.mp4 5MB
  81. 03 File Management/007 Arranging Open Workbook Windows.mp4 5MB
  82. 30 PivotTables and PivotCharts/008 Setting PivotTable Options.mp4 5MB
  83. 30 PivotTables and PivotCharts/005 Changing Calculated Value Fields.mp4 5MB
  84. 07 Columns Rows/002 Adjusting Column Width and Row Height.mp4 5MB
  85. 34 Security Features/004 Password Protecting Excel Files.mp4 5MB
  86. 34 Security Features/002 Worksheet Protection.mp4 5MB
  87. 04 Data Entry/003 Entering Numbers into Cells.mp4 4MB
  88. 28 Formatting Charts in Excel/014 Formatting the Chart and Plot Areas.mp4 4MB
  89. 09 Worksheet Tools/006 Copying or Moving Worksheets.mp4 4MB
  90. 02 Getting Acquainted with Excel/013 The Zoom Slider.mp4 4MB
  91. 02 Getting Acquainted with Excel/010 The Workbook Window.mp4 4MB
  92. 15 Conditional Formatting and Cell Styles/004 Using Table and Cell Styles.mp4 4MB
  93. 24 What-If Analysis and Forecasts/003 Using Goal Seek.mp4 4MB
  94. 35 Making Macros/003 The Personal Macro Workbook.mp4 4MB
  95. 27 Creating Charts In Excel/003 Adding Chart Elements.mp4 4MB
  96. 33 Slicers and Timelines/002 Modifying Slicers.mp4 4MB
  97. 12 Helping Yourself/002 The Tell Me Bar- 2016 Only.mp4 4MB
  98. 02 Getting Acquainted with Excel/004 The Ribbon.mp4 4MB
  99. 14 Named Ranges/004 Using Named Ranges in Formulas.mp4 4MB
  100. 05 Creating Formulas/004 Using AutoSum.mp4 4MB
  101. 18 Auditing Worksheets/005 Using the Watch Window.mp4 4MB
  102. 13 3D Formulas/002 3D Formula Syntax.mp4 4MB
  103. 10 Setting Worksheet Layout/004 Page Settings.mp4 4MB
  104. 05 Creating Formulas/009 Function Compatibility.mp4 4MB
  105. 23 Filtering Data/002 Using the Top 10 AutoFilter.mp4 4MB
  106. 28 Formatting Charts in Excel/016 Applying Shape Styles.mp4 4MB
  107. 04 Data Entry/001 Selecting Cells.mp4 4MB
  108. 13 3D Formulas/001 Creating 3D Formulas.mp4 4MB
  109. 02 Getting Acquainted with Excel/002 The Excel Environment.mp4 3MB
  110. 19 Outlining Worksheets/002 Applying and Removing Outlines.mp4 3MB
  111. 28 Formatting Charts in Excel/004 Formatting Axis Titles.mp4 3MB
  112. 17 Sharing Workbooks/005 Reviewing Changes.mp4 3MB
  113. 04 Data Entry/002 Entering Text into Cells.mp4 3MB
  114. 28 Formatting Charts in Excel/001 Formatting Chart Objects.mp4 3MB
  115. 03 File Management/011 Comparing Open Workbooks.mp4 3MB
  116. 14 Named Ranges/005 Naming 3D Ranges.mp4 3MB
  117. 19 Outlining Worksheets/001 Using Outlines.mp4 3MB
  118. 23 Filtering Data/007 Copying Filter Results to a New Location.mp4 3MB
  119. 09 Worksheet Tools/005 Coloring Worksheet Tabs.mp4 3MB
  120. 28 Formatting Charts in Excel/012 Formatting Trendlines.mp4 3MB
  121. 28 Formatting Charts in Excel/002 Inserting Objects into a Chart.mp4 3MB
  122. 13 3D Formulas/003 Creating 3D Range References.mp4 3MB
  123. 02 Getting Acquainted with Excel/001 About Excel.mp4 3MB
  124. 02 Getting Acquainted with Excel/015 Keyboard Shortcuts.mp4 3MB
  125. 02 Getting Acquainted with Excel/011 The Status Bar.mp4 3MB
  126. 28 Formatting Charts in Excel/017 Applying WordArt Styles.mp4 3MB
  127. 28 Formatting Charts in Excel/003 Formatting Axes.mp4 3MB
  128. 28 Formatting Charts in Excel/007 Formatting a Data Table.mp4 3MB
  129. 10 Setting Worksheet Layout/001 Using Page Break Preview.mp4 3MB
  130. 03 File Management/009 Split Panes.mp4 3MB
  131. 07 Columns Rows/003 Hiding and Unhiding Columns and Rows.mp4 3MB
  132. 02 Getting Acquainted with Excel/003 The Title Bar.mp4 3MB
  133. 02 Getting Acquainted with Excel/012 The Workbook View Buttons.mp4 3MB
  134. 28 Formatting Charts in Excel/008 Formatting Error Bars.mp4 3MB
  135. 28 Formatting Charts in Excel/006 Formatting Data Labels.mp4 3MB
  136. 05 Creating Formulas/001 Ranged Formula Syntax.mp4 3MB
  137. 09 Worksheet Tools/003 Navigating Worksheets.mp4 3MB
  138. 05 Creating Formulas/002 Simple Formula Syntax.mp4 3MB
  139. 28 Formatting Charts in Excel/009 Formatting Gridlines.mp4 3MB
  140. 09 Worksheet Tools/002 Selecting Multiple Worksheets.mp4 3MB
  141. 28 Formatting Charts in Excel/013 Formatting UpDown Bars.mp4 3MB
  142. 37 Instruction Manuals/003 Advanced Excel Manual.pdf 3MB
  143. 07 Columns Rows/001 Selecting Columns and Rows.mp4 3MB
  144. 18 Auditing Worksheets/001 Auditing Worksheets.mp4 3MB
  145. 28 Formatting Charts in Excel/011 Formatting Drop and High-Low Lines.mp4 3MB
  146. 31 Power Pivot/007 Power Pivot PivotTables and PivotCharts.mp4 3MB
  147. 33 Slicers and Timelines/004 Modifying Timelines.mp4 3MB
  148. 17 Sharing Workbooks/001 About Sharing Workbooks.mp4 3MB
  149. 28 Formatting Charts in Excel/010 Formatting a Legend.mp4 3MB
  150. 34 Security Features/003 Workbook Protection.mp4 3MB
  151. 32 Power View/003 Changing the Layout of Report Visualizations.mp4 2MB
  152. 32 Power View/008 Cross-Filtering Visualizations.mp4 2MB
  153. 06 Copying Pasting Formulas/004 The Undo Button.mp4 2MB
  154. 03 File Management/005 Recovering Unsaved Workbooks.mp4 2MB
  155. 06 Copying Pasting Formulas/003 AutoFilling Cells.mp4 2MB
  156. 28 Formatting Charts in Excel/005 Formatting a Chart Title.mp4 2MB
  157. 35 Making Macros/002 Running and Deleting Recorded Macros.mp4 2MB
  158. 14 Named Ranges/002 Creating Names from Headings.mp4 2MB
  159. 21 Tables/002 Adding and Editing Records.mp4 2MB
  160. 05 Creating Formulas/006 Editing a Range.mp4 2MB
  161. 09 Worksheet Tools/001 Inserting and Deleting Worksheets.mp4 2MB
  162. 30 PivotTables and PivotCharts/007 Formatting PivotCharts.mp4 2MB
  163. 02 Getting Acquainted with Excel/008 Touch Mode.mp4 2MB
  164. 09 Worksheet Tools/004 Renaming Worksheets.mp4 2MB
  165. 03 File Management/006 Opening a Workbook in a New Window.mp4 2MB
  166. 06 Copying Pasting Formulas/005 The Redo Button.mp4 2MB
  167. 10 Setting Worksheet Layout/005 Setting Margins.mp4 2MB
  168. 37 Instruction Manuals/002 Intermediate Excel Manual.pdf 2MB
  169. 37 Instruction Manuals/001 Introductory Excel Manual.pdf 2MB
  170. 03 File Management/013 Switching to Full Screen View.mp4 2MB
  171. 10 Setting Worksheet Layout/003 Opening the Page Setup Dialog Box.mp4 2MB
  172. 08 Formatting Worksheets/004 Copying All Formatting from Cells to Another Area.mp4 2MB
  173. 02 Getting Acquainted with Excel/005 The File Tab and Backstage View.mp4 2MB
  174. 27 Creating Charts In Excel/009 Choosing a Chart Style.mp4 2MB
  175. 15 Conditional Formatting and Cell Styles/003 Clearing Conditional Formatting.mp4 2MB
  176. 10 Setting Worksheet Layout/002 Using the Page Layout View.mp4 2MB
  177. 27 Creating Charts In Excel/005 Changing the Chart Type.mp4 2MB
  178. 32 Power View/006 Creating Multiples in a Chart.mp4 2MB
  179. 14 Named Ranges/006 Deleting Named Ranges.mp4 2MB
  180. 05 Creating Formulas/008 AutoCalculate.mp4 2MB
  181. 04 Data Entry/008 Ranged Data Entry.mp4 2MB
  182. 27 Creating Charts In Excel/011 Printing Charts.mp4 2MB
  183. 15 Conditional Formatting and Cell Styles/002 Finding Cells with Conditional Formatting.mp4 1MB
  184. 18 Auditing Worksheets/003 Tracing Errors.mp4 1MB
  185. 04 Data Entry/004 AutoComplete.mp4 1MB
  186. 27 Creating Charts In Excel/012 Deleting Charts.mp4 1MB
  187. 21 Tables/003 Inserting Records and Fields.mp4 1MB
  188. 03 File Management/001 Creating New Workbooks.mp4 1MB
  189. 28 Formatting Charts in Excel/015 Naming Charts.mp4 1MB
  190. 03 File Management/012 Switching Open Workbooks.mp4 1MB
  191. 27 Creating Charts In Excel/010 Changing Color Schemes.mp4 1MB
  192. 04 Data Entry/005 Pick from Drop-Down List.mp4 1MB
  193. 03 File Management/003 Closing Workbooks.mp4 1MB
  194. 14 Named Ranges/003 Moving to a Named Range.mp4 1MB
  195. 02 Getting Acquainted with Excel/009 The Formula Bar.mp4 1MB
  196. 32 Power View/004 Using Undo and Redo in Power View.mp4 1MB
  197. 27 Creating Charts In Excel/008 Choosing a Chart Layout.mp4 1MB
  198. 21 Tables/004 Deleting Records and Fields.mp4 1MB
  199. 03 File Management/010 Hiding and Unhiding Workbook Windows.mp4 1MB
  200. 05 Creating Formulas/007 Formula AutoCorrect.mp4 968KB
  201. 08 Formatting Worksheets/003 Clearing All Formatting from Cells.mp4 922KB
  202. 02 Getting Acquainted with Excel/006 Scroll Bars.mp4 883KB
  203. 27 Creating Charts In Excel/007 Switching Column and Row Data.mp4 840KB
  204. 02 Getting Acquainted with Excel/014 The Mini Toolbar.mp4 699KB