| 01 Introduction to PivotTables.en-US.srt | 614.4 B | ||
| 01 Introduction to PivotTables.en-US.vtt | 614.4 B | ||
| 01 Introduction to PivotTables.mp4 | 4.3 MB | ||
| 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 Format data for use in a PivotTable.en-US.srt | 1.3 KB | ||
| 02 Format data for use in a PivotTable.en-US.vtt | 1.3 KB | ||
| 02 Format data for use in a PivotTable.mp4 | 1.2 MB | ||
| 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 Create a PivotTable.en-US.srt | 614.4 B | ||
| 03 Create a PivotTable.en-US.vtt | 614.4 B | ||
| 03 Create a PivotTable.mp4 | 1 MB | ||
| 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 Pivot a PivotTable.en-US.srt | 5.8 KB | ||
| 04 Pivot a PivotTable.en-US.vtt | 5.5 KB | ||
| 04 Pivot a PivotTable.mp4 | 15.2 MB | ||
| 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 Configure a PivotTable.en-US.srt | 5.1 KB | ||
| 05 Configure a PivotTable.en-US.vtt | 4.9 KB | ||
| 05 Configure a PivotTable.mp4 | 28.7 MB | ||
| 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 Connect to an external data sourceConnect to an external data source.en-US.srt | 4.6 KB | ||
| 06 Connect to an external data sourceConnect to an external data source.en-US.vtt | 4.5 KB | ||
| 06 Connect to an external data sourceConnect to an external data source.mp4 | 16.4 MB | ||
| 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 Connect to an external data source.en-US.srt | 8 KB | ||
| 07 Connect to an external data source.en-US.vtt | 7.6 KB | ||
| 07 Connect to an external data source.mp4 | 17.5 MB | ||
| 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 Consolidate data from multiple sources.en-US.srt | 7 KB | ||
| 08 Consolidate data from multiple sources.en-US.vtt | 6.7 KB | ||
| 08 Consolidate data from multiple sources.mp4 | 19.1 MB | ||
| 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 Define a default PivotTable layout.en-US.srt | 4.7 KB | ||
| 09 Define a default PivotTable layout.en-US.vtt | 4.6 KB | ||
| 09 Define a default PivotTable layout.mp4 | 10.2 MB | ||
| 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 | ||
| 10 Summarizing PivotTable Data.en-US.srt | 8 KB | ||
| 10 Summarizing PivotTable Data.en-US.vtt | 7.6 KB | ||
| 10 Summarizing PivotTable Data.mp4 | 15.8 MB | ||
| 11 Manage subtotals and grand totals.en-US.srt | 10.6 KB | ||
| 11 Manage subtotals and grand totals.en-US.vtt | 10.1 KB | ||
| 11 Manage subtotals and grand totals.mp4 | 33.8 MB | ||
| 12 Change the data field summary operation.en-US.srt | 6.8 KB | ||
| 12 Change the data field summary operation.en-US.vtt | 6.5 KB | ||
| 12 Change the data field summary operation.mp4 | 18.1 MB | ||
| 13 Summarize more than one data field.en-US.srt | 5.7 KB | ||
| 13 Summarize more than one data field.en-US.vtt | 5.5 KB | ||
| 13 Summarize more than one data field.mp4 | 13 MB | ||
| 14 Manage dates in a PivotTable.en-US.srt | 5.9 KB | ||
| 14 Manage dates in a PivotTable.en-US.vtt | 5.7 KB | ||
| 14 Manage dates in a PivotTable.mp4 | 16.3 MB | ||
| 15 Create a calculated field.en-US.srt | 3.9 KB | ||
| 15 Create a calculated field.en-US.vtt | 3.8 KB | ||
| 15 Create a calculated field.mp4 | 10.7 MB | ||
| 16 Use PivotTable data in a formula.en-US.srt | 7.1 KB | ||
| 16 Use PivotTable data in a formula.en-US.vtt | 6.8 KB | ||
| 16 Use PivotTable data in a formula.mp4 | 30.7 MB | ||
| 17 Drill down to the underlying data.en-US.srt | 6.9 KB | ||
| 17 Drill down to the underlying data.en-US.vtt | 6.6 KB | ||
| 17 Drill down to the underlying data.mp4 | 33.9 MB | ||
| 18 Sort PivotTable data.en-US.srt | 6.1 KB | ||
| 18 Sort PivotTable data.en-US.vtt | 5.8 KB | ||
| 18 Sort PivotTable data.mp4 | 12.7 MB | ||
| 19 Create a custom sort order.en-US.srt | 4.1 KB | ||
| 19 Create a custom sort order.en-US.vtt | 4 KB | ||
| 19 Create a custom sort order.mp4 | 26.4 MB | ||
| 20 Filter a PivotTable field by selection.en-US.srt | 6.1 KB | ||
| 20 Filter a PivotTable field by selection.en-US.vtt | 5.9 KB | ||
| 20 Filter a PivotTable field by selection.mp4 | 13.8 MB | ||
| 21 Filter a PivotTable by rule.en-US.srt | 6.9 KB | ||
| 21 Filter a PivotTable by rule.en-US.vtt | 6.6 KB | ||
| 21 Filter a PivotTable by rule.mp4 | 21.7 MB | ||
| 22 Filter a PivotTable using a search filter.en-US.srt | 6.2 KB | ||
| 22 Filter a PivotTable using a search filter.en-US.vtt | 6 KB | ||
| 22 Filter a PivotTable using a search filter.mp4 | 14.2 MB | ||
| 23 Filter a PivotTable using slicers.en-US.srt | 5.7 KB | ||
| 23 Filter a PivotTable using slicers.en-US.vtt | 5.5 KB | ||
| 23 Filter a PivotTable using slicers.mp4 | 13.8 MB | ||
| 24 Format slicers.en-US.srt | 5.1 KB | ||
| 24 Format slicers.en-US.vtt | 4.9 KB | ||
| 24 Format slicers.mp4 | 11.5 MB | ||
| 25 Filter a PivotTable with report filter fields.en-US.srt | 8.2 KB | ||
| 25 Filter a PivotTable with report filter fields.en-US.vtt | 7.8 KB | ||
| 25 Filter a PivotTable with report filter fields.mp4 | 19.6 MB | ||
| 26 Clear and reapply PivotTable filters.en-US.srt | 9.3 KB | ||
| 26 Clear and reapply PivotTable filters.en-US.vtt | 8.9 KB | ||
| 26 Clear and reapply PivotTable filters.mp4 | 22.3 MB | ||
| 27 Filter a PivotTable using a Timeline.en-US.srt | 6 KB | ||
| 27 Filter a PivotTable using a Timeline.en-US.vtt | 5.8 KB | ||
| 27 Filter a PivotTable using a Timeline.mp4 | 13.3 MB | ||
| 28 Apply a PivotTable style.en-US.srt | 6 KB | ||
| 28 Apply a PivotTable style.en-US.vtt | 5.8 KB | ||
| 28 Apply a PivotTable style.mp4 | 13.2 MB | ||
| 29 Create a PivotTable style.en-US.srt | 6.1 KB | ||
| 29 Create a PivotTable style.en-US.vtt | 5.9 KB | ||
| 29 Create a PivotTable style.mp4 | 16 MB | ||
| 30 Change the PivotTable layout.en-US.srt | 6.6 KB | ||
| 30 Change the PivotTable layout.en-US.vtt | 6.4 KB | ||
| 30 Change the PivotTable layout.mp4 | 14 MB | ||
| 31 Change the data field number format.en-US.srt | 6.9 KB | ||
| 31 Change the data field number format.en-US.vtt | 6.6 KB | ||
| 31 Change the data field number format.mp4 | 13.9 MB | ||
| 32 Highlight cells by applying a rule.en-US.srt | 9.3 KB | ||
| 32 Highlight cells by applying a rule.en-US.vtt | 8.8 KB | ||
| 32 Highlight cells by applying a rule.mp4 | 24 MB | ||
| 33 Highlight the top or bottom values in a PivotTable.en-US.srt | 8.3 KB | ||
| 33 Highlight the top or bottom values in a PivotTable.en-US.vtt | 7.9 KB | ||
| 33 Highlight the top or bottom values in a PivotTable.mp4 | 18.7 MB | ||
| 34 Format cells using data bars.en-US.srt | 5.2 KB | ||
| 34 Format cells using data bars.en-US.vtt | 5 KB | ||
| 34 Format cells using data bars.mp4 | 13.2 MB | ||
| 35 Format cells using color scales.en-US.srt | 6.4 KB | ||
| 35 Format cells using color scales.en-US.vtt | 6.1 KB | ||
| 35 Format cells using color scales.mp4 | 13.7 MB | ||
| 36 Format cells using icon sets.en-US.srt | 6.4 KB | ||
| 36 Format cells using icon sets.en-US.vtt | 6.1 KB | ||
| 36 Format cells using icon sets.mp4 | 13.6 MB | ||
| 37 Edit a conditional formatting rule.en-US.srt | 8 KB | ||
| 37 Edit a conditional formatting rule.en-US.vtt | 7.6 KB | ||
| 37 Edit a conditional formatting rule.mp4 | 17.8 MB | ||
| 38 Control how multiple rules are applied.en-US.srt | 9.1 KB | ||
| 38 Control how multiple rules are applied.en-US.vtt | 8.6 KB | ||
| 38 Control how multiple rules are applied.mp4 | 27 MB | ||
| 39 Delete a conditional formatting rule.en-US.srt | 5.7 KB | ||
| 39 Delete a conditional formatting rule.en-US.vtt | 5.5 KB | ||
| 39 Delete a conditional formatting rule.mp4 | 13.2 MB | ||
| 40 Create a PivotChart.en-US.srt | 9.3 KB | ||
| 40 Create a PivotChart.en-US.vtt | 8.9 KB | ||
| 40 Create a PivotChart.mp4 | 20.9 MB | ||
| 41 Pivot a PivotChart.en-US.srt | 5.4 KB | ||
| 41 Pivot a PivotChart.en-US.vtt | 5.2 KB | ||
| 41 Pivot a PivotChart.mp4 | 13.3 MB | ||
| 42 Filter a PivotChart.en-US.srt | 5.2 KB | ||
| 42 Filter a PivotChart.en-US.vtt | 5 KB | ||
| 42 Filter a PivotChart.mp4 | 14.2 MB | ||
| 43 Format a PivotChart.en-US.srt | 4.5 KB | ||
| 43 Format a PivotChart.en-US.vtt | 4.4 KB | ||
| 43 Format a PivotChart.mp4 | 12.6 MB | ||
| 44 Change a PivotChart’s layout.en-US.srt | 6.2 KB | ||
| 44 Change a PivotChart’s layout.en-US.vtt | 5.9 KB | ||
| 44 Change a PivotChart’s layout.mp4 | 13.3 MB | ||
| 45 Change a PivotChart’s chart type.en-US.srt | 3.3 KB | ||
| 45 Change a PivotChart’s chart type.en-US.vtt | 3.2 KB | ||
| 45 Change a PivotChart’s chart type.mp4 | 6.7 MB | ||
| 46 Add a trendline to a PivotChart.en-US.srt | 5.3 KB | ||
| 46 Add a trendline to a PivotChart.en-US.vtt | 5.1 KB | ||
| 46 Add a trendline to a PivotChart.mp4 | 10.5 MB | ||
| 47 Print a PivotTable.en-US.srt | 5.6 KB | ||
| 47 Print a PivotTable.en-US.vtt | 5.4 KB | ||
| 47 Print a PivotTable.mp4 | 11.8 MB | ||
| 48 Set PivotTable print options.en-US.srt | 4.6 KB | ||
| 48 Set PivotTable print options.en-US.vtt | 4.5 KB | ||
| 48 Set PivotTable print options.mp4 | 8.9 MB | ||
| 49 Print each item on its own page.en-US.srt | 4.3 KB | ||
| 49 Print each item on its own page.en-US.vtt | 4.2 KB | ||
| 49 Print each item on its own page.mp4 | 8.9 MB | ||
| 50 Print a PivotChart.en-US.srt | 6.2 KB | ||
| 50 Print a PivotChart.en-US.vtt | 6 KB | ||
| 50 Print a PivotChart.mp4 | 13.6 MB | ||
| 51 Record and review an Excel macro.en-US.srt | 3.8 KB | ||
| 51 Record and review an Excel macro.en-US.vtt | 3.7 KB | ||
| 51 Record and review an Excel macro.mp4 | 9.6 MB | ||
| 52 Print a PivotTable.en-US.srt | 7 KB | ||
| 52 Print a PivotTable.en-US.vtt | 6.7 KB | ||
| 52 Print a PivotTable.mp4 | 15.2 MB | ||
| 53 Set PivotTable print options.en-US.srt | 7.4 KB | ||
| 53 Set PivotTable print options.en-US.vtt | 7.1 KB | ||
| 53 Set PivotTable print options.mp4 | 15.3 MB | ||
| 54 Print each item on its own page.en-US.srt | 2.1 KB | ||
| 54 Print each item on its own page.en-US.vtt | 2 KB | ||
| 54 Print each item on its own page.mp4 | 3.9 MB | ||
| 55 Print a PivotChart.en-US.srt | 5.6 KB | ||
| 55 Print a PivotChart.en-US.vtt | 5.4 KB | ||
| 55 Print a PivotChart.mp4 | 13.6 MB | ||
| 56 Record and review an Excel macro.en-US.srt | 8.1 KB | ||
| 56 Record and review an Excel macro.en-US.vtt | 7.8 KB | ||
| 56 Record and review an Excel macro.mp4 | 16.4 MB | ||
| 57 Run an Excel macro.mp4 | 9.4 MB | ||
| 58 Create a simple PivotTable presentation kit.en-US.srt | 3.8 KB | ||
| 58 Create a simple PivotTable presentation kit.en-US.vtt | 3.6 KB | ||
| 58 Create a simple PivotTable presentation kit.mp4 | 7.8 MB | ||
| 59 Change PivotTables using keyboard shortcuts.en-US.srt | 6.1 KB | ||
| 59 Change PivotTables using keyboard shortcuts.en-US.vtt | 5.8 KB | ||
| 59 Change PivotTables using keyboard shortcuts.mp4 | 14.6 MB | ||
| 60 Create relationships between tables.en-US.srt | 5 KB | ||
| 60 Create relationships between tables.en-US.vtt | 4.8 KB | ||
| 60 Create relationships between tables.mp4 | 12.9 MB | ||
| 61 Create a PivotTable using the data model.en-US.srt | 4.2 KB | ||
| 61 Create a PivotTable using the data model.en-US.vtt | 4.1 KB | ||
| 61 Create a PivotTable using the data model.mp4 | 8.7 MB | ||
| 62 Edit table relationships.en-US.srt | 6 KB | ||
| 62 Edit table relationships.en-US.vtt | 5.8 KB | ||
| 62 Edit table relationships.mp4 | 12.3 MB | ||
| 63 Deactivate and delete table relationships.en-US.srt | 5.7 KB | ||
| 63 Deactivate and delete table relationships.en-US.vtt | 5.5 KB | ||
| 63 Deactivate and delete table relationships.mp4 | 12.9 MB | ||
| 64 Define sets using the Data Model.en-US.srt | 5.7 KB | ||
| 64 Define sets using the Data Model.en-US.vtt | 5.5 KB | ||
| 64 Define sets using the Data Model.mp4 | 12.9 MB | ||
| 65 Additional resources.en-US.srt | 1.9 KB | ||
| 65 Additional resources.en-US.vtt | 1.8 KB | ||
| 65 Additional resources.mp4 | 2.6 MB | ||
| Bonus Resources.txt | 409.6 B | ||
| DataSource.xlsx | 512.2 KB | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 255 total files | |||
Skillshare - Microsoft Excel - Data Analysis with Excel Pivot Tables
https://CourseLala.com
Duration: 4h 2m | Video: .MP4, 1280x720, 30 fps | Audio: AAC, 48 kHz, 2ch | Size: 996 MB
Genre: eLearning | Language: English
Many Excel users aren't sure how to use PivotTables. In this course, Excel super user richard trujillo shows you how to navigate the complexity of PivotTables while taking advantage of their power. richard explains how to create PivotTables from single or multiple data sources, place and configure a PivotTable,
define a default PivotTable layout, and more. It shows ways to summarize your data, add calculated fields, filter results, and format your layout to make it more readable.
What you'll learn
Take your data analysis skills from ZERO to PRO with Excel Pivot Tables
Learn how to use Pivot Tables and Pivot Charts to streamline and absolutely revolutionize your workflow in Excel
Master unique Pivot Table tips, tools and case studies that you won't find in ANY other course, guaranteed
Explore fun, interactive, and highly effective lessons from a best-selling Excel instructor
Get LIFETIME access to project files, quizzes, homework exercises, and 1-on-1 expert support
Test your skills with 10 real-world Pivot Table case studies (weather, shark attacks, wine tastings, burrito ratings, and more!)
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 2.2 GB | freecoursewb | 4 years | 7 | 2 | |
|
Skillshare - Creating an Automatic Table of Contents for Your Microsoft Word Document Posted by
freecoursewb in Other
|
274.4 MB | freecoursewb | 4 years | 0 | 0 |
| 1.3 GB | freecoursewb | 4 years | 0 | 0 | |
| 590.9 MB | freecoursewb | 4 years | 8 | 1 | |
| 756 MB | freecoursewb | 4 years | 0 | 0 |
All Comments