zhongziso种子搜
首页
功能
磁力转BT
BT转磁力
使用教程
免责声明
关于
zhongziso
搜索
Udemy - Excel with Excel Pivot Tables!
magnet:?xt=urn:btih:7959d12d60c9c261bf4c70e44b5c3fa4373505e0&dn=Udemy - Excel with Excel Pivot Tables!
磁力链接详情
Hash值:
7959d12d60c9c261bf4c70e44b5c3fa4373505e0
点击数:
126
文件大小:
2.6 GB
文件数量:
218
创建日期:
2017-1-24 01:38
最后访问:
2024-9-9 14:03
访问标签:
Udemy
-
Excel
with
Excel
Pivot
Tables!
文件列表详情
00_-_None/01_-_INTRODUCTION.mp4 2.31 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/07_-_ARRANGING_YOUR_DATA_SET_~_Tabular_Format.mp4 15.75 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/08_-_ARRANGING_YOUR_DATA_SET_~_No_Gaps.mp4 15.73 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/09_-_ARRANGING_YOUR_DATA_SET_~_Formatting.mp4 6.72 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/10_-_ARRANGING_YOUR_DATA_SET_~_Tables.mp4 15.78 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/11_-_ARRANGING_YOUR_DATA_SET_~_TIP_-_Clean_Your_Data_Set.mp4 9.9 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/12_-_CREATING_A_PIVOT_TABLE_~_Inserting_a_Pivot_Table.mp4 13.84 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/13_-_CREATING_A_PIVOT_TABLE_~_Field_List_-_Activate_move_resize_and_layout.mp4 6.56 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/14_-_CREATING_A_PIVOT_TABLE_~_Field_List_and_Areas.mp4 19.24 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/15_-_CREATING_A_PIVOT_TABLE_~_Drill_down_to_audit.mp4 11.11 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/16_-_CREATING_A_PIVOT_TABLE_~_Sort_Field_List_from_A_to_Z.mp4 2.93 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/17_-_CREATING_A_PIVOT_TABLE_~_TIP_-_Double_click_on_any_labels_to_show_more_Fields.mp4 3.49 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/18_-_CREATING_A_PIVOT_TABLE_~_TIP_-_Defer_Layout_Update.mp4 3.43 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/19_-_OPTIONS_DATA_~_Pivot_Cache_explained.mp4 4.38 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/20_-_OPTIONS_DATA_~_Refresh.mp4 5.07 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/21_-_OPTIONS_DATA_~_Refresh_All.mp4 9.84 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/22_-_OPTIONS_DATA_~_Refresh_External_Data.mp4 21.4 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/23_-_OPTIONS_DATA_~_Import_from_Access_database.mp4 11.57 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/24_-_OPTIONS_DATA_~_Change_Data_Source.mp4 19.1 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/25_-_OPTIONS_ACTIONS_~_Clear_Filters_and_Clear_Pivot.mp4 4.82 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/26_-_OPTIONS_ACTIONS_~_Select_and_format.mp4 19.1 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/27_-_OPTIONS_ACTIONS_~_Move_a_Pivot_Table.mp4 4.23 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/28_-_DESIGN_STYLES_~_Pivot_Table_Styles.mp4 22.5 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/29_-_DESIGN_STYLES_~_Customising_a_Pivot_Table_Style.mp4 23.18 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/30_-_DESIGN_STYLES_~_Use_a_customised_style_in_another_workbook.mp4 7.44 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/31_-_DESIGN_LAYOUT_~_Subtotals.mp4 4.19 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/32_-_DESIGN_LAYOUT_~_Grand_Totals.mp4 4.81 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/33_-_DESIGN_LAYOUT_~_Report_Layouts.mp4 13.9 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/34_-_DESIGN_LAYOUT_~_Blank_Rows.mp4 2.81 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/35_-_DESIGN_LAYOUT_~_TIP_-_Show_the_Classic_Pivot_Table_Layout.mp4 5.79 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/36_-_OPTIONS_SHOW_~_Expand_and_Collapse_buttons.mp4 23.94 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/37_-_OPTIONS_SHOW_~_Move_and_Remove_Fields_and_Items.mp4 11.67 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/38_-_OPTIONS_SHOW_~_Show_Hide_Field_List.mp4 1.68 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/39_-_OPTIONS_SHOW_~_Show_Hide_Field_Headers.mp4 1.74 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/40_-_CUSTOMISATION_~_Change_Count_of_to_Sum_of.mp4 5.48 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/41_-_CUSTOMISATION_~_Number_formatting.mp4 7.49 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/42_-_CUSTOMISATION_~_Field_name_formatting.mp4 9.57 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/43_-_CUSTOMISATION_~_TIP_-_Predetermined_number_formatting.mp4 5.59 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/44_-_CUSTOMISATION_~_TIP_-_Change_Sum_views_in_Label_areas.mp4 3.11 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/45_-_LAYOUT_and_FORMAT_~_Indent_rows_in_compact_layout.mp4 5.77 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/46_-_LAYOUT_and_FORMAT_~_Change_the_layout_of_a_report_filter.mp4 6.02 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/47_-_LAYOUT_and_FORMAT_~_Format_error_values.mp4 3.45 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/48_-_LAYOUT_and_FORMAT_~_Format_empty_cells.mp4 7 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/49_-_LAYOUT_and_FORMAT_~_Keep_column_widths_upon_refresh.mp4 4.66 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/50_-_LAYOUT_and_FORMAT_~_TIP_-_Automatic_Refresh_a_Pivot_Table.mp4 4.18 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/51_-_LAYOUT_and_FORMAT_~_TIP_-_Printing_a_pivot_table_on_two_pages.mp4 6.14 MB
01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/52_-_LAYOUT_and_FORMAT_~_TIP_-Show_report_filter_on_multiple_pages.mp4 12.74 MB
02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/54_-_Create_multiple_subtotals.mp4 8.29 MB
02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/55_-_Count.mp4 15.08 MB
02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/56_-_Average.mp4 16.86 MB
02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/57_-_Maximum.mp4 10.62 MB
02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/58_-_Minimum.mp4 7.68 MB
02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/59_-_Product.mp4 12.25 MB
02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/60_-_Count_Numbers.mp4 8.07 MB
02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/61_-_Std_Dev.mp4 24.78 MB
02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/62_-_Varp.mp4 18.3 MB
02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/63_-_TIP_-_Show_various_Grand_Totals.mp4 12.76 MB
02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/64_-_TIP_-_Shortcuts_to_Field_and_Value_Field_Settings.mp4 11.01 MB
02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/65_-_TIP_-_See_all_pivot_Items.mp4 20.2 MB
02_-_VALUE_FIELD_SETTINGS_SUMMARIZE_VALUES_BY/66_-_TIP_-_Show_a_unique_count.mp4 14.09 MB
03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/68_-_Percent_of_Grand_Total.mp4 12.48 MB
03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/69_-_Percent_of_Column_Total.mp4 11.31 MB
03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/70_-_Percent_of_Row_Total.mp4 11.13 MB
03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/71_-_Percent_Of.mp4 18.49 MB
03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/72_-_Percent_of_Parent_Row_Total_NEW_IN_EXCEL_2010_.mp4 21.86 MB
03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/73_-_Percent_of_Parent_Column_Total_NEW_IN_EXCEL_2010_.mp4 11.88 MB
03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/74_-_Percent_of_Parent_Total_NEW_IN_EXCEL_2010_.mp4 16.57 MB
03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/75_-_Difference_From.mp4 24.2 MB
03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/76_-_Percent_Difference_From.mp4 20.05 MB
03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/77_-_Running_Total_in.mp4 10.53 MB
03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/78_-_Percent_Running_Total_in_NEW_IN_EXCEL_2010_.mp4 11.61 MB
03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/79_-_Rank_Smallest_to_Largest_NEW_IN_EXCEL_2010_.mp4 8.38 MB
03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/80_-_Rank_Largest_to_Smallest_NEW_IN_EXCEL_2010_.mp4 9.91 MB
03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/81_-_Index.mp4 15.34 MB
03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/82_-_TIP_-_Shortcuts_to_Show_Values_As.mp4 4.84 MB
03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/83_-_CASE_STUDY_~_ACCOUNTING_-_Percent_of_Revenue_Margins.mp4 10.65 MB
03_-_VALUE_FIELD_SETTINGS_SHOW_VALUES_AS/84_-_CASE_STUDY_~_FINANCIAL_-_Actual_v_Plan_Variance_Report.mp4 23.1 MB
04_-_GROUPING/86_-_Group_by_Date.mp4 8.8 MB
04_-_GROUPING/87_-_Group_by_Months.mp4 8.32 MB
04_-_GROUPING/88_-_Group_by_Quarters_and_Years.mp4 7.22 MB
04_-_GROUPING/89_-_Group_by_Sales_ranges.mp4 13.89 MB
04_-_GROUPING/90_-_Group_by_Text_fields.mp4 6.71 MB
04_-_GROUPING/91_-_Group_by_Time.mp4 6.74 MB
04_-_GROUPING/92_-_TIP_-_Shortcuts_to_Grouping.mp4 5.75 MB
04_-_GROUPING/93_-_TIP_-_Grouping_by_Half_Years.mp4 5.46 MB
04_-_GROUPING/94_-_TIP_-_Group_by_a_Date_that_starts_on_a_Monday.mp4 7.73 MB
04_-_GROUPING/95_-_TIP_-_Grouping_by_a_custom_date.mp4 10.49 MB
04_-_GROUPING/96_-_TIP_-_Group_by_fiscal_years_and_quarters.mp4 20.95 MB
04_-_GROUPING/97_-_TIP_-_Errors_when_grouping_by_dates.mp4 11.7 MB
04_-_GROUPING/98_-_TIP_-_Group_two_pivot_tables_independently.mp4 20.71 MB
04_-_GROUPING/99_-_TIP_-_Fixing_the_problem_of_counting_grouped_sales.mp4 2.7 MB
04_-_GROUPING/100_-_TIP_-_Display_dates_that_have_no_data.mp4 6.36 MB
04_-_GROUPING/101_-_CASE_STUDY_~_ACCOUNTING_-_Quarterly_Comparative_Report.mp4 37.65 MB
04_-_GROUPING/102_-_CASE_STUDY_~_FINANCIAL_-_Min_and_Max_Bank_Balance.mp4 20.14 MB
05_-_SORTING/104_-_Sorting_by_Largest_or_Smallest.mp4 7.14 MB
05_-_SORTING/105_-_Sort_an_Item_Row_Left_to_Right_.mp4 6.27 MB
05_-_SORTING/106_-_Sort_manually_drag_write_right_click_.mp4 7.35 MB
05_-_SORTING/107_-_Sort_using_a_Custom_List.mp4 11.65 MB
05_-_SORTING/108_-_Override_a_Custom_List_sort.mp4 4.97 MB
05_-_SORTING/109_-_Sort_row_from_A-Z_and_sales_from_Z-A.mp4 5.84 MB
05_-_SORTING/110_-_TIP_-_Sort_new_items_added_to_your_data_source.mp4 4.71 MB
05_-_SORTING/111_-_TIP_-_Clear_a_sort.mp4 2.7 MB
05_-_SORTING/112_-_TIP_-_Sort_Largest_to_Smallest_Grand_Totals.mp4 2.24 MB
06_-_FILTERING/114_-_Filter_by_Dates.mp4 25.11 MB
06_-_FILTERING/115_-_Filter_by_Labels_-_Text.mp4 9.73 MB
06_-_FILTERING/116_-_Filter_by_Labels_-_Numerical_Text.mp4 11.11 MB
06_-_FILTERING/117_-_Filter_by_Values.mp4 15.13 MB
06_-_FILTERING/118_-_Filter_by_Values_-_Top_or_Bottom_10_Items.mp4 8.12 MB
06_-_FILTERING/119_-_Filter_by_Values_-_Top_or_Bottom_Percent.mp4 7.65 MB
06_-_FILTERING/120_-_Filter_by_Values_-_Top_or_Bottom_Sum.mp4 6.63 MB
06_-_FILTERING/121_-_Filter_by_Report_Filter.mp4 14.18 MB
06_-_FILTERING/122_-_TIP_-_Shortcuts_to_filters.mp4 7.1 MB
06_-_FILTERING/123_-_TIP_-_Keep_or_hide_selected_items.mp4 3.77 MB
06_-_FILTERING/124_-_TIP_-_Filter_by_Text_wildcards_and_.mp4 12.39 MB
06_-_FILTERING/125_-_TIP_-_Filter_by_multiple_fields.mp4 4.37 MB
06_-_FILTERING/126_-_TIP_-_Apply_multiple_filters.mp4 7.4 MB
06_-_FILTERING/127_-_TIP_-_Filter_by_multiple_values.mp4 4.98 MB
06_-_FILTERING/128_-_TIP_-_Include_new_items_in_manual_filter.mp4 8.08 MB
06_-_FILTERING/129_-_TIP_-_Clear_filters_with_one_click.mp4 6.37 MB
06_-_FILTERING/130_-_TIP_-_Add_a_filter_for_the_column_items.mp4 3.03 MB
06_-_FILTERING/131_-_CASE_STUDY_~_ACCOUNTING_-_Top_5_Expenses_report.mp4 9.47 MB
06_-_FILTERING/132_-_CASE_STUDY_~_FINANCIAL_-_Top_25Percent_of_Channel_Partners.mp4 9.96 MB
07_-_SLICERS_NEW_IN_EXCEL_2010/134_-_Insert_a_Slicer.mp4 13.79 MB
07_-_SLICERS_NEW_IN_EXCEL_2010/135_-_Slicer_Styles.mp4 10.05 MB
07_-_SLICERS_NEW_IN_EXCEL_2010/136_-_Creating_a_custom_style.mp4 22.9 MB
07_-_SLICERS_NEW_IN_EXCEL_2010/137_-_Copy_a_custom_style_into_a_new_workbook.mp4 6.89 MB
07_-_SLICERS_NEW_IN_EXCEL_2010/138_-_Slicer_Settings.mp4 21.98 MB
07_-_SLICERS_NEW_IN_EXCEL_2010/139_-_Slicer_Size_and_Properties.mp4 10.64 MB
07_-_SLICERS_NEW_IN_EXCEL_2010/140_-_Slicer_Connections_for_multiple_pivot_tables.mp4 13.76 MB
07_-_SLICERS_NEW_IN_EXCEL_2010/141_-_TIP_-_Different_ways_to_filter_a_Slicer.mp4 4.57 MB
07_-_SLICERS_NEW_IN_EXCEL_2010/142_-_TIP_-_Use_one_slicer_for_two_pivot_tables.mp4 6.58 MB
07_-_SLICERS_NEW_IN_EXCEL_2010/143_-_TIP_-_Lock_the_workbook_but_not_the_slicer.mp4 6.92 MB
07_-_SLICERS_NEW_IN_EXCEL_2010/144_-_TIP_-_Interactive_employee_photos_with_Slicers_FUN_.mp4 31.08 MB
07_-_SLICERS_NEW_IN_EXCEL_2010/145_-_CASE_STUDY_~_ACCOUNTING_-_Select_a_Monthly_PandL_report_with_a_Slicer.mp4 20.95 MB
07_-_SLICERS_NEW_IN_EXCEL_2010/146_-_CASE_STUDY_~_FINANCIAL_-_Base_Best_and_Worst_case_Forecast.mp4 22.65 MB
08_-_CALCULATED_FIELDS_and_ITEMS/148_-_Creating_a_Calculated_Field.mp4 17.09 MB
08_-_CALCULATED_FIELDS_and_ITEMS/149_-_Use_an_existing_Calculated_Field_in_a_new_calculation.mp4 12.79 MB
08_-_CALCULATED_FIELDS_and_ITEMS/150_-_Editing_a_Calculated_Field.mp4 12.77 MB
08_-_CALCULATED_FIELDS_and_ITEMS/151_-_Excel_formulas_and_Calculated_Fields.mp4 13.99 MB
08_-_CALCULATED_FIELDS_and_ITEMS/152_-_Creating_a_Calculated_Item.mp4 17.67 MB
08_-_CALCULATED_FIELDS_and_ITEMS/153_-_Use_an_existing_Calculated_Item_in_a_new_calculation.mp4 8.57 MB
08_-_CALCULATED_FIELDS_and_ITEMS/154_-_Editing_a_Calculated_Item.mp4 13.79 MB
08_-_CALCULATED_FIELDS_and_ITEMS/155_-_Excel_formulas_and_Calculated_Items.mp4 9.76 MB
08_-_CALCULATED_FIELDS_and_ITEMS/156_-_Calculated_Item_on_Column_Labels.mp4 11.2 MB
08_-_CALCULATED_FIELDS_and_ITEMS/157_-_Shortcomings_of_Calculated_Items.mp4 8.34 MB
08_-_CALCULATED_FIELDS_and_ITEMS/158_-_TIP_-_Solve_Order_for_Calculated_Items.mp4 21.37 MB
08_-_CALCULATED_FIELDS_and_ITEMS/159_-_TIP_-_List_Calculated_Field_and_Item_formulas.mp4 4.88 MB
08_-_CALCULATED_FIELDS_and_ITEMS/160_-_TIP_-_Remove_a_Calculated_Field_temporarily.mp4 3.94 MB
08_-_CALCULATED_FIELDS_and_ITEMS/161_-_TIP_-_Order_of_operations.mp4 4.52 MB
08_-_CALCULATED_FIELDS_and_ITEMS/162_-_CASE_STUDY_~_ACCOUNTING_-_Creating_a_PandL_Pivot_Table_Report.mp4 58.6 MB
08_-_CALCULATED_FIELDS_and_ITEMS/163_-_CASE_STUDY_~_FINANCIAL_-_Actuals_v_Plan_with_Calculated_Fields.mp4 50.99 MB
09_-_PIVOT_CHARTS/165_-_Insert_a_Pivot_Chart.mp4 12.12 MB
09_-_PIVOT_CHARTS/166_-_Insert_a_Slicer_with_a_Pivot_Chart.mp4 7.42 MB
09_-_PIVOT_CHARTS/167_-_Pivot_Chart_Designs.mp4 15.04 MB
09_-_PIVOT_CHARTS/168_-_Pivot_Chart_Layouts.mp4 20.35 MB
09_-_PIVOT_CHARTS/169_-_Pivot_Chart_Formats.mp4 20.07 MB
09_-_PIVOT_CHARTS/170_-_Limitations_of_Pivot_Charts_and_workarounds.mp4 8.2 MB
09_-_PIVOT_CHARTS/171_-_Saving_a_Pivot_Chart_template.mp4 6.41 MB
09_-_PIVOT_CHARTS/172_-_TIP_-_Shortcuts_to_formatting_a_Pivot_Chart.mp4 5.65 MB
09_-_PIVOT_CHARTS/173_-_TIP_-_Link_chart_title_to_a_pivot_cell.mp4 3.88 MB
09_-_PIVOT_CHARTS/174_-_TIP_-_Copying_a_second_chart.mp4 3.56 MB
09_-_PIVOT_CHARTS/175_-_TIP_-_Put_a_chart_on_a_separate_page_with_F11.mp4 2.53 MB
09_-_PIVOT_CHARTS/176_-_TIP_-_Insert_Pivot_Chart_straight_from_the_data_source.mp4 4.58 MB
09_-_PIVOT_CHARTS/177_-_TIP_-_Paste_Pivot_Chart_to_your_email_as_a_picture.mp4 3.52 MB
09_-_PIVOT_CHARTS/178_-_TIP_-_Paste_Pivot_Chart_to_PowerPoint_and_make_live_updates.mp4 5.88 MB
09_-_PIVOT_CHARTS/179_-_TIP_-_Printing_a_Pivot_Chart.mp4 5.89 MB
09_-_PIVOT_CHARTS/180_-_TIP_-_Include_a_Sparkline_with_your_pivot_table.mp4 5.54 MB
09_-_PIVOT_CHARTS/181_-_TIP_-_Charts_Do_s_and_Don_ts.mp4 10.14 MB
09_-_PIVOT_CHARTS/182_-_TIP_-_Change_Chart_Type_with_Slicers_FUN_.mp4 28.79 MB
09_-_PIVOT_CHARTS/183_-_TIP_-_Workaround_to_creating_an_interactive_Scatter_graph.mp4 10.73 MB
09_-_PIVOT_CHARTS/184_-_CASE_STUDY_~_ACCOUNTING_-_PandL_Pivot_Table_report_with_Graphs.mp4 38.49 MB
09_-_PIVOT_CHARTS/185_-_CASE_STUDY_~_FINANCIAL_-_Pivot_Table_Slicer_and_Chart_Dashboard.mp4 67.81 MB
10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/187_-_Intro_to_Conditional_Formatting.mp4 13.75 MB
10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/188_-_Highlight_Cell_Rules_based_on_values.mp4 6.45 MB
10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/189_-_Highlight_Cell_Rules_based_on_text_labels.mp4 4.41 MB
10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/190_-_Highlight_Cell_Rules_based_on_date_labels.mp4 5.74 MB
10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/191_-_Top_and_Bottom_Rules.mp4 17.07 MB
10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/192_-_Data_Bars_Color_Scales_and_Icon_Sets_NEW_IN_EXCEL_2010_.mp4 24.18 MB
10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/193_-_TIP_-_Format_only_cells_that_contain_-_For_Bonuses.mp4 7.3 MB
10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/194_-_TIP_-_Format_only_Top_or_Bottom_ranked_values_-_Top_3_sales_per_year.mp4 8.6 MB
10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/195_-_TIP_-_Format_values_that_are_above_or_below_the_average_-_For_Promotions.mp4 5.91 MB
10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/196_-_TIP_-_Use_a_formula_to_determine_which_cells_to_format.mp4 9.45 MB
10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/197_-_Use_selected_cells_to_format_multiple_fields.mp4 8.73 MB
10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/198_-_All_cells_showing_values_to_format_multiple_fields.mp4 7.58 MB
10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/199_-_Control_Conditional_Formatting_with_Slicers.mp4 10.47 MB
10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/200_-_Show_text_in_the_Pivot_Table_Values_area.mp4 22.3 MB
10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/201_-_Cond_Format_blank_cells_or_cells.mp4 5.65 MB
10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/202_-_CASE_STUDY_~_ACCOUNTING_-_Accounts_Receivable_Ageing_Report_Matrix.mp4 27.31 MB
10_-_CONDITIONAL_FORMATTING_PIVOT_TABLES/203_-_CASE_STUDY_~_FINANCIAL_-_Conditionally_Format_your_sales_results.mp4 15.55 MB
11_-_GETPIVOTDATA_Formula/205_-_Intro_to_GETPIVOTDATA.mp4 22.06 MB
11_-_GETPIVOTDATA_Formula/206_-_Create_a_custom_report_with_GETPIVOTDATA.mp4 21.83 MB
11_-_GETPIVOTDATA_Formula/207_-_Reference_Dates_with_GETPIVOTDATA.mp4 11.04 MB
11_-_GETPIVOTDATA_Formula/208_-_Data_validation_with_GETPIVOTDATA.mp4 12.68 MB
11_-_GETPIVOTDATA_Formula/209_-_Shortfalls_of_GETPIVOTDATA.mp4 6.03 MB
11_-_GETPIVOTDATA_Formula/210_-_TIP_-_Grand_Totals_to_the_left_of_the_pivot_table.mp4 13.42 MB
11_-_GETPIVOTDATA_Formula/211_-_CASE_STUDY_~_ACCOUNTING_-_Live_forecasting_with_GETPIVOTDATA.mp4 31.02 MB
11_-_GETPIVOTDATA_Formula/212_-_CASE_STUDY_~_FINANCIAL_-_Channel_Analysis_with_GETPIVOTDATA.mp4 24.99 MB
12_-_MACROS_and_PIVOT_TABLES/214_-_Adding_the_Developer_tab_and_disabling_macros.mp4 9.08 MB
12_-_MACROS_and_PIVOT_TABLES/215_-_Record_a_simple_macro_to_Refresh_a_pivot_table.mp4 17.51 MB
12_-_MACROS_and_PIVOT_TABLES/216_-_Date_filter_macro.mp4 15.07 MB
12_-_MACROS_and_PIVOT_TABLES/217_-_Different_pivot_table_views_macro.mp4 19.08 MB
12_-_MACROS_and_PIVOT_TABLES/218_-_Top_10_macro.mp4 11.4 MB
12_-_MACROS_and_PIVOT_TABLES/219_-_Add_macro_to_quick_access_toolbar.mp4 7.14 MB
13_-_DATA_MANAGEMENT/221_-_Reducing_file_memory_by_copying_existing_pivot_table.mp4 8.75 MB
13_-_DATA_MANAGEMENT/222_-_Reducing_file_memory_by_deleting_the_data_source.mp4 12.23 MB
13_-_DATA_MANAGEMENT/223_-_Reducing_file_memory_by_saving_file_as_Excel_Binary_Workbook.mp4 6.27 MB
13_-_DATA_MANAGEMENT/224_-_Reducing_file_memory_by_keeping_data_source_in_MS_Access.mp4 10.37 MB
13_-_DATA_MANAGEMENT/225_-_Compatibility_Issues_with_Excel_2007_and_Excel_2010.mp4 4.27 MB
13_-_DATA_MANAGEMENT/226_-_Sharing_a_Pivot_Table_via_OneDrive.mp4 8.57 MB
14_-_BONUS_VIDEOS/228_-_Sales_Forecasting_with_Calculated_Fields.mp4 21.27 MB
14_-_BONUS_VIDEOS/229_-_Consolidate_with_a_Pivot_Table.mp4 22.14 MB
14_-_BONUS_VIDEOS/230_-_Frequency_distribution_with_a_Pivot_Table.mp4 10.02 MB
14_-_BONUS_VIDEOS/231_-_Break_Even_Model.mp4 9.42 MB
14_-_BONUS_VIDEOS/232_-_Several_Slicer_custom_styles_for_you_to_use.mp4 6.87 MB
14_-_BONUS_VIDEOS/233_-_Interactive_Balance_Sheet_Pivot_Table.mp4 47.83 MB
14_-_BONUS_VIDEOS/234_-_Monthly_Sales_Manager_Performance_Report.mp4 27.67 MB
14_-_BONUS_VIDEOS/235_-_Reconciling_customer_payments.mp4 6.45 MB
14_-_BONUS_VIDEOS/236_-_THANK_YOU_.mp4 1.63 MB
其他位置