|
|
001 Aggregating & Summarizing Data with Pivot Tables.mp4
|
MP4
|
29.9 MB
|
|
|
001 Aggregating & Summarizing Data with Pivot Tables_en.srt
|
SRT
|
7.1 KB
|
|
|
001 BONUS LECTURE_ More from Maven.html
|
HTML
|
7.7 KB
|
|
|
001 Changing Pivot Table Number Formats.mp4
|
MP4
|
8.7 MB
|
|
|
001 Changing Pivot Table Number Formats_en.srt
|
SRT
|
3.4 KB
|
|
|
001 Course Structure & Outline.mp4
|
MP4
|
18.5 MB
|
|
|
001 Course Structure & Outline_en.srt
|
SRT
|
5.4 KB
|
|
|
001 Intro to Excel Pivot Charts.mp4
|
MP4
|
8.9 MB
|
|
|
001 Intro to Excel Pivot Charts_en.srt
|
SRT
|
3.7 KB
|
|
|
001 Setting Expectations.mp4
|
MP4
|
6.2 MB
|
|
|
001 Setting Expectations_en.srt
|
SRT
|
2.6 KB
|
|
|
001 Sorting Data with Pivot Tables.mp4
|
MP4
|
35.3 MB
|
|
|
001 Sorting Data with Pivot Tables_en.srt
|
SRT
|
7.5 KB
|
|
|
001 Why Pivot Tables_.mp4
|
MP4
|
13.4 MB
|
|
|
001 Why Pivot Tables__en.srt
|
SRT
|
6.5 KB
|
|
|
002 DOWNLOAD_ Case Study Resources.html
|
HTML
|
512 B
|
|
|
002 PRO TIP_ Avoiding the Pivot Table _Count Of_ Trap.mp4
|
MP4
|
31 MB
|
|
|
002 PRO TIP_ Avoiding the Pivot Table _Count Of_ Trap_en.srt
|
SRT
|
5.5 KB
|
|
|
002 PRO TIP_ Fixing Incorrect Alphabetical Sorting.mp4
|
MP4
|
10.2 MB
|
|
|
002 PRO TIP_ Fixing Incorrect Alphabetical Sorting_en.srt
|
SRT
|
2.9 KB
|
|
|
002 PRO TIP_ Formatting Empty Pivot Table Cells.mp4
|
MP4
|
7.2 MB
|
|
|
002 PRO TIP_ Formatting Empty Pivot Table Cells_en.srt
|
SRT
|
2.5 KB
|
|
|
002 Pivot Chart Demo_ Column Chart.mp4
|
MP4
|
22.8 MB
|
|
|
002 Pivot Chart Demo_ Column Chart_en.srt
|
SRT
|
5.9 KB
|
|
|
002 READ ME_ Important Notes for New Students.html
|
HTML
|
4.8 KB
|
|
|
002 Structuring Source Data for Analysis in Excel.mp4
|
MP4
|
6.2 MB
|
|
|
002 Structuring Source Data for Analysis in Excel_en.srt
|
SRT
|
2.9 KB
|
|
|
003 Configuring Pivot Table Layouts & Styles.mp4
|
MP4
|
22.9 MB
|
|
|
003 Configuring Pivot Table Layouts & Styles_en.srt
|
SRT
|
8.3 KB
|
|
|
003 Creating Your First Pivot Table.mp4
|
MP4
|
15.8 MB
|
|
|
003 Creating Your First Pivot Table_en.srt
|
SRT
|
4.6 KB
|
|
|
003 DOWNLOAD_ Course Resources.html
|
HTML
|
1 KB
|
|
|
003 Defining Value Calculations with Pivot Tables.mp4
|
MP4
|
12.4 MB
|
|
|
003 Defining Value Calculations with Pivot Tables_en.srt
|
SRT
|
5.2 KB
|
|
|
003 Filtering Data with Pivot Table Label & Selection Filters.mp4
|
MP4
|
69.8 MB
|
|
|
003 Filtering Data with Pivot Table Label & Selection Filters_en.srt
|
SRT
|
11.8 KB
|
|
|
003 Pivot Chart Demo_ Pie & Donut Charts.mp4
|
MP4
|
17.5 MB
|
|
|
003 Pivot Chart Demo_ Pie & Donut Charts_en.srt
|
SRT
|
7.9 KB
|
|
|
003 Pivot Table Demo_ Analyzing U.S. Voter Demographics.mp4
|
MP4
|
36.4 MB
|
|
|
003 Pivot Table Demo_ Analyzing U.S. Voter Demographics_en.srt
|
SRT
|
14.3 KB
|
|
|
004 Calculating Pivot Table Values_ % of Column_Row.mp4
|
MP4
|
15.5 MB
|
|
|
004 Calculating Pivot Table Values_ % of Column_Row_en.srt
|
SRT
|
5.4 KB
|
|
|
004 Getting to Know the IMDb Movie Database.mp4
|
MP4
|
29.3 MB
|
|
|
004 Getting to Know the IMDb Movie Database_en.srt
|
SRT
|
3.7 KB
|
|
|
004 HOMEWORK_ Analyzing U.S. Voter Demographics.html
|
HTML
|
2.5 KB
|
|
|
004 IMPORTANT_ Add to Data Model.html
|
HTML
|
1.1 KB
|
|
|
004 PRO TIP_ Pivot Table Label Filters with Wildcards.mp4
|
MP4
|
15.3 MB
|
|
|
004 PRO TIP_ Pivot Table Label Filters with Wildcards_en.srt
|
SRT
|
4.7 KB
|
|
|
004 PRO TIP_ Using Tabular Pivot Tables to Create New Source Data.mp4
|
MP4
|
11.5 MB
|
|
|
004 PRO TIP_ Using Tabular Pivot Tables to Create New Source Data_en.srt
|
SRT
|
3.1 KB
|
|
|
004 Pivot Chart Demo_ Clustered Bar Chart.mp4
|
MP4
|
13.7 MB
|
|
|
004 Pivot Chart Demo_ Clustered Bar Chart_en.srt
|
SRT
|
4.7 KB
|
|
|
005 Calculating Pivot Table Values_ % of Parent.mp4
|
MP4
|
12.4 MB
|
|
|
005 Calculating Pivot Table Values_ % of Parent_en.srt
|
SRT
|
4.1 KB
|
|
|
005 Customizing Pivot Table Headers & Labels.mp4
|
MP4
|
4 MB
|
|
|
005 Customizing Pivot Table Headers & Labels_en.srt
|
SRT
|
1.9 KB
|
|
|
005 Filtering Data with Pivot Table Value Filters.mp4
|
MP4
|
13.2 MB
|
|
|
005 Filtering Data with Pivot Table Value Filters_en.srt
|
SRT
|
4.2 KB
|
|
|
005 Navigating the Pivot Table Field List.mp4
|
MP4
|
28.8 MB
|
|
|
005 Navigating the Pivot Table Field List_en.srt
|
SRT
|
11.2 KB
|
|
|
005 PRO TIP_ Preventing Charts from Resizing with Cells.mp4
|
MP4
|
18.1 MB
|
|
|
005 PRO TIP_ Preventing Charts from Resizing with Cells_en.srt
|
SRT
|
6.9 KB
|
|
|
005 Pivot Table Demo_ Analyzing San Francisco Salary Data.mp4
|
MP4
|
141 MB
|
|
|
005 Pivot Table Demo_ Analyzing San Francisco Salary Data_en.srt
|
SRT
|
18.4 KB
|
|
|
005 Setting Expectations.mp4
|
MP4
|
7.1 MB
|
|
|
005 Setting Expectations_en.srt
|
SRT
|
1.9 KB
|
|
|
006 Applying Basic Conditional Formats to Pivot Tables.mp4
|
MP4
|
50.9 MB
|
|
|
006 Applying Basic Conditional Formats to Pivot Tables_en.srt
|
SRT
|
10.2 KB
|
|
|
006 Calculating Pivot Table Values_ Difference From.mp4
|
MP4
|
14.7 MB
|
|
|
006 Calculating Pivot Table Values_ Difference From_en.srt
|
SRT
|
6.3 KB
|
|
|
006 Changing Pivot Chart Types.mp4
|
MP4
|
9.7 MB
|
|
|
006 Changing Pivot Chart Types_en.srt
|
SRT
|
4.7 KB
|
|
|
006 HOMEWORK_ Analyzing San Francisco Salary Data.html
|
HTML
|
2 KB
|
|
|
006 KNOWLEDGE CHECK_ Manipulating the Pivot Table Field List.html
|
HTML
|
1.7 KB
|
|
|
006 PRO TIP_ Enabling Multiple Pivot Table Filters.mp4
|
MP4
|
27.5 MB
|
|
|
006 PRO TIP_ Enabling Multiple Pivot Table Filters_en.srt
|
SRT
|
3.8 KB
|
|
|
007 Calculating Pivot Table Values_ Running Total.mp4
|
MP4
|
8.8 MB
|
|
|
007 Calculating Pivot Table Values_ Running Total_en.srt
|
SRT
|
3.8 KB
|
|
|
007 Exploring Pivot Table Analyze & Design Options.mp4
|
MP4
|
6.3 MB
|
|
|
007 Exploring Pivot Table Analyze & Design Options_en.srt
|
SRT
|
2.2 KB
|
|
|
007 Grouping & Segmenting Data with Pivot Tables.mp4
|
MP4
|
18.1 MB
|
|
|
007 Grouping & Segmenting Data with Pivot Tables_en.srt
|
SRT
|
4.7 KB
|
|
|
007 PRO TIP_ Adding Data Bars with Invisible Text.mp4
|
MP4
|
14.7 MB
|
|
|
007 PRO TIP_ Adding Data Bars with Invisible Text_en.srt
|
SRT
|
3.5 KB
|
|
|
007 Pivot Chart Demo_ Stacked Area Chart.mp4
|
MP4
|
50.3 MB
|
|
|
007 Pivot Chart Demo_ Stacked Area Chart_en.srt
|
SRT
|
8 KB
|
|
|
007 Pivot Table Demo_ Exploring Shark Attack Records.mp4
|
MP4
|
67.5 MB
|
|
|
007 Pivot Table Demo_ Exploring Shark Attack Records_en.srt
|
SRT
|
14.8 KB
|
|
|
008 Applying Advanced Conditional Formats to Pivot Tables.mp4
|
MP4
|
52.5 MB
|
|
|
008 Applying Advanced Conditional Formats to Pivot Tables_en.srt
|
SRT
|
9.7 KB
|
|
|
008 Calculating Pivot Table Values_ Rank.mp4
|
MP4
|
11.1 MB
|
|
|
008 Calculating Pivot Table Values_ Rank_en.srt
|
SRT
|
3.7 KB
|
|
|
008 Customizing Pivot Chart Layouts & Styles.mp4
|
MP4
|
15.2 MB
|
|
|
008 Customizing Pivot Chart Layouts & Styles_en.srt
|
SRT
|
6.1 KB
|
|
|
008 HOMEWORK_ Exploring Shark Attack Records.html
|
HTML
|
2.7 KB
|
|
|
008 PRO TIP_ Enabling & Disabling Automatic Date Grouping.mp4
|
MP4
|
22.4 MB
|
|
|
008 PRO TIP_ Enabling & Disabling Automatic Date Grouping_en.srt
|
SRT
|
6.4 KB
|
|
|
008 Selecting, Clearing, Moving & Copying Pivot Tables.mp4
|
MP4
|
24.9 MB
|
|
|
008 Selecting, Clearing, Moving & Copying Pivot Tables_en.srt
|
SRT
|
8.1 KB
|
|
|
009 Calculating Pivot Table Values_ Index.mp4
|
MP4
|
68.9 MB
|
|
|
009 Calculating Pivot Table Values_ Index_en.srt
|
SRT
|
10.7 KB
|
|
|
009 Filtering Data with Pivot Table Slicers & Timelines.mp4
|
MP4
|
32.1 MB
|
|
|
009 Filtering Data with Pivot Table Slicers & Timelines_en.srt
|
SRT
|
7 KB
|
|
|
009 HOMEWORK_ Excel Pivot Table Formatting.html
|
HTML
|
2.7 KB
|
|
|
009 Moving Pivot Charts to New Excel Worksheets.mp4
|
MP4
|
7.7 MB
|
|
|
009 Moving Pivot Charts to New Excel Worksheets_en.srt
|
SRT
|
3.1 KB
|
|
|
009 Pivot Table Demo_ Analyzing Stock Market Data.mp4
|
MP4
|
138.8 MB
|
|
|
009 Pivot Table Demo_ Analyzing Stock Market Data_en.srt
|
SRT
|
17.3 KB
|
|
|
009 Refreshing & Updating Pivot Tables.mp4
|
MP4
|
78.9 MB
|
|
|
009 Refreshing & Updating Pivot Tables_en.srt
|
SRT
|
10.7 KB
|
|
|
010 Applying Slicers & Timelines to Multiple Pivot Charts.mp4
|
MP4
|
30.3 MB
|
|
|
010 Applying Slicers & Timelines to Multiple Pivot Charts_en.srt
|
SRT
|
6.9 KB
|
|
|
010 Breaking Out Pivot Table Report Filter Pages.mp4
|
MP4
|
17.2 MB
|
|
|
010 Breaking Out Pivot Table Report Filter Pages_en.srt
|
SRT
|
6 KB
|
|
|
010 HOMEWORK_ Analyzing Stock Market Data.html
|
HTML
|
1.7 KB
|
|
|
010 KNOWLEDGE CHECK_ Pivot Table Value Calculations.html
|
HTML
|
1 KB
|
|
|
010 PRO TIP_ Dealing with Growing Source Data.mp4
|
MP4
|
85 MB
|
|
|
010 PRO TIP_ Dealing with Growing Source Data_en.srt
|
SRT
|
9 KB
|
|
|
011 Building Dynamic Dashboards with Pivot Tables & Pivot Charts.mp4
|
MP4
|
97.9 MB
|
|
|
011 Building Dynamic Dashboards with Pivot Tables & Pivot Charts_en.srt
|
SRT
|
17.4 KB
|
|
|
011 Defining Calculated Fields with Pivot Tables.mp4
|
MP4
|
51.1 MB
|
|
|
011 Defining Calculated Fields with Pivot Tables_en.srt
|
SRT
|
8.9 KB
|
|
|
011 HOMEWORK_ Sorting, Filtering & Grouping Data with Excel Pivot Tables.html
|
HTML
|
2.5 KB
|
|
|
011 Pivot Table Demo_ Analyzing Major League Baseball Teams.mp4
|
MP4
|
119.1 MB
|
|
|
011 Pivot Table Demo_ Analyzing Major League Baseball Teams_en.srt
|
SRT
|
19.4 KB
|
|
|
011 Removing & Reviving Data from the Pivot Table Cache.mp4
|
MP4
|
49.7 MB
|
|
|
011 Removing & Reviving Data from the Pivot Table Cache_en.srt
|
SRT
|
8.2 KB
|
|
|
012 Creating Calculated Fields in Pivot Tables vs. Source Data.mp4
|
MP4
|
36.7 MB
|
|
|
012 Creating Calculated Fields in Pivot Tables vs. Source Data_en.srt
|
SRT
|
6.3 KB
|
|
|
012 HOMEWORK_ Analyzing Major League Baseball Teams.html
|
HTML
|
2.7 KB
|
|
|
012 HOMEWORK_ Visualizing Data with Excel Pivot Charts.html
|
HTML
|
3.3 KB
|
|
|
012 PRO TIP_ How Excel Pivot Tables ACTUALLY Work.mp4
|
MP4
|
24.5 MB
|
|
|
012 PRO TIP_ How Excel Pivot Tables ACTUALLY Work_en.srt
|
SRT
|
5.1 KB
|
|
|
013 HOMEWORK_ Excel Pivot Table 101.html
|
HTML
|
3.2 KB
|
|
|
013 PRO TIP_ Pivot Table Calculations Using Count Columns (Part 1).mp4
|
MP4
|
45.2 MB
|
|
|
013 PRO TIP_ Pivot Table Calculations Using Count Columns (Part 1)_en.srt
|
SRT
|
10.1 KB
|
|
|
013 Pivot Table Demo_ Exploring San Diego Burrito Ratings.mp4
|
MP4
|
161.6 MB
|
|
|
013 Pivot Table Demo_ Exploring San Diego Burrito Ratings_en.srt
|
SRT
|
22.4 KB
|
|
|
014 HOMEWORK_ Exploring San Diego Burrito Ratings.html
|
HTML
|
2.5 KB
|
|
|
014 PRO TIP_ Pivot Table Calculations Using Count Columns (Part 2).mp4
|
MP4
|
29.4 MB
|
|
|
014 PRO TIP_ Pivot Table Calculations Using Count Columns (Part 2)_en.srt
|
SRT
|
5.8 KB
|
|
|
015 Inserting Pivot Table Calculated Items (USE WITH CAUTION_).mp4
|
MP4
|
27.5 MB
|
|
|
015 Inserting Pivot Table Calculated Items (USE WITH CAUTION_)_en.srt
|
SRT
|
8.8 KB
|
|
|
015 Pivot Table Demo_ Tracking Daily Weather Conditions.mp4
|
MP4
|
98.4 MB
|
|
|
015 Pivot Table Demo_ Tracking Daily Weather Conditions_en.srt
|
SRT
|
17.5 KB
|
|
|
016 Generating Solve Order & List Formulas Reports.mp4
|
MP4
|
29.1 MB
|
|
|
016 Generating Solve Order & List Formulas Reports_en.srt
|
SRT
|
6.8 KB
|
|
|
016 HOMEWORK_ Tracking Daily Weather Conditions.html
|
HTML
|
2.1 KB
|
|
|
017 HOMEWORK_ Enriching Data with Pivot Table Calculated Values & Fields.html
|
HTML
|
3.4 KB
|
|
|
017 Pivot Table Demo_ Analyzing Spartan Race Facebook Posts.mp4
|
MP4
|
125.7 MB
|
|
|
017 Pivot Table Demo_ Analyzing Spartan Race Facebook Posts_en.srt
|
SRT
|
20 KB
|
|
|
018 HOMEWORK_ Analyzing Spartan Race Facebook Posts.html
|
HTML
|
2.1 KB
|
|
|
019 Pivot Table Demo_ Analyzing Apple App Store Data.mp4
|
MP4
|
158.9 MB
|
|
|
019 Pivot Table Demo_ Analyzing Apple App Store Data_en.srt
|
SRT
|
26.9 KB
|
|
|
020 HOMEWORK_ Analyzing Apple App Store Data.html
|
HTML
|
3.8 KB
|
|
|
021 Pivot Table Demo_ Analyzing Wine Tasting Scores.mp4
|
MP4
|
156.5 MB
|
|
|
021 Pivot Table Demo_ Analyzing Wine Tasting Scores_en.srt
|
SRT
|
25 KB
|
|
|
022 HOMEWORK_ Analyzing Wine Tasting Scores.html
|
HTML
|
3.2 KB
|
|
|
17313005-Excel-PivotTable-Slides.pdf
|
PDF
|
2.2 MB
|
|
|
17313009-IMDb-Movie-Database.xlsx
|
XLSX
|
459.6 KB
|
|
|
17313013-2016-Movies.xlsx
|
XLSX
|
9.8 KB
|
|
|
17313021-PivotTable-Case-Studies.pdf
|
PDF
|
1.6 MB
|
|
|
17313025-PivotTable-Case-Studies.xlsx
|
XLSX
|
29.1 MB
|
|
|
17313033-PivotTable-Case-Studies-COMPLETE.xlsx
|
XLSX
|
49.2 MB
|
|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
