Udemy - Excel with Excel Pivot Tables!
File List
| File | Size |
|---|---|
| 00_-_None/01_-_INTRODUCTION.mp4 | 2.31 MB |
| 00_-_None/02_-_COURSE_TRACKER_WORKBOOK.txt | 317 B |
| 00_-_None/04_-_BONUS_-_TOP_20_EXCEL_SHORTCUTS.txt | 468 B |
| 01_-_CUSTOMIZING_YOUR_PIVOT_TABLE/06_-_WORKBOOKS.txt | 134 B |
| 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 |
Trackers
No trackers found.