GetFreeCourses Co-Udemy-Microsoft Excel - Data Analysis with Excel Pivot Tables

1. 1. Getting Started/1. Course Structure & Outline.mp46.76MB
2. 1. Getting Started/4. Getting to Know the IMDb Movie Database.mp49.31MB
3. 1. Getting Started/5. Setting Expectations.mp42.21MB
4. 2. Excel Pivot Table 101/1. Why Pivot Tables.mp47.7MB
5. 2. Excel Pivot Table 101/10. PRO TIP Dealing with Growing Source Data.mp428.02MB
6. 2. Excel Pivot Table 101/11. Removing & Reviving Data from the Pivot Table Cache.mp458.99MB
7. 2. Excel Pivot Table 101/12. PRO TIP How Excel Pivot Tables ACTUALLY Work.mp47.95MB
8. 2. Excel Pivot Table 101/2. Structuring Source Data for Analysis in Excel.mp44.2MB
9. 2. Excel Pivot Table 101/3. Creating Your First Pivot Table.mp410.68MB
10. 2. Excel Pivot Table 101/5. Navigating the Pivot Table Field List.mp415.69MB
11. 2. Excel Pivot Table 101/7. Exploring Pivot Table Analyze & Design Options.mp43.37MB
12. 2. Excel Pivot Table 101/8. Selecting, Clearing, Moving & Copying Pivot Tables.mp410.84MB
13. 2. Excel Pivot Table 101/9. Refreshing & Updating Pivot Tables.mp425.67MB
14. 3. Formatting Data with Pivot Tables/1. Changing Pivot Table Number Formats.mp44.71MB
15. 3. Formatting Data with Pivot Tables/2. PRO TIP Formatting Empty Pivot Table Cells.mp44.01MB
16. 3. Formatting Data with Pivot Tables/3. Configuring Pivot Table Layouts & Styles.mp412.81MB
17. 3. Formatting Data with Pivot Tables/4. PRO TIP Using Tabular Pivot Tables to Create New Source Data.mp45.95MB
18. 3. Formatting Data with Pivot Tables/5. Customizing Pivot Table Headers & Labels.mp42.5MB
19. 3. Formatting Data with Pivot Tables/6. Applying Basic Conditional Formats to Pivot Tables.mp418.59MB
20. 3. Formatting Data with Pivot Tables/7. PRO TIP Adding Data Bars with Invisible Text.mp45.25MB
21. 3. Formatting Data with Pivot Tables/8. Applying Advanced Conditional Formats to Pivot Tables.mp468.27MB
22. 4. Sorting, Filtering & Grouping Data with Pivot Tables/1. Sorting Data with Pivot Tables.mp412.1MB
23. 4. Sorting, Filtering & Grouping Data with Pivot Tables/10. Breaking Out Pivot Table Report Filter Pages.mp49.32MB
24. 4. Sorting, Filtering & Grouping Data with Pivot Tables/2. PRO TIP Fixing Incorrect Alphabetical Sorting.mp45.82MB
25. 4. Sorting, Filtering & Grouping Data with Pivot Tables/3. Filtering Data with Pivot Table Label & Selection Filters.mp421.04MB
26. 4. Sorting, Filtering & Grouping Data with Pivot Tables/4. PRO TIP Pivot Table Label Filters with Wildcards.mp410.38MB
27. 4. Sorting, Filtering & Grouping Data with Pivot Tables/5. Filtering Data with Pivot Table Value Filters.mp47.37MB
28. 4. Sorting, Filtering & Grouping Data with Pivot Tables/6. PRO TIP Enabling Multiple Pivot Table Filters.mp47.9MB
29. 4. Sorting, Filtering & Grouping Data with Pivot Tables/7. Grouping & Segmenting Data with Pivot Tables.mp49.56MB
30. 4. Sorting, Filtering & Grouping Data with Pivot Tables/8. PRO TIP Enabling & Disabling Automatic Date Grouping.mp410.66MB
31. 4. Sorting, Filtering & Grouping Data with Pivot Tables/9. Filtering Data with Pivot Table Slicers & Timelines.mp410.29MB
32. 5. Enriching Data with Pivot Table Calculated Values & Fields/1. Aggregating & Summarizing Data with Pivot Tables.mp49.07MB
33. 5. Enriching Data with Pivot Table Calculated Values & Fields/11. Defining Calculated Fields with Pivot Tables.mp414.88MB
34. 5. Enriching Data with Pivot Table Calculated Values & Fields/12. Creating Calculated Fields in Pivot Tables vs. Source Data.mp410.43MB
35. 5. Enriching Data with Pivot Table Calculated Values & Fields/13. PRO TIP Pivot Table Calculations Using Count Columns (Part 1).mp416.61MB
36. 5. Enriching Data with Pivot Table Calculated Values & Fields/14. PRO TIP Pivot Table Calculations Using Count Columns (Part 2).mp49.91MB
37. 5. Enriching Data with Pivot Table Calculated Values & Fields/15. Inserting Pivot Table Calculated Items (USE WITH CAUTION!).mp411.78MB
38. 5. Enriching Data with Pivot Table Calculated Values & Fields/16. Generating Solve Order & List Formulas Reports.mp410.06MB
39. 5. Enriching Data with Pivot Table Calculated Values & Fields/2. PRO TIP Avoiding the Pivot Table Count Of Trap.mp49.76MB
40. 5. Enriching Data with Pivot Table Calculated Values & Fields/3. Defining Value Calculations with Pivot Tables.mp46.5MB
41. 5. Enriching Data with Pivot Table Calculated Values & Fields/4. Calculating Pivot Table Values % of ColumnRow.mp48.62MB
42. 5. Enriching Data with Pivot Table Calculated Values & Fields/5. Calculating Pivot Table Values % of Parent.mp46.65MB
43. 5. Enriching Data with Pivot Table Calculated Values & Fields/6. Calculating Pivot Table Values Difference From.mp410.03MB
44. 5. Enriching Data with Pivot Table Calculated Values & Fields/7. Calculating Pivot Table Values Running Total.mp45.99MB
45. 5. Enriching Data with Pivot Table Calculated Values & Fields/8. Calculating Pivot Table Values Rank.mp45.91MB
46. 5. Enriching Data with Pivot Table Calculated Values & Fields/9. Calculating Pivot Table Values Index.mp420.46MB
47. 6. Visualizing Data with Excel Pivot Charts/1. Intro to Excel Pivot Charts.mp44.63MB
48. 6. Visualizing Data with Excel Pivot Charts/10. Applying Slicers & Timelines to Multiple Pivot Charts.mp410.56MB
49. 6. Visualizing Data with Excel Pivot Charts/11. Building Dynamic Dashboards with Pivot Tables & Pivot Charts.mp427.4MB
50. 6. Visualizing Data with Excel Pivot Charts/2. Pivot Chart Demo Column Chart.mp48.03MB
51. 6. Visualizing Data with Excel Pivot Charts/3. Pivot Chart Demo Pie & Donut Charts.mp411.4MB
52. 6. Visualizing Data with Excel Pivot Charts/4. Pivot Chart Demo Clustered Bar Chart.mp47.37MB
53. 6. Visualizing Data with Excel Pivot Charts/5. PRO TIP Preventing Charts from Resizing with Cells.mp49.11MB
54. 6. Visualizing Data with Excel Pivot Charts/6. Changing Pivot Chart Types.mp46.33MB
55. 6. Visualizing Data with Excel Pivot Charts/7. Pivot Chart Demo Stacked Area Chart.mp413.46MB
56. 6. Visualizing Data with Excel Pivot Charts/8. Customizing Pivot Chart Layouts & Styles.mp47.82MB
57. 6. Visualizing Data with Excel Pivot Charts/9. Moving Pivot Charts to New Excel Worksheets.mp44.34MB
58. 7. Excel Pivot Table Case Studies/1. Setting Expectations.mp43.64MB
59. 7. Excel Pivot Table Case Studies/11. Pivot Table Demo Analyzing Major League Baseball Teams.mp433.91MB
60. 7. Excel Pivot Table Case Studies/13. Pivot Table Demo Exploring San Diego Burrito Ratings.mp444.42MB
61. 7. Excel Pivot Table Case Studies/15. Pivot Table Demo Tracking Daily Weather Conditions.mp430.78MB
62. 7. Excel Pivot Table Case Studies/17. Pivot Table Demo Analyzing Spartan Race Facebook Posts.mp437.27MB
63. 7. Excel Pivot Table Case Studies/19. Pivot Table Demo Analyzing Apple App Store Data.mp4208.29MB
64. 7. Excel Pivot Table Case Studies/21. Pivot Table Demo Analyzing Wine Tasting Scores.mp4191.14MB
65. 7. Excel Pivot Table Case Studies/3. Pivot Table Demo Analyzing U.S. Voter Demographics.mp426.7MB
66. 7. Excel Pivot Table Case Studies/5. Pivot Table Demo Analyzing San Francisco Salary Data.mp436.88MB
67. 7. Excel Pivot Table Case Studies/7. Pivot Table Demo Exploring Shark Attack Records.mp423.24MB
68. 7. Excel Pivot Table Case Studies/9. Pivot Table Demo Analyzing Stock Market Data.mp436.85MB
69. 8. Wrapping Up/1. Resources & Next Steps.mp44.48MB