种子简介

种子名称： Udemy - Excel with Excel Pivot Tables!
文件类型： 视频
文件数目： 218个文件
文件大小： 2.6 GB
收录时间： 2017-1-24 01:38
已经下载： 3次
资源热度： 132
最近下载： 2024-9-30 18:59

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:7959d12d60c9c261bf4c70e44b5c3fa4373505e0&dn=Udemy - Excel with Excel Pivot Tables! 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

Udemy - Excel with Excel Pivot Tables!.torrent

00_-_None/01_-_INTRODUCTION.mp42.31MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/07_-_ARRANGING_YOUR_DATA_SET_~_Tabular_Format.mp415.75MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/08_-_ARRANGING_YOUR_DATA_SET_~_No_Gaps.mp415.73MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/09_-_ARRANGING_YOUR_DATA_SET_~_Formatting.mp46.72MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/10_-_ARRANGING_YOUR_DATA_SET_~_Tables.mp415.78MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/11_-_ARRANGING_YOUR_DATA_SET_~_TIP_-_Clean_Your_Data_Set.mp49.9MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/12_-_CREATING_A_PIVOT_TABLE_~_Inserting_a_Pivot_Table.mp413.84MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/13_-_CREATING_A_PIVOT_TABLE_~_Field_List_-_Activate_move_resize_and_layout.mp46.56MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/14_-_CREATING_A_PIVOT_TABLE_~_Field_List_and_Areas.mp419.24MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/15_-_CREATING_A_PIVOT_TABLE_~_Drill_down_to_audit.mp411.11MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/16_-_CREATING_A_PIVOT_TABLE_~_Sort_Field_List_from_A_to_Z.mp42.93MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/17_-_CREATING_A_PIVOT_TABLE_~_TIP_-_Double_click_on_any_labels_to_show_more_Fields.mp43.49MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/18_-_CREATING_A_PIVOT_TABLE_~_TIP_-_Defer_Layout_Update.mp43.43MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/19_-_OPTIONS_DATA_~_Pivot_Cache_explained.mp44.38MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/20_-_OPTIONS_DATA_~_Refresh.mp45.07MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/21_-_OPTIONS_DATA_~_Refresh_All.mp49.84MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/22_-_OPTIONS_DATA_~_Refresh_External_Data.mp421.4MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/23_-_OPTIONS_DATA_~_Import_from_Access_database.mp411.57MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/24_-_OPTIONS_DATA_~_Change_Data_Source.mp419.1MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/25_-_OPTIONS_ACTIONS_~_Clear_Filters_and_Clear_Pivot.mp44.82MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/26_-_OPTIONS_ACTIONS_~_Select_and_format.mp419.1MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/27_-_OPTIONS_ACTIONS_~_Move_a_Pivot_Table.mp44.23MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/28_-_DESIGN_STYLES_~_Pivot_Table_Styles.mp422.5MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/29_-_DESIGN_STYLES_~_Customising_a_Pivot_Table_Style.mp423.18MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/30_-_DESIGN_STYLES_~_Use_a_customised_style_in_another_workbook.mp47.44MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/31_-_DESIGN_LAYOUT_~_Subtotals.mp44.19MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/32_-_DESIGN_LAYOUT_~_Grand_Totals.mp44.81MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/33_-_DESIGN_LAYOUT_~_Report_Layouts.mp413.9MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/34_-_DESIGN_LAYOUT_~_Blank_Rows.mp42.81MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/35_-_DESIGN_LAYOUT_~_TIP_-_Show_the_Classic_Pivot_Table_Layout.mp45.79MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/36_-_OPTIONS_SHOW_~_Expand_and_Collapse_buttons.mp423.94MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/37_-_OPTIONS_SHOW_~_Move_and_Remove_Fields_and_Items.mp411.67MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/38_-_OPTIONS_SHOW_~_Show_Hide_Field_List.mp41.68MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/39_-_OPTIONS_SHOW_~_Show_Hide_Field_Headers.mp41.74MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/40_-_CUSTOMISATION_~_Change_Count_of_to_Sum_of.mp45.48MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/41_-_CUSTOMISATION_~_Number_formatting.mp47.49MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/42_-_CUSTOMISATION_~_Field_name_formatting.mp49.57MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/43_-_CUSTOMISATION_~_TIP_-_Predetermined_number_formatting.mp45.59MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/44_-_CUSTOMISATION_~_TIP_-_Change_Sum_views_in_Label_areas.mp43.11MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/45_-_LAYOUT_and_FORMAT_~_Indent_rows_in_compact_layout.mp45.77MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/46_-_LAYOUT_and_FORMAT_~_Change_the_layout_of_a_report_filter.mp46.02MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/47_-_LAYOUT_and_FORMAT_~_Format_error_values.mp43.45MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/48_-_LAYOUT_and_FORMAT_~_Format_empty_cells.mp47MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/49_-_LAYOUT_and_FORMAT_~_Keep_column_widths_upon_refresh.mp44.66MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/50_-_LAYOUT_and_FORMAT_~_TIP_-_Automatic_Refresh_a_Pivot_Table.mp44.18MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/51_-_LAYOUT_and_FORMAT_~_TIP_-_Printing_a_pivot_table_on_two_pages.mp46.14MB

01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/52_-_LAYOUT_and_FORMAT_~_TIP_-Show_report_filter_on_multiple_pages.mp412.74MB

02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/54_-_Create_multiple_subtotals.mp48.29MB

02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/55_-_Count.mp415.08MB

02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/56_-_Average.mp416.86MB

02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/57_-_Maximum.mp410.62MB

02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/58_-_Minimum.mp47.68MB

02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/59_-_Product.mp412.25MB

02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/60_-_Count_Numbers.mp48.07MB

02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/61_-_Std_Dev.mp424.78MB

02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/62_-_Varp.mp418.3MB

02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/63_-_TIP_-_Show_various_Grand_Totals.mp412.76MB

02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/64_-_TIP_-_Shortcuts_to_Field_and_Value_Field_Settings.mp411.01MB

02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/65_-_TIP_-_See_all_pivot_Items.mp420.2MB

02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/66_-_TIP_-_Show_a_unique_count.mp414.09MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/68_-_Percent_of_Grand_Total.mp412.48MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/69_-_Percent_of_Column_Total.mp411.31MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/70_-_Percent_of_Row_Total.mp411.13MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/71_-_Percent_Of.mp418.49MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/72_-_Percent_of_Parent_Row_Total_NEW_IN_EXCEL_2010_.mp421.86MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/73_-_Percent_of_Parent_Column_Total_NEW_IN_EXCEL_2010_.mp411.88MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/74_-_Percent_of_Parent_Total_NEW_IN_EXCEL_2010_.mp416.57MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/75_-_Difference_From.mp424.2MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/76_-_Percent_Difference_From.mp420.05MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/77_-_Running_Total_in.mp410.53MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/78_-_Percent_Running_Total_in_NEW_IN_EXCEL_2010_.mp411.61MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/79_-_Rank_Smallest_to_Largest_NEW_IN_EXCEL_2010_.mp48.38MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/80_-_Rank_Largest_to_Smallest_NEW_IN_EXCEL_2010_.mp49.91MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/81_-_Index.mp415.34MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/82_-_TIP_-_Shortcuts_to_Show_Values_As.mp44.84MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/83_-_CASE_STUDY_~_ACCOUNTING_-_Percent_of_Revenue_Margins.mp410.65MB

03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/84_-_CASE_STUDY_~_FINANCIAL_-_Actual_v_Plan_Variance_Report.mp423.1MB

04_-_GROUPING/86_-_Group_by_Date.mp48.8MB

04_-_GROUPING/87_-_Group_by_Months.mp48.32MB

04_-_GROUPING/88_-_Group_by_Quarters_and_Years.mp47.22MB

04_-_GROUPING/89_-_Group_by_Sales_ranges.mp413.89MB

04_-_GROUPING/90_-_Group_by_Text_fields.mp46.71MB

04_-_GROUPING/91_-_Group_by_Time.mp46.74MB

04_-_GROUPING/92_-_TIP_-_Shortcuts_to_Grouping.mp45.75MB

04_-_GROUPING/93_-_TIP_-_Grouping_by_Half_Years.mp45.46MB

04_-_GROUPING/94_-_TIP_-_Group_by_a_Date_that_starts_on_a_Monday.mp47.73MB

04_-_GROUPING/95_-_TIP_-_Grouping_by_a_custom_date.mp410.49MB

04_-_GROUPING/96_-_TIP_-_Group_by_fiscal_years_and_quarters.mp420.95MB

04_-_GROUPING/97_-_TIP_-_Errors_when_grouping_by_dates.mp411.7MB

04_-_GROUPING/98_-_TIP_-_Group_two_pivot_tables_independently.mp420.71MB

04_-_GROUPING/99_-_TIP_-_Fixing_the_problem_of_counting_grouped_sales.mp42.7MB

04_-_GROUPING/100_-_TIP_-_Display_dates_that_have_no_data.mp46.36MB

04_-_GROUPING/101_-_CASE_STUDY_~_ACCOUNTING_-_Quarterly_Comparative_Report.mp437.65MB

04_-_GROUPING/102_-_CASE_STUDY_~_FINANCIAL_-_Min_and_Max_Bank_Balance.mp420.14MB

05_-_SORTING/104_-_Sorting_by_Largest_or_Smallest.mp47.14MB

05_-_SORTING/105_-_Sort_an_Item_Row_Left_to_Right_.mp46.27MB

05_-_SORTING/106_-_Sort_manually_drag_write_right_click_.mp47.35MB

05_-_SORTING/107_-_Sort_using_a_Custom_List.mp411.65MB

05_-_SORTING/108_-_Override_a_Custom_List_sort.mp44.97MB

05_-_SORTING/109_-_Sort_row_from_A-Z_and_sales_from_Z-A.mp45.84MB

05_-_SORTING/110_-_TIP_-_Sort_new_items_added_to_your_data_source.mp44.71MB

05_-_SORTING/111_-_TIP_-_Clear_a_sort.mp42.7MB

05_-_SORTING/112_-_TIP_-_Sort_Largest_to_Smallest_Grand_Totals.mp42.24MB

06_-_FILTERING/114_-_Filter_by_Dates.mp425.11MB

06_-_FILTERING/115_-_Filter_by_Labels_-_Text.mp49.73MB

06_-_FILTERING/116_-_Filter_by_Labels_-_Numerical_Text.mp411.11MB

06_-_FILTERING/117_-_Filter_by_Values.mp415.13MB

06_-_FILTERING/118_-_Filter_by_Values_-_Top_or_Bottom_10_Items.mp48.12MB

06_-_FILTERING/119_-_Filter_by_Values_-_Top_or_Bottom_Percent.mp47.65MB

06_-_FILTERING/120_-_Filter_by_Values_-_Top_or_Bottom_Sum.mp46.63MB

06_-_FILTERING/121_-_Filter_by_Report_Filter.mp414.18MB

06_-_FILTERING/122_-_TIP_-_Shortcuts_to_filters.mp47.1MB

06_-_FILTERING/123_-_TIP_-_Keep_or_hide_selected_items.mp43.77MB

06_-_FILTERING/124_-_TIP_-_Filter_by_Text_wildcards_and_.mp412.39MB

06_-_FILTERING/125_-_TIP_-_Filter_by_multiple_fields.mp44.37MB

06_-_FILTERING/126_-_TIP_-_Apply_multiple_filters.mp47.4MB

06_-_FILTERING/127_-_TIP_-_Filter_by_multiple_values.mp44.98MB

06_-_FILTERING/128_-_TIP_-_Include_new_items_in_manual_filter.mp48.08MB

06_-_FILTERING/129_-_TIP_-_Clear_filters_with_one_click.mp46.37MB

06_-_FILTERING/130_-_TIP_-_Add_a_filter_for_the_column_items.mp43.03MB

06_-_FILTERING/131_-_CASE_STUDY_~_ACCOUNTING_-_Top_5_Expenses_report.mp49.47MB

06_-_FILTERING/132_-_CASE_STUDY_~_FINANCIAL_-_Top_25Percent_of_Channel_Partners.mp49.96MB

07_-_SLICERS_NEW_IN_EXCEL_2010/134_-_Insert_a_Slicer.mp413.79MB

07_-_SLICERS_NEW_IN_EXCEL_2010/135_-_Slicer_Styles.mp410.05MB

07_-_SLICERS_NEW_IN_EXCEL_2010/136_-_Creating_a_custom_style.mp422.9MB

07_-_SLICERS_NEW_IN_EXCEL_2010/137_-_Copy_a_custom_style_into_a_new_workbook.mp46.89MB

07_-_SLICERS_NEW_IN_EXCEL_2010/138_-_Slicer_Settings.mp421.98MB

07_-_SLICERS_NEW_IN_EXCEL_2010/139_-_Slicer_Size_and_Properties.mp410.64MB

07_-_SLICERS_NEW_IN_EXCEL_2010/140_-_Slicer_Connections_for_multiple_pivot_tables.mp413.76MB

07_-_SLICERS_NEW_IN_EXCEL_2010/141_-_TIP_-_Different_ways_to_filter_a_Slicer.mp44.57MB

07_-_SLICERS_NEW_IN_EXCEL_2010/142_-_TIP_-_Use_one_slicer_for_two_pivot_tables.mp46.58MB

07_-_SLICERS_NEW_IN_EXCEL_2010/143_-_TIP_-_Lock_the_workbook_but_not_the_slicer.mp46.92MB

07_-_SLICERS_NEW_IN_EXCEL_2010/144_-_TIP_-_Interactive_employee_photos_with_Slicers_FUN_.mp431.08MB

07_-_SLICERS_NEW_IN_EXCEL_2010/145_-_CASE_STUDY_~_ACCOUNTING_-_Select_a_Monthly_PandL_report_with_a_Slicer.mp420.95MB

07_-_SLICERS_NEW_IN_EXCEL_2010/146_-_CASE_STUDY_~_FINANCIAL_-_Base_Best_and_Worst_case_Forecast.mp422.65MB

08_-_CALCULATED_FIELDS_and_ITEMS/148_-_Creating_a_Calculated_Field.mp417.09MB

08_-_CALCULATED_FIELDS_and_ITEMS/149_-_Use_an_existing_Calculated_Field_in_a_new_calculation.mp412.79MB

08_-_CALCULATED_FIELDS_and_ITEMS/150_-_Editing_a_Calculated_Field.mp412.77MB

08_-_CALCULATED_FIELDS_and_ITEMS/151_-_Excel_formulas_and_Calculated_Fields.mp413.99MB

08_-_CALCULATED_FIELDS_and_ITEMS/152_-_Creating_a_Calculated_Item.mp417.67MB

08_-_CALCULATED_FIELDS_and_ITEMS/153_-_Use_an_existing_Calculated_Item_in_a_new_calculation.mp48.57MB

08_-_CALCULATED_FIELDS_and_ITEMS/154_-_Editing_a_Calculated_Item.mp413.79MB

08_-_CALCULATED_FIELDS_and_ITEMS/155_-_Excel_formulas_and_Calculated_Items.mp49.76MB

08_-_CALCULATED_FIELDS_and_ITEMS/156_-_Calculated_Item_on_Column_Labels.mp411.2MB

08_-_CALCULATED_FIELDS_and_ITEMS/157_-_Shortcomings_of_Calculated_Items.mp48.34MB

08_-_CALCULATED_FIELDS_and_ITEMS/158_-_TIP_-_Solve_Order_for_Calculated_Items.mp421.37MB

08_-_CALCULATED_FIELDS_and_ITEMS/159_-_TIP_-_List_Calculated_Field_and_Item_formulas.mp44.88MB

08_-_CALCULATED_FIELDS_and_ITEMS/160_-_TIP_-_Remove_a_Calculated_Field_temporarily.mp43.94MB

08_-_CALCULATED_FIELDS_and_ITEMS/161_-_TIP_-_Order_of_operations.mp44.52MB

08_-_CALCULATED_FIELDS_and_ITEMS/162_-_CASE_STUDY_~_ACCOUNTING_-_Creating_a_PandL_Pivot_Table_Report.mp458.6MB

08_-_CALCULATED_FIELDS_and_ITEMS/163_-_CASE_STUDY_~_FINANCIAL_-_Actuals_v_Plan_with_Calculated_Fields.mp450.99MB

09_-_PIVOT_CHARTS/165_-_Insert_a_Pivot_Chart.mp412.12MB

09_-_PIVOT_CHARTS/166_-_Insert_a_Slicer_with_a_Pivot_Chart.mp47.42MB

09_-_PIVOT_CHARTS/167_-_Pivot_Chart_Designs.mp415.04MB

09_-_PIVOT_CHARTS/168_-_Pivot_Chart_Layouts.mp420.35MB

09_-_PIVOT_CHARTS/169_-_Pivot_Chart_Formats.mp420.07MB

09_-_PIVOT_CHARTS/170_-_Limitations_of_Pivot_Charts_and_workarounds.mp48.2MB

09_-_PIVOT_CHARTS/171_-_Saving_a_Pivot_Chart_template.mp46.41MB

09_-_PIVOT_CHARTS/172_-_TIP_-_Shortcuts_to_formatting_a_Pivot_Chart.mp45.65MB

09_-_PIVOT_CHARTS/173_-_TIP_-_Link_chart_title_to_a_pivot_cell.mp43.88MB

09_-_PIVOT_CHARTS/174_-_TIP_-_Copying_a_second_chart.mp43.56MB

09_-_PIVOT_CHARTS/175_-_TIP_-_Put_a_chart_on_a_separate_page_with_F11.mp42.53MB

09_-_PIVOT_CHARTS/176_-_TIP_-_Insert_Pivot_Chart_straight_from_the_data_source.mp44.58MB

09_-_PIVOT_CHARTS/177_-_TIP_-_Paste_Pivot_Chart_to_your_email_as_a_picture.mp43.52MB

09_-_PIVOT_CHARTS/178_-_TIP_-_Paste_Pivot_Chart_to_PowerPoint_and_make_live_updates.mp45.88MB

09_-_PIVOT_CHARTS/179_-_TIP_-_Printing_a_Pivot_Chart.mp45.89MB

09_-_PIVOT_CHARTS/180_-_TIP_-_Include_a_Sparkline_with_your_pivot_table.mp45.54MB

09_-_PIVOT_CHARTS/181_-_TIP_-_Charts_Do_s_and_Don_ts.mp410.14MB

09_-_PIVOT_CHARTS/182_-_TIP_-_Change_Chart_Type_with_Slicers_FUN_.mp428.79MB

09_-_PIVOT_CHARTS/183_-_TIP_-_Workaround_to_creating_an_interactive_Scatter_graph.mp410.73MB

09_-_PIVOT_CHARTS/184_-_CASE_STUDY_~_ACCOUNTING_-_PandL_Pivot_Table_report_with_Graphs.mp438.49MB

09_-_PIVOT_CHARTS/185_-_CASE_STUDY_~_FINANCIAL_-_Pivot_Table_Slicer_and_Chart_Dashboard.mp467.81MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/187_-_Intro_to_Conditional_Formatting.mp413.75MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/188_-_Highlight_Cell_Rules_based_on_values.mp46.45MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/189_-_Highlight_Cell_Rules_based_on_text_labels.mp44.41MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/190_-_Highlight_Cell_Rules_based_on_date_labels.mp45.74MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/191_-_Top_and_Bottom_Rules.mp417.07MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/192_-_Data_Bars_Color_Scales_and_Icon_Sets_NEW_IN_EXCEL_2010_.mp424.18MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/193_-_TIP_-_Format_only_cells_that_contain_-_For_Bonuses.mp47.3MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/194_-_TIP_-_Format_only_Top_or_Bottom_ranked_values_-_Top_3_sales_per_year.mp48.6MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/195_-_TIP_-_Format_values_that_are_above_or_below_the_average_-_For_Promotions.mp45.91MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/196_-_TIP_-_Use_a_formula_to_determine_which_cells_to_format.mp49.45MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/197_-_Use_selected_cells_to_format_multiple_fields.mp48.73MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/198_-_All_cells_showing_values_to_format_multiple_fields.mp47.58MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/199_-_Control_Conditional_Formatting_with_Slicers.mp410.47MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/200_-_Show_text_in_the_Pivot_Table_Values_area.mp422.3MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/201_-_Cond_Format_blank_cells_or_cells.mp45.65MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/202_-_CASE_STUDY_~_ACCOUNTING_-_Accounts_Receivable_Ageing_Report_Matrix.mp427.31MB

10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/203_-_CASE_STUDY_~_FINANCIAL_-_Conditionally_Format_your_sales_results.mp415.55MB

11_-_GETPIVOTDATA_Formula/205_-_Intro_to_GETPIVOTDATA.mp422.06MB

11_-_GETPIVOTDATA_Formula/206_-_Create_a_custom_report_with_GETPIVOTDATA.mp421.83MB

11_-_GETPIVOTDATA_Formula/207_-_Reference_Dates_with_GETPIVOTDATA.mp411.04MB

11_-_GETPIVOTDATA_Formula/208_-_Data_validation_with_GETPIVOTDATA.mp412.68MB

11_-_GETPIVOTDATA_Formula/209_-_Shortfalls_of_GETPIVOTDATA.mp46.03MB

11_-_GETPIVOTDATA_Formula/210_-_TIP_-_Grand_Totals_to_the_left_of_the_pivot_table.mp413.42MB

11_-_GETPIVOTDATA_Formula/211_-_CASE_STUDY_~_ACCOUNTING_-_Live_forecasting_with_GETPIVOTDATA.mp431.02MB

11_-_GETPIVOTDATA_Formula/212_-_CASE_STUDY_~_FINANCIAL_-_Channel_Analysis_with_GETPIVOTDATA.mp424.99MB

12_-_MACROS_and_PIVOT_TABLES/214_-_Adding_the_Developer_tab_and_disabling_macros.mp49.08MB

12_-_MACROS_and_PIVOT_TABLES/215_-_Record_a_simple_macro_to_Refresh_a_pivot_table.mp417.51MB

12_-_MACROS_and_PIVOT_TABLES/216_-_Date_filter_macro.mp415.07MB

12_-_MACROS_and_PIVOT_TABLES/217_-_Different_pivot_table_views_macro.mp419.08MB

12_-_MACROS_and_PIVOT_TABLES/218_-_Top_10_macro.mp411.4MB

12_-_MACROS_and_PIVOT_TABLES/219_-_Add_macro_to_quick_access_toolbar.mp47.14MB

13_-_DATA_MANAGEMENT/221_-_Reducing_file_memory_by_copying_existing_pivot_table.mp48.75MB

13_-_DATA_MANAGEMENT/222_-_Reducing_file_memory_by_deleting_the_data_source.mp412.23MB

13_-_DATA_MANAGEMENT/223_-_Reducing_file_memory_by_saving_file_as_Excel_Binary_Workbook.mp46.27MB

13_-_DATA_MANAGEMENT/224_-_Reducing_file_memory_by_keeping_data_source_in_MS_Access.mp410.37MB

13_-_DATA_MANAGEMENT/225_-_Compatibility_Issues_with_Excel_2007_and_Excel_2010.mp44.27MB

13_-_DATA_MANAGEMENT/226_-_Sharing_a_Pivot_Table_via_OneDrive.mp48.57MB

14_-_BONUS_VIDEOS/228_-_Sales_Forecasting_with_Calculated_Fields.mp421.27MB

14_-_BONUS_VIDEOS/229_-_Consolidate_with_a_Pivot_Table.mp422.14MB

14_-_BONUS_VIDEOS/230_-_Frequency_distribution_with_a_Pivot_Table.mp410.02MB

14_-_BONUS_VIDEOS/231_-_Break_Even_Model.mp49.42MB

14_-_BONUS_VIDEOS/232_-_Several_Slicer_custom_styles_for_you_to_use.mp46.87MB

14_-_BONUS_VIDEOS/233_-_Interactive_Balance_Sheet_Pivot_Table.mp447.83MB

14_-_BONUS_VIDEOS/234_-_Monthly_Sales_Manager_Performance_Report.mp427.67MB

14_-_BONUS_VIDEOS/235_-_Reconciling_customer_payments.mp46.45MB

14_-_BONUS_VIDEOS/236_-_THANK_YOU_.mp41.63MB