Udemy Excel with Excel Pivot Tables | 7959D12D60C9C261BF4C70E44B5C3FA4373505E0

Udemy Excel with Excel Pivot Tables

Name	Udemy - Excel with Excel Pivot Tables!	DOWNLOAD Copy Link
Total Size	2.8 GB
Total Files	223
Hash	7959D12D60C9C261BF4C70E44B5C3FA4373505E0

/00_-_None/
01_-_INTRODUCTION.mp4	2.4 MB
02_-_COURSE_TRACKER_WORKBOOK.txt	0.3 KB
04_-_BONUS_-_TOP_20_EXCEL_SHORTCUTS.txt	0.5 KB
/01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/
06_-_WORKBOOKS.txt	0.1 KB
07_-_ARRANGING_YOUR_DATA_SET_~_Tabular_Format.mp4	16.5 MB
08_-_ARRANGING_YOUR_DATA_SET_~_No_Gaps.mp4	16.5 MB
09_-_ARRANGING_YOUR_DATA_SET_~_Formatting.mp4	7.0 MB
10_-_ARRANGING_YOUR_DATA_SET_~_Tables.mp4	16.5 MB
11_-_ARRANGING_YOUR_DATA_SET_~_TIP_-_Clean_Your_Data_Set.mp4	10.4 MB
12_-_CREATING_A_PIVOT_TABLE_~_Inserting_a_Pivot_Table.mp4	14.5 MB
13_-_CREATING_A_PIVOT_TABLE_~_Field_List_-_Activate_move_resize_and_layout.mp4	6.9 MB
14_-_CREATING_A_PIVOT_TABLE_~_Field_List_and_Areas.mp4	20.2 MB
15_-_CREATING_A_PIVOT_TABLE_~_Drill_down_to_audit.mp4	11.7 MB
16_-_CREATING_A_PIVOT_TABLE_~_Sort_Field_List_from_A_to_Z.mp4	3.1 MB
17_-_CREATING_A_PIVOT_TABLE_~_TIP_-_Double_click_on_any_labels_to_show_more_Fields.mp4	3.7 MB
18_-_CREATING_A_PIVOT_TABLE_~_TIP_-_Defer_Layout_Update.mp4	3.6 MB
19_-_OPTIONS_DATA_~_Pivot_Cache_explained.mp4	4.6 MB
20_-_OPTIONS_DATA_~_Refresh.mp4	5.3 MB
21_-_OPTIONS_DATA_~_Refresh_All.mp4	10.3 MB
22_-_OPTIONS_DATA_~_Refresh_External_Data.mp4	22.4 MB
23_-_OPTIONS_DATA_~_Import_from_Access_database.mp4	12.1 MB
24_-_OPTIONS_DATA_~_Change_Data_Source.mp4	20.0 MB
25_-_OPTIONS_ACTIONS_~_Clear_Filters_and_Clear_Pivot.mp4	5.1 MB
26_-_OPTIONS_ACTIONS_~_Select_and_format.mp4	20.0 MB
27_-_OPTIONS_ACTIONS_~_Move_a_Pivot_Table.mp4	4.4 MB
28_-_DESIGN_STYLES_~_Pivot_Table_Styles.mp4	23.6 MB
29_-_DESIGN_STYLES_~_Customising_a_Pivot_Table_Style.mp4	24.3 MB
30_-_DESIGN_STYLES_~_Use_a_customised_style_in_another_workbook.mp4	7.8 MB
31_-_DESIGN_LAYOUT_~_Subtotals.mp4	4.4 MB
32_-_DESIGN_LAYOUT_~_Grand_Totals.mp4	5.0 MB
33_-_DESIGN_LAYOUT_~_Report_Layouts.mp4	14.6 MB
34_-_DESIGN_LAYOUT_~_Blank_Rows.mp4	2.9 MB
35_-_DESIGN_LAYOUT_~_TIP_-_Show_the_Classic_Pivot_Table_Layout.mp4	6.1 MB
36_-_OPTIONS_SHOW_~_Expand_and_Collapse_buttons.mp4	25.1 MB
37_-_OPTIONS_SHOW_~_Move_and_Remove_Fields_and_Items.mp4	12.2 MB
38_-_OPTIONS_SHOW_~_Show_Hide_Field_List.mp4	1.8 MB
39_-_OPTIONS_SHOW_~_Show_Hide_Field_Headers.mp4	1.8 MB
40_-_CUSTOMISATION_~_Change_Count_of_to_Sum_of.mp4	5.8 MB
41_-_CUSTOMISATION_~_Number_formatting.mp4	7.9 MB
42_-_CUSTOMISATION_~_Field_name_formatting.mp4	10.0 MB
43_-_CUSTOMISATION_~_TIP_-_Predetermined_number_formatting.mp4	5.9 MB
44_-_CUSTOMISATION_~_TIP_-_Change_Sum_views_in_Label_areas.mp4	3.3 MB
45_-_LAYOUT_and_FORMAT_~_Indent_rows_in_compact_layout.mp4	6.1 MB
46_-_LAYOUT_and_FORMAT_~_Change_the_layout_of_a_report_filter.mp4	6.3 MB
47_-_LAYOUT_and_FORMAT_~_Format_error_values.mp4	3.6 MB
48_-_LAYOUT_and_FORMAT_~_Format_empty_cells.mp4	7.3 MB
49_-_LAYOUT_and_FORMAT_~_Keep_column_widths_upon_refresh.mp4	4.9 MB
50_-_LAYOUT_and_FORMAT_~_TIP_-_Automatic_Refresh_a_Pivot_Table.mp4	4.4 MB
51_-_LAYOUT_and_FORMAT_~_TIP_-_Printing_a_pivot_table_on_two_pages.mp4	6.4 MB
52_-_LAYOUT_and_FORMAT_~_TIP_-Show_report_filter_on_multiple_pages.mp4	13.4 MB
/02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/
54_-_Create_multiple_subtotals.mp4	8.7 MB
55_-_Count.mp4	15.8 MB
56_-_Average.mp4	17.7 MB
57_-_Maximum.mp4	11.1 MB
58_-_Minimum.mp4	8.1 MB
59_-_Product.mp4	12.8 MB
60_-_Count_Numbers.mp4	8.5 MB
61_-_Std_Dev.mp4	26.0 MB
62_-_Varp.mp4	19.2 MB
63_-_TIP_-_Show_various_Grand_Totals.mp4	13.4 MB
64_-_TIP_-_Shortcuts_to_Field_and_Value_Field_Settings.mp4	11.5 MB
65_-_TIP_-_See_all_pivot_Items.mp4	21.2 MB
66_-_TIP_-_Show_a_unique_count.mp4	14.8 MB
/03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/
68_-_Percent_of_Grand_Total.mp4	13.1 MB
69_-_Percent_of_Column_Total.mp4	11.9 MB
70_-_Percent_of_Row_Total.mp4	11.7 MB
71_-_Percent_Of.mp4	19.4 MB
72_-_Percent_of_Parent_Row_Total_NEW_IN_EXCEL_2010_.mp4	22.9 MB
73_-_Percent_of_Parent_Column_Total_NEW_IN_EXCEL_2010_.mp4	12.5 MB
74_-_Percent_of_Parent_Total_NEW_IN_EXCEL_2010_.mp4	17.4 MB
75_-_Difference_From.mp4	25.4 MB
76_-_Percent_Difference_From.mp4	21.0 MB
77_-_Running_Total_in.mp4	11.0 MB
78_-_Percent_Running_Total_in_NEW_IN_EXCEL_2010_.mp4	12.2 MB
79_-_Rank_Smallest_to_Largest_NEW_IN_EXCEL_2010_.mp4	8.8 MB
80_-_Rank_Largest_to_Smallest_NEW_IN_EXCEL_2010_.mp4	10.4 MB
81_-_Index.mp4	16.1 MB
82_-_TIP_-_Shortcuts_to_Show_Values_As.mp4	5.1 MB
83_-_CASE_STUDY_~_ACCOUNTING_-_Percent_of_Revenue_Margins.mp4	11.2 MB
84_-_CASE_STUDY_~_FINANCIAL_-_Actual_v_Plan_Variance_Report.mp4	24.2 MB
/04_-_GROUPING/
86_-_Group_by_Date.mp4	9.2 MB
87_-_Group_by_Months.mp4	8.7 MB
88_-_Group_by_Quarters_and_Years.mp4	7.6 MB
89_-_Group_by_Sales_ranges.mp4	14.6 MB
90_-_Group_by_Text_fields.mp4	7.0 MB
91_-_Group_by_Time.mp4	7.1 MB
92_-_TIP_-_Shortcuts_to_Grouping.mp4	6.0 MB
93_-_TIP_-_Grouping_by_Half_Years.mp4	5.7 MB
94_-_TIP_-_Group_by_a_Date_that_starts_on_a_Monday.mp4	8.1 MB
95_-_TIP_-_Grouping_by_a_custom_date.mp4	11.0 MB
96_-_TIP_-_Group_by_fiscal_years_and_quarters.mp4	22.0 MB
97_-_TIP_-_Errors_when_grouping_by_dates.mp4	12.3 MB
98_-_TIP_-_Group_two_pivot_tables_independently.mp4	21.7 MB
99_-_TIP_-_Fixing_the_problem_of_counting_grouped_sales.mp4	2.8 MB
100_-_TIP_-_Display_dates_that_have_no_data.mp4	6.7 MB
101_-_CASE_STUDY_~_ACCOUNTING_-_Quarterly_Comparative_Report.mp4	39.5 MB
102_-_CASE_STUDY_~_FINANCIAL_-_Min_and_Max_Bank_Balance.mp4	21.1 MB
/05_-_SORTING/
104_-_Sorting_by_Largest_or_Smallest.mp4	7.5 MB
105_-_Sort_an_Item_Row_Left_to_Right_.mp4	6.6 MB
106_-_Sort_manually_drag_write_right_click_.mp4	7.7 MB
107_-_Sort_using_a_Custom_List.mp4	12.2 MB
108_-_Override_a_Custom_List_sort.mp4	5.2 MB
109_-_Sort_row_from_A-Z_and_sales_from_Z-A.mp4	6.1 MB
110_-_TIP_-_Sort_new_items_added_to_your_data_source.mp4	4.9 MB
111_-_TIP_-_Clear_a_sort.mp4	2.8 MB
112_-_TIP_-_Sort_Largest_to_Smallest_Grand_Totals.mp4	2.3 MB
/06_-_FILTERING/
114_-_Filter_by_Dates.mp4	26.3 MB
115_-_Filter_by_Labels_-_Text.mp4	10.2 MB
116_-_Filter_by_Labels_-_Numerical_Text.mp4	11.7 MB
117_-_Filter_by_Values.mp4	15.9 MB
118_-_Filter_by_Values_-_Top_or_Bottom_10_Items.mp4	8.5 MB
119_-_Filter_by_Values_-_Top_or_Bottom_Percent.mp4	8.0 MB
120_-_Filter_by_Values_-_Top_or_Bottom_Sum.mp4	7.0 MB
121_-_Filter_by_Report_Filter.mp4	14.9 MB
122_-_TIP_-_Shortcuts_to_filters.mp4	7.4 MB
123_-_TIP_-_Keep_or_hide_selected_items.mp4	4.0 MB
124_-_TIP_-_Filter_by_Text_wildcards_and_.mp4	13.0 MB
125_-_TIP_-_Filter_by_multiple_fields.mp4	4.6 MB
126_-_TIP_-_Apply_multiple_filters.mp4	7.8 MB
127_-_TIP_-_Filter_by_multiple_values.mp4	5.2 MB
128_-_TIP_-_Include_new_items_in_manual_filter.mp4	8.5 MB
129_-_TIP_-_Clear_filters_with_one_click.mp4	6.7 MB
130_-_TIP_-_Add_a_filter_for_the_column_items.mp4	3.2 MB
131_-_CASE_STUDY_~_ACCOUNTING_-_Top_5_Expenses_report.mp4	9.9 MB
132_-_CASE_STUDY_~_FINANCIAL_-_Top_25Percent_of_Channel_Partners.mp4	10.4 MB
/07_-_SLICERS_NEW_IN_EXCEL_2010/
134_-_Insert_a_Slicer.mp4	14.5 MB
135_-_Slicer_Styles.mp4	10.5 MB
136_-_Creating_a_custom_style.mp4	24.0 MB
137_-_Copy_a_custom_style_into_a_new_workbook.mp4	7.2 MB
138_-_Slicer_Settings.mp4	23.1 MB
139_-_Slicer_Size_and_Properties.mp4	11.2 MB
140_-_Slicer_Connections_for_multiple_pivot_tables.mp4	14.4 MB
141_-_TIP_-_Different_ways_to_filter_a_Slicer.mp4	4.8 MB
142_-_TIP_-_Use_one_slicer_for_two_pivot_tables.mp4	6.9 MB
143_-_TIP_-_Lock_the_workbook_but_not_the_slicer.mp4	7.3 MB
144_-_TIP_-_Interactive_employee_photos_with_Slicers_FUN_.mp4	32.6 MB
145_-_CASE_STUDY_~_ACCOUNTING_-_Select_a_Monthly_PandL_report_with_a_Slicer.mp4	22.0 MB
146_-_CASE_STUDY_~_FINANCIAL_-_Base_Best_and_Worst_case_Forecast.mp4	23.7 MB
/08_-_CALCULATED_FIELDS_and_ITEMS/
148_-_Creating_a_Calculated_Field.mp4	17.9 MB
149_-_Use_an_existing_Calculated_Field_in_a_new_calculation.mp4	13.4 MB
150_-_Editing_a_Calculated_Field.mp4	13.4 MB
151_-_Excel_formulas_and_Calculated_Fields.mp4	14.7 MB
152_-_Creating_a_Calculated_Item.mp4	18.5 MB
153_-_Use_an_existing_Calculated_Item_in_a_new_calculation.mp4	9.0 MB
154_-_Editing_a_Calculated_Item.mp4	14.5 MB
155_-_Excel_formulas_and_Calculated_Items.mp4	10.2 MB
156_-_Calculated_Item_on_Column_Labels.mp4	11.7 MB
157_-_Shortcomings_of_Calculated_Items.mp4	8.8 MB
158_-_TIP_-_Solve_Order_for_Calculated_Items.mp4	22.4 MB
159_-_TIP_-_List_Calculated_Field_and_Item_formulas.mp4	5.1 MB
160_-_TIP_-_Remove_a_Calculated_Field_temporarily.mp4	4.1 MB
161_-_TIP_-_Order_of_operations.mp4	4.7 MB
162_-_CASE_STUDY_~_ACCOUNTING_-_Creating_a_PandL_Pivot_Table_Report.mp4	61.4 MB
163_-_CASE_STUDY_~_FINANCIAL_-_Actuals_v_Plan_with_Calculated_Fields.mp4	53.5 MB
/09_-_PIVOT_CHARTS/
165_-_Insert_a_Pivot_Chart.mp4	12.7 MB
166_-_Insert_a_Slicer_with_a_Pivot_Chart.mp4	7.8 MB
167_-_Pivot_Chart_Designs.mp4	15.8 MB
168_-_Pivot_Chart_Layouts.mp4	21.3 MB
169_-_Pivot_Chart_Formats.mp4	21.0 MB
170_-_Limitations_of_Pivot_Charts_and_workarounds.mp4	8.6 MB
171_-_Saving_a_Pivot_Chart_template.mp4	6.7 MB
172_-_TIP_-_Shortcuts_to_formatting_a_Pivot_Chart.mp4	5.9 MB
173_-_TIP_-_Link_chart_title_to_a_pivot_cell.mp4	4.1 MB
174_-_TIP_-_Copying_a_second_chart.mp4	3.7 MB
175_-_TIP_-_Put_a_chart_on_a_separate_page_with_F11.mp4	2.6 MB
176_-_TIP_-_Insert_Pivot_Chart_straight_from_the_data_source.mp4	4.8 MB
177_-_TIP_-_Paste_Pivot_Chart_to_your_email_as_a_picture.mp4	3.7 MB
178_-_TIP_-_Paste_Pivot_Chart_to_PowerPoint_and_make_live_updates.mp4	6.2 MB
179_-_TIP_-_Printing_a_Pivot_Chart.mp4	6.2 MB
180_-_TIP_-_Include_a_Sparkline_with_your_pivot_table.mp4	5.8 MB
181_-_TIP_-_Charts_Do_s_and_Don_ts.mp4	10.6 MB
182_-_TIP_-_Change_Chart_Type_with_Slicers_FUN_.mp4	30.2 MB
183_-_TIP_-_Workaround_to_creating_an_interactive_Scatter_graph.mp4	11.2 MB
184_-_CASE_STUDY_~_ACCOUNTING_-_PandL_Pivot_Table_report_with_Graphs.mp4	40.4 MB
185_-_CASE_STUDY_~_FINANCIAL_-_Pivot_Table_Slicer_and_Chart_Dashboard.mp4	71.1 MB
/10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/
187_-_Intro_to_Conditional_Formatting.mp4	14.4 MB
188_-_Highlight_Cell_Rules_based_on_values.mp4	6.8 MB
189_-_Highlight_Cell_Rules_based_on_text_labels.mp4	4.6 MB
190_-_Highlight_Cell_Rules_based_on_date_labels.mp4	6.0 MB
191_-_Top_and_Bottom_Rules.mp4	17.9 MB
192_-_Data_Bars_Color_Scales_and_Icon_Sets_NEW_IN_EXCEL_2010_.mp4	25.4 MB
193_-_TIP_-_Format_only_cells_that_contain_-_For_Bonuses.mp4	7.7 MB
194_-_TIP_-_Format_only_Top_or_Bottom_ranked_values_-_Top_3_sales_per_year.mp4	9.0 MB
195_-_TIP_-_Format_values_that_are_above_or_below_the_average_-_For_Promotions.mp4	6.2 MB
196_-_TIP_-_Use_a_formula_to_determine_which_cells_to_format.mp4	9.9 MB
197_-_Use_selected_cells_to_format_multiple_fields.mp4	9.2 MB
198_-_All_cells_showing_values_to_format_multiple_fields.mp4	7.9 MB
199_-_Control_Conditional_Formatting_with_Slicers.mp4	11.0 MB
200_-_Show_text_in_the_Pivot_Table_Values_area.mp4	23.4 MB
201_-_Cond_Format_blank_cells_or_cells.mp4	5.9 MB
202_-_CASE_STUDY_~_ACCOUNTING_-_Accounts_Receivable_Ageing_Report_Matrix.mp4	28.6 MB
203_-_CASE_STUDY_~_FINANCIAL_-_Conditionally_Format_your_sales_results.mp4	16.3 MB
/11_-_GETPIVOTDATA_Formula/
205_-_Intro_to_GETPIVOTDATA.mp4	23.1 MB
206_-_Create_a_custom_report_with_GETPIVOTDATA.mp4	22.9 MB
207_-_Reference_Dates_with_GETPIVOTDATA.mp4	11.6 MB
208_-_Data_validation_with_GETPIVOTDATA.mp4	13.3 MB
209_-_Shortfalls_of_GETPIVOTDATA.mp4	6.3 MB
210_-_TIP_-_Grand_Totals_to_the_left_of_the_pivot_table.mp4	14.1 MB
211_-_CASE_STUDY_~_ACCOUNTING_-_Live_forecasting_with_GETPIVOTDATA.mp4	32.5 MB
212_-_CASE_STUDY_~_FINANCIAL_-_Channel_Analysis_with_GETPIVOTDATA.mp4	26.2 MB
/12_-_MACROS_and_PIVOT_TABLES/
214_-_Adding_the_Developer_tab_and_disabling_macros.mp4	9.5 MB
215_-_Record_a_simple_macro_to_Refresh_a_pivot_table.mp4	18.4 MB
216_-_Date_filter_macro.mp4	15.8 MB
217_-_Different_pivot_table_views_macro.mp4	20.0 MB
218_-_Top_10_macro.mp4	11.9 MB
219_-_Add_macro_to_quick_access_toolbar.mp4	7.5 MB
/13_-_DATA_MANAGEMENT/
220_-_WORKBOOKS.txt	0.1 KB
221_-_Reducing_file_memory_by_copying_existing_pivot_table.mp4	9.2 MB
222_-_Reducing_file_memory_by_deleting_the_data_source.mp4	12.8 MB
223_-_Reducing_file_memory_by_saving_file_as_Excel_Binary_Workbook.mp4	6.6 MB
224_-_Reducing_file_memory_by_keeping_data_source_in_MS_Access.mp4	10.9 MB
225_-_Compatibility_Issues_with_Excel_2007_and_Excel_2010.mp4	4.5 MB
226_-_Sharing_a_Pivot_Table_via_OneDrive.mp4	9.0 MB
/14_-_BONUS_VIDEOS/
227_-_WORKBOOKS.txt	0.1 KB
228_-_Sales_Forecasting_with_Calculated_Fields.mp4	22.3 MB
229_-_Consolidate_with_a_Pivot_Table.mp4	23.2 MB
230_-_Frequency_distribution_with_a_Pivot_Table.mp4	10.5 MB
231_-_Break_Even_Model.mp4	9.9 MB
232_-_Several_Slicer_custom_styles_for_you_to_use.mp4	7.2 MB
233_-_Interactive_Balance_Sheet_Pivot_Table.mp4	50.2 MB
234_-_Monthly_Sales_Manager_Performance_Report.mp4	29.0 MB
235_-_Reconciling_customer_payments.mp4	6.8 MB
236_-_THANK_YOU_.mp4	1.7 MB
Total files 223