|
|
01 Introduction to PivotTables.en-US.srt
|
SRT
|
614.4 B
|
|
|
01 Introduction to PivotTables.en-US.vtt
|
VTT
|
614.4 B
|
|
|
01 Introduction to PivotTables.mp4
|
MP4
|
4.3 MB
|
|
|
01_01_Intro.xlsx
|
XLSX
|
738.2 KB
|
|
|
01_02_Data.xlsx
|
XLSX
|
510.2 KB
|
|
|
01_03_Create.xlsx
|
XLSX
|
510.3 KB
|
|
|
01_04_Pivot.xlsx
|
XLSX
|
738.1 KB
|
|
|
01_05_Configure.xlsx
|
XLSX
|
738.4 KB
|
|
|
01_06_Connect.xlsx
|
XLSX
|
8.2 KB
|
|
|
01_07_Consolidate.xlsx
|
XLSX
|
10.6 KB
|
|
|
01_08_Manage.xlsx
|
XLSX
|
738.1 KB
|
|
|
01_09_Default.xlsx
|
XLSX
|
734.9 KB
|
|
|
02 Format data for use in a PivotTable.en-US.srt
|
SRT
|
1.3 KB
|
|
|
02 Format data for use in a PivotTable.en-US.vtt
|
VTT
|
1.3 KB
|
|
|
02 Format data for use in a PivotTable.mp4
|
MP4
|
1.2 MB
|
|
|
02_01_Totals.xlsx
|
XLSX
|
732.3 KB
|
|
|
02_02_Summary.xlsx
|
XLSX
|
731.8 KB
|
|
|
02_03_Multiple.xlsx
|
XLSX
|
732.2 KB
|
|
|
02_04_Dates.xlsx
|
XLSX
|
729.7 KB
|
|
|
02_05_Calculated.xlsx
|
XLSX
|
689.2 KB
|
|
|
02_06_GetPivot.xlsx
|
XLSX
|
732.3 KB
|
|
|
02_07_DrillDown.xlsx
|
XLSX
|
732.3 KB
|
|
|
02_08_Group.xlsx
|
XLSX
|
732.3 KB
|
|
|
03 Create a PivotTable.en-US.srt
|
SRT
|
614.4 B
|
|
|
03 Create a PivotTable.en-US.vtt
|
VTT
|
614.4 B
|
|
|
03 Create a PivotTable.mp4
|
MP4
|
1 MB
|
|
|
03_01_Sort.xlsx
|
XLSX
|
736 KB
|
|
|
03_02_Custom.xlsx
|
XLSX
|
729.1 KB
|
|
|
03_03_Selection.xlsx
|
XLSX
|
729 KB
|
|
|
03_04_Rule.xlsx
|
XLSX
|
736 KB
|
|
|
03_05_SearchFilter.xlsx
|
XLSX
|
734.8 KB
|
|
|
03_06_Slicer.xlsx
|
XLSX
|
732.4 KB
|
|
|
03_07_FormatSlicer.xlsx
|
XLSX
|
737.3 KB
|
|
|
03_08_ReportFilter.xlsx
|
XLSX
|
736 KB
|
|
|
03_09_ClearFilters.xlsx
|
XLSX
|
735.1 KB
|
|
|
03_10_Timeline.xlsx
|
XLSX
|
739.6 KB
|
|
|
04 Pivot a PivotTable.en-US.srt
|
SRT
|
5.8 KB
|
|
|
04 Pivot a PivotTable.en-US.vtt
|
VTT
|
5.5 KB
|
|
|
04 Pivot a PivotTable.mp4
|
MP4
|
15.2 MB
|
|
|
04_01_ApplyStyle.xlsx
|
XLSX
|
732.4 KB
|
|
|
04_02_CreateNewStyle.xlsx
|
XLSX
|
732.3 KB
|
|
|
04_03_Layout.xlsx
|
XLSX
|
732.3 KB
|
|
|
04_04_DataFormat.xlsx
|
XLSX
|
732.4 KB
|
|
|
05 Configure a PivotTable.en-US.srt
|
SRT
|
5.1 KB
|
|
|
05 Configure a PivotTable.en-US.vtt
|
VTT
|
4.9 KB
|
|
|
05 Configure a PivotTable.mp4
|
MP4
|
28.7 MB
|
|
|
05_01_Rule.xlsx
|
XLSX
|
732.2 KB
|
|
|
05_02_TopTen.xlsx
|
XLSX
|
732.2 KB
|
|
|
05_03_DataBars.xlsx
|
XLSX
|
732.4 KB
|
|
|
05_04_ColorScale.xlsx
|
XLSX
|
732.2 KB
|
|
|
05_05_IconSet.xlsx
|
XLSX
|
718.6 KB
|
|
|
05_06_EditRules.xlsx
|
XLSX
|
718.7 KB
|
|
|
05_07_MultipleRules.xlsx
|
XLSX
|
718.9 KB
|
|
|
05_08_Delete.xlsx
|
XLSX
|
719 KB
|
|
|
06 Connect to an external data sourceConnect to an external data source.en-US.srt
|
SRT
|
4.6 KB
|
|
|
06 Connect to an external data sourceConnect to an external data source.en-US.vtt
|
VTT
|
4.5 KB
|
|
|
06 Connect to an external data sourceConnect to an external data source.mp4
|
MP4
|
16.4 MB
|
|
|
06_01_Create.xlsx
|
XLSX
|
737.7 KB
|
|
|
06_02_Pivot.xlsx
|
XLSX
|
743.9 KB
|
|
|
06_03_Filter.xlsx
|
XLSX
|
743.7 KB
|
|
|
06_04_Format.xlsx
|
XLSX
|
743.9 KB
|
|
|
06_05_Layout.xlsx
|
XLSX
|
743.9 KB
|
|
|
06_06_Type.xlsx
|
XLSX
|
743.9 KB
|
|
|
06_07_Trendline.xlsx
|
XLSX
|
744.5 KB
|
|
|
07 Connect to an external data source.en-US.srt
|
SRT
|
8 KB
|
|
|
07 Connect to an external data source.en-US.vtt
|
VTT
|
7.6 KB
|
|
|
07 Connect to an external data source.mp4
|
MP4
|
17.5 MB
|
|
|
07_01_Print.xlsx
|
XLSX
|
732.3 KB
|
|
|
07_02_Options.xlsx
|
XLSX
|
732.5 KB
|
|
|
07_03_Items.xlsx
|
XLSX
|
732.5 KB
|
|
|
07_04_Chart.xlsx
|
XLSX
|
738.4 KB
|
|
|
08 Consolidate data from multiple sources.en-US.srt
|
SRT
|
7 KB
|
|
|
08 Consolidate data from multiple sources.en-US.vtt
|
VTT
|
6.7 KB
|
|
|
08 Consolidate data from multiple sources.mp4
|
MP4
|
19.1 MB
|
|
|
08_01_Record.xlsx
|
XLSX
|
732.2 KB
|
|
|
08_02_Run.xlsm
|
XLSM
|
736.9 KB
|
|
|
08_03_Present.xlsm
|
XLSM
|
728 KB
|
|
|
08_04_Keyboard.xlsx
|
XLSX
|
732.2 KB
|
|
|
09 Define a default PivotTable layout.en-US.srt
|
SRT
|
4.7 KB
|
|
|
09 Define a default PivotTable layout.en-US.vtt
|
VTT
|
4.6 KB
|
|
|
09 Define a default PivotTable layout.mp4
|
MP4
|
10.2 MB
|
|
|
09_01_Define.xlsx
|
XLSX
|
279.3 KB
|
|
|
09_02_Create.xlsx
|
XLSX
|
712.5 KB
|
|
|
09_03_Edit.xlsx
|
XLSX
|
716.9 KB
|
|
|
09_04_Delete.xlsx
|
XLSX
|
942.4 KB
|
|
|
09_05_Sets.xlsx
|
XLSX
|
732.4 KB
|
|
|
10 Summarizing PivotTable Data.en-US.srt
|
SRT
|
8 KB
|
|
|
10 Summarizing PivotTable Data.en-US.vtt
|
VTT
|
7.6 KB
|
|
|
10 Summarizing PivotTable Data.mp4
|
MP4
|
15.8 MB
|
|
|
11 Manage subtotals and grand totals.en-US.srt
|
SRT
|
10.6 KB
|
|
|
11 Manage subtotals and grand totals.en-US.vtt
|
VTT
|
10.1 KB
|
|
|
11 Manage subtotals and grand totals.mp4
|
MP4
|
33.8 MB
|
|
|
12 Change the data field summary operation.en-US.srt
|
SRT
|
6.8 KB
|
|
|
12 Change the data field summary operation.en-US.vtt
|
VTT
|
6.5 KB
|
|
|
12 Change the data field summary operation.mp4
|
MP4
|
18.1 MB
|
|
|
13 Summarize more than one data field.en-US.srt
|
SRT
|
5.7 KB
|
|
|
13 Summarize more than one data field.en-US.vtt
|
VTT
|
5.5 KB
|
|
|
13 Summarize more than one data field.mp4
|
MP4
|
13 MB
|
|
|
14 Manage dates in a PivotTable.en-US.srt
|
SRT
|
5.9 KB
|
|
|
14 Manage dates in a PivotTable.en-US.vtt
|
VTT
|
5.7 KB
|
|
|
14 Manage dates in a PivotTable.mp4
|
MP4
|
16.3 MB
|
|
|
15 Create a calculated field.en-US.srt
|
SRT
|
3.9 KB
|
|
|
15 Create a calculated field.en-US.vtt
|
VTT
|
3.8 KB
|
|
|
15 Create a calculated field.mp4
|
MP4
|
10.7 MB
|
|
|
16 Use PivotTable data in a formula.en-US.srt
|
SRT
|
7.1 KB
|
|
|
16 Use PivotTable data in a formula.en-US.vtt
|
VTT
|
6.8 KB
|
|
|
16 Use PivotTable data in a formula.mp4
|
MP4
|
30.7 MB
|
|
|
17 Drill down to the underlying data.en-US.srt
|
SRT
|
6.9 KB
|
|
|
17 Drill down to the underlying data.en-US.vtt
|
VTT
|
6.6 KB
|
|
|
17 Drill down to the underlying data.mp4
|
MP4
|
33.9 MB
|
|
|
18 Sort PivotTable data.en-US.srt
|
SRT
|
6.1 KB
|
|
|
18 Sort PivotTable data.en-US.vtt
|
VTT
|
5.8 KB
|
|
|
18 Sort PivotTable data.mp4
|
MP4
|
12.7 MB
|
|
|
19 Create a custom sort order.en-US.srt
|
SRT
|
4.1 KB
|
|
|
19 Create a custom sort order.en-US.vtt
|
VTT
|
4 KB
|
|
|
19 Create a custom sort order.mp4
|
MP4
|
26.4 MB
|
|
|
20 Filter a PivotTable field by selection.en-US.srt
|
SRT
|
6.1 KB
|
|
|
20 Filter a PivotTable field by selection.en-US.vtt
|
VTT
|
5.9 KB
|
|
|
20 Filter a PivotTable field by selection.mp4
|
MP4
|
13.8 MB
|
|
|
21 Filter a PivotTable by rule.en-US.srt
|
SRT
|
6.9 KB
|
|
|
21 Filter a PivotTable by rule.en-US.vtt
|
VTT
|
6.6 KB
|
|
|
21 Filter a PivotTable by rule.mp4
|
MP4
|
21.7 MB
|
|
|
22 Filter a PivotTable using a search filter.en-US.srt
|
SRT
|
6.2 KB
|
|
|
22 Filter a PivotTable using a search filter.en-US.vtt
|
VTT
|
6 KB
|
|
|
22 Filter a PivotTable using a search filter.mp4
|
MP4
|
14.2 MB
|
|
|
23 Filter a PivotTable using slicers.en-US.srt
|
SRT
|
5.7 KB
|
|
|
23 Filter a PivotTable using slicers.en-US.vtt
|
VTT
|
5.5 KB
|
|
|
23 Filter a PivotTable using slicers.mp4
|
MP4
|
13.8 MB
|
|
|
24 Format slicers.en-US.srt
|
SRT
|
5.1 KB
|
|
|
24 Format slicers.en-US.vtt
|
VTT
|
4.9 KB
|
|
|
24 Format slicers.mp4
|
MP4
|
11.5 MB
|
|
|
25 Filter a PivotTable with report filter fields.en-US.srt
|
SRT
|
8.2 KB
|
|
|
25 Filter a PivotTable with report filter fields.en-US.vtt
|
VTT
|
7.8 KB
|
|
|
25 Filter a PivotTable with report filter fields.mp4
|
MP4
|
19.6 MB
|
|
|
26 Clear and reapply PivotTable filters.en-US.srt
|
SRT
|
9.3 KB
|
|
|
26 Clear and reapply PivotTable filters.en-US.vtt
|
VTT
|
8.9 KB
|
|
|
26 Clear and reapply PivotTable filters.mp4
|
MP4
|
22.3 MB
|
|
|
27 Filter a PivotTable using a Timeline.en-US.srt
|
SRT
|
6 KB
|
|
|
27 Filter a PivotTable using a Timeline.en-US.vtt
|
VTT
|
5.8 KB
|
|
|
27 Filter a PivotTable using a Timeline.mp4
|
MP4
|
13.3 MB
|
|
|
28 Apply a PivotTable style.en-US.srt
|
SRT
|
6 KB
|
|
|
28 Apply a PivotTable style.en-US.vtt
|
VTT
|
5.8 KB
|
|
|
28 Apply a PivotTable style.mp4
|
MP4
|
13.2 MB
|
|
|
29 Create a PivotTable style.en-US.srt
|
SRT
|
6.1 KB
|
|
|
29 Create a PivotTable style.en-US.vtt
|
VTT
|
5.9 KB
|
|
|
29 Create a PivotTable style.mp4
|
MP4
|
16 MB
|
|
|
30 Change the PivotTable layout.en-US.srt
|
SRT
|
6.6 KB
|
|
|
30 Change the PivotTable layout.en-US.vtt
|
VTT
|
6.4 KB
|
|
|
30 Change the PivotTable layout.mp4
|
MP4
|
14 MB
|
|
|
31 Change the data field number format.en-US.srt
|
SRT
|
6.9 KB
|
|
|
31 Change the data field number format.en-US.vtt
|
VTT
|
6.6 KB
|
|
|
31 Change the data field number format.mp4
|
MP4
|
13.9 MB
|
|
|
32 Highlight cells by applying a rule.en-US.srt
|
SRT
|
9.3 KB
|
|
|
32 Highlight cells by applying a rule.en-US.vtt
|
VTT
|
8.8 KB
|
|
|
32 Highlight cells by applying a rule.mp4
|
MP4
|
24 MB
|
|
|
33 Highlight the top or bottom values in a PivotTable.en-US.srt
|
SRT
|
8.3 KB
|
|
|
33 Highlight the top or bottom values in a PivotTable.en-US.vtt
|
VTT
|
7.9 KB
|
|
|
33 Highlight the top or bottom values in a PivotTable.mp4
|
MP4
|
18.7 MB
|
|
|
34 Format cells using data bars.en-US.srt
|
SRT
|
5.2 KB
|
|
|
34 Format cells using data bars.en-US.vtt
|
VTT
|
5 KB
|
|
|
34 Format cells using data bars.mp4
|
MP4
|
13.2 MB
|
|
|
35 Format cells using color scales.en-US.srt
|
SRT
|
6.4 KB
|
|
|
35 Format cells using color scales.en-US.vtt
|
VTT
|
6.1 KB
|
|
|
35 Format cells using color scales.mp4
|
MP4
|
13.7 MB
|
|
|
36 Format cells using icon sets.en-US.srt
|
SRT
|
6.4 KB
|
|
|
36 Format cells using icon sets.en-US.vtt
|
VTT
|
6.1 KB
|
|
|
36 Format cells using icon sets.mp4
|
MP4
|
13.6 MB
|
|
|
37 Edit a conditional formatting rule.en-US.srt
|
SRT
|
8 KB
|
|
|
37 Edit a conditional formatting rule.en-US.vtt
|
VTT
|
7.6 KB
|
|
|
37 Edit a conditional formatting rule.mp4
|
MP4
|
17.8 MB
|
|
|
38 Control how multiple rules are applied.en-US.srt
|
SRT
|
9.1 KB
|
|
|
38 Control how multiple rules are applied.en-US.vtt
|
VTT
|
8.6 KB
|
|
|
38 Control how multiple rules are applied.mp4
|
MP4
|
27 MB
|
|
|
39 Delete a conditional formatting rule.en-US.srt
|
SRT
|
5.7 KB
|
|
|
39 Delete a conditional formatting rule.en-US.vtt
|
VTT
|
5.5 KB
|
|
|
39 Delete a conditional formatting rule.mp4
|
MP4
|
13.2 MB
|
|
|
40 Create a PivotChart.en-US.srt
|
SRT
|
9.3 KB
|
|
|
40 Create a PivotChart.en-US.vtt
|
VTT
|
8.9 KB
|
|
|
40 Create a PivotChart.mp4
|
MP4
|
20.9 MB
|
|
|
41 Pivot a PivotChart.en-US.srt
|
SRT
|
5.4 KB
|
|
|
41 Pivot a PivotChart.en-US.vtt
|
VTT
|
5.2 KB
|
|
|
41 Pivot a PivotChart.mp4
|
MP4
|
13.3 MB
|
|
|
42 Filter a PivotChart.en-US.srt
|
SRT
|
5.2 KB
|
|
|
42 Filter a PivotChart.en-US.vtt
|
VTT
|
5 KB
|
|
|
42 Filter a PivotChart.mp4
|
MP4
|
14.2 MB
|
|
|
43 Format a PivotChart.en-US.srt
|
SRT
|
4.5 KB
|
|
|
43 Format a PivotChart.en-US.vtt
|
VTT
|
4.4 KB
|
|
|
43 Format a PivotChart.mp4
|
MP4
|
12.6 MB
|
|
|
44 Change a PivotChart’s layout.en-US.srt
|
SRT
|
6.2 KB
|
|
|
44 Change a PivotChart’s layout.en-US.vtt
|
VTT
|
5.9 KB
|
|
|
44 Change a PivotChart’s layout.mp4
|
MP4
|
13.3 MB
|
|
|
45 Change a PivotChart’s chart type.en-US.srt
|
SRT
|
3.3 KB
|
|
|
45 Change a PivotChart’s chart type.en-US.vtt
|
VTT
|
3.2 KB
|
|
|
45 Change a PivotChart’s chart type.mp4
|
MP4
|
6.7 MB
|
|
|
46 Add a trendline to a PivotChart.en-US.srt
|
SRT
|
5.3 KB
|
|
|
46 Add a trendline to a PivotChart.en-US.vtt
|
VTT
|
5.1 KB
|
|
|
46 Add a trendline to a PivotChart.mp4
|
MP4
|
10.5 MB
|
|
|
47 Print a PivotTable.en-US.srt
|
SRT
|
5.6 KB
|
|
|
47 Print a PivotTable.en-US.vtt
|
VTT
|
5.4 KB
|
|
|
47 Print a PivotTable.mp4
|
MP4
|
11.8 MB
|
|
|
48 Set PivotTable print options.en-US.srt
|
SRT
|
4.6 KB
|
|
|
48 Set PivotTable print options.en-US.vtt
|
VTT
|
4.5 KB
|
|
|
48 Set PivotTable print options.mp4
|
MP4
|
8.9 MB
|
|
|
49 Print each item on its own page.en-US.srt
|
SRT
|
4.3 KB
|
|
|
49 Print each item on its own page.en-US.vtt
|
VTT
|
4.2 KB
|
|
|
49 Print each item on its own page.mp4
|
MP4
|
8.9 MB
|
|
|
50 Print a PivotChart.en-US.srt
|
SRT
|
6.2 KB
|
|
|
50 Print a PivotChart.en-US.vtt
|
VTT
|
6 KB
|
|
|
50 Print a PivotChart.mp4
|
MP4
|
13.6 MB
|
|
|
51 Record and review an Excel macro.en-US.srt
|
SRT
|
3.8 KB
|
|
|
51 Record and review an Excel macro.en-US.vtt
|
VTT
|
3.7 KB
|
|
|
51 Record and review an Excel macro.mp4
|
MP4
|
9.6 MB
|
|
|
52 Print a PivotTable.en-US.srt
|
SRT
|
7 KB
|
|
|
52 Print a PivotTable.en-US.vtt
|
VTT
|
6.7 KB
|
|
|
52 Print a PivotTable.mp4
|
MP4
|
15.2 MB
|
|
|
53 Set PivotTable print options.en-US.srt
|
SRT
|
7.4 KB
|
|
|
53 Set PivotTable print options.en-US.vtt
|
VTT
|
7.1 KB
|
|
|
53 Set PivotTable print options.mp4
|
MP4
|
15.3 MB
|
|
|
54 Print each item on its own page.en-US.srt
|
SRT
|
2.1 KB
|
|
|
54 Print each item on its own page.en-US.vtt
|
VTT
|
2 KB
|
|
|
54 Print each item on its own page.mp4
|
MP4
|
3.9 MB
|
|
|
55 Print a PivotChart.en-US.srt
|
SRT
|
5.6 KB
|
|
|
55 Print a PivotChart.en-US.vtt
|
VTT
|
5.4 KB
|
|
|
55 Print a PivotChart.mp4
|
MP4
|
13.6 MB
|
|
|
56 Record and review an Excel macro.en-US.srt
|
SRT
|
8.1 KB
|
|
|
56 Record and review an Excel macro.en-US.vtt
|
VTT
|
7.8 KB
|
|
|
56 Record and review an Excel macro.mp4
|
MP4
|
16.4 MB
|
|
|
57 Run an Excel macro.mp4
|
MP4
|
9.4 MB
|
|
|
58 Create a simple PivotTable presentation kit.en-US.srt
|
SRT
|
3.8 KB
|
|
|
58 Create a simple PivotTable presentation kit.en-US.vtt
|
VTT
|
3.6 KB
|
|
|
58 Create a simple PivotTable presentation kit.mp4
|
MP4
|
7.8 MB
|
|
|
59 Change PivotTables using keyboard shortcuts.en-US.srt
|
SRT
|
6.1 KB
|
|
|
59 Change PivotTables using keyboard shortcuts.en-US.vtt
|
VTT
|
5.8 KB
|
|
|
59 Change PivotTables using keyboard shortcuts.mp4
|
MP4
|
14.6 MB
|
|
|
60 Create relationships between tables.en-US.srt
|
SRT
|
5 KB
|
|
|
60 Create relationships between tables.en-US.vtt
|
VTT
|
4.8 KB
|
|
|
60 Create relationships between tables.mp4
|
MP4
|
12.9 MB
|
|
|
61 Create a PivotTable using the data model.en-US.srt
|
SRT
|
4.2 KB
|
|
|
61 Create a PivotTable using the data model.en-US.vtt
|
VTT
|
4.1 KB
|
|
|
61 Create a PivotTable using the data model.mp4
|
MP4
|
8.7 MB
|
|
|
62 Edit table relationships.en-US.srt
|
SRT
|
6 KB
|
|
|
62 Edit table relationships.en-US.vtt
|
VTT
|
5.8 KB
|
|
|
62 Edit table relationships.mp4
|
MP4
|
12.3 MB
|
|
|
63 Deactivate and delete table relationships.en-US.srt
|
SRT
|
5.7 KB
|
|
|
63 Deactivate and delete table relationships.en-US.vtt
|
VTT
|
5.5 KB
|
|
|
63 Deactivate and delete table relationships.mp4
|
MP4
|
12.9 MB
|
|
|
64 Define sets using the Data Model.en-US.srt
|
SRT
|
5.7 KB
|
|
|
64 Define sets using the Data Model.en-US.vtt
|
VTT
|
5.5 KB
|
|
|
64 Define sets using the Data Model.mp4
|
MP4
|
12.9 MB
|
|
|
65 Additional resources.en-US.srt
|
SRT
|
1.9 KB
|
|
|
65 Additional resources.en-US.vtt
|
VTT
|
1.8 KB
|
|
|
65 Additional resources.mp4
|
MP4
|
2.6 MB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
DataSource.xlsx
|
XLSX
|
512.2 KB
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
