589689.xyz

microsoft-excel-pivot-tables-for-2007-2010-2013

  • 收录时间:2018-03-03 08:03:03
  • 文件大小:2GB
  • 下载次数:195
  • 最近下载:2020-12-15 02:41:58
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 09 PIVOT CHARTS/021 CASE STUDY FINANCIAL Pivot Table Slicer Chart Dashboard.mp4 68MB
  2. 08 CALCULATED FIELDS ITEMS/015 CASE STUDY ACCOUNTING Creating a PL Pivot Table Report.mp4 59MB
  3. 08 CALCULATED FIELDS ITEMS/016 CASE STUDY FINANCIAL Actuals v Plan with Calculated Fields.mp4 51MB
  4. 14 BONUS VIDEOS/006 Interactive Balance Sheet Pivot Table.mp4 48MB
  5. 09 PIVOT CHARTS/020 CASE STUDY ACCOUNTING PL Pivot Table report with Graphs.mp4 38MB
  6. 04 GROUPING/016 CASE STUDY ACCOUNTING Quarterly Comparative Report.mp4 38MB
  7. 07 SLICERS NEW IN EXCEL 2010/011 TIP Interactive employee photos with Slicers FUN.mp4 31MB
  8. 11 GETPIVOTDATA Formula/007 CASE STUDY ACCOUNTING Live forecasting with GETPIVOTDATA.mp4 31MB
  9. 09 PIVOT CHARTS/018 TIP Change Chart Type with Slicers FUN.mp4 29MB
  10. 14 BONUS VIDEOS/007 Monthly Sales Manager Performance Report.mp4 28MB
  11. 10 CONDITIONAL FORMATTING PIVOT TABLES/016 CASE STUDY ACCOUNTING Accounts Receivable Ageing Report Matrix.mp4 27MB
  12. 06 FILTERING/001 Filter by Dates.mp4 25MB
  13. 11 GETPIVOTDATA Formula/008 CASE STUDY FINANCIAL Channel Analysis with GETPIVOTDATA.mp4 25MB
  14. 02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/008 Std Dev.mp4 25MB
  15. 03 VALUE FIELD SETTINGS SHOW VALUES AS/008 Difference From.mp4 24MB
  16. 10 CONDITIONAL FORMATTING PIVOT TABLES/006 Data Bars, Color Scales Icon Sets NEW IN EXCEL 2010.mp4 24MB
  17. 01 CUSTOMIZING YOUR PIVOT TABLE/030 OPTIONS SHOW Expand Collapse buttons.mp4 24MB
  18. 01 CUSTOMIZING YOUR PIVOT TABLE/023 DESIGN STYLES Customising a Pivot Table Style.mp4 23MB
  19. 03 VALUE FIELD SETTINGS SHOW VALUES AS/017 CASE STUDY FINANCIAL Actual v Plan Variance Report.mp4 23MB
  20. 07 SLICERS NEW IN EXCEL 2010/003 Creating a custom style.mp4 23MB
  21. 07 SLICERS NEW IN EXCEL 2010/013 CASE STUDY FINANCIAL Base, Best Worst case Forecast.mp4 23MB
  22. 01 CUSTOMIZING YOUR PIVOT TABLE/022 DESIGN STYLES Pivot Table Styles.mp4 22MB
  23. 10 CONDITIONAL FORMATTING PIVOT TABLES/014 Show text in the Pivot Table Values area.mp4 22MB
  24. 14 BONUS VIDEOS/002 Consolidate with a Pivot Table.mp4 22MB
  25. 11 GETPIVOTDATA Formula/001 Intro to GETPIVOTDATA.mp4 22MB
  26. 07 SLICERS NEW IN EXCEL 2010/005 Slicer Settings.mp4 22MB
  27. 01 CUSTOMIZING YOUR PIVOT TABLE/016 OPTIONS DATA Refresh External Data.mp4 21MB
  28. 08 CALCULATED FIELDS ITEMS/011 TIP Solve Order for Calculated Items.mp4 21MB
  29. 14 BONUS VIDEOS/001 Sales Forecasting with Calculated Fields.mp4 21MB
  30. 04 GROUPING/011 TIP Group by fiscal years quarters.mp4 21MB
  31. 07 SLICERS NEW IN EXCEL 2010/012 CASE STUDY ACCOUNTING Select a Monthly PL report with a Slicer.mp4 21MB
  32. 09 PIVOT CHARTS/004 Pivot Chart Layouts.mp4 20MB
  33. 02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/012 TIP See all pivot Items.mp4 20MB
  34. 04 GROUPING/017 CASE STUDY FINANCIAL Min Max Bank Balance.mp4 20MB
  35. 09 PIVOT CHARTS/005 Pivot Chart Formats.mp4 20MB
  36. 03 VALUE FIELD SETTINGS SHOW VALUES AS/009 Difference From.mp4 20MB
  37. 01 CUSTOMIZING YOUR PIVOT TABLE/008 CREATING A PIVOT TABLE Field List Areas.mp4 19MB
  38. 01 CUSTOMIZING YOUR PIVOT TABLE/020 OPTIONS ACTIONS Select format.mp4 19MB
  39. 01 CUSTOMIZING YOUR PIVOT TABLE/018 OPTIONS DATA Change Data Source.mp4 19MB
  40. 12 MACROS PIVOT TABLES/004 Different pivot table views macro.mp4 19MB
  41. 03 VALUE FIELD SETTINGS SHOW VALUES AS/004 Of.mp4 18MB
  42. 02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/009 Varp.mp4 18MB
  43. 08 CALCULATED FIELDS ITEMS/005 Creating a Calculated Item.mp4 18MB
  44. 12 MACROS PIVOT TABLES/002 Record a simple macro to Refresh a pivot table.mp4 18MB
  45. 08 CALCULATED FIELDS ITEMS/001 Creating a Calculated Field.mp4 17MB
  46. 10 CONDITIONAL FORMATTING PIVOT TABLES/005 Top Bottom Rules.mp4 17MB
  47. 02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/003 Average.mp4 17MB
  48. 03 VALUE FIELD SETTINGS SHOW VALUES AS/007 of Parent Total NEW IN EXCEL 2010.mp4 17MB
  49. 01 CUSTOMIZING YOUR PIVOT TABLE/004 ARRANGING YOUR DATA SET Tables.mp4 16MB
  50. 10 CONDITIONAL FORMATTING PIVOT TABLES/017 CASE STUDY FINANCIAL Conditionally Format your sales results.mp4 16MB
  51. 03 VALUE FIELD SETTINGS SHOW VALUES AS/014 Index.mp4 15MB
  52. 02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/002 Count.mp4 15MB
  53. 12 MACROS PIVOT TABLES/003 Date filter macro.mp4 15MB
  54. 09 PIVOT CHARTS/003 Pivot Chart Designs.mp4 15MB
  55. 04 GROUPING/001 Group by Date.mp4 15MB
  56. 06 FILTERING/008 Filter by Report Filter.mp4 14MB
  57. 02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/013 TIP Show a unique count.mp4 14MB
  58. 08 CALCULATED FIELDS ITEMS/004 Excel formulas Calculated Fields.mp4 14MB
  59. 01 CUSTOMIZING YOUR PIVOT TABLE/027 DESIGN LAYOUT Report Layouts.mp4 14MB
  60. 04 GROUPING/004 Group by Sales ranges.mp4 14MB
  61. 07 SLICERS NEW IN EXCEL 2010/001 Insert a Slicer.mp4 14MB
  62. 08 CALCULATED FIELDS ITEMS/007 Editing a Calculated Item.mp4 14MB
  63. 07 SLICERS NEW IN EXCEL 2010/007 Slicer Connections for multiple pivot tables.mp4 14MB
  64. 10 CONDITIONAL FORMATTING PIVOT TABLES/001 Intro to Conditional Formatting.mp4 14MB
  65. 11 GETPIVOTDATA Formula/006 TIP Grand Totals to the left of the pivot table.mp4 13MB
  66. 08 CALCULATED FIELDS ITEMS/002 Use an existing Calculated Field in a new calculation.mp4 13MB
  67. 08 CALCULATED FIELDS ITEMS/003 Editing a Calculated Field.mp4 13MB
  68. 02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/010 TIP Show various Grand Totals.mp4 13MB
  69. 01 CUSTOMIZING YOUR PIVOT TABLE/046 LAYOUT FORMAT TIPShow report filter on multiple pages.mp4 13MB
  70. 11 GETPIVOTDATA Formula/004 Data validation with GETPIVOTDATA.mp4 13MB
  71. 03 VALUE FIELD SETTINGS SHOW VALUES AS/001 of Grand Total.mp4 12MB
  72. 06 FILTERING/011 TIP Filter by Text wildcards and .mp4 12MB
  73. 02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/006 Product.mp4 12MB
  74. 13 DATA MANAGEMENT/002 Reducing file memory by deleting the data source.mp4 12MB
  75. 09 PIVOT CHARTS/001 Insert a Pivot Chart.mp4 12MB
  76. 03 VALUE FIELD SETTINGS SHOW VALUES AS/006 of Parent Column Total NEW IN EXCEL 2010.mp4 12MB
  77. 04 GROUPING/012 TIP Errors when grouping by dates.mp4 12MB
  78. 01 CUSTOMIZING YOUR PIVOT TABLE/031 OPTIONS SHOW Move Remove Fields and Items.mp4 12MB
  79. 05 SORTING/004 Sort using a Custom List.mp4 12MB
  80. 03 VALUE FIELD SETTINGS SHOW VALUES AS/011 Running Total in NEW IN EXCEL 2010.mp4 12MB
  81. 01 CUSTOMIZING YOUR PIVOT TABLE/017 OPTIONS DATA Import from Access database.mp4 12MB
  82. 12 MACROS PIVOT TABLES/005 Top 10 macro.mp4 11MB
  83. 03 VALUE FIELD SETTINGS SHOW VALUES AS/002 of Column Total.mp4 11MB
  84. 08 CALCULATED FIELDS ITEMS/009 Calculated Item on Column Labels.mp4 11MB
  85. 01 CUSTOMIZING YOUR PIVOT TABLE/009 CREATING A PIVOT TABLE Drill down to audit.mp4 11MB
  86. 06 FILTERING/003 Filter by Labels - Numerical Text.mp4 11MB
  87. 11 GETPIVOTDATA Formula/003 Reference Dates with GETPIVOTDATA.mp4 11MB
  88. 02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/011 TIP Shortcuts to Field Value Field Settings.mp4 11MB
  89. 09 PIVOT CHARTS/019 TIP Workaround to creating an interactive Scatter graph.mp4 11MB
  90. 03 VALUE FIELD SETTINGS SHOW VALUES AS/016 CASE STUDY ACCOUNTING of Revenue Margins.mp4 11MB
  91. 07 SLICERS NEW IN EXCEL 2010/006 Slicer Size Properties.mp4 11MB
  92. 02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/004 Maximum.mp4 11MB
  93. 03 VALUE FIELD SETTINGS SHOW VALUES AS/010 Running Total in.mp4 11MB
  94. 04 GROUPING/010 TIP Grouping by a custom date.mp4 10MB
  95. 10 CONDITIONAL FORMATTING PIVOT TABLES/013 Control Conditional Formatting with Slicers.mp4 10MB
  96. 13 DATA MANAGEMENT/004 Reducing file memory by keeping data source in MS Access.mp4 10MB
  97. 09 PIVOT CHARTS/017 TIP Charts Dos Donts.mp4 10MB
  98. 07 SLICERS NEW IN EXCEL 2010/002 Slicer Styles.mp4 10MB
  99. 14 BONUS VIDEOS/003 Frequency distribution with a Pivot Table.mp4 10MB
  100. 06 FILTERING/019 CASE STUDY FINANCIAL Top 25 of Channel Partners.mp4 10MB
  101. 03 VALUE FIELD SETTINGS SHOW VALUES AS/013 Rank Largest to Smallest NEW IN EXCEL 2010.mp4 10MB
  102. 01 CUSTOMIZING YOUR PIVOT TABLE/005 ARRANGING YOUR DATA SET TIP Clean Your Data Set.mp4 10MB
  103. 01 CUSTOMIZING YOUR PIVOT TABLE/015 OPTIONS DATA Refresh All.mp4 10MB
  104. 08 CALCULATED FIELDS ITEMS/008 Excel formulas Calculated Items.mp4 10MB
  105. 03 VALUE FIELD SETTINGS SHOW VALUES AS/003 of Row Total.mp4 10MB
  106. 06 FILTERING/002 Filter by Labels - Text.mp4 10MB
  107. 01 CUSTOMIZING YOUR PIVOT TABLE/036 CUSTOMISATION Field name formatting.mp4 10MB
  108. 06 FILTERING/018 CASE STUDY ACCOUNTING Top 5 Expenses report.mp4 9MB
  109. 10 CONDITIONAL FORMATTING PIVOT TABLES/010 TIP Use a formula to determine which cells to format.mp4 9MB
  110. 14 BONUS VIDEOS/004 Break Even Model.mp4 9MB
  111. 13 DATA MANAGEMENT/001 Reducing file memory by copying existing pivot table.mp4 9MB
  112. 10 CONDITIONAL FORMATTING PIVOT TABLES/011 Use selected cells to format multiple fields.mp4 9MB
  113. 10 CONDITIONAL FORMATTING PIVOT TABLES/008 TIP Format only Top or Bottom ranked values - Top 3 sales per year.mp4 9MB
  114. 13 DATA MANAGEMENT/006 Sharing a Pivot Table via OneDrive.mp4 9MB
  115. 08 CALCULATED FIELDS ITEMS/006 Use an existing Calculated Item in a new calculation.mp4 9MB
  116. 03 VALUE FIELD SETTINGS SHOW VALUES AS/012 Rank Smallest to Largest NEW IN EXCEL 2010.mp4 8MB
  117. 08 CALCULATED FIELDS ITEMS/010 Shortcomings of Calculated Items.mp4 8MB
  118. 04 GROUPING/002 Group by Months.mp4 8MB
  119. 02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/001 Create multiple subtotals.mp4 8MB
  120. 09 PIVOT CHARTS/006 Limitations of Pivot Charts workarounds.mp4 8MB
  121. 06 FILTERING/005 Filter by Values - Top or Bottom 10 Items.mp4 8MB
  122. 06 FILTERING/015 TIP Include new items in manual filter.mp4 8MB
  123. 02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/007 Count Numbers.mp4 8MB
  124. 04 GROUPING/009 TIP Group by a Date that starts on a Monday.mp4 8MB
  125. 02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/005 Minimum.mp4 8MB
  126. 06 FILTERING/006 Filter by Values - Top or Bottom .mp4 8MB
  127. 10 CONDITIONAL FORMATTING PIVOT TABLES/012 All cells showing values to format multiple fields.mp4 8MB
  128. 01 CUSTOMIZING YOUR PIVOT TABLE/035 CUSTOMISATION Number formatting.mp4 7MB
  129. 01 CUSTOMIZING YOUR PIVOT TABLE/024 DESIGN STYLES Use a customised style in another workbook.mp4 7MB
  130. 09 PIVOT CHARTS/002 Insert a Slicer with a Pivot Chart.mp4 7MB
  131. 06 FILTERING/013 TIP Apply multiple filters.mp4 7MB
  132. 05 SORTING/003 Sort manually drag, write, right click.mp4 7MB
  133. 04 GROUPING/013 TIP Group two pivot tables independently.mp4 7MB
  134. 10 CONDITIONAL FORMATTING PIVOT TABLES/007 TIP Format only cells that contain - For Bonuses.mp4 7MB
  135. 04 GROUPING/003 Group by Quarters Years.mp4 7MB
  136. 05 SORTING/001 Sorting by Largest or Smallest.mp4 7MB
  137. 12 MACROS PIVOT TABLES/006 Add macro to quick access toolbar.mp4 7MB
  138. 06 FILTERING/009 TIP Shortcuts to filters.mp4 7MB
  139. 01 CUSTOMIZING YOUR PIVOT TABLE/042 LAYOUT FORMAT Format empty cells.mp4 7MB
  140. 07 SLICERS NEW IN EXCEL 2010/010 TIP Lock the workbook but not the slicer.mp4 7MB
  141. 07 SLICERS NEW IN EXCEL 2010/004 Copy a custom style into a new workbook.mp4 7MB
  142. 14 BONUS VIDEOS/005 Several Slicer custom styles for you to use.mp4 7MB
  143. 04 GROUPING/006 Group by Time.mp4 7MB
  144. 01 CUSTOMIZING YOUR PIVOT TABLE/003 ARRANGING YOUR DATA SET Formatting.mp4 7MB
  145. 04 GROUPING/005 Group by Text fields.mp4 7MB
  146. 06 FILTERING/007 Filter by Values - Top or Bottom Sum.mp4 7MB
  147. 07 SLICERS NEW IN EXCEL 2010/009 TIP Use one slicer for two pivot tables.mp4 7MB
  148. 01 CUSTOMIZING YOUR PIVOT TABLE/007 CREATING A PIVOT TABLE Field List - Activate, move, resize layout.mp4 7MB
  149. 14 BONUS VIDEOS/008 Reconciling customer payments.mp4 6MB
  150. 10 CONDITIONAL FORMATTING PIVOT TABLES/002 Highlight Cell Rules based on values.mp4 6MB
  151. 09 PIVOT CHARTS/007 Saving a Pivot Chart template.mp4 6MB
  152. 06 FILTERING/016 TIP Clear filters with one click.mp4 6MB
  153. 04 GROUPING/015 TIP Display dates that have no data.mp4 6MB
  154. 05 SORTING/002 Sort an Item Row Left to Right.mp4 6MB
  155. 13 DATA MANAGEMENT/003 Reducing file memory by saving file as Excel Binary Workbook.mp4 6MB
  156. 01 CUSTOMIZING YOUR PIVOT TABLE/045 LAYOUT FORMAT TIP Printing a pivot table on two pages.mp4 6MB
  157. 11 GETPIVOTDATA Formula/005 Shortfalls of GETPIVOTDATA.mp4 6MB
  158. 01 CUSTOMIZING YOUR PIVOT TABLE/040 LAYOUT FORMAT Change the layout of a report filter.mp4 6MB
  159. 10 CONDITIONAL FORMATTING PIVOT TABLES/009 TIP Format values that are above or below the average - For Promotions.mp4 6MB
  160. 09 PIVOT CHARTS/015 TIP Printing a Pivot Chart.mp4 6MB
  161. 09 PIVOT CHARTS/014 TIP Paste Pivot Chart to PowerPoint make live updates.mp4 6MB
  162. 05 SORTING/006 Sort row from A-Z and sales from Z-A.mp4 6MB
  163. 01 CUSTOMIZING YOUR PIVOT TABLE/029 DESIGN LAYOUT TIP Show the Classic Pivot Table Layout.mp4 6MB
  164. 01 CUSTOMIZING YOUR PIVOT TABLE/039 LAYOUT FORMAT Indent rows in compact layout.mp4 6MB
  165. 04 GROUPING/007 TIP Shortcuts to Grouping.mp4 6MB
  166. 10 CONDITIONAL FORMATTING PIVOT TABLES/004 Highlight Cell Rules based on date labels.mp4 6MB
  167. 10 CONDITIONAL FORMATTING PIVOT TABLES/015 Cond Format blank cells or cells.mp4 6MB
  168. 09 PIVOT CHARTS/008 TIP Shortcuts to formatting a Pivot Chart.mp4 6MB
  169. 01 CUSTOMIZING YOUR PIVOT TABLE/037 CUSTOMISATION TIP Predetermined number formatting.mp4 6MB
  170. 09 PIVOT CHARTS/016 TIP Include a Sparkline with your pivot table.mp4 6MB
  171. 06 FILTERING/004 Filter by Values.mp4 6MB
  172. 01 CUSTOMIZING YOUR PIVOT TABLE/034 CUSTOMISATION Change Count of to Sum of.mp4 5MB
  173. 04 GROUPING/008 TIP Grouping by Half Years.mp4 5MB
  174. 01 CUSTOMIZING YOUR PIVOT TABLE/014 OPTIONS DATA Refresh.mp4 5MB
  175. 06 FILTERING/014 TIP Filter by multiple values.mp4 5MB
  176. 05 SORTING/005 Override a Custom List sort.mp4 5MB
  177. 08 CALCULATED FIELDS ITEMS/012 TIP List Calculated Field Item formulas.mp4 5MB
  178. 03 VALUE FIELD SETTINGS SHOW VALUES AS/015 TIP Shortcuts to Show Values As.mp4 5MB
  179. 01 CUSTOMIZING YOUR PIVOT TABLE/019 OPTIONS ACTIONS Clear Filters Clear Pivot.mp4 5MB
  180. 01 CUSTOMIZING YOUR PIVOT TABLE/026 DESIGN LAYOUT Grand Totals.mp4 5MB
  181. 05 SORTING/007 TIP Sort new items added to your data source.mp4 5MB
  182. 01 CUSTOMIZING YOUR PIVOT TABLE/043 LAYOUT FORMAT Keep column widths upon refresh.mp4 5MB
  183. 09 PIVOT CHARTS/012 TIP Insert Pivot Chart straight from the data source.mp4 5MB
  184. 07 SLICERS NEW IN EXCEL 2010/008 TIP Different ways to filter a Slicer.mp4 5MB
  185. 08 CALCULATED FIELDS ITEMS/014 TIP Order of operations.mp4 5MB
  186. 10 CONDITIONAL FORMATTING PIVOT TABLES/003 Highlight Cell Rules based on text labels.mp4 4MB
  187. 01 CUSTOMIZING YOUR PIVOT TABLE/013 OPTIONS DATA Pivot Cache explained.mp4 4MB
  188. 06 FILTERING/012 TIP Filter by multiple fields.mp4 4MB
  189. 13 DATA MANAGEMENT/005 Compatibility Issues with Excel 2007 and Excel 2010.mp4 4MB
  190. 01 CUSTOMIZING YOUR PIVOT TABLE/021 OPTIONS ACTIONS Move a Pivot Table.mp4 4MB
  191. 01 CUSTOMIZING YOUR PIVOT TABLE/025 DESIGN LAYOUT Subtotals.mp4 4MB
  192. 01 CUSTOMIZING YOUR PIVOT TABLE/044 LAYOUT FORMAT TIP Automatic Refresh a Pivot Table.mp4 4MB
  193. 08 CALCULATED FIELDS ITEMS/013 TIP Remove a Calculated Field temporarily.mp4 4MB
  194. 09 PIVOT CHARTS/009 TIP Link chart title to a pivot cell.mp4 4MB
  195. 12 MACROS PIVOT TABLES/001 Adding the Developer tab disabling macros.mp4 4MB
  196. 06 FILTERING/010 TIP Keep or hide selected items.mp4 4MB
  197. 09 PIVOT CHARTS/010 TIP Copying a second chart.mp4 4MB
  198. 09 PIVOT CHARTS/013 TIP Paste Pivot Chart to your email as a picture.mp4 4MB
  199. 01 CUSTOMIZING YOUR PIVOT TABLE/011 CREATING A PIVOT TABLE TIP Double click on any labels to show more Fields.mp4 3MB
  200. 01 CUSTOMIZING YOUR PIVOT TABLE/041 LAYOUT FORMAT Format error values.mp4 3MB
  201. 01 CUSTOMIZING YOUR PIVOT TABLE/012 CREATING A PIVOT TABLE TIP Defer Layout Update.mp4 3MB
  202. 01 CUSTOMIZING YOUR PIVOT TABLE/038 CUSTOMISATION TIP Change Sum views in Label areas.mp4 3MB
  203. 06 FILTERING/017 TIP Add a filter for the column items.mp4 3MB
  204. 01 CUSTOMIZING YOUR PIVOT TABLE/006 CREATING A PIVOT TABLE Inserting a Pivot Table.mp4 3MB
  205. 01 CUSTOMIZING YOUR PIVOT TABLE/010 CREATING A PIVOT TABLE Sort Field List from A to Z.mp4 3MB
  206. 01 CUSTOMIZING YOUR PIVOT TABLE/028 DESIGN LAYOUT Blank Rows.mp4 3MB
  207. 04 GROUPING/014 TIP Fixing the problem of counting grouped sales.mp4 3MB
  208. 05 SORTING/008 TIP Clear a sort.mp4 3MB
  209. 09 PIVOT CHARTS/011 TIP Put a chart on a separate page with F11.mp4 3MB
  210. 00 None/000 INTRODUCTION.mp4 2MB
  211. 05 SORTING/009 TIP Sort Largest to Smallest Grand Totals.mp4 2MB
  212. 01 CUSTOMIZING YOUR PIVOT TABLE/001 ARRANGING YOUR DATA SET Tabular Format.mp4 2MB
  213. 01 CUSTOMIZING YOUR PIVOT TABLE/033 OPTIONS SHOW ShowHide Field Headers.mp4 2MB
  214. 01 CUSTOMIZING YOUR PIVOT TABLE/032 OPTIONS SHOW ShowHide Field List.mp4 2MB
  215. 14 BONUS VIDEOS/009 THANK YOU.mp4 2MB
  216. 01 CUSTOMIZING YOUR PIVOT TABLE/002 ARRANGING YOUR DATA SET No Gaps.mp4 1MB
  217. 11 GETPIVOTDATA Formula/002 Create a custom report with GETPIVOTDATA.mp4 1MB
  218. 00 None/000 BONUS PIVOT TABLE CHEAT SHEET.pdf 995KB
  219. 03 VALUE FIELD SETTINGS SHOW VALUES AS/005 of Parent Row Total NEW IN EXCEL 2010.mp4 591KB
  220. 00 None/001 BONUS EXCEL RESOURCE BLOG.pdf 279KB
  221. 00 None/002 BONUS MY EXCEL PODCAST SHOW.pdf 30KB
  222. 07 SLICERS NEW IN EXCEL 2010/001 Identify the steps for customizing a Slicer Quiz.html 7KB
  223. 03 VALUE FIELD SETTINGS SHOW VALUES AS/001 Identify the steps to showing the values as a Year to Date accumulation Quiz.html 7KB
  224. 02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/001 Recall the way to change a Count Of to a Sum Of Quiz.html 7KB
  225. 08 CALCULATED FIELDS ITEMS/001 State the steps to creating a Calculated Item Quiz.html 7KB
  226. 05 SORTING/001 Identify the steps to creating a Custom List Quiz.html 7KB
  227. 10 CONDITIONAL FORMATTING PIVOT TABLES/001 Recognize the option that conditionally formats all values except the Subtotals Quiz.html 7KB
  228. 11 GETPIVOTDATA Formula/001 Define when to use the GETPIVOTDATA function Quiz.html 7KB
  229. 12 MACROS PIVOT TABLES/001 Recall how to assign a macro Quiz.html 7KB
  230. 13 DATA MANAGEMENT/001 List the ways to reduce the memory size of an Excel file Quiz.html 7KB
  231. 09 PIVOT CHARTS/001 State the button to format a Pivot Chart Quiz.html 7KB
  232. 01 CUSTOMIZING YOUR PIVOT TABLE/001 Recognize which button is used to update a Pivot Table Quiz.html 7KB
  233. 06 FILTERING/001 Recall the command to search for a wildcard entry Quiz.html 7KB
  234. 04 GROUPING/001 State which command is used to group a PivotTable report by weeks Quiz.html 7KB
  235. 00 None/001 BONUS TOP 20 EXCEL SHORTCUTS.html 2KB
  236. 00 None/000 COURSE TRACKER WORKBOOK.html 2KB
  237. 05 SORTING/001 WORKBOOKS.html 1KB
  238. 10 CONDITIONAL FORMATTING PIVOT TABLES/001 WORKBOOKS.html 1KB
  239. 07 SLICERS NEW IN EXCEL 2010/001 WORKBOOKS.html 1KB
  240. 06 FILTERING/001 WORKBOOKS.html 1KB
  241. 09 PIVOT CHARTS/001 WORKBOOKS.html 1KB
  242. 14 BONUS VIDEOS/001 WORKBOOKS.html 1KB
  243. 12 MACROS PIVOT TABLES/001 WORKBOOKS.html 1KB
  244. 11 GETPIVOTDATA Formula/001 WORKBOOKS.html 1KB
  245. 02 VALUE FIELD SETTINGS SUMMARIZE VALUES BY/001 WORKBOOKS.html 1KB
  246. 03 VALUE FIELD SETTINGS SHOW VALUES AS/001 WORKBOOKS.html 1KB
  247. 08 CALCULATED FIELDS ITEMS/001 WORKBOOKS.html 1KB
  248. 04 GROUPING/001 WORKBOOKS.html 1KB
  249. 01 CUSTOMIZING YOUR PIVOT TABLE/001 WORKBOOKS.html 1KB
  250. 13 DATA MANAGEMENT/001 WORKBOOKS.html 1KB