GigaCourse com Udemy Microsoft Excel Data Analysis with Excel Pivot Tables

GigaCourse com Udemy Microsoft Excel Data Analysis with Excel Pivot Tables

Name	[GigaCourse.com] Udemy - Microsoft Excel - Data Analysis with Excel Pivot Tables	DOWNLOAD Copy Link
Total Size	1.5 GB
Total Files	173
Hash	1D5657804FCF68CD4D73AF576A284827E26D17C0

/1. Getting Started/
1. Course Structure & Outline.mp4	7.1 MB
1. Course Structure & Outline.srt	5.5 KB
2. READ ME Important Notes for New Students.html	4.5 KB
3. DOWNLOAD Course Resources.html	0.5 KB
3.1 IMDb Movie Database.xlsx.xlsx	470.6 KB
3.2 Excel_PivotTable_Slides.pdf.pdf	2.4 MB
3.3 2016_Movies.xlsx.xlsx	10.1 KB
4. Getting to Know the IMDb Movie Database.mp4	9.8 MB
4. Getting to Know the IMDb Movie Database.srt	3.6 KB
5. Setting Expectations.mp4	2.3 MB
5. Setting Expectations.srt	1.9 KB
/2. Excel Pivot Table 101/
1. Why Pivot Tables.mp4	8.1 MB
1. Why Pivot Tables.srt	6.5 KB
10. PRO TIP Dealing with Growing Source Data.mp4	29.4 MB
10. PRO TIP Dealing with Growing Source Data.srt	8.8 KB
11. Removing & Reviving Data from the Pivot Table Cache.mp4	61.9 MB
11. Removing & Reviving Data from the Pivot Table Cache.srt	8.1 KB
12. PRO TIP How Excel Pivot Tables ACTUALLY Work.mp4	8.3 MB
12. PRO TIP How Excel Pivot Tables ACTUALLY Work.srt	5.0 KB
13. QUIZ Excel Pivot Table 101.html	0.1 KB
14. HOMEWORK Excel Pivot Table 101.html	3.4 KB
2. Structuring Source Data for Analysis in Excel.mp4	4.4 MB
2. Structuring Source Data for Analysis in Excel.srt	2.9 KB
3. Creating Your First Pivot Table.mp4	11.2 MB
3. Creating Your First Pivot Table.srt	4.6 KB
4. IMPORTANT Add to Data Model.html	1.1 KB
5. Navigating the Pivot Table Field List.mp4	16.4 MB
5. Navigating the Pivot Table Field List.srt	11.2 KB
6. KNOWLEDGE CHECK Manipulating the Pivot Table Field List.html	1.8 KB
7. Exploring Pivot Table Analyze & Design Options.mp4	3.5 MB
7. Exploring Pivot Table Analyze & Design Options.srt	2.2 KB
8. Selecting, Clearing, Moving & Copying Pivot Tables.mp4	11.4 MB
8. Selecting, Clearing, Moving & Copying Pivot Tables.srt	8.1 KB
9. Refreshing & Updating Pivot Tables.mp4	26.9 MB
9. Refreshing & Updating Pivot Tables.srt	10.2 KB
/3. Formatting Data with Pivot Tables/
1. Changing Pivot Table Number Formats.mp4	4.9 MB
1. Changing Pivot Table Number Formats.srt	3.5 KB
10. HOMEWORK Excel Pivot Table Formatting.html	2.8 KB
2. PRO TIP Formatting Empty Pivot Table Cells.mp4	4.2 MB
2. PRO TIP Formatting Empty Pivot Table Cells.srt	2.6 KB
3. Configuring Pivot Table Layouts & Styles.mp4	13.4 MB
3. Configuring Pivot Table Layouts & Styles.srt	8.2 KB
4. PRO TIP Using Tabular Pivot Tables to Create New Source Data.mp4	6.2 MB
4. PRO TIP Using Tabular Pivot Tables to Create New Source Data.srt	3.2 KB
5. Customizing Pivot Table Headers & Labels.mp4	2.6 MB
5. Customizing Pivot Table Headers & Labels.srt	1.9 KB
6. Applying Basic Conditional Formats to Pivot Tables.mp4	19.5 MB
6. Applying Basic Conditional Formats to Pivot Tables.srt	9.9 KB
7. PRO TIP Adding Data Bars with Invisible Text.mp4	5.5 MB
7. PRO TIP Adding Data Bars with Invisible Text.srt	3.4 KB
8. Applying Advanced Conditional Formats to Pivot Tables.mp4	71.6 MB
8. Applying Advanced Conditional Formats to Pivot Tables.srt	9.7 KB
9. QUIZ Excel Pivot Table Formatting.html	0.1 KB
/4. Sorting, Filtering & Grouping Data with Pivot Tables/
1. Sorting Data with Pivot Tables.mp4	12.7 MB
1. Sorting Data with Pivot Tables.srt	7.3 KB
10. Breaking Out Pivot Table Report Filter Pages.mp4	9.8 MB
10. Breaking Out Pivot Table Report Filter Pages.srt	5.8 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	6.1 MB
2. PRO TIP Fixing Incorrect Alphabetical Sorting.srt	3.0 KB
3. Filtering Data with Pivot Table Label & Selection Filters.mp4	22.1 MB
3. Filtering Data with Pivot Table Label & Selection Filters.srt	12.0 KB
4. PRO TIP Pivot Table Label Filters with Wildcards.mp4	10.9 MB
4. PRO TIP Pivot Table Label Filters with Wildcards.srt	5.1 KB
5. Filtering Data with Pivot Table Value Filters.mp4	7.7 MB
5. Filtering Data with Pivot Table Value Filters.srt	4.2 KB
6. PRO TIP Enabling Multiple Pivot Table Filters.mp4	8.3 MB
6. PRO TIP Enabling Multiple Pivot Table Filters.srt	3.7 KB
7. Grouping & Segmenting Data with Pivot Tables.mp4	10.0 MB
7. Grouping & Segmenting Data with Pivot Tables.srt	4.6 KB
8. PRO TIP Enabling & Disabling Automatic Date Grouping.mp4	11.2 MB
8. PRO TIP Enabling & Disabling Automatic Date Grouping.srt	6.5 KB
9. Filtering Data with Pivot Table Slicers & Timelines.mp4	10.8 MB
9. Filtering Data with Pivot Table Slicers & Timelines.srt	6.8 KB
/5. Enriching Data with Pivot Table Calculated Values & Fields/
1. Aggregating & Summarizing Data with Pivot Tables.mp4	9.5 MB
1. Aggregating & Summarizing Data with Pivot Tables.srt	7.0 KB
10. KNOWLEDGE CHECK Pivot Table Value Calculations.html	1.1 KB
11. Defining Calculated Fields with Pivot Tables.mp4	15.6 MB
11. Defining Calculated Fields with Pivot Tables.srt	8.8 KB
12. Creating Calculated Fields in Pivot Tables vs. Source Data.mp4	10.9 MB
12. Creating Calculated Fields in Pivot Tables vs. Source Data.srt	6.2 KB
13. PRO TIP Pivot Table Calculations Using Count Columns (Part 1).mp4	17.4 MB
13. PRO TIP Pivot Table Calculations Using Count Columns (Part 1).srt	10.0 KB
14. PRO TIP Pivot Table Calculations Using Count Columns (Part 2).mp4	10.4 MB
14. PRO TIP Pivot Table Calculations Using Count Columns (Part 2).srt	5.9 KB
15. Inserting Pivot Table Calculated Items (USE WITH CAUTION!).mp4	12.4 MB
15. Inserting Pivot Table Calculated Items (USE WITH CAUTION!).srt	8.6 KB
16. Generating Solve Order & List Formulas Reports.mp4	10.5 MB
16. Generating Solve Order & List Formulas Reports.srt	6.9 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.6 KB
2. PRO TIP Avoiding the Pivot Table Count Of Trap.mp4	10.2 MB
2. PRO TIP Avoiding the Pivot Table Count Of Trap.srt	5.5 KB
3. Defining Value Calculations with Pivot Tables.mp4	6.8 MB
3. Defining Value Calculations with Pivot Tables.srt	5.3 KB
4. Calculating Pivot Table Values % of ColumnRow.mp4	9.0 MB
4. Calculating Pivot Table Values % of ColumnRow.srt	5.4 KB
5. Calculating Pivot Table Values % of Parent.mp4	7.0 MB
5. Calculating Pivot Table Values % of Parent.srt	4.1 KB
6. Calculating Pivot Table Values Difference From.mp4	10.5 MB
6. Calculating Pivot Table Values Difference From.srt	6.2 KB
7. Calculating Pivot Table Values Running Total.mp4	6.3 MB
7. Calculating Pivot Table Values Running Total.srt	4.0 KB
8. Calculating Pivot Table Values Rank.mp4	6.2 MB
8. Calculating Pivot Table Values Rank.srt	3.5 KB
9. Calculating Pivot Table Values Index.mp4	21.5 MB
9. Calculating Pivot Table Values Index.srt	10.4 KB
/6. Visualizing Data with Excel Pivot Charts/
1. Intro to Excel Pivot Charts.mp4	4.9 MB
1. Intro to Excel Pivot Charts.srt	3.6 KB
10. Applying Slicers & Timelines to Multiple Pivot Charts.mp4	11.1 MB
10. Applying Slicers & Timelines to Multiple Pivot Charts.srt	6.9 KB
11. Building Dynamic Dashboards with Pivot Tables & Pivot Charts.mp4	28.7 MB
11. Building Dynamic Dashboards with Pivot Tables & Pivot Charts.srt	17.3 KB
12. QUIZ Visualizing Data with Excel Pivot Charts.html	0.1 KB
13. HOMEWORK Visualizing Data with Excel Pivot Charts.html	3.5 KB
2. Pivot Chart Demo Column Chart.mp4	8.4 MB
2. Pivot Chart Demo Column Chart.srt	5.9 KB
3. Pivot Chart Demo Pie & Donut Charts.mp4	11.9 MB
3. Pivot Chart Demo Pie & Donut Charts.srt	8.2 KB
4. Pivot Chart Demo Clustered Bar Chart.mp4	7.7 MB
4. Pivot Chart Demo Clustered Bar Chart.srt	4.8 KB
5. PRO TIP Preventing Charts from Resizing with Cells.mp4	9.5 MB
5. PRO TIP Preventing Charts from Resizing with Cells.srt	6.9 KB
6. Changing Pivot Chart Types.mp4	6.6 MB
6. Changing Pivot Chart Types.srt	4.6 KB
7. Pivot Chart Demo Stacked Area Chart.mp4	14.1 MB
7. Pivot Chart Demo Stacked Area Chart.srt	7.9 KB
8. Customizing Pivot Chart Layouts & Styles.mp4	8.2 MB
8. Customizing Pivot Chart Layouts & Styles.srt	5.9 KB
9. Moving Pivot Charts to New Excel Worksheets.mp4	4.5 MB
9. Moving Pivot Charts to New Excel Worksheets.srt	3.2 KB
/7. Excel Pivot Table Case Studies/
1. Setting Expectations.mp4	3.8 MB
1. Setting Expectations.srt	2.7 KB
10. HOMEWORK Analyzing Stock Market Data.html	1.8 KB
11. Pivot Table Demo Analyzing Major League Baseball Teams.mp4	35.6 MB
11. Pivot Table Demo Analyzing Major League Baseball Teams.srt	19.2 KB
12. HOMEWORK Analyzing Major League Baseball Teams.html	2.9 KB
13. Pivot Table Demo Exploring San Diego Burrito Ratings.mp4	46.6 MB
13. Pivot Table Demo Exploring San Diego Burrito Ratings.srt	22.6 KB
14. HOMEWORK Exploring San Diego Burrito Ratings.html	2.7 KB
15. Pivot Table Demo Tracking Daily Weather Conditions.mp4	32.3 MB
15. Pivot Table Demo Tracking Daily Weather Conditions.srt	17.2 KB
16. HOMEWORK Tracking Daily Weather Conditions.html	2.3 KB
17. Pivot Table Demo Analyzing Spartan Race Facebook Posts.mp4	39.1 MB
17. Pivot Table Demo Analyzing Spartan Race Facebook Posts.srt	19.7 KB
18. HOMEWORK Analyzing Spartan Race Facebook Posts.html	2.3 KB
19. Pivot Table Demo Analyzing Apple App Store Data.mp4	218.4 MB
19. Pivot Table Demo Analyzing Apple App Store Data.srt	26.5 KB
2. DOWNLOAD Case Study Resources.html	0.5 KB
2.1 PivotTable Case Studies_COMPLETE.xlsx.xlsx	51.6 MB
2.2 PivotTable_Case_Studies.pdf.pdf	1.6 MB
2.3 PivotTable Case Studies.xlsx.xlsx	30.5 MB
20. HOMEWORK Analyzing Apple App Store Data.html	4.0 KB
21. Pivot Table Demo Analyzing Wine Tasting Scores.mp4	200.4 MB
21. Pivot Table Demo Analyzing Wine Tasting Scores.srt	24.0 KB
22. HOMEWORK Analyzing Wine Tasting Scores.html	3.4 KB
3. Pivot Table Demo Analyzing U.S. Voter Demographics.mp4	28.0 MB
3. Pivot Table Demo Analyzing U.S. Voter Demographics.srt	13.7 KB
4. HOMEWORK Analyzing U.S. Voter Demographics.html	2.7 KB
5. Pivot Table Demo Analyzing San Francisco Salary Data.mp4	38.7 MB
5. Pivot Table Demo Analyzing San Francisco Salary Data.srt	17.8 KB
6. HOMEWORK Analyzing San Francisco Salary Data.html	2.1 KB
7. Pivot Table Demo Exploring Shark Attack Records.mp4	24.4 MB
7. Pivot Table Demo Exploring Shark Attack Records.srt	14.3 KB
8. HOMEWORK Exploring Shark Attack Records.html	2.9 KB
9. Pivot Table Demo Analyzing Stock Market Data.mp4	38.6 MB
9. Pivot Table Demo Analyzing Stock Market Data.srt	17.0 KB
/8. Wrapping Up/
1. Resources & Next Steps.mp4	4.7 MB
1. Resources & Next Steps.srt	4.0 KB
2. More from Maven Analytics.html	3.4 KB
/
Readme.txt	1.0 KB
[GigaCourse.com].url	0.0 KB
Total files 173