|
|
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 LESSON.html
|
HTML
|
9.8 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.6 KB
|
|
|
001 Intro to Excel Pivot Charts.mp4
|
MP4
|
8.9 MB
|
|
|
001 Intro to Excel Pivot Charts_en.srt
|
SRT
|
3.8 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.4 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.6 KB
|
|
|
002 PRO TIP Fixing Incorrect Alphabetical Sorting.mp4
|
MP4
|
10.2 MB
|
|
|
002 PRO TIP Fixing Incorrect Alphabetical Sorting_en.srt
|
SRT
|
3 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
|
6 KB
|
|
|
002 PivotTable-Case-Studies-COMPLETE.xlsx
|
XLSX
|
49.2 MB
|
|
|
002 PivotTable-Case-Studies.pdf
|
PDF
|
1.6 MB
|
|
|
002 PivotTable-Case-Studies.xlsx
|
XLSX
|
29.1 MB
|
|
|
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
|
3 KB
|
|
|
003 2016-Movies.xlsx
|
XLSX
|
9.8 KB
|
|
|
003 Configuring Pivot Table Layouts & Styles.mp4
|
MP4
|
22.9 MB
|
|
|
003 Configuring Pivot Table Layouts & Styles_en.srt
|
SRT
|
8.2 KB
|
|
|
003 Creating Your First Pivot Table.mp4
|
MP4
|
26.8 MB
|
|
|
003 Creating Your First Pivot Table_en.srt
|
SRT
|
4.7 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 Excel-PivotTable-Slides.pdf
|
PDF
|
2.2 MB
|
|
|
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
|
12.1 KB
|
|
|
003 IMDb-Movie-Database.xlsx
|
XLSX
|
459.6 KB
|
|
|
003 Pivot Chart Demo Pie & Donut Charts.mp4
|
MP4
|
17.1 MB
|
|
|
003 Pivot Chart Demo Pie & Donut Charts_en.srt
|
SRT
|
8.2 KB
|
|
|
003 Pivot Table Demo Analyzing U.S. Voter Demographics.mp4
|
MP4
|
77 MB
|
|
|
003 Pivot Table Demo Analyzing U.S. Voter Demographics_en.srt
|
SRT
|
13.7 KB
|
|
|
004 Calculating Pivot Table Values % of ColumnRow.mp4
|
MP4
|
15.5 MB
|
|
|
004 Calculating Pivot Table Values % of ColumnRow_en.srt
|
SRT
|
5.2 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.6 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
|
24.3 MB
|
|
|
004 PRO TIP Pivot Table Label Filters with Wildcards_en.srt
|
SRT
|
4.8 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.2 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
|
3.9 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.1 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.7 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
|
17.9 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.1 KB
|
|
|
006 Calculating Pivot Table Values Difference From.mp4
|
MP4
|
14.7 MB
|
|
|
006 Calculating Pivot Table Values Difference From_en.srt
|
SRT
|
6.1 KB
|
|
|
006 Changing Pivot Chart Types.mp4
|
MP4
|
9.7 MB
|
|
|
006 Changing Pivot Chart Types_en.srt
|
SRT
|
4.8 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.9 KB
|
|
|
007 Calculating Pivot Table Values Running Total.mp4
|
MP4
|
8.8 MB
|
|
|
007 Calculating Pivot Table Values Running Total_en.srt
|
SRT
|
3.7 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.6 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.4 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.6 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.9 KB
|
|
|
008 Calculating Pivot Table Values Rank.mp4
|
MP4
|
11.1 MB
|
|
|
008 Calculating Pivot Table Values Rank_en.srt
|
SRT
|
3.5 KB
|
|
|
008 Customizing Pivot Chart Layouts & Styles.mp4
|
MP4
|
15.2 MB
|
|
|
008 Customizing Pivot Chart Layouts & Styles_en.srt
|
SRT
|
6 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.5 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
|
6.9 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.2 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.2 KB
|
|
|
009 Refreshing & Updating Pivot Tables.mp4
|
MP4
|
78.9 MB
|
|
|
009 Refreshing & Updating Pivot Tables_en.srt
|
SRT
|
10.3 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
|
7 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.1 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
|
8.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.1 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.2 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.5 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.2 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
|
4.9 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.3 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.5 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.9 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.6 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.3 KB
|
|
|
016 Generating Solve Order & List Formulas Reports.mp4
|
MP4
|
29.1 MB
|
|
|
016 Generating Solve Order & List Formulas Reports_en.srt
|
SRT
|
6.7 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
|
19.9 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
|
27 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
|
24.5 KB
|
|
|
022 HOMEWORK Analyzing Wine Tasting Scores.html
|
HTML
|
3.2 KB
|
|
|
[CourseClub.Me].url
|
URL
|
102.4 B
|
|
|
[FreeCourseSite.com].url
|
URL
|
102.4 B
|
|
|
[GigaCourse.Com].url
|
URL
|
0 B
|
