| 01_01_Intro.xlsx | 738.2 KB | ||
| 01_02_Data.xlsx | 510.2 KB | ||
| 01_03_Create.xlsx | 510.3 KB | ||
| 01_04_Pivot.xlsx | 738.1 KB | ||
| 01_05_Configure.xlsx | 738.4 KB | ||
| 01_06_Connect.xlsx | 8.2 KB | ||
| 01_07_Consolidate.xlsx | 10.6 KB | ||
| 01_08_Manage.xlsx | 738.1 KB | ||
| 01_09_Default.xlsx | 734.9 KB | ||
| 02_01_Totals.xlsx | 732.3 KB | ||
| 02_02_Summary.xlsx | 731.8 KB | ||
| 02_03_Multiple.xlsx | 732.2 KB | ||
| 02_04_Dates.xlsx | 729.7 KB | ||
| 02_05_Calculated.xlsx | 689.2 KB | ||
| 02_06_GetPivot.xlsx | 732.3 KB | ||
| 02_07_DrillDown.xlsx | 732.3 KB | ||
| 02_08_Group.xlsx | 732.3 KB | ||
| 03_01_Sort.xlsx | 736 KB | ||
| 03_02_Custom.xlsx | 729.1 KB | ||
| 03_03_Selection.xlsx | 729 KB | ||
| 03_04_Rule.xlsx | 736 KB | ||
| 03_05_SearchFilter.xlsx | 734.8 KB | ||
| 03_06_Slicer.xlsx | 732.4 KB | ||
| 03_07_FormatSlicer.xlsx | 737.3 KB | ||
| 03_08_ReportFilter.xlsx | 736 KB | ||
| 03_09_ClearFilters.xlsx | 735.1 KB | ||
| 03_10_Timeline.xlsx | 739.6 KB | ||
| 04_01_ApplyStyle.xlsx | 732.4 KB | ||
| 04_02_CreateNewStyle.xlsx | 732.3 KB | ||
| 04_03_Layout.xlsx | 732.3 KB | ||
| 04_04_DataFormat.xlsx | 732.4 KB | ||
| 05_01_Rule.xlsx | 732.2 KB | ||
| 05_02_TopTen.xlsx | 732.2 KB | ||
| 05_03_DataBars.xlsx | 732.4 KB | ||
| 05_04_ColorScale.xlsx | 732.2 KB | ||
| 05_05_IconSet.xlsx | 718.6 KB | ||
| 05_06_EditRules.xlsx | 718.7 KB | ||
| 05_07_MultipleRules.xlsx | 718.9 KB | ||
| 05_08_Delete.xlsx | 719 KB | ||
| 06_01_Create.xlsx | 737.7 KB | ||
| 06_02_Pivot.xlsx | 743.9 KB | ||
| 06_03_Filter.xlsx | 743.7 KB | ||
| 06_04_Format.xlsx | 743.9 KB | ||
| 06_05_Layout.xlsx | 743.9 KB | ||
| 06_06_Type.xlsx | 743.9 KB | ||
| 06_07_Trendline.xlsx | 744.5 KB | ||
| 07_01_Print.xlsx | 732.3 KB | ||
| 07_02_Options.xlsx | 732.5 KB | ||
| 07_03_Items.xlsx | 732.5 KB | ||
| 07_04_Chart.xlsx | 738.4 KB | ||
| 08_01_Record.xlsx | 732.2 KB | ||
| 08_02_Run.xlsm | 736.9 KB | ||
| 08_03_Present.xlsm | 728 KB | ||
| 08_04_Keyboard.xlsx | 732.2 KB | ||
| 09_01_Define.xlsx | 279.3 KB | ||
| 09_02_Create.xlsx | 712.5 KB | ||
| 09_03_Edit.xlsx | 716.9 KB | ||
| 09_04_Delete.xlsx | 942.4 KB | ||
| 09_05_Sets.xlsx | 732.4 KB | ||
| Bonus Resources.txt | 307.2 B | ||
| DataSource.xlsx | 512.2 KB | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| Glossary.pdf | 27.9 KB | ||
| [10] Filter a PivotTable using a Timeline.mp4 | 11.4 MB | ||
| [10] Filter a PivotTable using a Timeline.srt | 6.7 KB | ||
| [1] Additional resources.mp4 | 2 MB | ||
| [1] Additional resources.srt | 1.9 KB | ||
| [1] Apply a PivotTable style.mp4 | 12.2 MB | ||
| [1] Apply a PivotTable style.srt | 7.3 KB | ||
| [1] Apply the power of Excel PivotTables.mp4 | 2.8 MB | ||
| [1] Apply the power of Excel PivotTables.srt | 1 KB | ||
| [1] Create a PivotChart.mp4 | 13.8 MB | ||
| [1] Create a PivotChart.srt | 6.3 KB | ||
| [1] Create relationships between tables.mp4 | 13.2 MB | ||
| [1] Create relationships between tables.srt | 6.3 KB | ||
| [1] Highlight cells by applying a rule.mp4 | 11.1 MB | ||
| [1] Highlight cells by applying a rule.srt | 6.5 KB | ||
| [1] Introduction to PivotTables.mp4 | 11.7 MB | ||
| [1] Introduction to PivotTables.srt | 5.7 KB | ||
| [1] Manage subtotals and grand totals.mp4 | 10.3 MB | ||
| [1] Manage subtotals and grand totals.srt | 5.8 KB | ||
| [1] Print a PivotTable.mp4 | 7.1 MB | ||
| [1] Print a PivotTable.srt | 4 KB | ||
| [1] Record and review an Excel macro.mp4 | 11.4 MB | ||
| [1] Record and review an Excel macro.srt | 5.9 KB | ||
| [1] Sort PivotTable data.mp4 | 11.6 MB | ||
| [1] Sort PivotTable data.srt | 6.1 KB | ||
| [2] Change the data field summary operation.mp4 | 13 MB | ||
| [2] Change the data field summary operation.srt | 6.1 KB | ||
| [2] Create a PivotTable style.mp4 | 17 MB | ||
| [2] Create a PivotTable style.srt | 9.4 KB | ||
| [2] Create a PivotTable using the data model.mp4 | 9.7 MB | ||
| [2] Create a PivotTable using the data model.srt | 5.6 KB | ||
| [2] Create a custom sort order.mp4 | 14.8 MB | ||
| [2] Create a custom sort order.srt | 7.1 KB | ||
| [2] Format data for use in a PivotTable.mp4 | 12.9 MB | ||
| [2] Format data for use in a PivotTable.srt | 5 KB | ||
| [2] Highlight the top or bottom values in a PivotTable.mp4 | 14.7 MB | ||
| [2] Highlight the top or bottom values in a PivotTable.srt | 8 KB | ||
| [2] Pivot a PivotChart.mp4 | 5.1 MB | ||
| [2] Pivot a PivotChart.srt | 3.3 KB | ||
| [2] Run an Excel macro.mp4 | 15.1 MB | ||
| [2] Run an Excel macro.srt | 8.5 KB | ||
| [2] Set PivotTable print options.mp4 | 12.4 MB | ||
| [2] Set PivotTable print options.srt | 7.4 KB | ||
| [2] What you should know before starting.mp4 | 1.1 MB | ||
| [2] What you should know before starting.srt | 1.3 KB | ||
| [3] Change the PivotTable layout.mp4 | 16.1 MB | ||
| [3] Change the PivotTable layout.srt | 8.3 KB | ||
| [3] Create a PivotTable.mp4 | 10.6 MB | ||
| [3] Create a PivotTable.srt | 5.2 KB | ||
| [3] Create a simple PivotTable presentation kit.mp4 | 7.3 MB | ||
| [3] Create a simple PivotTable presentation kit.srt | 4.5 KB | ||
| [3] Edit table relationships.mp4 | 7.2 MB | ||
| [3] Edit table relationships.srt | 4.2 KB | ||
| [3] Filter a PivotChart.mp4 | 8.6 MB | ||
| [3] Filter a PivotChart.srt | 5.5 KB | ||
| [3] Filter a PivotTable field by selection.mp4 | 11 MB | ||
| [3] Filter a PivotTable field by selection.srt | 6.6 KB | ||
| [3] Format cells using data bars.mp4 | 19.3 MB | ||
| [3] Format cells using data bars.srt | 9.4 KB | ||
| [3] Print each item on its own page.mp4 | 13.1 MB | ||
| [3] Print each item on its own page.srt | 7.6 KB | ||
| [3] Summarize more than one data field.mp4 | 8.1 MB | ||
| [3] Summarize more than one data field.srt | 4.8 KB | ||
| [3] The changing Excel interface.mp4 | 1.1 MB | ||
| [3] The changing Excel interface.srt | 716.8 B | ||
| [4] Change PivotTables using keyboard shortcuts.mp4 | 6.4 MB | ||
| [4] Change PivotTables using keyboard shortcuts.srt | 3.7 KB | ||
| [4] Change the data field number format.mp4 | 9.5 MB | ||
| [4] Change the data field number format.srt | 5.2 KB | ||
| [4] Deactivate and delete table relationships.mp4 | 10.4 MB | ||
| [4] Deactivate and delete table relationships.srt | 6.1 KB | ||
| [4] Filter a PivotTable by rule.mp4 | 11.6 MB | ||
| [4] Filter a PivotTable by rule.srt | 5.6 KB | ||
| [4] Format a PivotChart.mp4 | 9.4 MB | ||
| [4] Format a PivotChart.srt | 5.8 KB | ||
| [4] Format cells using color scales.mp4 | 11.1 MB | ||
| [4] Format cells using color scales.srt | 5.8 KB | ||
| [4] Manage dates in a PivotTable.mp4 | 16.1 MB | ||
| [4] Manage dates in a PivotTable.srt | 7 KB | ||
| [4] Pivot a PivotTable.mp4 | 16.2 MB | ||
| [4] Pivot a PivotTable.srt | 8.4 KB | ||
| [4] Print a PivotChart.mp4 | 3 MB | ||
| [4] Print a PivotChart.srt | 2.2 KB | ||
| [5] Change a PivotChart’s layout.mp4 | 7.3 MB | ||
| [5] Change a PivotChart’s layout.srt | 4.8 KB | ||
| [5] Configure a PivotTable.mp4 | 14.8 MB | ||
| [5] Configure a PivotTable.srt | 7.3 KB | ||
| [5] Create a calculated field.mp4 | 15.7 MB | ||
| [5] Create a calculated field.srt | 7.2 KB | ||
| [5] Define sets using the Data Model.mp4 | 9.5 MB | ||
| [5] Define sets using the Data Model.srt | 5.9 KB | ||
| [5] Filter a PivotTable using a search filter.mp4 | 9.4 MB | ||
| [5] Filter a PivotTable using a search filter.srt | 5.1 KB | ||
| [5] Format cells using icon sets.mp4 | 17.2 MB | ||
| [5] Format cells using icon sets.srt | 9.5 KB | ||
| [6] Change a PivotChart’s chart type.mp4 | 7.3 MB | ||
| [6] Change a PivotChart’s chart type.srt | 4.5 KB | ||
| [6] Connect to an external data source.mp4 | 7.3 MB | ||
| [6] Connect to an external data source.srt | 4.9 KB | ||
| [6] Edit a conditional formatting rule.mp4 | 9.8 MB | ||
| [6] Edit a conditional formatting rule.srt | 6 KB | ||
| [6] Filter a PivotTable using slicers.mp4 | 17.6 MB | ||
| [6] Filter a PivotTable using slicers.srt | 8.3 KB | ||
| [6] Use PivotTable data in a formula.mp4 | 10.4 MB | ||
| [6] Use PivotTable data in a formula.srt | 6 KB | ||
| [7] Add a trendline to a PivotChart.mp4 | 10.1 MB | ||
| [7] Add a trendline to a PivotChart.srt | 6.5 KB | ||
| [7] Consolidate data from multiple sources.mp4 | 12.6 MB | ||
| [7] Consolidate data from multiple sources.srt | 8.2 KB | ||
| [7] Control how multiple rules are applied.mp4 | 9.4 MB | ||
| [7] Control how multiple rules are applied.srt | 5.4 KB | ||
| [7] Drill down to the underlying data.mp4 | 9.8 MB | ||
| [7] Drill down to the underlying data.srt | 4.1 KB | ||
| [7] Format slicers.mp4 | 18.2 MB | ||
| [7] Format slicers.srt | 9.5 KB | ||
| [8] Delete a conditional formatting rule.mp4 | 8.7 MB | ||
| [8] Delete a conditional formatting rule.srt | 5.3 KB | ||
| [8] Filter a PivotTable with report filter fields.mp4 | 11.4 MB | ||
| [8] Filter a PivotTable with report filter fields.srt | 6.6 KB | ||
| [8] Manage PivotTables.mp4 | 23.7 MB | ||
| [8] Manage PivotTables.srt | 10.7 KB | ||
| [9] Clear and reapply PivotTable filters.mp4 | 11.8 MB | ||
| [9] Clear and reapply PivotTable filters.srt | 6.3 KB | ||
| [9] Define a default PivotTable layout.mp4 | 14 MB | ||
| [9] Define a default PivotTable layout.srt | 6.8 KB | ||
| ▲ 187 total files | |||
Excel: PivotTables in Depth (2021)
https://TutPig.com
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Skill Level: Beginner | Genre: eLearning | Language: English + srt | Duration: 3h 50m | Size: 556.6 MB
Many Excel users aren’t sure how to use PivotTables. In this course, Excel power user Curt Frye shows you how to navigate the complexity of PivotTables while taking advantage of their power. Curt explains how to build PivotTables from single or multiple data sources, pivot and configure a PivotTable, define a default PivotTable layout, and more. He nstrates ways to summarize your data, add calculated fields, filter your results, and format your layout to make it more readable. Curt steps you through how to sort and filter PivotTable data, format your PivotTable and, and apply conditional formats. Plus, he goes over how to create PivotCharts to visualize your data, enhance PivotTables with macros, and use the Data Model feature to build PivotTables from related tables.
Note: This course was recorded in Microsoft 365. However, anyone using a recent standalone version of Excel (Excel 2021, 2019, or 2016) should be able to follow along with the course contents.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 379.37 MB | Nawel087 | 1 year | 36 | 0 | |
| 415.95 MB | Nawel087 | 1 year | 26 | 0 | |
| 602.97 MB | Nawel087 | 1 year | 20 | 0 | |
| 143.8 MB | Nawel087 | 2 years | 1 | 1 | |
| 223.39 MB | Nawel087 | 2 years | 36 | 0 |
All Comments