589689.xyz

Pluralsight - Excel 2019 Pro by Bill Kulterman

  • 收录时间:2019-12-05 15:00:23
  • 文件大小:1GB
  • 下载次数:88
  • 最近下载:2021-01-22 16:25:07
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 1. Working with Data/0. Outline Data.mp4 37MB
  2. 8. Charts/0. Insert Sparklines.mp4 31MB
  3. 9. Pivot Tables/0. Create Pivot Tables.mp4 30MB
  4. 2. Power Query/0. Import, Transform, and Connect to Data.mp4 29MB
  5. 7. Conditional Formatting/0. Apply Conditional Formatting.mp4 29MB
  6. 7. Conditional Formatting/2. Create Conditional Formatting Rules That Use Formulas.mp4 28MB
  7. 6. Error Checking/3. Validate Formulas by Using Error Checking Rules.mp4 25MB
  8. 5. Expanded Functions/5. Calculate Data by Using Financial Functions- PPMT & IPMT.mp4 22MB
  9. 1. Working with Data/1. Insert Subtotals.mp4 22MB
  10. 5. Expanded Functions/3. Perform What-if Analysis by Using Scenario Manager.mp4 22MB
  11. 7. Conditional Formatting/1. Create Custom Conditional Formatting Rules.mp4 21MB
  12. 2. Power Query/1. Combine and Display Data.mp4 20MB
  13. 12. Macros/0. Create a Simple Macro.mp4 19MB
  14. 5. Expanded Functions/1. Serialize Numbers by Using DATE and TIME Functions.mp4 19MB
  15. 8. Charts/7. Add and Modify Chart Elements.mp4 19MB
  16. 4. Logical and Statistical Functions/8. Perform Logical Operations by Using Nested Functions.mp4 18MB
  17. 4. Logical and Statistical Functions/1. Perform Logical Operations by Using the SUMIF Function.mp4 18MB
  18. 7. Conditional Formatting/3. Manage Conditional Formatting Rules.mp4 18MB
  19. 10. Advanced Options/0. Display Hidden Ribbon Tabs.mp4 18MB
  20. 9. Pivot Tables/8. Use Cube Functions to Get Data out of the Excel Data Model.mp4 18MB
  21. 4. Logical and Statistical Functions/4. Perform Statistical Operations by Using the SUMIFS Function.mp4 18MB
  22. 11. Finalizing a Workbook/3. Restrict Editing.mp4 17MB
  23. 4. Logical and Statistical Functions/2. Perform Logical Operations by Using the AVERAGEIF Function.mp4 17MB
  24. 8. Charts/2. Add Additional Data Series.mp4 17MB
  25. 9. Pivot Tables/1. Modify Field Selections and Options.mp4 17MB
  26. 9. Pivot Tables/6. Add Calculated Fields.mp4 17MB
  27. 6. Error Checking/1. Trace Precedence and Dependence.mp4 16MB
  28. 5. Expanded Functions/0. Reference the Date and Time by Using the NOW and TODAY Functions.mp4 16MB
  29. 13. Form Controls/0. Insert and Configure Form Controls.mp4 15MB
  30. 3. Text Functions/0. Format Text by Using RIGHT, LEFT, and MID Functions.mp4 15MB
  31. 1. Working with Data/5. Consolidate Data.mp4 15MB
  32. 4. Logical and Statistical Functions/5. Perform Statistical Operations by Using the AVERAGEIFS Function.mp4 14MB
  33. 1. Working with Data/6. Configure Data Validation.mp4 14MB
  34. 11. Finalizing a Workbook/1. Inspect a Workbook for Accessibility Issues.mp4 14MB
  35. 4. Logical and Statistical Functions/7. Perform Logical Operations by Using AND, OR, and NOT Functions.mp4 13MB
  36. 3. Text Functions/1. Format Text by Using UPPER, LOWER, and PROPER Functions.mp4 13MB
  37. 9. Pivot Tables/5. Add Additional Fields.mp4 13MB
  38. 11. Finalizing a Workbook/0. Inspect a Workbook for Hidden Properties or Personal Information.mp4 13MB
  39. 10. Advanced Options/1. Configure Formula Calculation Options.mp4 13MB
  40. 6. Error Checking/4. Monitor Cells and Formulas by Using the Watch Window.mp4 13MB
  41. 11. Finalizing a Workbook/2. Inspect a Workbook for Compatibility Issues.mp4 13MB
  42. 9. Pivot Tables/9. Create Pivot Charts.mp4 13MB
  43. 0. Formatting/0. Create Custom Number Formats.mp4 13MB
  44. 8. Charts/10. Add Trendlines to Charts.mp4 13MB
  45. 8. Charts/9. Apply Chart Styles.mp4 13MB
  46. 4. Logical and Statistical Functions/6. Perform Statistical Operations by Using the COUNTIFS Function.mp4 12MB
  47. 3. Text Functions/2. Format Text by Using the CONCAT Function.mp4 12MB
  48. 9. Pivot Tables/3. Group Pivot Table Data.mp4 12MB
  49. 8. Charts/1. Create a New Chart.mp4 12MB
  50. 1. Working with Data/2. Insert References.mp4 12MB
  51. 12. Macros/3. Copy Macros Between Workbooks.mp4 11MB
  52. 5. Expanded Functions/6. Calculate Data by Using Financial Functions- FV.mp4 11MB
  53. 9. Pivot Tables/4. Format Pivot Table Data.mp4 11MB
  54. 8. Charts/4. Analyze Data by Using Quick Analysis.mp4 11MB
  55. 8. Charts/11. Create Dual-axis Charts.mp4 10MB
  56. 9. Pivot Tables/10. Manipulate Options in Existing Pivot Charts.mp4 10MB
  57. 6. Error Checking/0. Display Formulas.mp4 10MB
  58. 8. Charts/6. Move Charts to a Chart Sheet.mp4 10MB
  59. 9. Pivot Tables/2. Create Slicers.mp4 9MB
  60. 11. Finalizing a Workbook/4. Protect Workbook Structure.mp4 9MB
  61. 1. Working with Data/3. Reference Data in Another Workbook.mp4 9MB
  62. 5. Expanded Functions/2. Perform What-if Analysis by Using Goal Seek.mp4 9MB
  63. 9. Pivot Tables/7. Drill down into PivotTable Details.mp4 9MB
  64. 12. Macros/1. Modify a Simple Macro.mp4 9MB
  65. 11. Finalizing a Workbook/6. Manage Workbook Versions.mp4 9MB
  66. 8. Charts/12. Save a Chart as a Template.mp4 9MB
  67. 5. Expanded Functions/4. Calculate Data by Using Financial Functions- PMT.mp4 9MB
  68. 0. Formatting/1. Apply International Currency Formats.mp4 8MB
  69. 9. Pivot Tables/12. Drill down into Pivot Chart Details.mp4 8MB
  70. 1. Working with Data/4. Reference Data by Using Structured References.mp4 8MB
  71. 8. Charts/8. Apply Chart Layouts.mp4 8MB
  72. 4. Logical and Statistical Functions/0. Perform Logical Operations by Using the IF Function.mp4 8MB
  73. 6. Error Checking/2. Evaluate Formulas.mp4 8MB
  74. 0. Formatting/2. Display Data in Multiple International Formats.mp4 8MB
  75. 12. Macros/2. Save and Enable Macros in a Workbook.mp4 7MB
  76. 9. Pivot Tables/11. Apply Styles to Pivot Charts.mp4 7MB
  77. 8. Charts/5. Resize Charts.mp4 7MB
  78. 12. Macros/4. Create a Macro Button.mp4 6MB
  79. 11. Finalizing a Workbook/5. Encrypt a Workbook with a Password.mp4 6MB
  80. 4. Logical and Statistical Functions/3. Perform Statistical Operations by Using the COUNTIF Function.mp4 5MB
  81. 8. Charts/3. Switch Between Rows and Columns in Source Data.mp4 5MB
  82. 2. Power Query/0. Import, Transform, and Connect to Data.srt 14KB
  83. 5. Expanded Functions/5. Calculate Data by Using Financial Functions- PPMT & IPMT.srt 13KB
  84. 5. Expanded Functions/3. Perform What-if Analysis by Using Scenario Manager.srt 11KB
  85. 9. Pivot Tables/8. Use Cube Functions to Get Data out of the Excel Data Model.srt 10KB
  86. 2. Power Query/1. Combine and Display Data.srt 10KB
  87. 13. Form Controls/0. Insert and Configure Form Controls.srt 10KB
  88. 4. Logical and Statistical Functions/8. Perform Logical Operations by Using Nested Functions.srt 10KB
  89. 9. Pivot Tables/0. Create Pivot Tables.srt 10KB
  90. 7. Conditional Formatting/0. Apply Conditional Formatting.srt 10KB
  91. 5. Expanded Functions/0. Reference the Date and Time by Using the NOW and TODAY Functions.srt 10KB
  92. 12. Macros/0. Create a Simple Macro.srt 9KB
  93. 5. Expanded Functions/1. Serialize Numbers by Using DATE and TIME Functions.srt 9KB
  94. 0. Formatting/0. Create Custom Number Formats.srt 8KB
  95. 1. Working with Data/6. Configure Data Validation.srt 8KB
  96. 10. Advanced Options/0. Display Hidden Ribbon Tabs.srt 8KB
  97. 8. Charts/7. Add and Modify Chart Elements.srt 8KB
  98. 9. Pivot Tables/1. Modify Field Selections and Options.srt 8KB
  99. 7. Conditional Formatting/2. Create Conditional Formatting Rules That Use Formulas.srt 7KB
  100. 8. Charts/10. Add Trendlines to Charts.srt 7KB
  101. 8. Charts/0. Insert Sparklines.srt 7KB
  102. 9. Pivot Tables/6. Add Calculated Fields.srt 7KB
  103. 7. Conditional Formatting/1. Create Custom Conditional Formatting Rules.srt 7KB
  104. 11. Finalizing a Workbook/3. Restrict Editing.srt 7KB
  105. 6. Error Checking/3. Validate Formulas by Using Error Checking Rules.srt 7KB
  106. 6. Error Checking/1. Trace Precedence and Dependence.srt 7KB
  107. 8. Charts/2. Add Additional Data Series.srt 6KB
  108. 4. Logical and Statistical Functions/1. Perform Logical Operations by Using the SUMIF Function.srt 6KB
  109. 11. Finalizing a Workbook/0. Inspect a Workbook for Hidden Properties or Personal Information.srt 6KB
  110. 10. Advanced Options/1. Configure Formula Calculation Options.srt 6KB
  111. 4. Logical and Statistical Functions/4. Perform Statistical Operations by Using the SUMIFS Function.srt 6KB
  112. 8. Charts/11. Create Dual-axis Charts.srt 6KB
  113. 5. Expanded Functions/6. Calculate Data by Using Financial Functions- FV.srt 6KB
  114. 9. Pivot Tables/5. Add Additional Fields.srt 6KB
  115. 5. Expanded Functions/2. Perform What-if Analysis by Using Goal Seek.srt 6KB
  116. 9. Pivot Tables/2. Create Slicers.srt 6KB
  117. 1. Working with Data/5. Consolidate Data.srt 6KB
  118. 1. Working with Data/0. Outline Data.srt 6KB
  119. 1. Working with Data/2. Insert References.srt 6KB
  120. 4. Logical and Statistical Functions/2. Perform Logical Operations by Using the AVERAGEIF Function.srt 6KB
  121. 7. Conditional Formatting/3. Manage Conditional Formatting Rules.srt 6KB
  122. 9. Pivot Tables/9. Create Pivot Charts.srt 6KB
  123. 8. Charts/1. Create a New Chart.srt 6KB
  124. 8. Charts/9. Apply Chart Styles.srt 5KB
  125. 8. Charts/4. Analyze Data by Using Quick Analysis.srt 5KB
  126. 6. Error Checking/4. Monitor Cells and Formulas by Using the Watch Window.srt 5KB
  127. 5. Expanded Functions/4. Calculate Data by Using Financial Functions- PMT.srt 5KB
  128. 9. Pivot Tables/4. Format Pivot Table Data.srt 5KB
  129. 9. Pivot Tables/10. Manipulate Options in Existing Pivot Charts.srt 5KB
  130. 9. Pivot Tables/3. Group Pivot Table Data.srt 5KB
  131. 11. Finalizing a Workbook/2. Inspect a Workbook for Compatibility Issues.srt 5KB
  132. 11. Finalizing a Workbook/1. Inspect a Workbook for Accessibility Issues.srt 5KB
  133. 1. Working with Data/4. Reference Data by Using Structured References.srt 5KB
  134. 4. Logical and Statistical Functions/7. Perform Logical Operations by Using AND, OR, and NOT Functions.srt 5KB
  135. 3. Text Functions/0. Format Text by Using RIGHT, LEFT, and MID Functions.srt 5KB
  136. 11. Finalizing a Workbook/6. Manage Workbook Versions.srt 5KB
  137. 4. Logical and Statistical Functions/5. Perform Statistical Operations by Using the AVERAGEIFS Function.srt 4KB
  138. 1. Working with Data/3. Reference Data in Another Workbook.srt 4KB
  139. 1. Working with Data/1. Insert Subtotals.srt 4KB
  140. 0. Formatting/2. Display Data in Multiple International Formats.srt 4KB
  141. content.txt 4KB
  142. 9. Pivot Tables/12. Drill down into Pivot Chart Details.srt 4KB
  143. 12. Macros/3. Copy Macros Between Workbooks.srt 4KB
  144. 8. Charts/12. Save a Chart as a Template.srt 4KB
  145. 8. Charts/8. Apply Chart Layouts.srt 4KB
  146. 0. Formatting/1. Apply International Currency Formats.srt 4KB
  147. 8. Charts/6. Move Charts to a Chart Sheet.srt 4KB
  148. 9. Pivot Tables/7. Drill down into PivotTable Details.srt 4KB
  149. 3. Text Functions/1. Format Text by Using UPPER, LOWER, and PROPER Functions.srt 4KB
  150. 11. Finalizing a Workbook/4. Protect Workbook Structure.srt 4KB
  151. 12. Macros/1. Modify a Simple Macro.srt 3KB
  152. 3. Text Functions/2. Format Text by Using the CONCAT Function.srt 3KB
  153. 12. Macros/2. Save and Enable Macros in a Workbook.srt 3KB
  154. 6. Error Checking/2. Evaluate Formulas.srt 3KB
  155. 4. Logical and Statistical Functions/0. Perform Logical Operations by Using the IF Function.srt 3KB
  156. 9. Pivot Tables/11. Apply Styles to Pivot Charts.srt 3KB
  157. 4. Logical and Statistical Functions/6. Perform Statistical Operations by Using the COUNTIFS Function.srt 3KB
  158. 8. Charts/5. Resize Charts.srt 3KB
  159. 6. Error Checking/0. Display Formulas.srt 3KB
  160. 11. Finalizing a Workbook/5. Encrypt a Workbook with a Password.srt 3KB
  161. 8. Charts/3. Switch Between Rows and Columns in Source Data.srt 2KB
  162. 4. Logical and Statistical Functions/3. Perform Statistical Operations by Using the COUNTIF Function.srt 2KB
  163. 12. Macros/4. Create a Macro Button.srt 2KB