589689.xyz

Udemy - Excel with Excel Pivot Tables!

  • 收录时间:2018-03-09 00:30:09
  • 文件大小:3GB
  • 下载次数:102
  • 最近下载:2020-12-28 12:39:08
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 09_-_PIVOT_CHARTS/185_-_CASE_STUDY_~_FINANCIAL_-_Pivot_Table_Slicer_and_Chart_Dashboard.mp4 68MB
  2. 08_-_CALCULATED_FIELDS_and_ITEMS/162_-_CASE_STUDY_~_ACCOUNTING_-_Creating_a_PandL_Pivot_Table_Report.mp4 59MB
  3. 08_-_CALCULATED_FIELDS_and_ITEMS/163_-_CASE_STUDY_~_FINANCIAL_-_Actuals_v_Plan_with_Calculated_Fields.mp4 51MB
  4. 14_-_BONUS_VIDEOS/233_-_Interactive_Balance_Sheet_Pivot_Table.mp4 48MB
  5. 09_-_PIVOT_CHARTS/184_-_CASE_STUDY_~_ACCOUNTING_-_PandL_Pivot_Table_report_with_Graphs.mp4 38MB
  6. 04_-_GROUPING/101_-_CASE_STUDY_~_ACCOUNTING_-_Quarterly_Comparative_Report.mp4 38MB
  7. 07_-_SLICERS_NEW_IN_EXCEL_2010/144_-_TIP_-_Interactive_employee_photos_with_Slicers_FUN_.mp4 31MB
  8. 11_-_GETPIVOTDATA_Formula/211_-_CASE_STUDY_~_ACCOUNTING_-_Live_forecasting_with_GETPIVOTDATA.mp4 31MB
  9. 09_-_PIVOT_CHARTS/182_-_TIP_-_Change_Chart_Type_with_Slicers_FUN_.mp4 29MB
  10. 14_-_BONUS_VIDEOS/234_-_Monthly_Sales_Manager_Performance_Report.mp4 28MB
  11. 10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/202_-_CASE_STUDY_~_ACCOUNTING_-_Accounts_Receivable_Ageing_Report_Matrix.mp4 27MB
  12. 06_-_FILTERING/114_-_Filter_by_Dates.mp4 25MB
  13. 11_-_GETPIVOTDATA_Formula/212_-_CASE_STUDY_~_FINANCIAL_-_Channel_Analysis_with_GETPIVOTDATA.mp4 25MB
  14. 02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/61_-_Std_Dev.mp4 25MB
  15. 03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/75_-_Difference_From.mp4 24MB
  16. 10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/192_-_Data_Bars_Color_Scales_and_Icon_Sets_NEW_IN_EXCEL_2010_.mp4 24MB
  17. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/36_-_OPTIONS_SHOW_~_Expand_and_Collapse_buttons.mp4 24MB
  18. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/29_-_DESIGN_STYLES_~_Customising_a_Pivot_Table_Style.mp4 23MB
  19. 03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/84_-_CASE_STUDY_~_FINANCIAL_-_Actual_v_Plan_Variance_Report.mp4 23MB
  20. 07_-_SLICERS_NEW_IN_EXCEL_2010/136_-_Creating_a_custom_style.mp4 23MB
  21. 07_-_SLICERS_NEW_IN_EXCEL_2010/146_-_CASE_STUDY_~_FINANCIAL_-_Base_Best_and_Worst_case_Forecast.mp4 23MB
  22. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/28_-_DESIGN_STYLES_~_Pivot_Table_Styles.mp4 22MB
  23. 10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/200_-_Show_text_in_the_Pivot_Table_Values_area.mp4 22MB
  24. 14_-_BONUS_VIDEOS/229_-_Consolidate_with_a_Pivot_Table.mp4 22MB
  25. 11_-_GETPIVOTDATA_Formula/205_-_Intro_to_GETPIVOTDATA.mp4 22MB
  26. 07_-_SLICERS_NEW_IN_EXCEL_2010/138_-_Slicer_Settings.mp4 22MB
  27. 03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/72_-_Percent_of_Parent_Row_Total_NEW_IN_EXCEL_2010_.mp4 22MB
  28. 11_-_GETPIVOTDATA_Formula/206_-_Create_a_custom_report_with_GETPIVOTDATA.mp4 22MB
  29. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/22_-_OPTIONS_DATA_~_Refresh_External_Data.mp4 21MB
  30. 08_-_CALCULATED_FIELDS_and_ITEMS/158_-_TIP_-_Solve_Order_for_Calculated_Items.mp4 21MB
  31. 14_-_BONUS_VIDEOS/228_-_Sales_Forecasting_with_Calculated_Fields.mp4 21MB
  32. 04_-_GROUPING/96_-_TIP_-_Group_by_fiscal_years_and_quarters.mp4 21MB
  33. 07_-_SLICERS_NEW_IN_EXCEL_2010/145_-_CASE_STUDY_~_ACCOUNTING_-_Select_a_Monthly_PandL_report_with_a_Slicer.mp4 21MB
  34. 04_-_GROUPING/98_-_TIP_-_Group_two_pivot_tables_independently.mp4 21MB
  35. 09_-_PIVOT_CHARTS/168_-_Pivot_Chart_Layouts.mp4 20MB
  36. 02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/65_-_TIP_-_See_all_pivot_Items.mp4 20MB
  37. 04_-_GROUPING/102_-_CASE_STUDY_~_FINANCIAL_-_Min_and_Max_Bank_Balance.mp4 20MB
  38. 09_-_PIVOT_CHARTS/169_-_Pivot_Chart_Formats.mp4 20MB
  39. 03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/76_-_Percent_Difference_From.mp4 20MB
  40. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/14_-_CREATING_A_PIVOT_TABLE_~_Field_List_and_Areas.mp4 19MB
  41. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/26_-_OPTIONS_ACTIONS_~_Select_and_format.mp4 19MB
  42. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/24_-_OPTIONS_DATA_~_Change_Data_Source.mp4 19MB
  43. 12_-_MACROS_and_PIVOT_TABLES/217_-_Different_pivot_table_views_macro.mp4 19MB
  44. 03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/71_-_Percent_Of.mp4 18MB
  45. 02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/62_-_Varp.mp4 18MB
  46. 08_-_CALCULATED_FIELDS_and_ITEMS/152_-_Creating_a_Calculated_Item.mp4 18MB
  47. 12_-_MACROS_and_PIVOT_TABLES/215_-_Record_a_simple_macro_to_Refresh_a_pivot_table.mp4 18MB
  48. 08_-_CALCULATED_FIELDS_and_ITEMS/148_-_Creating_a_Calculated_Field.mp4 17MB
  49. 10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/191_-_Top_and_Bottom_Rules.mp4 17MB
  50. 02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/56_-_Average.mp4 17MB
  51. 03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/74_-_Percent_of_Parent_Total_NEW_IN_EXCEL_2010_.mp4 17MB
  52. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/10_-_ARRANGING_YOUR_DATA_SET_~_Tables.mp4 16MB
  53. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/07_-_ARRANGING_YOUR_DATA_SET_~_Tabular_Format.mp4 16MB
  54. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/08_-_ARRANGING_YOUR_DATA_SET_~_No_Gaps.mp4 16MB
  55. 10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/203_-_CASE_STUDY_~_FINANCIAL_-_Conditionally_Format_your_sales_results.mp4 16MB
  56. 03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/81_-_Index.mp4 15MB
  57. 06_-_FILTERING/117_-_Filter_by_Values.mp4 15MB
  58. 02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/55_-_Count.mp4 15MB
  59. 12_-_MACROS_and_PIVOT_TABLES/216_-_Date_filter_macro.mp4 15MB
  60. 09_-_PIVOT_CHARTS/167_-_Pivot_Chart_Designs.mp4 15MB
  61. 06_-_FILTERING/121_-_Filter_by_Report_Filter.mp4 14MB
  62. 02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/66_-_TIP_-_Show_a_unique_count.mp4 14MB
  63. 08_-_CALCULATED_FIELDS_and_ITEMS/151_-_Excel_formulas_and_Calculated_Fields.mp4 14MB
  64. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/33_-_DESIGN_LAYOUT_~_Report_Layouts.mp4 14MB
  65. 04_-_GROUPING/89_-_Group_by_Sales_ranges.mp4 14MB
  66. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/12_-_CREATING_A_PIVOT_TABLE_~_Inserting_a_Pivot_Table.mp4 14MB
  67. 07_-_SLICERS_NEW_IN_EXCEL_2010/134_-_Insert_a_Slicer.mp4 14MB
  68. 08_-_CALCULATED_FIELDS_and_ITEMS/154_-_Editing_a_Calculated_Item.mp4 14MB
  69. 07_-_SLICERS_NEW_IN_EXCEL_2010/140_-_Slicer_Connections_for_multiple_pivot_tables.mp4 14MB
  70. 10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/187_-_Intro_to_Conditional_Formatting.mp4 14MB
  71. 11_-_GETPIVOTDATA_Formula/210_-_TIP_-_Grand_Totals_to_the_left_of_the_pivot_table.mp4 13MB
  72. 08_-_CALCULATED_FIELDS_and_ITEMS/149_-_Use_an_existing_Calculated_Field_in_a_new_calculation.mp4 13MB
  73. 08_-_CALCULATED_FIELDS_and_ITEMS/150_-_Editing_a_Calculated_Field.mp4 13MB
  74. 02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/63_-_TIP_-_Show_various_Grand_Totals.mp4 13MB
  75. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/52_-_LAYOUT_and_FORMAT_~_TIP_-Show_report_filter_on_multiple_pages.mp4 13MB
  76. 11_-_GETPIVOTDATA_Formula/208_-_Data_validation_with_GETPIVOTDATA.mp4 13MB
  77. 03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/68_-_Percent_of_Grand_Total.mp4 12MB
  78. 06_-_FILTERING/124_-_TIP_-_Filter_by_Text_wildcards_and_.mp4 12MB
  79. 02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/59_-_Product.mp4 12MB
  80. 13_-_DATA_MANAGEMENT/222_-_Reducing_file_memory_by_deleting_the_data_source.mp4 12MB
  81. 09_-_PIVOT_CHARTS/165_-_Insert_a_Pivot_Chart.mp4 12MB
  82. 03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/73_-_Percent_of_Parent_Column_Total_NEW_IN_EXCEL_2010_.mp4 12MB
  83. 04_-_GROUPING/97_-_TIP_-_Errors_when_grouping_by_dates.mp4 12MB
  84. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/37_-_OPTIONS_SHOW_~_Move_and_Remove_Fields_and_Items.mp4 12MB
  85. 05_-_SORTING/107_-_Sort_using_a_Custom_List.mp4 12MB
  86. 03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/78_-_Percent_Running_Total_in_NEW_IN_EXCEL_2010_.mp4 12MB
  87. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/23_-_OPTIONS_DATA_~_Import_from_Access_database.mp4 12MB
  88. 12_-_MACROS_and_PIVOT_TABLES/218_-_Top_10_macro.mp4 11MB
  89. 03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/69_-_Percent_of_Column_Total.mp4 11MB
  90. 08_-_CALCULATED_FIELDS_and_ITEMS/156_-_Calculated_Item_on_Column_Labels.mp4 11MB
  91. 03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/70_-_Percent_of_Row_Total.mp4 11MB
  92. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/15_-_CREATING_A_PIVOT_TABLE_~_Drill_down_to_audit.mp4 11MB
  93. 06_-_FILTERING/116_-_Filter_by_Labels_-_Numerical_Text.mp4 11MB
  94. 11_-_GETPIVOTDATA_Formula/207_-_Reference_Dates_with_GETPIVOTDATA.mp4 11MB
  95. 02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/64_-_TIP_-_Shortcuts_to_Field_and_Value_Field_Settings.mp4 11MB
  96. 09_-_PIVOT_CHARTS/183_-_TIP_-_Workaround_to_creating_an_interactive_Scatter_graph.mp4 11MB
  97. 03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/83_-_CASE_STUDY_~_ACCOUNTING_-_Percent_of_Revenue_Margins.mp4 11MB
  98. 07_-_SLICERS_NEW_IN_EXCEL_2010/139_-_Slicer_Size_and_Properties.mp4 11MB
  99. 02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/57_-_Maximum.mp4 11MB
  100. 03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/77_-_Running_Total_in.mp4 11MB
  101. 04_-_GROUPING/95_-_TIP_-_Grouping_by_a_custom_date.mp4 10MB
  102. 10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/199_-_Control_Conditional_Formatting_with_Slicers.mp4 10MB
  103. 13_-_DATA_MANAGEMENT/224_-_Reducing_file_memory_by_keeping_data_source_in_MS_Access.mp4 10MB
  104. 09_-_PIVOT_CHARTS/181_-_TIP_-_Charts_Do_s_and_Don_ts.mp4 10MB
  105. 07_-_SLICERS_NEW_IN_EXCEL_2010/135_-_Slicer_Styles.mp4 10MB
  106. 14_-_BONUS_VIDEOS/230_-_Frequency_distribution_with_a_Pivot_Table.mp4 10MB
  107. 06_-_FILTERING/132_-_CASE_STUDY_~_FINANCIAL_-_Top_25Percent_of_Channel_Partners.mp4 10MB
  108. 03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/80_-_Rank_Largest_to_Smallest_NEW_IN_EXCEL_2010_.mp4 10MB
  109. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/11_-_ARRANGING_YOUR_DATA_SET_~_TIP_-_Clean_Your_Data_Set.mp4 10MB
  110. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/21_-_OPTIONS_DATA_~_Refresh_All.mp4 10MB
  111. 08_-_CALCULATED_FIELDS_and_ITEMS/155_-_Excel_formulas_and_Calculated_Items.mp4 10MB
  112. 06_-_FILTERING/115_-_Filter_by_Labels_-_Text.mp4 10MB
  113. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/42_-_CUSTOMISATION_~_Field_name_formatting.mp4 10MB
  114. 06_-_FILTERING/131_-_CASE_STUDY_~_ACCOUNTING_-_Top_5_Expenses_report.mp4 9MB
  115. 10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/196_-_TIP_-_Use_a_formula_to_determine_which_cells_to_format.mp4 9MB
  116. 14_-_BONUS_VIDEOS/231_-_Break_Even_Model.mp4 9MB
  117. 12_-_MACROS_and_PIVOT_TABLES/214_-_Adding_the_Developer_tab_and_disabling_macros.mp4 9MB
  118. 04_-_GROUPING/86_-_Group_by_Date.mp4 9MB
  119. 13_-_DATA_MANAGEMENT/221_-_Reducing_file_memory_by_copying_existing_pivot_table.mp4 9MB
  120. 10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/197_-_Use_selected_cells_to_format_multiple_fields.mp4 9MB
  121. 10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/194_-_TIP_-_Format_only_Top_or_Bottom_ranked_values_-_Top_3_sales_per_year.mp4 9MB
  122. 13_-_DATA_MANAGEMENT/226_-_Sharing_a_Pivot_Table_via_OneDrive.mp4 9MB
  123. 08_-_CALCULATED_FIELDS_and_ITEMS/153_-_Use_an_existing_Calculated_Item_in_a_new_calculation.mp4 9MB
  124. 03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/79_-_Rank_Smallest_to_Largest_NEW_IN_EXCEL_2010_.mp4 8MB
  125. 08_-_CALCULATED_FIELDS_and_ITEMS/157_-_Shortcomings_of_Calculated_Items.mp4 8MB
  126. 04_-_GROUPING/87_-_Group_by_Months.mp4 8MB
  127. 02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/54_-_Create_multiple_subtotals.mp4 8MB
  128. 09_-_PIVOT_CHARTS/170_-_Limitations_of_Pivot_Charts_and_workarounds.mp4 8MB
  129. 06_-_FILTERING/118_-_Filter_by_Values_-_Top_or_Bottom_10_Items.mp4 8MB
  130. 06_-_FILTERING/128_-_TIP_-_Include_new_items_in_manual_filter.mp4 8MB
  131. 02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/60_-_Count_Numbers.mp4 8MB
  132. 04_-_GROUPING/94_-_TIP_-_Group_by_a_Date_that_starts_on_a_Monday.mp4 8MB
  133. 02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/58_-_Minimum.mp4 8MB
  134. 06_-_FILTERING/119_-_Filter_by_Values_-_Top_or_Bottom_Percent.mp4 8MB
  135. 10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/198_-_All_cells_showing_values_to_format_multiple_fields.mp4 8MB
  136. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/41_-_CUSTOMISATION_~_Number_formatting.mp4 7MB
  137. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/30_-_DESIGN_STYLES_~_Use_a_customised_style_in_another_workbook.mp4 7MB
  138. 09_-_PIVOT_CHARTS/166_-_Insert_a_Slicer_with_a_Pivot_Chart.mp4 7MB
  139. 06_-_FILTERING/126_-_TIP_-_Apply_multiple_filters.mp4 7MB
  140. 05_-_SORTING/106_-_Sort_manually_drag_write_right_click_.mp4 7MB
  141. 10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/193_-_TIP_-_Format_only_cells_that_contain_-_For_Bonuses.mp4 7MB
  142. 04_-_GROUPING/88_-_Group_by_Quarters_and_Years.mp4 7MB
  143. 05_-_SORTING/104_-_Sorting_by_Largest_or_Smallest.mp4 7MB
  144. 12_-_MACROS_and_PIVOT_TABLES/219_-_Add_macro_to_quick_access_toolbar.mp4 7MB
  145. 06_-_FILTERING/122_-_TIP_-_Shortcuts_to_filters.mp4 7MB
  146. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/48_-_LAYOUT_and_FORMAT_~_Format_empty_cells.mp4 7MB
  147. 07_-_SLICERS_NEW_IN_EXCEL_2010/143_-_TIP_-_Lock_the_workbook_but_not_the_slicer.mp4 7MB
  148. 07_-_SLICERS_NEW_IN_EXCEL_2010/137_-_Copy_a_custom_style_into_a_new_workbook.mp4 7MB
  149. 14_-_BONUS_VIDEOS/232_-_Several_Slicer_custom_styles_for_you_to_use.mp4 7MB
  150. 04_-_GROUPING/91_-_Group_by_Time.mp4 7MB
  151. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/09_-_ARRANGING_YOUR_DATA_SET_~_Formatting.mp4 7MB
  152. 04_-_GROUPING/90_-_Group_by_Text_fields.mp4 7MB
  153. 06_-_FILTERING/120_-_Filter_by_Values_-_Top_or_Bottom_Sum.mp4 7MB
  154. 07_-_SLICERS_NEW_IN_EXCEL_2010/142_-_TIP_-_Use_one_slicer_for_two_pivot_tables.mp4 7MB
  155. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/13_-_CREATING_A_PIVOT_TABLE_~_Field_List_-_Activate_move_resize_and_layout.mp4 7MB
  156. 14_-_BONUS_VIDEOS/235_-_Reconciling_customer_payments.mp4 6MB
  157. 10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/188_-_Highlight_Cell_Rules_based_on_values.mp4 6MB
  158. 09_-_PIVOT_CHARTS/171_-_Saving_a_Pivot_Chart_template.mp4 6MB
  159. 06_-_FILTERING/129_-_TIP_-_Clear_filters_with_one_click.mp4 6MB
  160. 04_-_GROUPING/100_-_TIP_-_Display_dates_that_have_no_data.mp4 6MB
  161. 05_-_SORTING/105_-_Sort_an_Item_Row_Left_to_Right_.mp4 6MB
  162. 13_-_DATA_MANAGEMENT/223_-_Reducing_file_memory_by_saving_file_as_Excel_Binary_Workbook.mp4 6MB
  163. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/51_-_LAYOUT_and_FORMAT_~_TIP_-_Printing_a_pivot_table_on_two_pages.mp4 6MB
  164. 11_-_GETPIVOTDATA_Formula/209_-_Shortfalls_of_GETPIVOTDATA.mp4 6MB
  165. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/46_-_LAYOUT_and_FORMAT_~_Change_the_layout_of_a_report_filter.mp4 6MB
  166. 10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/195_-_TIP_-_Format_values_that_are_above_or_below_the_average_-_For_Promotions.mp4 6MB
  167. 09_-_PIVOT_CHARTS/179_-_TIP_-_Printing_a_Pivot_Chart.mp4 6MB
  168. 09_-_PIVOT_CHARTS/178_-_TIP_-_Paste_Pivot_Chart_to_PowerPoint_and_make_live_updates.mp4 6MB
  169. 05_-_SORTING/109_-_Sort_row_from_A-Z_and_sales_from_Z-A.mp4 6MB
  170. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/35_-_DESIGN_LAYOUT_~_TIP_-_Show_the_Classic_Pivot_Table_Layout.mp4 6MB
  171. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/45_-_LAYOUT_and_FORMAT_~_Indent_rows_in_compact_layout.mp4 6MB
  172. 04_-_GROUPING/92_-_TIP_-_Shortcuts_to_Grouping.mp4 6MB
  173. 10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/190_-_Highlight_Cell_Rules_based_on_date_labels.mp4 6MB
  174. 10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/201_-_Cond_Format_blank_cells_or_cells.mp4 6MB
  175. 09_-_PIVOT_CHARTS/172_-_TIP_-_Shortcuts_to_formatting_a_Pivot_Chart.mp4 6MB
  176. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/43_-_CUSTOMISATION_~_TIP_-_Predetermined_number_formatting.mp4 6MB
  177. 09_-_PIVOT_CHARTS/180_-_TIP_-_Include_a_Sparkline_with_your_pivot_table.mp4 6MB
  178. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/40_-_CUSTOMISATION_~_Change_Count_of_to_Sum_of.mp4 5MB
  179. 04_-_GROUPING/93_-_TIP_-_Grouping_by_Half_Years.mp4 5MB
  180. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/20_-_OPTIONS_DATA_~_Refresh.mp4 5MB
  181. 06_-_FILTERING/127_-_TIP_-_Filter_by_multiple_values.mp4 5MB
  182. 05_-_SORTING/108_-_Override_a_Custom_List_sort.mp4 5MB
  183. 08_-_CALCULATED_FIELDS_and_ITEMS/159_-_TIP_-_List_Calculated_Field_and_Item_formulas.mp4 5MB
  184. 03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/82_-_TIP_-_Shortcuts_to_Show_Values_As.mp4 5MB
  185. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/25_-_OPTIONS_ACTIONS_~_Clear_Filters_and_Clear_Pivot.mp4 5MB
  186. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/32_-_DESIGN_LAYOUT_~_Grand_Totals.mp4 5MB
  187. 05_-_SORTING/110_-_TIP_-_Sort_new_items_added_to_your_data_source.mp4 5MB
  188. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/49_-_LAYOUT_and_FORMAT_~_Keep_column_widths_upon_refresh.mp4 5MB
  189. 09_-_PIVOT_CHARTS/176_-_TIP_-_Insert_Pivot_Chart_straight_from_the_data_source.mp4 5MB
  190. 07_-_SLICERS_NEW_IN_EXCEL_2010/141_-_TIP_-_Different_ways_to_filter_a_Slicer.mp4 5MB
  191. 08_-_CALCULATED_FIELDS_and_ITEMS/161_-_TIP_-_Order_of_operations.mp4 5MB
  192. 10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/189_-_Highlight_Cell_Rules_based_on_text_labels.mp4 4MB
  193. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/19_-_OPTIONS_DATA_~_Pivot_Cache_explained.mp4 4MB
  194. 06_-_FILTERING/125_-_TIP_-_Filter_by_multiple_fields.mp4 4MB
  195. 13_-_DATA_MANAGEMENT/225_-_Compatibility_Issues_with_Excel_2007_and_Excel_2010.mp4 4MB
  196. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/27_-_OPTIONS_ACTIONS_~_Move_a_Pivot_Table.mp4 4MB
  197. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/31_-_DESIGN_LAYOUT_~_Subtotals.mp4 4MB
  198. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/50_-_LAYOUT_and_FORMAT_~_TIP_-_Automatic_Refresh_a_Pivot_Table.mp4 4MB
  199. 08_-_CALCULATED_FIELDS_and_ITEMS/160_-_TIP_-_Remove_a_Calculated_Field_temporarily.mp4 4MB
  200. 09_-_PIVOT_CHARTS/173_-_TIP_-_Link_chart_title_to_a_pivot_cell.mp4 4MB
  201. 06_-_FILTERING/123_-_TIP_-_Keep_or_hide_selected_items.mp4 4MB
  202. 09_-_PIVOT_CHARTS/174_-_TIP_-_Copying_a_second_chart.mp4 4MB
  203. 09_-_PIVOT_CHARTS/177_-_TIP_-_Paste_Pivot_Chart_to_your_email_as_a_picture.mp4 4MB
  204. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/17_-_CREATING_A_PIVOT_TABLE_~_TIP_-_Double_click_on_any_labels_to_show_more_Fields.mp4 3MB
  205. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/47_-_LAYOUT_and_FORMAT_~_Format_error_values.mp4 3MB
  206. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/18_-_CREATING_A_PIVOT_TABLE_~_TIP_-_Defer_Layout_Update.mp4 3MB
  207. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/44_-_CUSTOMISATION_~_TIP_-_Change_Sum_views_in_Label_areas.mp4 3MB
  208. 06_-_FILTERING/130_-_TIP_-_Add_a_filter_for_the_column_items.mp4 3MB
  209. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/16_-_CREATING_A_PIVOT_TABLE_~_Sort_Field_List_from_A_to_Z.mp4 3MB
  210. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/34_-_DESIGN_LAYOUT_~_Blank_Rows.mp4 3MB
  211. 04_-_GROUPING/99_-_TIP_-_Fixing_the_problem_of_counting_grouped_sales.mp4 3MB
  212. 05_-_SORTING/111_-_TIP_-_Clear_a_sort.mp4 3MB
  213. 09_-_PIVOT_CHARTS/175_-_TIP_-_Put_a_chart_on_a_separate_page_with_F11.mp4 3MB
  214. 00_-_None/01_-_INTRODUCTION.mp4 2MB
  215. 05_-_SORTING/112_-_TIP_-_Sort_Largest_to_Smallest_Grand_Totals.mp4 2MB
  216. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/39_-_OPTIONS_SHOW_~_Show_Hide_Field_Headers.mp4 2MB
  217. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/38_-_OPTIONS_SHOW_~_Show_Hide_Field_List.mp4 2MB
  218. 14_-_BONUS_VIDEOS/236_-_THANK_YOU_.mp4 2MB
  219. 00_-_None/04_-_BONUS_-_TOP_20_EXCEL_SHORTCUTS.txt 468B
  220. 00_-_None/02_-_COURSE_TRACKER_WORKBOOK.txt 317B
  221. 14_-_BONUS_VIDEOS/227_-_WORKBOOKS.txt 135B
  222. 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/06_-_WORKBOOKS.txt 134B
  223. 13_-_DATA_MANAGEMENT/220_-_WORKBOOKS.txt 55B