Filename | Size |
| 1. Getting Started/1. Course Structure & Outline.mp4 | 6.8 MB |
| 1. Getting Started/1. Course Structure & Outline.srt | 5.4 KB |
| 1. Getting Started/2. READ ME Important Notes for New Students.html | 4.4 KB |
| 1. Getting Started/3. DOWNLOAD Course Resources.html | 486 B |
| 1. Getting Started/3.1 IMDb Movie Database.xlsx.xlsx | 459.6 KB |
| 1. Getting Started/3.2 Excel_PivotTable_Slides.pdf.pdf | 2.3 MB |
| 1. Getting Started/3.3 2016_Movies.xlsx.xlsx | 9.8 KB |
| 1. Getting Started/4. Getting to Know the IMDb Movie Database.mp4 | 9.3 MB |
| 1. Getting Started/4. Getting to Know the IMDb Movie Database.srt | 3.5 KB |
| 1. Getting Started/5. Setting Expectations.mp4 | 2.2 MB |
| 1. Getting Started/5. Setting Expectations.srt | 1.8 KB |
| 2. Excel Pivot Table 101/1. Why Pivot Tables.mp4 | 7.7 MB |
| 2. Excel Pivot Table 101/1. Why Pivot Tables.srt | 6.4 KB |
| 2. Excel Pivot Table 101/10. PRO TIP Dealing with Growing Source Data.mp4 | 28 MB |
| 2. Excel Pivot Table 101/10. PRO TIP Dealing with Growing Source Data.srt | 8.6 KB |
| 2. Excel Pivot Table 101/11. Removing & Reviving Data from the Pivot Table Cache.mp4 | 59 MB |
| 2. Excel Pivot Table 101/11. Removing & Reviving Data from the Pivot Table Cache.srt | 7.9 KB |
| 2. Excel Pivot Table 101/12. PRO TIP How Excel Pivot Tables ACTUALLY Work.mp4 | 8 MB |
| 2. Excel Pivot Table 101/12. PRO TIP How Excel Pivot Tables ACTUALLY Work.srt | 4.9 KB |
| 2. Excel Pivot Table 101/13. QUIZ Excel Pivot Table 101.html | 147 B |
| 2. Excel Pivot Table 101/14. HOMEWORK Excel Pivot Table 101.html | 3.3 KB |
| 2. Excel Pivot Table 101/2. Structuring Source Data for Analysis in Excel.mp4 | 4.2 MB |
| 2. Excel Pivot Table 101/2. Structuring Source Data for Analysis in Excel.srt | 2.9 KB |
| 2. Excel Pivot Table 101/3. Creating Your First Pivot Table.mp4 | 10.7 MB |
| 2. Excel Pivot Table 101/3. Creating Your First Pivot Table.srt | 4.5 KB |
| 2. Excel Pivot Table 101/4. IMPORTANT Add to Data Model.html | 1.1 KB |
| 2. Excel Pivot Table 101/5. Navigating the Pivot Table Field List.mp4 | 15.7 MB |
| 2. Excel Pivot Table 101/5. Navigating the Pivot Table Field List.srt | 10.9 KB |
| 2. Excel Pivot Table 101/6. KNOWLEDGE CHECK Manipulating the Pivot Table Field List.html | 1.8 KB |
| 2. Excel Pivot Table 101/7. Exploring Pivot Table Analyze & Design Options.mp4 | 3.4 MB |
| 2. Excel Pivot Table 101/7. Exploring Pivot Table Analyze & Design Options.srt | 2.2 KB |
| 2. Excel Pivot Table 101/8. Selecting, Clearing, Moving & Copying Pivot Tables.mp4 | 10.8 MB |
| 2. Excel Pivot Table 101/8. Selecting, Clearing, Moving & Copying Pivot Tables.srt | 7.9 KB |
| 2. Excel Pivot Table 101/9. Refreshing & Updating Pivot Tables.mp4 | 25.7 MB |
| 2. Excel Pivot Table 101/9. Refreshing & Updating Pivot Tables.srt | 9.9 KB |
| 3. Formatting Data with Pivot Tables/1. Changing Pivot Table Number Formats.mp4 | 4.7 MB |
| 3. Formatting Data with Pivot Tables/1. Changing Pivot Table Number Formats.srt | 3.4 KB |
| 3. Formatting Data with Pivot Tables/10. HOMEWORK Excel Pivot Table Formatting.html | 2.8 KB |
| 3. Formatting Data with Pivot Tables/2. PRO TIP Formatting Empty Pivot Table Cells.mp4 | 4 MB |
| 3. Formatting Data with Pivot Tables/2. PRO TIP Formatting Empty Pivot Table Cells.srt | 2.5 KB |
| 3. Formatting Data with Pivot Tables/3. Configuring Pivot Table Layouts & Styles.mp4 | 12.8 MB |
| 3. Formatting Data with Pivot Tables/3. Configuring Pivot Table Layouts & Styles.srt | 8 KB |
| 3. Formatting Data with Pivot Tables/4. PRO TIP Using Tabular Pivot Tables to Create New Source Data.mp4 | 5.9 MB |
| 3. Formatting Data with Pivot Tables/4. PRO TIP Using Tabular Pivot Tables to Create New Source Data.srt | 3.1 KB |
| 3. Formatting Data with Pivot Tables/5. Customizing Pivot Table Headers & Labels.mp4 | 2.5 MB |
| 3. Formatting Data with Pivot Tables/5. Customizing Pivot Table Headers & Labels.srt | 1.9 KB |
| 3. Formatting Data with Pivot Tables/6. Applying Basic Conditional Formats to Pivot Tables.mp4 | 18.6 MB |
| 3. Formatting Data with Pivot Tables/6. Applying Basic Conditional Formats to Pivot Tables.srt | 9.6 KB |
| 3. Formatting Data with Pivot Tables/7. PRO TIP Adding Data Bars with Invisible Text.mp4 | 5.2 MB |
| 3. Formatting Data with Pivot Tables/7. PRO TIP Adding Data Bars with Invisible Text.srt | 3.3 KB |
| 3. Formatting Data with Pivot Tables/8. Applying Advanced Conditional Formats to Pivot Tables.mp4 | 68.3 MB |
| 3. Formatting Data with Pivot Tables/8. Applying Advanced Conditional Formats to Pivot Tables.srt | 9.4 KB |
| 3. Formatting Data with Pivot Tables/9. QUIZ Excel Pivot Table Formatting.html | 147 B |
| 4. Sorting, Filtering & Grouping Data with Pivot Tables/1. Sorting Data with Pivot Tables.mp4 | 12.1 MB |
| 4. Sorting, Filtering & Grouping Data with Pivot Tables/1. Sorting Data with Pivot Tables.srt | 7.1 KB |
| 4. Sorting, Filtering & Grouping Data with Pivot Tables/10. Breaking Out Pivot Table Report Filter Pages.mp4 | 9.3 MB |
| 4. Sorting, Filtering & Grouping Data with Pivot Tables/10. Breaking Out Pivot Table Report Filter Pages.srt | 5.7 KB |
| 4. Sorting, Filtering & Grouping Data with Pivot Tables/11. QUIZ Sorting, Filtering & Grouping Data with Excel Pivot Tables.html | 147 B |
| 4. Sorting, Filtering & Grouping Data with Pivot Tables/12. HOMEWORK Sorting, Filtering & Grouping Data with Excel Pivot Tables.html | 2.6 KB |
| 4. Sorting, Filtering & Grouping Data with Pivot Tables/2. PRO TIP Fixing Incorrect Alphabetical Sorting.mp4 | 5.8 MB |
| 4. Sorting, Filtering & Grouping Data with Pivot Tables/2. PRO TIP Fixing Incorrect Alphabetical Sorting.srt | 2.9 KB |
| 4. Sorting, Filtering & Grouping Data with Pivot Tables/3. Filtering Data with Pivot Table Label & Selection Filters.mp4 | 21 MB |
| 4. Sorting, Filtering & Grouping Data with Pivot Tables/3. Filtering Data with Pivot Table Label & Selection Filters.srt | 11.7 KB |
| 4. Sorting, Filtering & Grouping Data with Pivot Tables/4. PRO TIP Pivot Table Label Filters with Wildcards.mp4 | 10.4 MB |
| 4. Sorting, Filtering & Grouping Data with Pivot Tables/4. PRO TIP Pivot Table Label Filters with Wildcards.srt | 5 KB |
| 4. Sorting, Filtering & Grouping Data with Pivot Tables/5. Filtering Data with Pivot Table Value Filters.mp4 | 7.4 MB |
| 4. Sorting, Filtering & Grouping Data with Pivot Tables/5. Filtering Data with Pivot Table Value Filters.srt | 4.1 KB |
| 4. Sorting, Filtering & Grouping Data with Pivot Tables/6. PRO TIP Enabling Multiple Pivot Table Filters.mp4 | 7.9 MB |
| 4. Sorting, Filtering & Grouping Data with Pivot Tables/6. PRO TIP Enabling Multiple Pivot Table Filters.srt | 3.6 KB |
| 4. Sorting, Filtering & Grouping Data with Pivot Tables/7. Grouping & Segmenting Data with Pivot Tables.mp4 | 9.6 MB |
| 4. Sorting, Filtering & Grouping Data with Pivot Tables/7. Grouping & Segmenting Data with Pivot Tables.srt | 4.5 KB |
| 4. Sorting, Filtering & Grouping Data with Pivot Tables/8. PRO TIP Enabling & Disabling Automatic Date Grouping.mp4 | 10.7 MB |
| 4. Sorting, Filtering & Grouping Data with Pivot Tables/8. PRO TIP Enabling & Disabling Automatic Date Grouping.srt | 6.4 KB |
| 4. Sorting, Filtering & Grouping Data with Pivot Tables/9. Filtering Data with Pivot Table Slicers & Timelines.mp4 | 10.3 MB |
| 4. Sorting, Filtering & Grouping Data with Pivot Tables/9. Filtering Data with Pivot Table Slicers & Timelines.srt | 6.6 KB |
| 5. Enriching Data with Pivot Table Calculated Values & Fields/1. Aggregating & Summarizing Data with Pivot Tables.mp4 | 9.1 MB |
| 5. Enriching Data with Pivot Table Calculated Values & Fields/1. Aggregating & Summarizing Data with Pivot Tables.srt | 6.8 KB |
| 5. Enriching Data with Pivot Table Calculated Values & Fields/10. KNOWLEDGE CHECK Pivot Table Value Calculations.html | 1 KB |
| 5. Enriching Data with Pivot Table Calculated Values & Fields/11. Defining Calculated Fields with Pivot Tables.mp4 | 14.9 MB |
| 5. Enriching Data with Pivot Table Calculated Values & Fields/11. Defining Calculated Fields with Pivot Tables.srt | 8.6 KB |
| 5. Enriching Data with Pivot Table Calculated Values & Fields/12. Creating Calculated Fields in Pivot Tables vs. Source Data.mp4 | 10.4 MB |
| 5. Enriching Data with Pivot Table Calculated Values & Fields/12. Creating Calculated Fields in Pivot Tables vs. Source Data.srt | 6.1 KB |
| 5. Enriching Data with Pivot Table Calculated Values & Fields/13. PRO TIP Pivot Table Calculations Using Count Columns (Part 1).mp4 | 16.6 MB |
| 5. Enriching Data with Pivot Table Calculated Values & Fields/13. PRO TIP Pivot Table Calculations Using Count Columns (Part 1).srt | 9.7 KB |
| 5. Enriching Data with Pivot Table Calculated Values & Fields/14. PRO TIP Pivot Table Calculations Using Count Columns (Part 2).mp4 | 9.9 MB |
| 5. Enriching Data with Pivot Table Calculated Values & Fields/14. PRO TIP Pivot Table Calculations Using Count Columns (Part 2).srt | 5.7 KB |
| 5. Enriching Data with Pivot Table Calculated Values & Fields/15. Inserting Pivot Table Calculated Items (USE WITH CAUTION!).mp4 | 11.8 MB |
| 5. Enriching Data with Pivot Table Calculated Values & Fields/15. Inserting Pivot Table Calculated Items (USE WITH CAUTION!).srt | 8.4 KB |
| 5. Enriching Data with Pivot Table Calculated Values & Fields/16. Generating Solve Order & List Formulas Reports.mp4 | 10.1 MB |
| 5. Enriching Data with Pivot Table Calculated Values & Fields/16. Generating Solve Order & List Formulas Reports.srt | 6.7 KB |
| 5. Enriching Data with Pivot Table Calculated Values & Fields/17. QUIZ Enriching Data with Pivot Table Calculated Values & Fields.html | 147 B |
| 5. Enriching Data with Pivot Table Calculated Values & Fields/18. HOMEWORK Enriching Data with Pivot Table Calculated Values & Fields.html | 3.5 KB |
| 5. Enriching Data with Pivot Table Calculated Values & Fields/2. PRO TIP Avoiding the Pivot Table Count Of Trap.mp4 | 9.8 MB |
| 5. Enriching Data with Pivot Table Calculated Values & Fields/2. PRO TIP Avoiding the Pivot Table Count Of Trap.srt | 5.4 KB |
| 5. Enriching Data with Pivot Table Calculated Values & Fields/3. Defining Value Calculations with Pivot Tables.mp4 | 6.5 MB |
| 5. Enriching Data with Pivot Table Calculated Values & Fields/3. Defining Value Calculations with Pivot Tables.srt | 5.2 KB |
| 5. Enriching Data with Pivot Table Calculated Values & Fields/4. Calculating Pivot Table Values % of ColumnRow.mp4 | 8.6 MB |
| 5. Enriching Data with Pivot Table Calculated Values & Fields/4. Calculating Pivot Table Values % of ColumnRow.srt | 5.3 KB |
| 5. Enriching Data with Pivot Table Calculated Values & Fields/5. Calculating Pivot Table Values % of Parent.mp4 | 6.7 MB |