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