589689.xyz

[] Udemy - Microsoft Excel - The Xtreme Excel Pivot Tables Course

  • 收录时间:2019-02-25 06:05:18
  • 文件大小:1GB
  • 下载次数:73
  • 最近下载:2021-01-19 10:13:07
  • 磁力链接:

文件列表

  1. 14. DATA MANAGEMENT/1.1 CHAPTER_13.zip.zip 109MB
  2. 16. NEW EXCEL 2013 PIVOT TABLE FEATURES/6. Data Models.mp4 75MB
  3. 16. NEW EXCEL 2013 PIVOT TABLE FEATURES/5. Timelime Slicers.mp4 39MB
  4. 10. PIVOT CHARTS/22. CASE STUDY ~ FINANCIAL Pivot Table Slicer & Chart Dashboard.mp4 28MB
  5. 1. Chapter 1/1. INTRODUCTION.mp4 26MB
  6. 16. NEW EXCEL 2013 PIVOT TABLE FEATURES/3. Recommended Pivot Tables.mp4 25MB
  7. 18. BONUS THE MYEXCELONLINE ACADEMY!/1. The MyExcelOnline Academy Online Course.mp4 22MB
  8. 16. NEW EXCEL 2013 PIVOT TABLE FEATURES/2. Cosmetic changes in the PivotTable Tools Ribbon Menu.mp4 22MB
  9. 16. NEW EXCEL 2013 PIVOT TABLE FEATURES/4. Distinct Count.mp4 20MB
  10. 9. CALCULATED FIELDS & ITEMS/16. CASE STUDY ~ ACCOUNTING Creating a P&L Pivot Table Report.mp4 20MB
  11. 15. BONUS VIDEOS/7. Interactive Balance Sheet Pivot Table.mp4 19MB
  12. 17. NEW EXCEL 2016 PIVOT TABLE FEATURES/2. Group Periods.mp4 18MB
  13. 17. NEW EXCEL 2016 PIVOT TABLE FEATURES/5. 3D Maps.mp4 18MB
  14. 9. CALCULATED FIELDS & ITEMS/17. CASE STUDY ~ FINANCIAL Actuals v Plan with Calculated Fields.mp4 17MB
  15. 10. PIVOT CHARTS/21. CASE STUDY ~ ACCOUNTING P&L Pivot Table report with Graphs.mp4 15MB
  16. 5. GROUPING/17. CASE STUDY ~ ACCOUNTING Quarterly Comparative Report.mp4 14MB
  17. 8. SLICERS (NEW IN EXCEL 2010)/12. TIP Interactive employee photos with Slicers! FUN!.mp4 13MB
  18. 12. GETPIVOTDATA Formula/8. CASE STUDY ~ ACCOUNTING Live forecasting with GETPIVOTDATA.mp4 12MB
  19. 10. PIVOT CHARTS/19. TIP Change Chart Type with Slicers! FUN!!!.mp4 12MB
  20. 17. NEW EXCEL 2016 PIVOT TABLE FEATURES/4. Pivot Chart - Expand and Collapse fields.mp4 12MB
  21. 11. CONDITIONAL FORMATTING PIVOT TABLES/17. CASE STUDY ~ ACCOUNTING Accounts Receivable Ageing Report Matrix.mp4 11MB
  22. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/9. Std Dev.mp4 11MB
  23. 7. FILTERING/2. Filter by Dates.mp4 10MB
  24. 15. BONUS VIDEOS/8. Monthly Sales Manager Performance Report.mp4 10MB
  25. 11. CONDITIONAL FORMATTING PIVOT TABLES/7. Data Bars, Color Scales & Icon Sets (NEW IN EXCEL 2010).mp4 10MB
  26. 12. GETPIVOTDATA Formula/9. CASE STUDY ~ FINANCIAL Channel Analysis with GETPIVOTDATA.mp4 10MB
  27. 4. VALUE FIELD SETTINGS SHOW VALUES AS/9. Difference From.mp4 9MB
  28. 8. SLICERS (NEW IN EXCEL 2010)/4. Creating a custom style.mp4 9MB
  29. 4. VALUE FIELD SETTINGS SHOW VALUES AS/18. CASE STUDY ~ FINANCIAL Actual v Plan Variance Report.mp4 9MB
  30. 5. GROUPING/12. TIP Group by fiscal years & quarters.mp4 9MB
  31. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/31. OPTIONS SHOW ~ Expand & Collapse buttons.mp4 9MB
  32. 12. GETPIVOTDATA Formula/3. Create a custom report with GETPIVOTDATA.mp4 9MB
  33. 8. SLICERS (NEW IN EXCEL 2010)/14. CASE STUDY ~ FINANCIAL Base, Best & Worst case Forecast.mp4 9MB
  34. 11. CONDITIONAL FORMATTING PIVOT TABLES/15. Show text in the Pivot Table Values area.mp4 9MB
  35. 12. GETPIVOTDATA Formula/2. Intro to GETPIVOTDATA.mp4 9MB
  36. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/13. TIP See all pivot Items.mp4 9MB
  37. 8. SLICERS (NEW IN EXCEL 2010)/6. Slicer Settings.mp4 9MB
  38. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/24. DESIGN STYLES ~ Customising a Pivot Table Style.mp4 9MB
  39. 10. PIVOT CHARTS/6. Pivot Chart Formats.mp4 9MB
  40. 15. BONUS VIDEOS/3. Consolidate with a Pivot Table.mp4 9MB
  41. 9. CALCULATED FIELDS & ITEMS/12. TIP Solve Order for Calculated Items.mp4 8MB
  42. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/17. OPTIONS DATA ~ Refresh External Data.mp4 8MB
  43. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/23. DESIGN STYLES ~ Pivot Table Styles.mp4 8MB
  44. 4. VALUE FIELD SETTINGS SHOW VALUES AS/6. % of Parent Row Total (NEW IN EXCEL 2010).mp4 8MB
  45. 5. GROUPING/18. CASE STUDY ~ FINANCIAL Min & Max Bank Balance.mp4 8MB
  46. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/9. CREATING A PIVOT TABLE ~ Field List & Areas.mp4 8MB
  47. 15. BONUS VIDEOS/2. Sales Forecasting with Calculated Fields.mp4 8MB
  48. 10. PIVOT CHARTS/5. Pivot Chart Layouts.mp4 8MB
  49. 4. VALUE FIELD SETTINGS SHOW VALUES AS/10. % Difference From.mp4 8MB
  50. 8. SLICERS (NEW IN EXCEL 2010)/13. CASE STUDY ~ ACCOUNTING Select a Monthly P&L report with a Slicer.mp4 8MB
  51. 5. GROUPING/14. TIP Group two pivot tables independently.mp4 8MB
  52. 13. MACROS & PIVOT TABLES/5. Different pivot table views macro.mp4 8MB
  53. 4. VALUE FIELD SETTINGS SHOW VALUES AS/5. % Of.mp4 7MB
  54. 9. CALCULATED FIELDS & ITEMS/6. Creating a Calculated Item.mp4 7MB
  55. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/21. OPTIONS ACTIONS ~ Select & format.mp4 7MB
  56. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/19. OPTIONS DATA ~ Change Data Source.mp4 7MB
  57. 13. MACROS & PIVOT TABLES/3. Record a simple macro to Refresh a pivot table.mp4 7MB
  58. 9. CALCULATED FIELDS & ITEMS/2. Creating a Calculated Field.mp4 7MB
  59. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/10. Varp.mp4 7MB
  60. 16. NEW EXCEL 2013 PIVOT TABLE FEATURES/1.1 New Excel 2013 Features.zip.zip 7MB
  61. 11. CONDITIONAL FORMATTING PIVOT TABLES/6. Top & Bottom Rules.mp4 7MB
  62. 10. PIVOT CHARTS/4. Pivot Chart Designs.mp4 6MB
  63. 13. MACROS & PIVOT TABLES/4. Date filter macro.mp4 6MB
  64. 4. VALUE FIELD SETTINGS SHOW VALUES AS/15. Index.mp4 6MB
  65. 4. VALUE FIELD SETTINGS SHOW VALUES AS/8. % of Parent Total (NEW IN EXCEL 2010).mp4 6MB
  66. 11. CONDITIONAL FORMATTING PIVOT TABLES/18. CASE STUDY ~ FINANCIAL Conditionally Format your sales results.mp4 6MB
  67. 7. FILTERING/5. Filter by Values.mp4 6MB
  68. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/4. Average.mp4 6MB
  69. 8. SLICERS (NEW IN EXCEL 2010)/2. Insert a Slicer.mp4 6MB
  70. 7. FILTERING/9. Filter by Report Filter.mp4 6MB
  71. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/5. ARRANGING YOUR DATA SET ~ Tables.mp4 6MB
  72. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/7. CREATING A PIVOT TABLE ~ Inserting a Pivot Table.mp4 6MB
  73. 5. GROUPING/5. Group by Sales ranges.mp4 6MB
  74. 9. CALCULATED FIELDS & ITEMS/5. Excel formulas & Calculated Fields.mp4 6MB
  75. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/3. ARRANGING YOUR DATA SET ~ No Gaps.mp4 6MB
  76. 5. GROUPING/2. Group by Date.mp4 6MB
  77. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/2. ARRANGING YOUR DATA SET ~ Tabular Format.mp4 6MB
  78. 8. SLICERS (NEW IN EXCEL 2010)/8. Slicer Connections for multiple pivot tables.mp4 6MB
  79. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/3. Count.mp4 6MB
  80. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/14. TIP Show a unique count.mp4 5MB
  81. 12. GETPIVOTDATA Formula/7. TIP Grand Totals to the left of the pivot table.mp4 5MB
  82. 11. CONDITIONAL FORMATTING PIVOT TABLES/2. Intro to Conditional Formatting.mp4 5MB
  83. 9. CALCULATED FIELDS & ITEMS/8. Editing a Calculated Item.mp4 5MB
  84. 7. FILTERING/12. TIP Filter by Text wildcards and .mp4 5MB
  85. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/28. DESIGN LAYOUT ~ Report Layouts.mp4 5MB
  86. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/7. Product.mp4 5MB
  87. 10. PIVOT CHARTS/2. Insert a Pivot Chart.mp4 5MB
  88. 9. CALCULATED FIELDS & ITEMS/3. Use an existing Calculated Field in a new calculation.mp4 5MB
  89. 12. GETPIVOTDATA Formula/5. Data validation with GETPIVOTDATA.mp4 5MB
  90. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/47. LAYOUT & FORMAT ~ TIPShow report filter on multiple pages.mp4 5MB
  91. 6. SORTING/5. Sort using a Custom List.mp4 5MB
  92. 1. Chapter 1/5.1 5 Speedy Steps to an Excel Pivot Table.pdf.pdf 5MB
  93. 13. MACROS & PIVOT TABLES/6. Top 10 macro.mp4 5MB
  94. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/11. TIP Show various Grand Totals.mp4 5MB
  95. 9. CALCULATED FIELDS & ITEMS/4. Editing a Calculated Field.mp4 5MB
  96. 4. VALUE FIELD SETTINGS SHOW VALUES AS/12. % Running Total in (NEW IN EXCEL 2010).mp4 5MB
  97. 5. GROUPING/13. TIP Errors when grouping by dates.mp4 5MB
  98. 12. GETPIVOTDATA Formula/4. Reference Dates with GETPIVOTDATA.mp4 5MB
  99. 4. VALUE FIELD SETTINGS SHOW VALUES AS/2. % of Grand Total.mp4 5MB
  100. 4. VALUE FIELD SETTINGS SHOW VALUES AS/7. % of Parent Column Total (NEW IN EXCEL 2010).mp4 5MB
  101. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/32. OPTIONS SHOW ~ Move & Remove Fields and Items.mp4 5MB
  102. 8. SLICERS (NEW IN EXCEL 2010)/7. Slicer Size & Properties.mp4 5MB
  103. 7. FILTERING/4. Filter by Labels - Numerical Text.mp4 4MB
  104. 9. CALCULATED FIELDS & ITEMS/10. Calculated Item on Column Labels.mp4 4MB
  105. 11. CONDITIONAL FORMATTING PIVOT TABLES/14. Control Conditional Formatting with Slicers.mp4 4MB
  106. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/18. OPTIONS DATA ~ Import from Access database.mp4 4MB
  107. 10. PIVOT CHARTS/20. TIP Workaround to creating an interactive Scatter graph.mp4 4MB
  108. 4. VALUE FIELD SETTINGS SHOW VALUES AS/3. % of Column Total.mp4 4MB
  109. 14. DATA MANAGEMENT/3. Reducing file memory by deleting the data source.mp4 4MB
  110. 4. VALUE FIELD SETTINGS SHOW VALUES AS/17. CASE STUDY ~ ACCOUNTING % of Revenue Margins.mp4 4MB
  111. 4. VALUE FIELD SETTINGS SHOW VALUES AS/11. Running Total in.mp4 4MB
  112. 10. PIVOT CHARTS/18. TIP Charts Do´s & Don'ts.mp4 4MB
  113. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/12. TIP Shortcuts to Field & Value Field Settings.mp4 4MB
  114. 4. VALUE FIELD SETTINGS SHOW VALUES AS/4. % of Row Total.mp4 4MB
  115. 15. BONUS VIDEOS/5. Break Even Model.mp4 4MB
  116. 4. VALUE FIELD SETTINGS SHOW VALUES AS/14. Rank Largest to Smallest (NEW IN EXCEL 2010).mp4 4MB
  117. 11. CONDITIONAL FORMATTING PIVOT TABLES/11. TIP Use a formula to determine which cells to format.mp4 4MB
  118. 8. SLICERS (NEW IN EXCEL 2010)/3. Slicer Styles.mp4 4MB
  119. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/5. Maximum.mp4 4MB
  120. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/10. CREATING A PIVOT TABLE ~ Drill down to audit.mp4 4MB
  121. 5. GROUPING/11. TIP Grouping by a custom date.mp4 4MB
  122. 15. BONUS VIDEOS/4. Frequency distribution with a Pivot Table.mp4 4MB
  123. 7. FILTERING/3. Filter by Labels - Text.mp4 4MB
  124. 14. DATA MANAGEMENT/5. Reducing file memory by keeping data source in MS Access.mp4 4MB
  125. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/16. OPTIONS DATA ~ Refresh All.mp4 4MB
  126. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/6. ARRANGING YOUR DATA SET ~ TIP Clean Your Data Set.mp4 4MB
  127. 17. NEW EXCEL 2016 PIVOT TABLE FEATURES/3. Multi-Select Slicer items.mp4 4MB
  128. 7. FILTERING/20. CASE STUDY ~ FINANCIAL Top 25% of Channel Partners.mp4 4MB
  129. 9. CALCULATED FIELDS & ITEMS/9. Excel formulas & Calculated Items.mp4 4MB
  130. 7. FILTERING/19. CASE STUDY ~ ACCOUNTING Top 5 Expenses report.mp4 4MB
  131. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/37. CUSTOMISATION ~ Field name formatting.mp4 4MB
  132. 13. MACROS & PIVOT TABLES/2. Adding the Developer tab & disabling macros.mp4 4MB
  133. 14. DATA MANAGEMENT/7. Sharing a Pivot Table via OneDrive.mp4 4MB
  134. 4. VALUE FIELD SETTINGS SHOW VALUES AS/13. Rank Smallest to Largest (NEW IN EXCEL 2010).mp4 4MB
  135. 9. CALCULATED FIELDS & ITEMS/7. Use an existing Calculated Item in a new calculation.mp4 3MB
  136. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/8. Count Numbers.mp4 3MB
  137. 10. PIVOT CHARTS/7. Limitations of Pivot Charts & workarounds.mp4 3MB
  138. 7. FILTERING/6. Filter by Values - Top or Bottom 10 Items.mp4 3MB
  139. 11. CONDITIONAL FORMATTING PIVOT TABLES/9. TIP Format only Top or Bottom ranked values - Top 3 sales per year.mp4 3MB
  140. 9. CALCULATED FIELDS & ITEMS/11. Shortcomings of Calculated Items.mp4 3MB
  141. 5. GROUPING/3. Group by Months.mp4 3MB
  142. 7. FILTERING/16. TIP Include new items in manual filter.mp4 3MB
  143. 11. CONDITIONAL FORMATTING PIVOT TABLES/12. Use selected cells to format multiple fields.mp4 3MB
  144. 14. DATA MANAGEMENT/2. Reducing file memory by copying existing pivot table.mp4 3MB
  145. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/2. Create multiple subtotals.mp4 3MB
  146. 5. GROUPING/10. TIP Group by a Date that starts on a Monday.mp4 3MB
  147. 10. PIVOT CHARTS/3. Insert a Slicer with a Pivot Chart.mp4 3MB
  148. 6. SORTING/4. Sort manually (drag, write, right click).mp4 3MB
  149. 11. CONDITIONAL FORMATTING PIVOT TABLES/13. All cells showing values to format multiple fields.mp4 3MB
  150. 7. FILTERING/7. Filter by Values - Top or Bottom %.mp4 3MB
  151. 5. GROUPING/4. Group by Quarters & Years.mp4 3MB
  152. 5. GROUPING/6. Group by Text fields.mp4 3MB
  153. 7. FILTERING/14. TIP Apply multiple filters.mp4 3MB
  154. 11. CONDITIONAL FORMATTING PIVOT TABLES/8. TIP Format only cells that contain - For Bonuses.mp4 3MB
  155. 6. SORTING/2. Sorting by Largest or Smallest.mp4 3MB
  156. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/36. CUSTOMISATION ~ Number formatting.mp4 3MB
  157. 15. BONUS VIDEOS/6. Several Slicer custom styles for you to use.mp4 3MB
  158. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/6. Minimum.mp4 3MB
  159. 13. MACROS & PIVOT TABLES/7. Add macro to quick access toolbar.mp4 3MB
  160. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/25. DESIGN STYLES ~ Use a customised style in another workbook.mp4 3MB
  161. 5. GROUPING/7. Group by Time.mp4 3MB
  162. 8. SLICERS (NEW IN EXCEL 2010)/5. Copy a custom style into a new workbook.mp4 3MB
  163. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/8. CREATING A PIVOT TABLE ~ Field List - Activate, move, resize & layout.mp4 3MB
  164. 7. FILTERING/10. TIP Shortcuts to filters.mp4 3MB
  165. 8. SLICERS (NEW IN EXCEL 2010)/11. TIP Lock the workbook but not the slicer.mp4 3MB
  166. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/43. LAYOUT & FORMAT ~ Format empty cells.mp4 3MB
  167. 7. FILTERING/8. Filter by Values - Top or Bottom Sum.mp4 3MB
  168. 10. PIVOT CHARTS/8. Saving a Pivot Chart template.mp4 3MB
  169. 15. BONUS VIDEOS/9. Reconciling customer payments.mp4 3MB
  170. 8. SLICERS (NEW IN EXCEL 2010)/10. TIP Use one slicer for two pivot tables.mp4 3MB
  171. 11. CONDITIONAL FORMATTING PIVOT TABLES/3. Highlight Cell Rules based on values.mp4 3MB
  172. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/4. ARRANGING YOUR DATA SET ~ Formatting.mp4 3MB
  173. 12. GETPIVOTDATA Formula/6. Shortfalls of GETPIVOTDATA.mp4 3MB
  174. 6. SORTING/3. Sort an Item Row (Left to Right).mp4 3MB
  175. 7. FILTERING/17. TIP Clear filters with one click.mp4 3MB
  176. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/1.1 CHAPTER 1.zip.zip 3MB
  177. 11. CONDITIONAL FORMATTING PIVOT TABLES/10. TIP Format values that are above or below the average - For Promotions.mp4 3MB
  178. 10. PIVOT CHARTS/15. TIP Paste Pivot Chart to PowerPoint & make live updates.mp4 3MB
  179. 5. GROUPING/9. TIP Grouping by Half Years.mp4 2MB
  180. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/46. LAYOUT & FORMAT ~ TIP Printing a pivot table on two pages.mp4 2MB
  181. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/41. LAYOUT & FORMAT ~ Change the layout of a report filter.mp4 2MB
  182. 5. GROUPING/8. TIP Shortcuts to Grouping.mp4 2MB
  183. 1. Chapter 1/4. BONUS #2 PIVOT TABLE CHEAT SHEET.pdf 2MB
  184. 6. SORTING/7. Sort row from A-Z and sales from Z-A.mp4 2MB
  185. 10. PIVOT CHARTS/17. TIP Include a Sparkline with your pivot table.mp4 2MB
  186. 10. PIVOT CHARTS/16. TIP Printing a Pivot Chart.mp4 2MB
  187. 11. CONDITIONAL FORMATTING PIVOT TABLES/5. Highlight Cell Rules based on date labels.mp4 2MB
  188. 10. PIVOT CHARTS/9. TIP Shortcuts to formatting a Pivot Chart.mp4 2MB
  189. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/38. CUSTOMISATION ~ TIP Predetermined number formatting.mp4 2MB
  190. 14. DATA MANAGEMENT/4. Reducing file memory by saving file as Excel Binary Workbook.mp4 2MB
  191. 5. GROUPING/16. TIP Display dates that have no data.mp4 2MB
  192. 11. CONDITIONAL FORMATTING PIVOT TABLES/16. Cond Format blank cells or cells.mp4 2MB
  193. 9. CALCULATED FIELDS & ITEMS/15. TIP Order of operations.mp4 2MB
  194. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/30. DESIGN LAYOUT ~ TIP Show the Classic Pivot Table Layout.mp4 2MB
  195. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/35. CUSTOMISATION ~ Change Count of to Sum of.mp4 2MB
  196. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/40. LAYOUT & FORMAT ~ Indent rows in compact layout.mp4 2MB
  197. 6. SORTING/6. Override a Custom List sort.mp4 2MB
  198. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/15. OPTIONS DATA ~ Refresh.mp4 2MB
  199. 9. CALCULATED FIELDS & ITEMS/13. TIP List Calculated Field & Item formulas.mp4 2MB
  200. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/20. OPTIONS ACTIONS ~ Clear Filters & Clear Pivot.mp4 2MB
  201. 6. SORTING/8. TIP Sort new items added to your data source.mp4 2MB
  202. 7. FILTERING/15. TIP Filter by multiple values.mp4 2MB
  203. 1. Chapter 1/6.1 Keyboard_Shortcuts_Bonus.pdf.pdf 2MB
  204. 18. BONUS THE MYEXCELONLINE ACADEMY!/2. THANK YOU!.mp4 2MB
  205. 4. VALUE FIELD SETTINGS SHOW VALUES AS/16. TIP Shortcuts to Show Values As.mp4 2MB
  206. 8. SLICERS (NEW IN EXCEL 2010)/9. TIP Different ways to filter a Slicer.mp4 2MB
  207. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/27. DESIGN LAYOUT ~ Grand Totals.mp4 2MB
  208. 10. PIVOT CHARTS/13. TIP Insert Pivot Chart straight from the data source.mp4 2MB
  209. 14. DATA MANAGEMENT/6. Compatibility Issues with Excel 2007 and Excel 2010.mp4 2MB
  210. 7. FILTERING/13. TIP Filter by multiple fields.mp4 2MB
  211. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/44. LAYOUT & FORMAT ~ Keep column widths upon refresh.mp4 2MB
  212. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/14. OPTIONS DATA ~ Pivot Cache explained.mp4 2MB
  213. 11. CONDITIONAL FORMATTING PIVOT TABLES/4. Highlight Cell Rules based on text labels.mp4 2MB
  214. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/22. OPTIONS ACTIONS ~ Move a Pivot Table.mp4 2MB
  215. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/45. LAYOUT & FORMAT ~ TIP Automatic Refresh a Pivot Table.mp4 2MB
  216. 10. PIVOT CHARTS/10. TIP Link chart title to a pivot cell.mp4 2MB
  217. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/26. DESIGN LAYOUT ~ Subtotals.mp4 2MB
  218. 9. CALCULATED FIELDS & ITEMS/14. TIP Remove a Calculated Field temporarily.mp4 2MB
  219. 10. PIVOT CHARTS/14. TIP Paste Pivot Chart to your email as a picture.mp4 2MB
  220. 10. PIVOT CHARTS/1.1 CHAPTER 9.zip 2MB
  221. 7. FILTERING/11. TIP Keep or hide selected items.mp4 2MB
  222. 10. PIVOT CHARTS/11. TIP Copying a second chart.mp4 2MB
  223. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/13. CREATING A PIVOT TABLE ~ TIP Defer Layout Update.mp4 1MB
  224. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/12. CREATING A PIVOT TABLE ~ TIP Double click on any labels to show more Fields.mp4 1MB
  225. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/42. LAYOUT & FORMAT ~ Format error values.mp4 1MB
  226. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/39. CUSTOMISATION ~ TIP Change Sum views in Label areas.mp4 1MB
  227. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/11. CREATING A PIVOT TABLE ~ Sort Field List from A to Z.mp4 1MB
  228. 7. FILTERING/18. TIP Add a filter for the column items.mp4 1MB
  229. 5. GROUPING/15. TIP Fixing the problem of counting grouped sales.mp4 1MB
  230. 10. PIVOT CHARTS/12. TIP Put a chart on a separate page with F11.mp4 1MB
  231. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/29. DESIGN LAYOUT ~ Blank Rows.mp4 1MB
  232. 11. CONDITIONAL FORMATTING PIVOT TABLES/1.1 CHAPTER 10.zip 1MB
  233. 7. FILTERING/1.1 CHAPTER 6.zip 1MB
  234. 6. SORTING/9. TIP Clear a sort.mp4 1MB
  235. 5. GROUPING/1.1 CHAPTER 4.zip 1010KB
  236. 9. CALCULATED FIELDS & ITEMS/1.1 CHAPTER 8.zip 1009KB
  237. 8. SLICERS (NEW IN EXCEL 2010)/1.1 CHAPTER 7.zip 997KB
  238. 6. SORTING/10. TIP Sort Largest to Smallest Grand Totals.mp4 913KB
  239. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/1.1 CHAPTER 2.zip 905KB
  240. 4. VALUE FIELD SETTINGS SHOW VALUES AS/1.1 CHAPTER 3.zip 837KB
  241. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/34. OPTIONS SHOW ~ ShowHide Field Headers.mp4 814KB
  242. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/33. OPTIONS SHOW ~ ShowHide Field List.mp4 779KB
  243. 12. GETPIVOTDATA Formula/1.1 CHAPTER 11.zip 589KB
  244. 13. MACROS & PIVOT TABLES/1.1 CHAPTER 12.zip 522KB
  245. 6. SORTING/1.1 CHAPTER 5.zip 465KB
  246. 15. BONUS VIDEOS/1.1 CHAPTER 14.zip 332KB
  247. 1. Chapter 1/9. BONUS EXCEL RESOURCE BLOG.pdf 279KB
  248. 17. NEW EXCEL 2016 PIVOT TABLE FEATURES/1.1 New Excel 2016 New Feature.zip.zip 278KB
  249. 1. Chapter 1/3.1 Xtreme Pivot Table Course Outline.xlsx.xlsx 63KB
  250. 18. BONUS THE MYEXCELONLINE ACADEMY!/1.1 Academy Course Upgrade COUPON.pdf.pdf 62KB
  251. 10. PIVOT CHARTS/22. CASE STUDY ~ FINANCIAL Pivot Table Slicer & Chart Dashboard.vtt 17KB
  252. 15. BONUS VIDEOS/7. Interactive Balance Sheet Pivot Table.vtt 12KB
  253. 8. SLICERS (NEW IN EXCEL 2010)/12. TIP Interactive employee photos with Slicers! FUN!.vtt 10KB
  254. 9. CALCULATED FIELDS & ITEMS/16. CASE STUDY ~ ACCOUNTING Creating a P&L Pivot Table Report.vtt 9KB
  255. 10. PIVOT CHARTS/21. CASE STUDY ~ ACCOUNTING P&L Pivot Table report with Graphs.vtt 8KB
  256. 10. PIVOT CHARTS/19. TIP Change Chart Type with Slicers! FUN!!!.vtt 8KB
  257. 12. GETPIVOTDATA Formula/8. CASE STUDY ~ ACCOUNTING Live forecasting with GETPIVOTDATA.vtt 8KB
  258. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/9. Std Dev.vtt 7KB
  259. 5. GROUPING/17. CASE STUDY ~ ACCOUNTING Quarterly Comparative Report.vtt 7KB
  260. 11. CONDITIONAL FORMATTING PIVOT TABLES/17. CASE STUDY ~ ACCOUNTING Accounts Receivable Ageing Report Matrix.vtt 7KB
  261. 7. FILTERING/2. Filter by Dates.vtt 7KB
  262. 9. CALCULATED FIELDS & ITEMS/17. CASE STUDY ~ FINANCIAL Actuals v Plan with Calculated Fields.vtt 7KB
  263. 16. NEW EXCEL 2013 PIVOT TABLE FEATURES/6. Data Models.vtt 7KB
  264. 11. CONDITIONAL FORMATTING PIVOT TABLES/7. Data Bars, Color Scales & Icon Sets (NEW IN EXCEL 2010).vtt 6KB
  265. 10. PIVOT CHARTS/6. Pivot Chart Formats.vtt 6KB
  266. 5. GROUPING/12. TIP Group by fiscal years & quarters.vtt 6KB
  267. 8. SLICERS (NEW IN EXCEL 2010)/4. Creating a custom style.vtt 6KB
  268. 12. GETPIVOTDATA Formula/3. Create a custom report with GETPIVOTDATA.vtt 6KB
  269. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/9. CREATING A PIVOT TABLE ~ Field List & Areas.vtt 6KB
  270. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/13. TIP See all pivot Items.vtt 6KB
  271. 12. GETPIVOTDATA Formula/2. Intro to GETPIVOTDATA.vtt 6KB
  272. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/17. OPTIONS DATA ~ Refresh External Data.vtt 5KB
  273. 4. VALUE FIELD SETTINGS SHOW VALUES AS/18. CASE STUDY ~ FINANCIAL Actual v Plan Variance Report.vtt 5KB
  274. 12. GETPIVOTDATA Formula/9. CASE STUDY ~ FINANCIAL Channel Analysis with GETPIVOTDATA.vtt 5KB
  275. 8. SLICERS (NEW IN EXCEL 2010)/14. CASE STUDY ~ FINANCIAL Base, Best & Worst case Forecast.vtt 5KB
  276. 8. SLICERS (NEW IN EXCEL 2010)/6. Slicer Settings.vtt 5KB
  277. 15. BONUS VIDEOS/3. Consolidate with a Pivot Table.vtt 5KB
  278. 15. BONUS VIDEOS/8. Monthly Sales Manager Performance Report.vtt 5KB
  279. 5. GROUPING/18. CASE STUDY ~ FINANCIAL Min & Max Bank Balance.vtt 5KB
  280. 13. MACROS & PIVOT TABLES/3. Record a simple macro to Refresh a pivot table.vtt 5KB
  281. 13. MACROS & PIVOT TABLES/5. Different pivot table views macro.vtt 5KB
  282. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/31. OPTIONS SHOW ~ Expand & Collapse buttons.vtt 4KB
  283. 8. SLICERS (NEW IN EXCEL 2010)/13. CASE STUDY ~ ACCOUNTING Select a Monthly P&L report with a Slicer.vtt 4KB
  284. 7. FILTERING/5. Filter by Values.vtt 4KB
  285. 16. NEW EXCEL 2013 PIVOT TABLE FEATURES/5. Timelime Slicers.vtt 4KB
  286. 8. SLICERS (NEW IN EXCEL 2010)/2. Insert a Slicer.vtt 4KB
  287. 4. VALUE FIELD SETTINGS SHOW VALUES AS/9. Difference From.vtt 4KB
  288. 15. BONUS VIDEOS/2. Sales Forecasting with Calculated Fields.vtt 4KB
  289. 13. MACROS & PIVOT TABLES/4. Date filter macro.vtt 4KB
  290. 9. CALCULATED FIELDS & ITEMS/2. Creating a Calculated Field.vtt 4KB
  291. 9. CALCULATED FIELDS & ITEMS/6. Creating a Calculated Item.vtt 4KB
  292. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/24. DESIGN STYLES ~ Customising a Pivot Table Style.vtt 4KB
  293. 4. VALUE FIELD SETTINGS SHOW VALUES AS/10. % Difference From.vtt 4KB
  294. 11. CONDITIONAL FORMATTING PIVOT TABLES/15. Show text in the Pivot Table Values area.vtt 4KB
  295. 11. CONDITIONAL FORMATTING PIVOT TABLES/18. CASE STUDY ~ FINANCIAL Conditionally Format your sales results.vtt 4KB
  296. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/7. CREATING A PIVOT TABLE ~ Inserting a Pivot Table.vtt 4KB
  297. 5. GROUPING/14. TIP Group two pivot tables independently.vtt 4KB
  298. 9. CALCULATED FIELDS & ITEMS/12. TIP Solve Order for Calculated Items.vtt 4KB
  299. 10. PIVOT CHARTS/4. Pivot Chart Designs.vtt 4KB
  300. 10. PIVOT CHARTS/5. Pivot Chart Layouts.vtt 4KB
  301. 11. CONDITIONAL FORMATTING PIVOT TABLES/6. Top & Bottom Rules.vtt 4KB
  302. 4. VALUE FIELD SETTINGS SHOW VALUES AS/5. % Of.vtt 4KB
  303. 7. FILTERING/9. Filter by Report Filter.vtt 4KB
  304. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/7. Product.vtt 3KB
  305. 8. SLICERS (NEW IN EXCEL 2010)/8. Slicer Connections for multiple pivot tables.vtt 3KB
  306. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/23. DESIGN STYLES ~ Pivot Table Styles.vtt 3KB
  307. 10. PIVOT CHARTS/2. Insert a Pivot Chart.vtt 3KB
  308. 4. VALUE FIELD SETTINGS SHOW VALUES AS/15. Index.vtt 3KB
  309. 12. GETPIVOTDATA Formula/4. Reference Dates with GETPIVOTDATA.vtt 3KB
  310. 6. SORTING/5. Sort using a Custom List.vtt 3KB
  311. 13. MACROS & PIVOT TABLES/6. Top 10 macro.vtt 3KB
  312. 5. GROUPING/5. Group by Sales ranges.vtt 3KB
  313. 7. FILTERING/12. TIP Filter by Text wildcards and .vtt 3KB
  314. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/10. Varp.vtt 3KB
  315. 12. GETPIVOTDATA Formula/7. TIP Grand Totals to the left of the pivot table.vtt 3KB
  316. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/19. OPTIONS DATA ~ Change Data Source.vtt 3KB
  317. 15. BONUS VIDEOS/5. Break Even Model.vtt 3KB
  318. 5. GROUPING/13. TIP Errors when grouping by dates.vtt 3KB
  319. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/5. ARRANGING YOUR DATA SET ~ Tables.vtt 3KB
  320. 9. CALCULATED FIELDS & ITEMS/5. Excel formulas & Calculated Fields.vtt 3KB
  321. 4. VALUE FIELD SETTINGS SHOW VALUES AS/6. % of Parent Row Total (NEW IN EXCEL 2010).vtt 3KB
  322. 11. CONDITIONAL FORMATTING PIVOT TABLES/2. Intro to Conditional Formatting.vtt 3KB
  323. 14. DATA MANAGEMENT/7. Sharing a Pivot Table via OneDrive.vtt 3KB
  324. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/14. TIP Show a unique count.vtt 3KB
  325. 8. SLICERS (NEW IN EXCEL 2010)/7. Slicer Size & Properties.vtt 3KB
  326. 5. GROUPING/2. Group by Date.vtt 3KB
  327. 10. PIVOT CHARTS/18. TIP Charts Do´s & Don'ts.vtt 3KB
  328. 7. FILTERING/4. Filter by Labels - Numerical Text.vtt 3KB
  329. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/21. OPTIONS ACTIONS ~ Select & format.vtt 3KB
  330. 13. MACROS & PIVOT TABLES/2. Adding the Developer tab & disabling macros.vtt 3KB
  331. 4. VALUE FIELD SETTINGS SHOW VALUES AS/12. % Running Total in (NEW IN EXCEL 2010).vtt 3KB
  332. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/32. OPTIONS SHOW ~ Move & Remove Fields and Items.vtt 3KB
  333. 11. CONDITIONAL FORMATTING PIVOT TABLES/11. TIP Use a formula to determine which cells to format.vtt 3KB
  334. 7. FILTERING/3. Filter by Labels - Text.vtt 3KB
  335. 10. PIVOT CHARTS/20. TIP Workaround to creating an interactive Scatter graph.vtt 3KB
  336. 4. VALUE FIELD SETTINGS SHOW VALUES AS/8. % of Parent Total (NEW IN EXCEL 2010).vtt 3KB
  337. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/3. ARRANGING YOUR DATA SET ~ No Gaps.vtt 3KB
  338. 4. VALUE FIELD SETTINGS SHOW VALUES AS/17. CASE STUDY ~ ACCOUNTING % of Revenue Margins.vtt 3KB
  339. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/6. ARRANGING YOUR DATA SET ~ TIP Clean Your Data Set.vtt 3KB
  340. 9. CALCULATED FIELDS & ITEMS/3. Use an existing Calculated Field in a new calculation.vtt 3KB
  341. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/3. Count.vtt 3KB
  342. 11. CONDITIONAL FORMATTING PIVOT TABLES/14. Control Conditional Formatting with Slicers.vtt 2KB
  343. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/11. TIP Show various Grand Totals.vtt 2KB
  344. 12. GETPIVOTDATA Formula/5. Data validation with GETPIVOTDATA.vtt 2KB
  345. 7. FILTERING/20. CASE STUDY ~ FINANCIAL Top 25% of Channel Partners.vtt 2KB
  346. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/28. DESIGN LAYOUT ~ Report Layouts.vtt 2KB
  347. 7. FILTERING/19. CASE STUDY ~ ACCOUNTING Top 5 Expenses report.vtt 2KB
  348. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/2. ARRANGING YOUR DATA SET ~ Tabular Format.vtt 2KB
  349. 9. CALCULATED FIELDS & ITEMS/8. Editing a Calculated Item.vtt 2KB
  350. 14. DATA MANAGEMENT/5. Reducing file memory by keeping data source in MS Access.vtt 2KB
  351. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/47. LAYOUT & FORMAT ~ TIPShow report filter on multiple pages.vtt 2KB
  352. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/4. Average.vtt 2KB
  353. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/37. CUSTOMISATION ~ Field name formatting.vtt 2KB
  354. 8. SLICERS (NEW IN EXCEL 2010)/3. Slicer Styles.vtt 2KB
  355. 16. NEW EXCEL 2013 PIVOT TABLE FEATURES/2. Cosmetic changes in the PivotTable Tools Ribbon Menu.vtt 2KB
  356. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/12. TIP Shortcuts to Field & Value Field Settings.vtt 2KB
  357. 16. NEW EXCEL 2013 PIVOT TABLE FEATURES/3. Recommended Pivot Tables.vtt 2KB
  358. 7. FILTERING/6. Filter by Values - Top or Bottom 10 Items.vtt 2KB
  359. 15. BONUS VIDEOS/4. Frequency distribution with a Pivot Table.vtt 2KB
  360. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/18. OPTIONS DATA ~ Import from Access database.vtt 2KB
  361. 4. VALUE FIELD SETTINGS SHOW VALUES AS/7. % of Parent Column Total (NEW IN EXCEL 2010).vtt 2KB
  362. 4. VALUE FIELD SETTINGS SHOW VALUES AS/14. Rank Largest to Smallest (NEW IN EXCEL 2010).vtt 2KB
  363. 9. CALCULATED FIELDS & ITEMS/4. Editing a Calculated Field.vtt 2KB
  364. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/16. OPTIONS DATA ~ Refresh All.vtt 2KB
  365. 4. VALUE FIELD SETTINGS SHOW VALUES AS/11. Running Total in.vtt 2KB
  366. 9. CALCULATED FIELDS & ITEMS/10. Calculated Item on Column Labels.vtt 2KB
  367. 4. VALUE FIELD SETTINGS SHOW VALUES AS/13. Rank Smallest to Largest (NEW IN EXCEL 2010).vtt 2KB
  368. 9. CALCULATED FIELDS & ITEMS/15. TIP Order of operations.vtt 2KB
  369. 7. FILTERING/16. TIP Include new items in manual filter.vtt 2KB
  370. 5. GROUPING/10. TIP Group by a Date that starts on a Monday.vtt 2KB
  371. 5. GROUPING/6. Group by Text fields.vtt 2KB
  372. 10. PIVOT CHARTS/7. Limitations of Pivot Charts & workarounds.vtt 2KB
  373. 15. BONUS VIDEOS/9. Reconciling customer payments.vtt 2KB
  374. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/5. Maximum.vtt 2KB
  375. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/8. Count Numbers.vtt 2KB
  376. 9. CALCULATED FIELDS & ITEMS/11. Shortcomings of Calculated Items.vtt 2KB
  377. 15. BONUS VIDEOS/6. Several Slicer custom styles for you to use.vtt 2KB
  378. 18. BONUS THE MYEXCELONLINE ACADEMY!/2. THANK YOU!.vtt 2KB
  379. 6. SORTING/4. Sort manually (drag, write, right click).vtt 2KB
  380. 4. VALUE FIELD SETTINGS SHOW VALUES AS/3. % of Column Total.vtt 2KB
  381. 7. FILTERING/7. Filter by Values - Top or Bottom %.vtt 2KB
  382. 5. GROUPING/3. Group by Months.vtt 2KB
  383. 7. FILTERING/17. TIP Clear filters with one click.vtt 2KB
  384. 11. CONDITIONAL FORMATTING PIVOT TABLES/10. TIP Format values that are above or below the average - For Promotions.vtt 2KB
  385. 5. GROUPING/4. Group by Quarters & Years.vtt 2KB
  386. 10. PIVOT CHARTS/3. Insert a Slicer with a Pivot Chart.vtt 2KB
  387. 5. GROUPING/11. TIP Grouping by a custom date.vtt 2KB
  388. 7. FILTERING/14. TIP Apply multiple filters.vtt 2KB
  389. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/8. CREATING A PIVOT TABLE ~ Field List - Activate, move, resize & layout.vtt 2KB
  390. 17. NEW EXCEL 2016 PIVOT TABLE FEATURES/2. Group Periods.vtt 2KB
  391. 6. SORTING/2. Sorting by Largest or Smallest.vtt 2KB
  392. 14. DATA MANAGEMENT/3. Reducing file memory by deleting the data source.vtt 2KB
  393. 5. GROUPING/9. TIP Grouping by Half Years.vtt 2KB
  394. 11. CONDITIONAL FORMATTING PIVOT TABLES/8. TIP Format only cells that contain - For Bonuses.vtt 2KB
  395. 17. NEW EXCEL 2016 PIVOT TABLE FEATURES/5. 3D Maps.vtt 2KB
  396. 12. GETPIVOTDATA Formula/6. Shortfalls of GETPIVOTDATA.vtt 2KB
  397. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/36. CUSTOMISATION ~ Number formatting.vtt 2KB
  398. 4. VALUE FIELD SETTINGS SHOW VALUES AS/2. % of Grand Total.vtt 2KB
  399. 7. FILTERING/10. TIP Shortcuts to filters.vtt 2KB
  400. 10. PIVOT CHARTS/8. Saving a Pivot Chart template.vtt 2KB
  401. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/4. ARRANGING YOUR DATA SET ~ Formatting.vtt 2KB
  402. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/2. Create multiple subtotals.vtt 2KB
  403. 11. CONDITIONAL FORMATTING PIVOT TABLES/12. Use selected cells to format multiple fields.vtt 2KB
  404. 5. GROUPING/7. Group by Time.vtt 2KB
  405. 11. CONDITIONAL FORMATTING PIVOT TABLES/9. TIP Format only Top or Bottom ranked values - Top 3 sales per year.vtt 2KB
  406. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/10. CREATING A PIVOT TABLE ~ Drill down to audit.vtt 2KB
  407. 7. FILTERING/8. Filter by Values - Top or Bottom Sum.vtt 2KB
  408. 6. SORTING/6. Override a Custom List sort.vtt 1KB
  409. 4. VALUE FIELD SETTINGS SHOW VALUES AS/4. % of Row Total.vtt 1KB
  410. 8. SLICERS (NEW IN EXCEL 2010)/11. TIP Lock the workbook but not the slicer.vtt 1KB
  411. 10. PIVOT CHARTS/15. TIP Paste Pivot Chart to PowerPoint & make live updates.vtt 1KB
  412. 11. CONDITIONAL FORMATTING PIVOT TABLES/13. All cells showing values to format multiple fields.vtt 1KB
  413. 11. CONDITIONAL FORMATTING PIVOT TABLES/3. Highlight Cell Rules based on values.vtt 1KB
  414. 10. PIVOT CHARTS/16. TIP Printing a Pivot Chart.vtt 1KB
  415. 18. BONUS THE MYEXCELONLINE ACADEMY!/1. The MyExcelOnline Academy Online Course.vtt 1KB
  416. 16. NEW EXCEL 2013 PIVOT TABLE FEATURES/4. Distinct Count.vtt 1KB
  417. 8. SLICERS (NEW IN EXCEL 2010)/5. Copy a custom style into a new workbook.vtt 1KB
  418. 9. CALCULATED FIELDS & ITEMS/9. Excel formulas & Calculated Items.vtt 1KB
  419. 5. GROUPING/8. TIP Shortcuts to Grouping.vtt 1KB
  420. 14. DATA MANAGEMENT/2. Reducing file memory by copying existing pivot table.vtt 1KB
  421. 9. CALCULATED FIELDS & ITEMS/7. Use an existing Calculated Item in a new calculation.vtt 1KB
  422. 10. PIVOT CHARTS/9. TIP Shortcuts to formatting a Pivot Chart.vtt 1KB
  423. 11. CONDITIONAL FORMATTING PIVOT TABLES/5. Highlight Cell Rules based on date labels.vtt 1KB
  424. 13. MACROS & PIVOT TABLES/7. Add macro to quick access toolbar.vtt 1KB
  425. 8. SLICERS (NEW IN EXCEL 2010)/10. TIP Use one slicer for two pivot tables.vtt 1KB
  426. 14. DATA MANAGEMENT/6. Compatibility Issues with Excel 2007 and Excel 2010.vtt 1KB
  427. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/41. LAYOUT & FORMAT ~ Change the layout of a report filter.vtt 1KB
  428. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/25. DESIGN STYLES ~ Use a customised style in another workbook.vtt 1KB
  429. 6. SORTING/8. TIP Sort new items added to your data source.vtt 1KB
  430. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/6. Minimum.vtt 1KB
  431. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/38. CUSTOMISATION ~ TIP Predetermined number formatting.vtt 1KB
  432. 10. PIVOT CHARTS/17. TIP Include a Sparkline with your pivot table.vtt 1KB
  433. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/43. LAYOUT & FORMAT ~ Format empty cells.vtt 1KB
  434. 8. SLICERS (NEW IN EXCEL 2010)/9. TIP Different ways to filter a Slicer.vtt 1KB
  435. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/46. LAYOUT & FORMAT ~ TIP Printing a pivot table on two pages.vtt 1KB
  436. 1. Chapter 1/8. BONUS #6 MY EXCEL PODCAST SHOW.html 1KB
  437. 11. CONDITIONAL FORMATTING PIVOT TABLES/16. Cond Format blank cells or cells.vtt 1KB
  438. 9. CALCULATED FIELDS & ITEMS/13. TIP List Calculated Field & Item formulas.vtt 1KB
  439. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/35. CUSTOMISATION ~ Change Count of to Sum of.vtt 1KB
  440. 6. SORTING/3. Sort an Item Row (Left to Right).vtt 1KB
  441. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/15. OPTIONS DATA ~ Refresh.vtt 1KB
  442. 17. NEW EXCEL 2016 PIVOT TABLE FEATURES/4. Pivot Chart - Expand and Collapse fields.vtt 1KB
  443. 10. PIVOT CHARTS/14. TIP Paste Pivot Chart to your email as a picture.vtt 1KB
  444. 1. Chapter 1/1. INTRODUCTION.vtt 1KB
  445. 7. FILTERING/15. TIP Filter by multiple values.vtt 1KB
  446. 7. FILTERING/13. TIP Filter by multiple fields.vtt 1KB
  447. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/30. DESIGN LAYOUT ~ TIP Show the Classic Pivot Table Layout.vtt 1KB
  448. 4. VALUE FIELD SETTINGS SHOW VALUES AS/16. TIP Shortcuts to Show Values As.vtt 1KB
  449. 10. PIVOT CHARTS/10. TIP Link chart title to a pivot cell.vtt 1KB
  450. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/14. OPTIONS DATA ~ Pivot Cache explained.vtt 979B
  451. 6. SORTING/7. Sort row from A-Z and sales from Z-A.vtt 932B
  452. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/13. CREATING A PIVOT TABLE ~ TIP Defer Layout Update.vtt 930B
  453. 5. GROUPING/16. TIP Display dates that have no data.vtt 920B
  454. 1. Chapter 1/2. EXCEL WORKBOOKS - IMPORTANT INSTRUCTIONS (PLEASE READ).html 914B
  455. 9. CALCULATED FIELDS & ITEMS/14. TIP Remove a Calculated Field temporarily.vtt 889B
  456. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/20. OPTIONS ACTIONS ~ Clear Filters & Clear Pivot.vtt 887B
  457. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/39. CUSTOMISATION ~ TIP Change Sum views in Label areas.vtt 859B
  458. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/22. OPTIONS ACTIONS ~ Move a Pivot Table.vtt 856B
  459. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/45. LAYOUT & FORMAT ~ TIP Automatic Refresh a Pivot Table.vtt 839B
  460. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/44. LAYOUT & FORMAT ~ Keep column widths upon refresh.vtt 835B
  461. 14. DATA MANAGEMENT/4. Reducing file memory by saving file as Excel Binary Workbook.vtt 822B
  462. 11. CONDITIONAL FORMATTING PIVOT TABLES/4. Highlight Cell Rules based on text labels.vtt 815B
  463. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/12. CREATING A PIVOT TABLE ~ TIP Double click on any labels to show more Fields.vtt 815B
  464. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/27. DESIGN LAYOUT ~ Grand Totals.vtt 798B
  465. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/40. LAYOUT & FORMAT ~ Indent rows in compact layout.vtt 784B
  466. 10. PIVOT CHARTS/13. TIP Insert Pivot Chart straight from the data source.vtt 782B
  467. 7. FILTERING/11. TIP Keep or hide selected items.vtt 773B
  468. [DesireCourse.Com].txt 754B
  469. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/26. DESIGN LAYOUT ~ Subtotals.vtt 729B
  470. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/42. LAYOUT & FORMAT ~ Format error values.vtt 714B
  471. 10. PIVOT CHARTS/11. TIP Copying a second chart.vtt 703B
  472. 5. GROUPING/15. TIP Fixing the problem of counting grouped sales.vtt 670B
  473. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/11. CREATING A PIVOT TABLE ~ Sort Field List from A to Z.vtt 598B
  474. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/29. DESIGN LAYOUT ~ Blank Rows.vtt 583B
  475. 10. PIVOT CHARTS/12. TIP Put a chart on a separate page with F11.vtt 569B
  476. 7. FILTERING/18. TIP Add a filter for the column items.vtt 567B
  477. 17. NEW EXCEL 2016 PIVOT TABLE FEATURES/3. Multi-Select Slicer items.vtt 525B
  478. 1. Chapter 1/7. BONUS #5 EXCEL RESOURCE BLOG.html 474B
  479. 1. Chapter 1/3. BONUS #1 COURSE TRACKER EXCEL WORKBOOK.html 431B
  480. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/34. OPTIONS SHOW ~ ShowHide Field Headers.vtt 358B
  481. 6. SORTING/9. TIP Clear a sort.vtt 352B
  482. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/33. OPTIONS SHOW ~ ShowHide Field List.vtt 286B
  483. 1. Chapter 1/6. BONUS #4 50+ EXCEL KEYBOARD SHORTCUTS (IN KEYBOARD LAYOUT).html 266B
  484. 6. SORTING/10. TIP Sort Largest to Smallest Grand Totals.vtt 205B
  485. 10. PIVOT CHARTS/23. State the button to format a Pivot Chart.html 135B
  486. 11. CONDITIONAL FORMATTING PIVOT TABLES/19. Recognize the option that conditionally formats all values except the Subtotals.html 135B
  487. 12. GETPIVOTDATA Formula/10. Define when to use the GETPIVOTDATA function.html 135B
  488. 13. MACROS & PIVOT TABLES/8. Recall how to assign a macro.html 135B
  489. 14. DATA MANAGEMENT/8. List the ways to reduce the memory size of an Excel file.html 135B
  490. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/48. Recognize which button is used to update a Pivot Table.html 135B
  491. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/15. Recall the way to change a Count Of to a Sum Of.html 135B
  492. 4. VALUE FIELD SETTINGS SHOW VALUES AS/19. Identify the steps to showing the values as a Year to Date accumulation.html 135B
  493. 5. GROUPING/19. State which command is used to group a PivotTable report by weeks.html 135B
  494. 6. SORTING/11. Identify the steps to creating a Custom List.html 135B
  495. 7. FILTERING/21. Recall the command to search for a wildcard entry.html 135B
  496. 8. SLICERS (NEW IN EXCEL 2010)/15. Identify the steps for customizing a Slicer.html 135B
  497. 9. CALCULATED FIELDS & ITEMS/18. State the steps to creating a Calculated Item.html 135B
  498. 18. BONUS THE MYEXCELONLINE ACADEMY!/1.2 The MyExcelOnline Academy Online Course.html 102B
  499. 14. DATA MANAGEMENT/1. WORKBOOKS.html 80B
  500. 10. PIVOT CHARTS/1. WORKBOOKS.html 76B
  501. 11. CONDITIONAL FORMATTING PIVOT TABLES/1. WORKBOOKS.html 76B
  502. 12. GETPIVOTDATA Formula/1. WORKBOOKS.html 76B
  503. 13. MACROS & PIVOT TABLES/1. WORKBOOKS.html 76B
  504. 15. BONUS VIDEOS/1. WORKBOOKS.html 76B
  505. 16. NEW EXCEL 2013 PIVOT TABLE FEATURES/1. WORKBOOKS.html 76B
  506. 17. NEW EXCEL 2016 PIVOT TABLE FEATURES/1. WORKBOOKS.html 76B
  507. 3. VALUE FIELD SETTINGS SUMMARIZE VALUES BY/1. WORKBOOKS.html 76B
  508. 4. VALUE FIELD SETTINGS SHOW VALUES AS/1. WORKBOOKS.html 76B
  509. 5. GROUPING/1. WORKBOOKS.html 76B
  510. 6. SORTING/1. WORKBOOKS.html 76B
  511. 7. FILTERING/1. WORKBOOKS.html 76B
  512. 8. SLICERS (NEW IN EXCEL 2010)/1. WORKBOOKS.html 76B
  513. 9. CALCULATED FIELDS & ITEMS/1. WORKBOOKS.html 76B
  514. 2. CUSTOMIZING YOUR EXCEL PIVOT TABLE/1. WORKBOOKS.html 73B
  515. [DesireCourse.Com].url 51B
  516. 1. Chapter 1/5. BONUS #3 5 SPEEDY STEPS TO AN EXCEL PIVOT TABLE INFORGRAPHIC.html 24B