Microsoft Excel Data Analysis with Excel Pivot Tables | 234E862F2E81D35EF1D5E5E401A4902ED4457C25

Microsoft Excel Data Analysis with Excel Pivot Tables

Name	Microsoft Excel - Data Analysis with Excel Pivot Tables	DOWNLOAD Copy Link
Total Size	1.0 GB
Total Files	132
Hash	234E862F2E81D35EF1D5E5E401A4902ED4457C25

/.../07 Excel Pivot Table Case Studies/
086 Pivot Table Demo Analyzing Apple App Store Data.mp4	218.4 MB
068 Setting Expectations.en.srt	2.7 KB
069 DOWNLOAD Case Study Resources.html	1.3 KB
069 PivotTable-Case-Studies-COMPLETE.xlsx	51.6 MB
069 PivotTable-Case-Studies.pdf	1.6 MB
069 PivotTable-Case-Studies.xlsx	30.5 MB
070 Pivot Table Demo Analyzing U.S. Voter Demographics.en.srt	13.7 KB
070 Pivot Table Demo Analyzing U.S. Voter Demographics.mp4	28.0 MB
071 HOMEWORK Analyzing U.S. Voter Demographics.html	3.6 KB
072 Pivot Table Demo Analyzing San Francisco Salary Data.en.srt	17.8 KB
072 Pivot Table Demo Analyzing San Francisco Salary Data.mp4	38.7 MB
073 HOMEWORK Analyzing San Francisco Salary Data.html	3.0 KB
074 Pivot Table Demo Exploring Shark Attack Records.en.srt	14.3 KB
074 Pivot Table Demo Exploring Shark Attack Records.mp4	24.4 MB
075 HOMEWORK Exploring Shark Attack Records.html	3.8 KB
076 Pivot Table Demo Analyzing Stock Market Data.en.srt	17.0 KB
076 Pivot Table Demo Analyzing Stock Market Data.mp4	38.6 MB
077 HOMEWORK Analyzing Stock Market Data.html	2.7 KB
078 Pivot Table Demo Analyzing Major League Baseball Teams.en.srt	19.2 KB
078 Pivot Table Demo Analyzing Major League Baseball Teams.mp4	35.6 MB
079 HOMEWORK Analyzing Major League Baseball Teams.html	3.8 KB
080 Pivot Table Demo Exploring San Diego Burrito Ratings.en.srt	22.6 KB
080 Pivot Table Demo Exploring San Diego Burrito Ratings.mp4	46.6 MB
081 HOMEWORK Exploring San Diego Burrito Ratings.html	3.6 KB
082 Pivot Table Demo Tracking Daily Weather Conditions.en.srt	17.2 KB
082 Pivot Table Demo Tracking Daily Weather Conditions.mp4	32.3 MB
083 HOMEWORK Tracking Daily Weather Conditions.html	3.1 KB
084 Pivot Table Demo Analyzing Spartan Race Facebook Posts.en.srt	19.7 KB
084 Pivot Table Demo Analyzing Spartan Race Facebook Posts.mp4	39.1 MB
085 HOMEWORK Analyzing Spartan Race Facebook Posts.html	3.1 KB
086 Pivot Table Demo Analyzing Apple App Store Data.en.srt	26.5 KB
087 HOMEWORK Analyzing Apple App Store Data.html	4.9 KB
088 Pivot Table Demo Analyzing Wine Tasting Scores.en.srt	24.0 KB
088 Pivot Table Demo Analyzing Wine Tasting Scores.mp4	200.4 MB
089 HOMEWORK Analyzing Wine Tasting Scores.html	4.3 KB
/
Visit Coursedrive.org.url	0.1 KB
ReadMe.txt	0.2 KB
/Microsoft Excel - Data Analysis with Excel Pivot Tables/
ReadMe.txt	0.2 KB
Visit Coursedrive.org.url	0.1 KB
/.../01 Getting Started/
001 Course Structure Outline.en.srt	5.5 KB
001 Course Structure Outline.mp4	7.1 MB
002 READ ME Important Notes for New Students.html	5.4 KB
003 DOWNLOAD Course Resources.html	1.4 KB
003 E6-Movies.xlsx	10.1 KB
003 Excel-PivotTable-Slides.pdf	2.4 MB
003 IMDb-Movie-Database.xlsx	470.6 KB
004 Getting to Know the IMDb Movie Database.en.srt	3.6 KB
004 Getting to Know the IMDb Movie Database.mp4	9.8 MB
005 Setting Expectations.en.srt	1.9 KB
005 Setting Expectations.mp4	2.3 MB
ReadMe.txt	0.2 KB
Visit Coursedrive.org.url	0.1 KB
/.../02 Excel Pivot Table 101/
006 Why Pivot Tables.en.srt	6.5 KB
006 Why Pivot Tables.mp4	8.1 MB
007 Structuring Source Data for Analysis in Excel.en.srt	2.9 KB
007 Structuring Source Data for Analysis in Excel.mp4	4.4 MB
008 Creating Your First Pivot Table.en.srt	4.6 KB
008 Creating Your First Pivot Table.mp4	11.2 MB
009 IMPORTANT Add to Data Model.html	2.0 KB
010 Navigating the Pivot Table Field List.en.srt	11.2 KB
010 Navigating the Pivot Table Field List.mp4	16.4 MB
011 KNOWLEDGE CHECK Manipulating the Pivot Table Field List.html	2.7 KB
012 Exploring Pivot Table Analyze Design Options.en.srt	2.2 KB
012 Exploring Pivot Table Analyze Design Options.mp4	3.5 MB
013 Selecting Clearing Moving Copying Pivot Tables.en.srt	8.1 KB
013 Selecting Clearing Moving Copying Pivot Tables.mp4	11.4 MB
014 Refreshing Updating Pivot Tables.en.srt	10.2 KB
014 Refreshing Updating Pivot Tables.mp4	26.9 MB
015 PRO TIP Dealing with Growing Source Data.en.srt	8.8 KB
015 PRO TIP Dealing with Growing Source Data.mp4	29.4 MB
016 Removing Reviving Data from the Pivot Table Cache.en.srt	8.1 KB
016 Removing Reviving Data from the Pivot Table Cache.mp4	61.9 MB
017 PRO TIP How Excel Pivot Tables ACTUALLY Work.en.srt	5.0 KB
017 PRO TIP How Excel Pivot Tables ACTUALLY Work.mp4	8.3 MB
018 HOMEWORK Excel Pivot Table 101.html	4.2 KB
/.../03 Formatting Data with Pivot Tables/
019 Changing Pivot Table Number Formats.en.srt	3.5 KB
019 Changing Pivot Table Number Formats.mp4	4.9 MB
020 PRO TIP Formatting Empty Pivot Table Cells.en.srt	2.6 KB
020 PRO TIP Formatting Empty Pivot Table Cells.mp4	4.2 MB
021 Configuring Pivot Table Layouts Styles.en.srt	8.2 KB
021 Configuring Pivot Table Layouts Styles.mp4	13.4 MB
022 PRO TIP Using Tabular Pivot Tables to Create New Source Data.en.srt	3.2 KB
023 Customizing Pivot Table Headers Labels.en.srt	1.9 KB
024 Applying Basic Conditional Formats to Pivot Tables.en.srt	9.9 KB
025 PRO TIP Adding Data Bars with Invisible Text.en.srt	3.4 KB
026 Applying Advanced Conditional Formats to Pivot Tables.en.srt	9.7 KB
027 HOMEWORK Excel Pivot Table Formatting.html	3.7 KB
/.../04 Sorting Filtering Grouping Data with Pivot Tables/
028 Sorting Data with Pivot Tables.en.srt	7.3 KB
029 PRO TIP Fixing Incorrect Alphabetical Sorting.en.srt	3.0 KB
030 Filtering Data with Pivot Table Label Selection Filters.en.srt	12.0 KB
031 PRO TIP Pivot Table Label Filters with Wildcards.en.srt	5.1 KB
032 Filtering Data with Pivot Table Value Filters.en.srt	4.2 KB
033 PRO TIP Enabling Multiple Pivot Table Filters.en.srt	3.7 KB
034 Grouping Segmenting Data with Pivot Tables.en.srt	4.6 KB
035 PRO TIP Enabling Disabling Automatic Date Grouping.en.srt	6.5 KB
036 Filtering Data with Pivot Table Slicers Timelines.en.srt	6.8 KB
037 Breaking Out Pivot Table Report Filter Pages.en.srt	5.8 KB
038 HOMEWORK Sorting Filtering Grouping Data with Excel Pivot Tables.html	3.5 KB
/.../05 Enriching Data with Pivot Table Calculated Values Fields/
039 Aggregating Summarizing Data with Pivot Tables.en.srt	7.0 KB
040 PRO TIP Avoiding the Pivot Table Count Of Trap.en.srt	5.5 KB
041 Defining Value Calculations with Pivot Tables.en.srt	5.3 KB
042 Calculating Pivot Table Values of ColumnRow.en.srt	5.4 KB
043 Calculating Pivot Table Values of Parent.en.srt	4.1 KB
044 Calculating Pivot Table Values Difference From.en.srt	6.2 KB
045 Calculating Pivot Table Values Running Total.en.srt	4.0 KB
046 Calculating Pivot Table Values Rank.en.srt	3.5 KB
047 Calculating Pivot Table Values Index.en.srt	10.4 KB
048 KNOWLEDGE CHECK Pivot Table Value Calculations.html	1.9 KB
049 Defining Calculated Fields with Pivot Tables.en.srt	8.8 KB
050 Creating Calculated Fields in Pivot Tables vs. Source Data.en.srt	6.2 KB
051 PRO TIP Pivot Table Calculations Using Count Columns (Part 1).en.srt	10.0 KB
052 PRO TIP Pivot Table Calculations Using Count Columns (Part 2).en.srt	5.9 KB
053 Inserting Pivot Table Calculated Items (USE WITH CAUTION).en.srt	8.6 KB
054 Generating Solve Order List Formulas Reports.en.srt	6.9 KB
055 HOMEWORK Enriching Data with Pivot Table Calculated Values Fields.html	4.5 KB
/.../06 Visualizing Data with Excel Pivot Charts/
056 Intro to Excel Pivot Charts.en.srt	3.6 KB
057 Pivot Chart Demo Column Chart.en.srt	5.9 KB
058 Pivot Chart Demo Pie Donut Charts.en.srt	8.2 KB
059 Pivot Chart Demo Clustered Bar Chart.en.srt	4.8 KB
060 PRO TIP Preventing Charts from Resizing with Cells.en.srt	6.9 KB
061 Changing Pivot Chart Types.en.srt	4.6 KB
062 Pivot Chart Demo Stacked Area Chart.en.srt	7.9 KB
063 Customizing Pivot Chart Layouts Styles.en.srt	5.9 KB
064 Moving Pivot Charts to New Excel Worksheets.en.srt	3.2 KB
065 Applying Slicers Timelines to Multiple Pivot Charts.en.srt	6.9 KB
066 Building Dynamic Dashboards with Pivot Tables Pivot Charts.en.srt	17.3 KB
067 HOMEWORK Visualizing Data with Excel Pivot Charts.html	4.4 KB
/.../08 Wrapping Up/
090 Resources Next Steps.en.srt	4.0 KB
090 Resources Next Steps.mp4	4.7 MB
091 More from Maven Analytics.html	5.1 KB
ReadMe.txt	0.2 KB
Visit Coursedrive.org.url	0.1 KB
Total files 132