Udemy - Microsoft Excel - Data Analysis with Excel Pivot Tables [...

Files:

• 1. Course Structure & Outline.mp4 (6.8 MB)
• 1. Course Structure & Outline.srt (5.4 KB)
• 2. READ ME Important Notes for New Students.html (4.4 KB)
• 3. DOWNLOAD Course Resources.html (0.5 KB)
• 3.1 IMDb Movie Database.xlsx.xlsx (459.6 KB)
• 3.2 Excel_PivotTable_Slides.pdf.pdf (2.3 MB)
• 3.3 2016_Movies.xlsx.xlsx (9.8 KB)
• 4. Getting to Know the IMDb Movie Database.mp4 (9.3 MB)
• 4. Getting to Know the IMDb Movie Database.srt (3.5 KB)
• 5. Setting Expectations.mp4 (2.2 MB)
• 5. Setting Expectations.srt (1.8 KB)

• 1. Why Pivot Tables.mp4 (7.7 MB)
• 1. Why Pivot Tables.srt (6.4 KB)
• 10. PRO TIP Dealing with Growing Source Data.mp4 (28.0 MB)
• 10. PRO TIP Dealing with Growing Source Data.srt (8.6 KB)
• 11. Removing & Reviving Data from the Pivot Table Cache.mp4 (59.0 MB)
• 11. Removing & Reviving Data from the Pivot Table Cache.srt (7.9 KB)
• 12. PRO TIP How Excel Pivot Tables ACTUALLY Work.mp4 (8.0 MB)
• 12. PRO TIP How Excel Pivot Tables ACTUALLY Work.srt (4.9 KB)
• 13. QUIZ Excel Pivot Table 101.html (0.1 KB)
• 14. HOMEWORK Excel Pivot Table 101.html (3.3 KB)
• 2. Structuring Source Data for Analysis in Excel.mp4 (4.2 MB)
• 2. Structuring Source Data for Analysis in Excel.srt (2.9 KB)
• 3. Creating Your First Pivot Table.mp4 (10.7 MB)
• 3. Creating Your First Pivot Table.srt (4.5 KB)
• 4. IMPORTANT Add to Data Model.html (1.1 KB)
• 5. Navigating the Pivot Table Field List.mp4 (15.7 MB)
• 5. Navigating the Pivot Table Field List.srt (10.9 KB)
• 6. KNOWLEDGE CHECK Manipulating the Pivot Table Field List.html (1.8 KB)
• 7. Exploring Pivot Table Analyze & Design Options.mp4 (3.4 MB)
• 7. Exploring Pivot Table Analyze & Design Options.srt (2.2 KB)
• 8. Selecting, Clearing, Moving & Copying Pivot Tables.mp4 (10.8 MB)
• 8. Selecting, Clearing, Moving & Copying Pivot Tables.srt (7.9 KB)
• 9. Refreshing & Updating Pivot Tables.mp4 (25.7 MB)
• 9. Refreshing & Updating Pivot Tables.srt (9.9 KB)

• 1. Changing Pivot Table Number Formats.mp4 (4.7 MB)
• 1. Changing Pivot Table Number Formats.srt (3.4 KB)
• 10. HOMEWORK Excel Pivot Table Formatting.html (2.8 KB)
• 2. PRO TIP Formatting Empty Pivot Table Cells.mp4 (4.0 MB)
• 2. PRO TIP Formatting Empty Pivot Table Cells.srt (2.5 KB)
• 3. Configuring Pivot Table Layouts & Styles.mp4 (12.8 MB)
• 3. Configuring Pivot Table Layouts & Styles.srt (8.0 KB)
• 4. PRO TIP Using Tabular Pivot Tables to Create New Source Data.mp4 (5.9 MB)
• 4. PRO TIP Using Tabular Pivot Tables to Create New Source Data.srt (3.1 KB)
• 5. Customizing Pivot Table Headers & Labels.mp4 (2.5 MB)
• 5. Customizing Pivot Table Headers & Labels.srt (1.9 KB)
• 6. Applying Basic Conditional Formats to Pivot Tables.mp4 (18.6 MB)
• 6. Applying Basic Conditional Formats to Pivot Tables.srt (9.6 KB)
• 7. PRO TIP Adding Data Bars with Invisible Text.mp4 (5.2 MB)
• 7. PRO TIP Adding Data Bars with Invisible Text.srt (3.3 KB)
• 8. Applying Advanced Conditional Formats to Pivot Tables.mp4 (68.3 MB)
• 8. Applying Advanced Conditional Formats to Pivot Tables.srt (9.4 KB)
• 9. QUIZ Excel Pivot Table Formatting.html (0.1 KB)

• 1. Sorting Data with Pivot Tables.mp4 (12.1 MB)
• 1. Sorting Data with Pivot Tables.srt (7.1 KB)
• 10. Breaking Out Pivot Table Report Filter Pages.mp4 (9.3 MB)
• 10. Breaking Out Pivot Table Report Filter Pages.srt (5.7 KB)
• 11. QUIZ Sorting, Filtering & Grouping Data with Excel Pivot Tables.html (0.1 KB)
• 12. HOMEWORK Sorting, Filtering & Grouping Data with Excel Pivot Tables.html (2.6 KB)
• 2. PRO TIP Fixing Incorrect Alphabetical Sorting.mp4 (5.8 MB)
• 2. PRO TIP Fixing Incorrect Alphabetical Sorting.srt (2.9 KB)
• 3. Filtering Data with Pivot Table Label & Selection Filters.mp4 (21.0 MB)
• 3. Filtering Data with Pivot Table Label & Selection Filters.srt (11.7 KB)
• 4. PRO TIP Pivot Table Label Filters with Wildcards.mp4 (10.4 MB)
• 4. PRO TIP Pivot Table Label Filters with Wildcards.srt (5.0 KB)
• 5. Filtering Data with Pivot Table Value Filters.mp4 (7.4 MB)
• 5. Filtering Data with Pivot Table Value Filters.srt (4.1 KB)
• 6. PRO TIP Enabling Multiple Pivot Table Filters.mp4 (7.9 MB)
• 6. PRO TIP Enabling Multiple Pivot Table Filters.srt (3.6 KB)
• 7. Grouping & Segmenting Data with Pivot Tables.mp4 (9.6 MB)
• 7. Grouping & Segmenting Data with Pivot Tables.srt (4.5 KB)
• 8. PRO TIP Enabling & Disabling Automatic Date Grouping.mp4 (10.7 MB)
• 8. PRO TIP Enabling & Disabling Automatic Date Grouping.srt (6.4 KB)
• 9. Filtering Data with Pivot Table Slicers & Timelines.mp4 (10.3 MB)
• 9. Filtering Data with Pivot Table Slicers & Timelines.srt (6.6 KB)

• 1. Aggregating & Summarizing Data with Pivot Tables.mp4 (9.1 MB)
• 1. Aggregating & Summarizing Data with Pivot Tables.srt (6.8 KB)
• 10. KNOWLEDGE CHECK Pivot Table Value Calculations.html (1.0 KB)
• 11. Defining Calculated Fields with Pivot Tables.mp4 (14.9 MB)
• 11. Defining Calculated Fields with Pivot Tables.srt (8.6 KB)
• 12. Creating Calculated Fields in Pivot Tables vs. Source Data.mp4 (10.4 MB)
• 12. Creating Calculated Fields in Pivot Tables vs. Source Data.srt (6.1 KB)
• 13. PRO TIP Pivot Table Calculations Using Count Columns (Part 1).mp4 (16.6 MB)
• 13. PRO TIP Pivot Table Calculations Using Count Columns (Part 1).srt (9.7 KB)
• 14. PRO TIP Pivot Table Calculations Using Count Columns (Part 2).mp4 (9.9 MB)
• 14. PRO TIP Pivot Table Calculations Using Count Columns (Part 2).srt (5.7 KB)
• 15. Inserting Pivot Table Calculated Items (USE WITH CAUTION!).mp4 (11.8 MB)
• 15. Inserting Pivot Table Calculated Items (USE WITH CAUTION!).srt (8.4 KB)
• 16. Generating Solve Order & List Formulas Reports.mp4 (10.1 MB)
• 16. Generating Solve Order & List Formulas Reports.srt (6.7 KB)
• 17. QUIZ Enriching Data with Pivot Table Calculated Values & Fields.html (0.1 KB)
• 18. HOMEWORK Enriching Data with Pivot Table Calculated Values & Fields.html (3.5 KB)
• 2. PRO TIP Avoiding the Pivot Table Count Of Trap.mp4 (9.8 MB)
• 2. PRO TIP Avoiding the Pivot Table Count Of Trap.srt (5.4 KB)
• 3. Defining Value Calculations with Pivot Tables.mp4 (6.5 MB)
• 3. Defining Value Calculations with Pivot Tables.srt (5.2 KB)
• 4. Calculating Pivot Table Values % of ColumnRow.mp4 (8.6 MB)
• 4. Calculating Pivot Table Values % of ColumnRow.srt (5.3 KB)
• 5. Calculating Pivot Table Values % of Parent.mp4 (6.7 MB)
• 5. Calculating Pivot Table Values % of Parent.srt (4.0 KB)
• 6. Calculating Pivot Table Values Difference From.mp4 (10.0 MB)
• 6. Calculating Pivot Table Values Difference From.srt (6.1 KB)
• 7. Calculating Pivot Table Values Running Total.mp4 (6.0 MB)
• 7. Calculating Pivot Table Values Running Total.srt (3.9 KB)
• 8. Calculating Pivot Table Values Rank.mp4 (5.9 MB)
• 8. Calculating Pivot Table Values Rank.srt (3.4 KB)
• 9. Calculating Pivot Table Values Index.mp4 (20.5 MB)
• 9. Calculating Pivot Table Values Index.srt (10.2 KB)

• 1. Intro to Excel Pivot Charts.mp4 (4.6 MB)
• 1. Intro to Excel Pivot Charts.srt (3.6 KB)
• 10. Applying Slicers & Timelines to Multiple Pivot Charts.mp4 (10.6 MB)
• 10. Applying Slicers & Timelines to Multiple Pivot Charts.srt (6.7 KB)
• 11. Building Dynamic Dashboards with Pivot Tables & Pivot Charts.mp4 (27.4 MB)
• 11. Building Dynamic Dashboards with Pivot Tables & Pivot Charts.srt (16.9 KB)
• 12. QUIZ Visualizing Data with Excel Pivot Charts.html (0.1 KB)
• 13. HOMEWORK Visualizing Data with Excel Pivot Charts.html (3.4 KB)
• 2. Pivot Chart Demo Column Chart.mp4 (8.0 MB)
• 2. Pivot Chart Demo Column Chart.srt (5.8 KB)
• 3. Pivot Chart Demo Pie & Donut Charts.mp4 (11.4 MB)
• 3. Pivot Chart Demo Pie & Donut Charts.srt (8.0 KB)
• 4. Pivot Chart Demo Clustered Bar Chart.mp4 (7.4 MB)
• 4. Pivot Chart Demo Clustered Bar Chart.srt (4.7 KB)
• 5. PRO TIP Preventing Charts from Resizing with Cells.mp4 (9.1 MB)
• 5. PRO TIP Preventing Charts from Resizing with Cells.srt (6.7 KB)
• 6. Changing Pivot Chart Types.mp4 (6.3 MB)
• 6. Changing Pivot Chart Types.srt (4.5 KB)
• 7. Pivot Chart Demo Stacked Area Chart.mp4 (13.5 MB)
• 7. Pivot Chart Demo Stacked Area Chart.srt (7.7 KB)
• 8. Customizing Pivot Chart Layouts & Styles.mp4 (7.8 MB)
• 8. Customizing Pivot Chart Layouts & Styles.srt (5.8 KB)
• 9. Moving Pivot Charts to New Excel Worksheets.mp4 (4.3 MB)
• 9. Moving Pivot Charts to New Excel Worksheets.srt (3.1 KB)

• 1. Setting Expectations.mp4 (3.6 MB)
• 1. Setting Expectations.srt (2.7 KB)
• 10. HOMEWORK Analyzing Stock Market Data.html (1.7 KB)
• 11. Pivot Table Demo Analyzing Major League Baseball Teams.mp4 (33.9 MB)
• 11. Pivot Table Demo Analyzing Major League Baseball Teams.srt (18.8 KB)
• 12. HOMEWORK Analyzing Major League Baseball Teams.html (2.8 KB)
• 13. Pivot Table Demo Exploring San Diego Burrito Ratings.mp4 (44.4 MB)
• 13. Pivot Table Demo Exploring San Diego Burrito Ratings.srt (22.1 KB)
• 14. HOMEWORK Exploring San Diego Burrito Ratings.html (2.6 KB)
• 15. Pivot Table Demo Tracking Daily Weather Conditions.mp4 (30.8 MB)
• 15. Pivot Table Demo Tracking Daily Weather Conditions.srt (16.8 KB)
• 16. HOMEWORK Tracking Daily Weather Conditions.html (2.2 KB)
• 17. Pivot Table Demo Analyzing Spartan Race Facebook Posts.mp4 (37.3 MB)
• 17. Pivot Table Demo Analyzing Spartan Race Facebook Posts.srt (19.3 KB)
• 18. HOMEWORK Analyzing Spartan Race Facebook Posts.html (2.2 KB)
• 19. Pivot Table Demo Analyzing Apple App Store Data.mp4 (208.3 MB)
• 19. Pivot Table Demo Analyzing Apple App Store Data.srt (25.9 KB)
• 2. DOWNLOAD Case Study Resources.html (0.5 KB)
• 2.1 PivotTable Case Studies_COMPLETE.xlsx.xlsx (49.2 MB)
• 2.2 PivotTable_Case_Studies.pdf.pdf (1.6 MB)
• 2.3 PivotTable Case Studies.xlsx.xlsx (29.1 MB)
• 20. HOMEWORK Analyzing Apple App Store Data.html (3.9 KB)
• 21. Pivot Table Demo Analyzing Wine Tasting Scores.mp4 (191.1 MB)
• 21. Pivot Table Demo Analyzing Wine Tasting Scores.srt (23.5 KB)
• 22. HOMEWORK Analyzing Wine Tasting Scores.html (3.3 KB)
• 3. Pivot Table Demo Analyzing U.S. Voter Demographics.mp4 (26.7 MB)
• 3. Pivot Table Demo Analyzing U.S. Voter Demographics.srt (13.4 KB)
• 4. HOMEWORK Analyzing U.S. Voter Demographics.html (2.6 KB)
• 5. Pivot Table Demo Analyzing San Francisco Salary Data.mp4 (36.9 MB)
• 5. Pivot Table Demo Analyzing San Francisco Salary Data.srt (17.4 KB)
• 6. HOMEWORK Analyzing San Francisco Salary Data.html (2.1 KB)
• 7. Pivot Table Demo Exploring Shark Attack Records.mp4 (23.2 MB)
• 7. Pivot Table Demo Exploring Shark Attack Records.srt (14.0 KB)
• 8. HOMEWORK Exploring Shark Attack Records.html (2.8 KB)
• 9. Pivot Table Demo Analyzing Stock Market Data.mp4 (36.9 MB)
• 9. Pivot Table Demo Analyzing Stock Market Data.srt (16.6 KB)

• 1. Resources & Next Steps.mp4 (4.5 MB)
• 1. Resources & Next Steps.srt (3.9 KB)
• 2. More from Maven Analytics.html (3.3 KB)

• Readme.txt (0.9 KB)
• [GigaCourse.com].url (0.0 KB)