|
|
1. Aggregating & Summarizing Data with Pivot Tables.mp4
|
MP4
|
9.1 MB
|
|
|
1. Aggregating & Summarizing Data with Pivot Tables.srt
|
SRT
|
6.8 KB
|
|
|
1. Changing Pivot Table Number Formats.mp4
|
MP4
|
4.7 MB
|
|
|
1. Changing Pivot Table Number Formats.srt
|
SRT
|
3.4 KB
|
|
|
1. Course Structure & Outline.mp4
|
MP4
|
6.8 MB
|
|
|
1. Course Structure & Outline.srt
|
SRT
|
5.4 KB
|
|
|
1. Intro to Excel Pivot Charts.mp4
|
MP4
|
4.6 MB
|
|
|
1. Intro to Excel Pivot Charts.srt
|
SRT
|
3.6 KB
|
|
|
1. Resources & Next Steps.mp4
|
MP4
|
4.5 MB
|
|
|
1. Resources & Next Steps.srt
|
SRT
|
3.9 KB
|
|
|
1. Setting Expectations.mp4
|
MP4
|
3.6 MB
|
|
|
1. Setting Expectations.srt
|
SRT
|
2.7 KB
|
|
|
1. Sorting Data with Pivot Tables.mp4
|
MP4
|
12.1 MB
|
|
|
1. Sorting Data with Pivot Tables.srt
|
SRT
|
7.1 KB
|
|
|
1. Why Pivot Tables.mp4
|
MP4
|
7.7 MB
|
|
|
1. Why Pivot Tables.srt
|
SRT
|
6.4 KB
|
|
|
10. Applying Slicers & Timelines to Multiple Pivot Charts.mp4
|
MP4
|
10.6 MB
|
|
|
10. Applying Slicers & Timelines to Multiple Pivot Charts.srt
|
SRT
|
6.7 KB
|
|
|
10. Breaking Out Pivot Table Report Filter Pages.mp4
|
MP4
|
9.3 MB
|
|
|
10. Breaking Out Pivot Table Report Filter Pages.srt
|
SRT
|
5.7 KB
|
|
|
10. HOMEWORK Analyzing Stock Market Data.html
|
HTML
|
1.7 KB
|
|
|
10. HOMEWORK Excel Pivot Table Formatting.html
|
HTML
|
2.8 KB
|
|
|
10. KNOWLEDGE CHECK Pivot Table Value Calculations.html
|
HTML
|
1 KB
|
|
|
10. PRO TIP Dealing with Growing Source Data.mp4
|
MP4
|
28 MB
|
|
|
10. PRO TIP Dealing with Growing Source Data.srt
|
SRT
|
8.6 KB
|
|
|
11. Building Dynamic Dashboards with Pivot Tables & Pivot Charts.mp4
|
MP4
|
27.4 MB
|
|
|
11. Building Dynamic Dashboards with Pivot Tables & Pivot Charts.srt
|
SRT
|
16.9 KB
|
|
|
11. Defining Calculated Fields with Pivot Tables.mp4
|
MP4
|
14.9 MB
|
|
|
11. Defining Calculated Fields with Pivot Tables.srt
|
SRT
|
8.6 KB
|
|
|
11. Pivot Table Demo Analyzing Major League Baseball Teams.mp4
|
MP4
|
33.9 MB
|
|
|
11. Pivot Table Demo Analyzing Major League Baseball Teams.srt
|
SRT
|
18.8 KB
|
|
|
11. QUIZ Sorting, Filtering & Grouping Data with Excel Pivot Tables.html
|
HTML
|
102 B
|
|
|
11. Removing & Reviving Data from the Pivot Table Cache.mp4
|
MP4
|
59 MB
|
|
|
11. Removing & Reviving Data from the Pivot Table Cache.srt
|
SRT
|
7.9 KB
|
|
|
12. Creating Calculated Fields in Pivot Tables vs. Source Data.mp4
|
MP4
|
10.4 MB
|
|
|
12. Creating Calculated Fields in Pivot Tables vs. Source Data.srt
|
SRT
|
6.1 KB
|
|
|
12. HOMEWORK Analyzing Major League Baseball Teams.html
|
HTML
|
2.8 KB
|
|
|
12. HOMEWORK Sorting, Filtering & Grouping Data with Excel Pivot Tables.html
|
HTML
|
2.6 KB
|
|
|
12. PRO TIP How Excel Pivot Tables ACTUALLY Work.mp4
|
MP4
|
8 MB
|
|
|
12. PRO TIP How Excel Pivot Tables ACTUALLY Work.srt
|
SRT
|
4.9 KB
|
|
|
12. QUIZ Visualizing Data with Excel Pivot Charts.html
|
HTML
|
102 B
|
|
|
13. HOMEWORK Visualizing Data with Excel Pivot Charts.html
|
HTML
|
3.4 KB
|
|
|
13. PRO TIP Pivot Table Calculations Using Count Columns (Part 1).mp4
|
MP4
|
16.6 MB
|
|
|
13. PRO TIP Pivot Table Calculations Using Count Columns (Part 1).srt
|
SRT
|
9.7 KB
|
|
|
13. Pivot Table Demo Exploring San Diego Burrito Ratings.mp4
|
MP4
|
44.4 MB
|
|
|
13. Pivot Table Demo Exploring San Diego Burrito Ratings.srt
|
SRT
|
22.1 KB
|
|
|
13. QUIZ Excel Pivot Table 101.html
|
HTML
|
102 B
|
|
|
14. HOMEWORK Excel Pivot Table 101.html
|
HTML
|
3.3 KB
|
|
|
14. HOMEWORK Exploring San Diego Burrito Ratings.html
|
HTML
|
2.6 KB
|
|
|
14. PRO TIP Pivot Table Calculations Using Count Columns (Part 2).mp4
|
MP4
|
9.9 MB
|
|
|
14. PRO TIP Pivot Table Calculations Using Count Columns (Part 2).srt
|
SRT
|
5.7 KB
|
|
|
15. Inserting Pivot Table Calculated Items (USE WITH CAUTION!).mp4
|
MP4
|
11.8 MB
|
|
|
15. Inserting Pivot Table Calculated Items (USE WITH CAUTION!).srt
|
SRT
|
8.4 KB
|
|
|
15. Pivot Table Demo Tracking Daily Weather Conditions.mp4
|
MP4
|
30.8 MB
|
|
|
15. Pivot Table Demo Tracking Daily Weather Conditions.srt
|
SRT
|
16.8 KB
|
|
|
16. Generating Solve Order & List Formulas Reports.mp4
|
MP4
|
10.1 MB
|
|
|
16. Generating Solve Order & List Formulas Reports.srt
|
SRT
|
6.7 KB
|
|
|
16. HOMEWORK Tracking Daily Weather Conditions.html
|
HTML
|
2.2 KB
|
|
|
17. Pivot Table Demo Analyzing Spartan Race Facebook Posts.mp4
|
MP4
|
37.3 MB
|
|
|
17. Pivot Table Demo Analyzing Spartan Race Facebook Posts.srt
|
SRT
|
19.3 KB
|
|
|
17. QUIZ Enriching Data with Pivot Table Calculated Values & Fields.html
|
HTML
|
102 B
|
|
|
18. HOMEWORK Analyzing Spartan Race Facebook Posts.html
|
HTML
|
2.2 KB
|
|
|
18. HOMEWORK Enriching Data with Pivot Table Calculated Values & Fields.html
|
HTML
|
3.5 KB
|
|
|
19. Pivot Table Demo Analyzing Apple App Store Data.mp4
|
MP4
|
208.3 MB
|
|
|
19. Pivot Table Demo Analyzing Apple App Store Data.srt
|
SRT
|
25.9 KB
|
|
|
2. DOWNLOAD Case Study Resources.html
|
HTML
|
512 B
|
|
|
2. More from Maven Analytics.html
|
HTML
|
3.3 KB
|
|
|
2. PRO TIP Avoiding the Pivot Table Count Of Trap.mp4
|
MP4
|
9.8 MB
|
|
|
2. PRO TIP Avoiding the Pivot Table Count Of Trap.srt
|
SRT
|
5.4 KB
|
|
|
2. PRO TIP Fixing Incorrect Alphabetical Sorting.mp4
|
MP4
|
5.8 MB
|
|
|
2. PRO TIP Fixing Incorrect Alphabetical Sorting.srt
|
SRT
|
2.9 KB
|
|
|
2. PRO TIP Formatting Empty Pivot Table Cells.mp4
|
MP4
|
4 MB
|
|
|
2. PRO TIP Formatting Empty Pivot Table Cells.srt
|
SRT
|
2.5 KB
|
|
|
2. Pivot Chart Demo Column Chart.mp4
|
MP4
|
8 MB
|
|
|
2. Pivot Chart Demo Column Chart.srt
|
SRT
|
5.8 KB
|
|
|
2. READ ME Important Notes for New Students.html
|
HTML
|
4.4 KB
|
|
|
2. Structuring Source Data for Analysis in Excel.mp4
|
MP4
|
4.2 MB
|
|
|
2. Structuring Source Data for Analysis in Excel.srt
|
SRT
|
2.9 KB
|
|
|
2.1 PivotTable Case Studies_COMPLETE.xlsx.xlsx
|
XLSX
|
49.2 MB
|
|
|
2.2 PivotTable_Case_Studies.pdf.pdf
|
PDF
|
1.6 MB
|
|
|
2.3 PivotTable Case Studies.xlsx.xlsx
|
XLSX
|
29.1 MB
|
|
|
20. HOMEWORK Analyzing Apple App Store Data.html
|
HTML
|
3.9 KB
|
|
|
21. Pivot Table Demo Analyzing Wine Tasting Scores.mp4
|
MP4
|
191.1 MB
|
|
|
21. Pivot Table Demo Analyzing Wine Tasting Scores.srt
|
SRT
|
23.5 KB
|
|
|
22. HOMEWORK Analyzing Wine Tasting Scores.html
|
HTML
|
3.3 KB
|
|
|
3. Configuring Pivot Table Layouts & Styles.mp4
|
MP4
|
12.8 MB
|
|
|
3. Configuring Pivot Table Layouts & Styles.srt
|
SRT
|
8 KB
|
|
|
3. Creating Your First Pivot Table.mp4
|
MP4
|
10.7 MB
|
|
|
3. Creating Your First Pivot Table.srt
|
SRT
|
4.5 KB
|
|
|
3. DOWNLOAD Course Resources.html
|
HTML
|
512 B
|
|
|
3. Defining Value Calculations with Pivot Tables.mp4
|
MP4
|
6.5 MB
|
|
|
3. Defining Value Calculations with Pivot Tables.srt
|
SRT
|
5.2 KB
|
|
|
3. Filtering Data with Pivot Table Label & Selection Filters.mp4
|
MP4
|
21 MB
|
|
|
3. Filtering Data with Pivot Table Label & Selection Filters.srt
|
SRT
|
11.7 KB
|
|
|
3. Pivot Chart Demo Pie & Donut Charts.mp4
|
MP4
|
11.4 MB
|
|
|
3. Pivot Chart Demo Pie & Donut Charts.srt
|
SRT
|
8 KB
|
|
|
3. Pivot Table Demo Analyzing U.S. Voter Demographics.mp4
|
MP4
|
26.7 MB
|
|
|
3. Pivot Table Demo Analyzing U.S. Voter Demographics.srt
|
SRT
|
13.4 KB
|
|
|
3.1 IMDb Movie Database.xlsx.xlsx
|
XLSX
|
459.6 KB
|
|
|
3.2 Excel_PivotTable_Slides.pdf.pdf
|
PDF
|
2.3 MB
|
|
|
3.3 2016_Movies.xlsx.xlsx
|
XLSX
|
9.8 KB
|
|
|
4. Calculating Pivot Table Values % of ColumnRow.mp4
|
MP4
|
8.6 MB
|
|
|
4. Calculating Pivot Table Values % of ColumnRow.srt
|
SRT
|
5.3 KB
|
|
|
4. Getting to Know the IMDb Movie Database.mp4
|
MP4
|
9.3 MB
|
|
|
4. Getting to Know the IMDb Movie Database.srt
|
SRT
|
3.5 KB
|
|
|
4. HOMEWORK Analyzing U.S. Voter Demographics.html
|
HTML
|
2.6 KB
|
|
|
4. IMPORTANT Add to Data Model.html
|
HTML
|
1.1 KB
|
|
|
4. PRO TIP Pivot Table Label Filters with Wildcards.mp4
|
MP4
|
10.4 MB
|
|
|
4. PRO TIP Pivot Table Label Filters with Wildcards.srt
|
SRT
|
5 KB
|
|
|
4. PRO TIP Using Tabular Pivot Tables to Create New Source Data.mp4
|
MP4
|
5.9 MB
|
|
|
4. PRO TIP Using Tabular Pivot Tables to Create New Source Data.srt
|
SRT
|
3.1 KB
|
|
|
4. Pivot Chart Demo Clustered Bar Chart.mp4
|
MP4
|
7.4 MB
|
|
|
4. Pivot Chart Demo Clustered Bar Chart.srt
|
SRT
|
4.7 KB
|
|
|
5. Calculating Pivot Table Values % of Parent.mp4
|
MP4
|
6.7 MB
|
|
|
5. Calculating Pivot Table Values % of Parent.srt
|
SRT
|
4 KB
|
|
|
5. Customizing Pivot Table Headers & Labels.mp4
|
MP4
|
2.5 MB
|
|
|
5. Customizing Pivot Table Headers & Labels.srt
|
SRT
|
1.9 KB
|
|
|
5. Filtering Data with Pivot Table Value Filters.mp4
|
MP4
|
7.4 MB
|
|
|
5. Filtering Data with Pivot Table Value Filters.srt
|
SRT
|
4.1 KB
|
|
|
5. Navigating the Pivot Table Field List.mp4
|
MP4
|
15.7 MB
|
|
|
5. Navigating the Pivot Table Field List.srt
|
SRT
|
10.9 KB
|
|
|
5. PRO TIP Preventing Charts from Resizing with Cells.mp4
|
MP4
|
9.1 MB
|
|
|
5. PRO TIP Preventing Charts from Resizing with Cells.srt
|
SRT
|
6.7 KB
|
|
|
5. Pivot Table Demo Analyzing San Francisco Salary Data.mp4
|
MP4
|
36.9 MB
|
|
|
5. Pivot Table Demo Analyzing San Francisco Salary Data.srt
|
SRT
|
17.4 KB
|
|
|
5. Setting Expectations.mp4
|
MP4
|
2.2 MB
|
|
|
5. Setting Expectations.srt
|
SRT
|
1.8 KB
|
|
|
6. Applying Basic Conditional Formats to Pivot Tables.mp4
|
MP4
|
18.6 MB
|
|
|
6. Applying Basic Conditional Formats to Pivot Tables.srt
|
SRT
|
9.6 KB
|
|
|
6. Calculating Pivot Table Values Difference From.mp4
|
MP4
|
10 MB
|
|
|
6. Calculating Pivot Table Values Difference From.srt
|
SRT
|
6.1 KB
|
|
|
6. Changing Pivot Chart Types.mp4
|
MP4
|
6.3 MB
|
|
|
6. Changing Pivot Chart Types.srt
|
SRT
|
4.5 KB
|
|
|
6. HOMEWORK Analyzing San Francisco Salary Data.html
|
HTML
|
2.1 KB
|
|
|
6. KNOWLEDGE CHECK Manipulating the Pivot Table Field List.html
|
HTML
|
1.8 KB
|
|
|
6. PRO TIP Enabling Multiple Pivot Table Filters.mp4
|
MP4
|
7.9 MB
|
|
|
6. PRO TIP Enabling Multiple Pivot Table Filters.srt
|
SRT
|
3.6 KB
|
|
|
7. Calculating Pivot Table Values Running Total.mp4
|
MP4
|
6 MB
|
|
|
7. Calculating Pivot Table Values Running Total.srt
|
SRT
|
3.9 KB
|
|
|
7. Exploring Pivot Table Analyze & Design Options.mp4
|
MP4
|
3.4 MB
|
|
|
7. Exploring Pivot Table Analyze & Design Options.srt
|
SRT
|
2.2 KB
|
|
|
7. Grouping & Segmenting Data with Pivot Tables.mp4
|
MP4
|
9.6 MB
|
|
|
7. Grouping & Segmenting Data with Pivot Tables.srt
|
SRT
|
4.5 KB
|
|
|
7. PRO TIP Adding Data Bars with Invisible Text.mp4
|
MP4
|
5.2 MB
|
|
|
7. PRO TIP Adding Data Bars with Invisible Text.srt
|
SRT
|
3.3 KB
|
|
|
7. Pivot Chart Demo Stacked Area Chart.mp4
|
MP4
|
13.5 MB
|
|
|
7. Pivot Chart Demo Stacked Area Chart.srt
|
SRT
|
7.7 KB
|
|
|
7. Pivot Table Demo Exploring Shark Attack Records.mp4
|
MP4
|
23.2 MB
|
|
|
7. Pivot Table Demo Exploring Shark Attack Records.srt
|
SRT
|
14 KB
|
|
|
8. Applying Advanced Conditional Formats to Pivot Tables.mp4
|
MP4
|
68.3 MB
|
|
|
8. Applying Advanced Conditional Formats to Pivot Tables.srt
|
SRT
|
9.4 KB
|
|
|
8. Calculating Pivot Table Values Rank.mp4
|
MP4
|
5.9 MB
|
|
|
8. Calculating Pivot Table Values Rank.srt
|
SRT
|
3.4 KB
|
|
|
8. Customizing Pivot Chart Layouts & Styles.mp4
|
MP4
|
7.8 MB
|
|
|
8. Customizing Pivot Chart Layouts & Styles.srt
|
SRT
|
5.8 KB
|
|
|
8. HOMEWORK Exploring Shark Attack Records.html
|
HTML
|
2.8 KB
|
|
|
8. PRO TIP Enabling & Disabling Automatic Date Grouping.mp4
|
MP4
|
10.7 MB
|
|
|
8. PRO TIP Enabling & Disabling Automatic Date Grouping.srt
|
SRT
|
6.4 KB
|
|
|
8. Selecting, Clearing, Moving & Copying Pivot Tables.mp4
|
MP4
|
10.8 MB
|
|
|
8. Selecting, Clearing, Moving & Copying Pivot Tables.srt
|
SRT
|
7.9 KB
|
|
|
9. Calculating Pivot Table Values Index.mp4
|
MP4
|
20.5 MB
|
|
|
9. Calculating Pivot Table Values Index.srt
|
SRT
|
10.2 KB
|
|
|
9. Filtering Data with Pivot Table Slicers & Timelines.mp4
|
MP4
|
10.3 MB
|
|
|
9. Filtering Data with Pivot Table Slicers & Timelines.srt
|
SRT
|
6.6 KB
|
|
|
9. Moving Pivot Charts to New Excel Worksheets.mp4
|
MP4
|
4.3 MB
|
|
|
9. Moving Pivot Charts to New Excel Worksheets.srt
|
SRT
|
3.1 KB
|
|
|
9. Pivot Table Demo Analyzing Stock Market Data.mp4
|
MP4
|
36.9 MB
|
|
|
9. Pivot Table Demo Analyzing Stock Market Data.srt
|
SRT
|
16.6 KB
|
|
|
9. QUIZ Excel Pivot Table Formatting.html
|
HTML
|
102 B
|
|
|
9. Refreshing & Updating Pivot Tables.mp4
|
MP4
|
25.7 MB
|
|
|
9. Refreshing & Updating Pivot Tables.srt
|
SRT
|
9.9 KB
|
|
|
Opening.exe
|
EXE
|
5 MB
|
|
|
Read.txt
|
TXT
|
716 B
|
