FileMood

Download [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


Copyright © 2024 FileMood.com