|
|
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_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_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_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_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_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_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_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_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
|
|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
DataSource.xlsx
|
XLSX
|
512.2 KB
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
|
|
Glossary.pdf
|
PDF
|
27.9 KB
|
|
|
[10] Filter a PivotTable using a Timeline.mp4
|
MP4
|
11.4 MB
|
|
|
[10] Filter a PivotTable using a Timeline.srt
|
SRT
|
6.7 KB
|
|
|
[1] Additional resources.mp4
|
MP4
|
2 MB
|
|
|
[1] Additional resources.srt
|
SRT
|
1.9 KB
|
|
|
[1] Apply a PivotTable style.mp4
|
MP4
|
12.2 MB
|
|
|
[1] Apply a PivotTable style.srt
|
SRT
|
7.3 KB
|
|
|
[1] Apply the power of Excel PivotTables.mp4
|
MP4
|
2.8 MB
|
|
|
[1] Apply the power of Excel PivotTables.srt
|
SRT
|
1 KB
|
|
|
[1] Create a PivotChart.mp4
|
MP4
|
13.8 MB
|
|
|
[1] Create a PivotChart.srt
|
SRT
|
6.3 KB
|
|
|
[1] Create relationships between tables.mp4
|
MP4
|
13.2 MB
|
|
|
[1] Create relationships between tables.srt
|
SRT
|
6.3 KB
|
|
|
[1] Highlight cells by applying a rule.mp4
|
MP4
|
11.1 MB
|
|
|
[1] Highlight cells by applying a rule.srt
|
SRT
|
6.5 KB
|
|
|
[1] Introduction to PivotTables.mp4
|
MP4
|
11.7 MB
|
|
|
[1] Introduction to PivotTables.srt
|
SRT
|
5.7 KB
|
|
|
[1] Manage subtotals and grand totals.mp4
|
MP4
|
10.3 MB
|
|
|
[1] Manage subtotals and grand totals.srt
|
SRT
|
5.8 KB
|
|
|
[1] Print a PivotTable.mp4
|
MP4
|
7.1 MB
|
|
|
[1] Print a PivotTable.srt
|
SRT
|
4 KB
|
|
|
[1] Record and review an Excel macro.mp4
|
MP4
|
11.4 MB
|
|
|
[1] Record and review an Excel macro.srt
|
SRT
|
5.9 KB
|
|
|
[1] Sort PivotTable data.mp4
|
MP4
|
11.6 MB
|
|
|
[1] Sort PivotTable data.srt
|
SRT
|
6.1 KB
|
|
|
[2] Change the data field summary operation.mp4
|
MP4
|
13 MB
|
|
|
[2] Change the data field summary operation.srt
|
SRT
|
6.1 KB
|
|
|
[2] Create a PivotTable style.mp4
|
MP4
|
17 MB
|
|
|
[2] Create a PivotTable style.srt
|
SRT
|
9.4 KB
|
|
|
[2] Create a PivotTable using the data model.mp4
|
MP4
|
9.7 MB
|
|
|
[2] Create a PivotTable using the data model.srt
|
SRT
|
5.6 KB
|
|
|
[2] Create a custom sort order.mp4
|
MP4
|
14.8 MB
|
|
|
[2] Create a custom sort order.srt
|
SRT
|
7.1 KB
|
|
|
[2] Format data for use in a PivotTable.mp4
|
MP4
|
12.9 MB
|
|
|
[2] Format data for use in a PivotTable.srt
|
SRT
|
5 KB
|
|
|
[2] Highlight the top or bottom values in a PivotTable.mp4
|
MP4
|
14.7 MB
|
|
|
[2] Highlight the top or bottom values in a PivotTable.srt
|
SRT
|
8 KB
|
|
|
[2] Pivot a PivotChart.mp4
|
MP4
|
5.1 MB
|
|
|
[2] Pivot a PivotChart.srt
|
SRT
|
3.3 KB
|
|
|
[2] Run an Excel macro.mp4
|
MP4
|
15.1 MB
|
|
|
[2] Run an Excel macro.srt
|
SRT
|
8.5 KB
|
|
|
[2] Set PivotTable print options.mp4
|
MP4
|
12.4 MB
|
|
|
[2] Set PivotTable print options.srt
|
SRT
|
7.4 KB
|
|
|
[2] What you should know before starting.mp4
|
MP4
|
1.1 MB
|
|
|
[2] What you should know before starting.srt
|
SRT
|
1.3 KB
|
|
|
[3] Change the PivotTable layout.mp4
|
MP4
|
16.1 MB
|
|
|
[3] Change the PivotTable layout.srt
|
SRT
|
8.3 KB
|
|
|
[3] Create a PivotTable.mp4
|
MP4
|
10.6 MB
|
|
|
[3] Create a PivotTable.srt
|
SRT
|
5.2 KB
|
|
|
[3] Create a simple PivotTable presentation kit.mp4
|
MP4
|
7.3 MB
|
|
|
[3] Create a simple PivotTable presentation kit.srt
|
SRT
|
4.5 KB
|
|
|
[3] Edit table relationships.mp4
|
MP4
|
7.2 MB
|
|
|
[3] Edit table relationships.srt
|
SRT
|
4.2 KB
|
|
|
[3] Filter a PivotChart.mp4
|
MP4
|
8.6 MB
|
|
|
[3] Filter a PivotChart.srt
|
SRT
|
5.5 KB
|
|
|
[3] Filter a PivotTable field by selection.mp4
|
MP4
|
11 MB
|
|
|
[3] Filter a PivotTable field by selection.srt
|
SRT
|
6.6 KB
|
|
|
[3] Format cells using data bars.mp4
|
MP4
|
19.3 MB
|
|
|
[3] Format cells using data bars.srt
|
SRT
|
9.4 KB
|
|
|
[3] Print each item on its own page.mp4
|
MP4
|
13.1 MB
|
|
|
[3] Print each item on its own page.srt
|
SRT
|
7.6 KB
|
|
|
[3] Summarize more than one data field.mp4
|
MP4
|
8.1 MB
|
|
|
[3] Summarize more than one data field.srt
|
SRT
|
4.8 KB
|
|
|
[3] The changing Excel interface.mp4
|
MP4
|
1.1 MB
|
|
|
[3] The changing Excel interface.srt
|
SRT
|
716.8 B
|
|
|
[4] Change PivotTables using keyboard shortcuts.mp4
|
MP4
|
6.4 MB
|
|
|
[4] Change PivotTables using keyboard shortcuts.srt
|
SRT
|
3.7 KB
|
|
|
[4] Change the data field number format.mp4
|
MP4
|
9.5 MB
|
|
|
[4] Change the data field number format.srt
|
SRT
|
5.2 KB
|
|
|
[4] Deactivate and delete table relationships.mp4
|
MP4
|
10.4 MB
|
|
|
[4] Deactivate and delete table relationships.srt
|
SRT
|
6.1 KB
|
|
|
[4] Filter a PivotTable by rule.mp4
|
MP4
|
11.6 MB
|
|
|
[4] Filter a PivotTable by rule.srt
|
SRT
|
5.6 KB
|
|
|
[4] Format a PivotChart.mp4
|
MP4
|
9.4 MB
|
|
|
[4] Format a PivotChart.srt
|
SRT
|
5.8 KB
|
|
|
[4] Format cells using color scales.mp4
|
MP4
|
11.1 MB
|
|
|
[4] Format cells using color scales.srt
|
SRT
|
5.8 KB
|
|
|
[4] Manage dates in a PivotTable.mp4
|
MP4
|
16.1 MB
|
|
|
[4] Manage dates in a PivotTable.srt
|
SRT
|
7 KB
|
|
|
[4] Pivot a PivotTable.mp4
|
MP4
|
16.2 MB
|
|
|
[4] Pivot a PivotTable.srt
|
SRT
|
8.4 KB
|
|
|
[4] Print a PivotChart.mp4
|
MP4
|
3 MB
|
|
|
[4] Print a PivotChart.srt
|
SRT
|
2.2 KB
|
|
|
[5] Change a PivotChart’s layout.mp4
|
MP4
|
7.3 MB
|
|
|
[5] Change a PivotChart’s layout.srt
|
SRT
|
4.8 KB
|
|
|
[5] Configure a PivotTable.mp4
|
MP4
|
14.8 MB
|
|
|
[5] Configure a PivotTable.srt
|
SRT
|
7.3 KB
|
|
|
[5] Create a calculated field.mp4
|
MP4
|
15.7 MB
|
|
|
[5] Create a calculated field.srt
|
SRT
|
7.2 KB
|
|
|
[5] Define sets using the Data Model.mp4
|
MP4
|
9.5 MB
|
|
|
[5] Define sets using the Data Model.srt
|
SRT
|
5.9 KB
|
|
|
[5] Filter a PivotTable using a search filter.mp4
|
MP4
|
9.4 MB
|
|
|
[5] Filter a PivotTable using a search filter.srt
|
SRT
|
5.1 KB
|
|
|
[5] Format cells using icon sets.mp4
|
MP4
|
17.2 MB
|
|
|
[5] Format cells using icon sets.srt
|
SRT
|
9.5 KB
|
|
|
[6] Change a PivotChart’s chart type.mp4
|
MP4
|
7.3 MB
|
|
|
[6] Change a PivotChart’s chart type.srt
|
SRT
|
4.5 KB
|
|
|
[6] Connect to an external data source.mp4
|
MP4
|
7.3 MB
|
|
|
[6] Connect to an external data source.srt
|
SRT
|
4.9 KB
|
|
|
[6] Edit a conditional formatting rule.mp4
|
MP4
|
9.8 MB
|
|
|
[6] Edit a conditional formatting rule.srt
|
SRT
|
6 KB
|
|
|
[6] Filter a PivotTable using slicers.mp4
|
MP4
|
17.6 MB
|
|
|
[6] Filter a PivotTable using slicers.srt
|
SRT
|
8.3 KB
|
|
|
[6] Use PivotTable data in a formula.mp4
|
MP4
|
10.4 MB
|
|
|
[6] Use PivotTable data in a formula.srt
|
SRT
|
6 KB
|
|
|
[7] Add a trendline to a PivotChart.mp4
|
MP4
|
10.1 MB
|
|
|
[7] Add a trendline to a PivotChart.srt
|
SRT
|
6.5 KB
|
|
|
[7] Consolidate data from multiple sources.mp4
|
MP4
|
12.6 MB
|
|
|
[7] Consolidate data from multiple sources.srt
|
SRT
|
8.2 KB
|
|
|
[7] Control how multiple rules are applied.mp4
|
MP4
|
9.4 MB
|
|
|
[7] Control how multiple rules are applied.srt
|
SRT
|
5.4 KB
|
|
|
[7] Drill down to the underlying data.mp4
|
MP4
|
9.8 MB
|
|
|
[7] Drill down to the underlying data.srt
|
SRT
|
4.1 KB
|
|
|
[7] Format slicers.mp4
|
MP4
|
18.2 MB
|
|
|
[7] Format slicers.srt
|
SRT
|
9.5 KB
|
|
|
[8] Delete a conditional formatting rule.mp4
|
MP4
|
8.7 MB
|
|
|
[8] Delete a conditional formatting rule.srt
|
SRT
|
5.3 KB
|
|
|
[8] Filter a PivotTable with report filter fields.mp4
|
MP4
|
11.4 MB
|
|
|
[8] Filter a PivotTable with report filter fields.srt
|
SRT
|
6.6 KB
|
|
|
[8] Manage PivotTables.mp4
|
MP4
|
23.7 MB
|
|
|
[8] Manage PivotTables.srt
|
SRT
|
10.7 KB
|
|
|
[9] Clear and reapply PivotTable filters.mp4
|
MP4
|
11.8 MB
|
|
|
[9] Clear and reapply PivotTable filters.srt
|
SRT
|
6.3 KB
|
|
|
[9] Define a default PivotTable layout.mp4
|
MP4
|
14 MB
|
|
|
[9] Define a default PivotTable layout.srt
|
SRT
|
6.8 KB
|
