Udemy - Excel with Excel Pivot Tables!

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