Filename Size 1. Microsoft Excel 101 Course Introduction/1. Ask Questions.mp4 71.3 MB 1. Microsoft Excel 101 Course Introduction/1. Ask Questions.vtt 6.1 KB 1. Microsoft Excel 101 Course Introduction/2. Course Exercise Files.mp4 60.3 MB 1. Microsoft Excel 101 Course Introduction/2. Course Exercise Files.vtt 4.5 KB 1. Microsoft Excel 101 Course Introduction/2.1 MonthlyBudget-01.xlsx.xlsx 14.3 KB 1. Microsoft Excel 101 Course Introduction/2.10 MonthlyBudget-SUMFunction-01.xlsx.xlsx 13.8 KB 1. Microsoft Excel 101 Course Introduction/2.11 MonthlyBudget-MIN-MAXFunctions-01.xlsx.xlsx 14 KB 1. Microsoft Excel 101 Course Introduction/2.2 MonthlyBudget-Headers-01.xlsx.xlsx 13.7 KB 1. Microsoft Excel 101 Course Introduction/2.3 MonthlyBudget-AutoFill-01.xlsx.xlsx 13.8 KB 1. Microsoft Excel 101 Course Introduction/2.4 MonthlyBudget-BasicFormulas-01.xlsx.xlsx 13.7 KB 1. Microsoft Excel 101 Course Introduction/2.5 MonthlyBudget-AutoSUM-01.xlsx.xlsx 14.1 KB 1. Microsoft Excel 101 Course Introduction/2.6 MonthlyBudget-ReferenceTypes-01.xlsx.xlsx 13.7 KB 1. Microsoft Excel 101 Course Introduction/2.7 MonthlyBudget-AverageFunction-01.xlsx.xlsx 14.1 KB 1. Microsoft Excel 101 Course Introduction/2.8 MonthlyBudget-Template-01.xlsx.xlsx 14.5 KB 1. Microsoft Excel 101 Course Introduction/2.9 MonthlyBudget-Count-01.xlsx.xlsx 14.3 KB 1. Microsoft Excel 101 Course Introduction/3. Certificate of Completion.mp4 39.6 MB 1. Microsoft Excel 101 Course Introduction/3. Certificate of Completion.vtt 3 KB 10. Working with Excel Templates/1. Intro to Excel Templates.mp4 5.4 MB 10. Working with Excel Templates/1. Intro to Excel Templates.vtt 2 KB 10. Working with Excel Templates/2. Opening an Existing Template.mp4 22.3 MB 10. Working with Excel Templates/2. Opening an Existing Template.vtt 7.7 KB 10. Working with Excel Templates/3. Creating a Custom Template.mp4 16.3 MB 10. Working with Excel Templates/3. Creating a Custom Template.vtt 6.2 KB 11. Congratulations! You've Built a Solid Microsoft Excel Foundation/1. Congratulations!.mp4 5.5 MB 11. Congratulations! You've Built a Solid Microsoft Excel Foundation/1. Congratulations!.vtt 1.2 KB 12. Microsoft Excel 102 Course Introduction/1. Course Exercise Files - Download these First!.html 281 B 12. Microsoft Excel 102 Course Introduction/1.1 NorthwindDB.zip.zip 392.3 KB 12. Microsoft Excel 102 Course Introduction/1.2 Excel102Exercises.txt.txt 25.9 KB 12. Microsoft Excel 102 Course Introduction/1.3 Excel102Exercises.xlsx.xlsx 136 KB 13. Working with an Excel List/1. Understanding Excel List Structure.mp4 29.4 MB 13. Working with an Excel List/1. Understanding Excel List Structure.vtt 7.6 KB 13. Working with an Excel List/2. Sorting a List Using Single Level Sort.mp4 20.3 MB 13. Working with an Excel List/2. Sorting a List Using Single Level Sort.vtt 4.9 KB 13. Working with an Excel List/3. Sorting a List Using Multi-Level Sorts.mp4 20.4 MB 13. Working with an Excel List/3. Sorting a List Using Multi-Level Sorts.vtt 4.7 KB 13. Working with an Excel List/4. Using Custom Sorts in an Excel List.mp4 20.5 MB 13. Working with an Excel List/4. Using Custom Sorts in an Excel List.vtt 5.9 KB 13. Working with an Excel List/5. Filter an Excel List Using the AutoFilter Tool.mp4 20.8 MB 13. Working with an Excel List/5. Filter an Excel List Using the AutoFilter Tool.vtt 6.5 KB 13. Working with an Excel List/6. Creating Subtotals in a List.mp4 39.6 MB 13. Working with an Excel List/6. Creating Subtotals in a List.vtt 9.1 KB 13. Working with an Excel List/7. Format a List as a Table.mp4 42.7 MB 13. Working with an Excel List/7. Format a List as a Table.vtt 10.2 KB 13. Working with an Excel List/8. Using Conditional Formatting to Find Duplicates.mp4 22.8 MB 13. Working with an Excel List/8. Using Conditional Formatting to Find Duplicates.vtt 4.9 KB 13. Working with an Excel List/9. Removing Duplicates.mp4 22.9 MB 13. Working with an Excel List/9. Removing Duplicates.vtt 5.3 KB 14. Excel List Functions/1. Excel Function DSUM().mp4 39.6 MB 14. Excel List Functions/1. Excel Function DSUM().vtt 8.3 KB 14. Excel List Functions/2. Excel Function DAVERAGE().mp4 17.6 MB 14. Excel List Functions/2. Excel Function DAVERAGE().vtt 3.6 KB 14. Excel List Functions/3. Excel Function DCOUNT().mp4 19.3 MB 14. Excel List Functions/3. Excel Function DCOUNT().vtt 4 KB 14. Excel List Functions/4. Excel Function SUBTOTAL().mp4 40.6 MB 14. Excel List Functions/4. Excel Function SUBTOTAL().vtt 8.2 KB 15. Excel Data Validation/1. Understanding the Need for Data Validation.mp4 22.7 MB 15. Excel Data Validation/1. Understanding the Need for Data Validation.vtt 6.7 KB 15. Excel Data Validation/2. Creating a Validation List.mp4 26 MB 15. Excel Data Validation/2. Creating a Validation List.vtt 7.2 KB 15. Excel Data Validation/3. Adding a Custom Validation Error.mp4 20.6 MB 15. Excel Data Validation/3. Adding a Custom Validation Error.vtt 5.7 KB 15. Excel Data Validation/4. Dynamic Formulas by Using Validation Techniques.mp4 22.5 MB 15. Excel Data Validation/4. Dynamic Formulas by Using Validation Techniques.vtt 5.4 KB 16. Importing and Exporting Data/1. Importing Data from Text Files.mp4 19.1 MB 16. Importing and Exporting Data/1. Importing Data from Text Files.vtt 7.3 KB 16. Importing and Exporting Data/2. Importing Data from Microsoft Access.mp4 16.9 MB 16. Importing and Exporting Data/2. Importing Data from Microsoft Access.vtt 5.5 KB 16. Importing and Exporting Data/3. Exporting Data to a Text File.mp4 22.5 MB 16. Importing and Exporting Data/3. Exporting Data to a Text File.vtt 5.5 KB 17. Excel PivotTables/1. Understanding Excel PivotTables.mp4 23.3 MB 17. Excel PivotTables/1. Understanding Excel PivotTables.vtt 4.8 KB 17. Excel PivotTables/2. Creating an Excel PivotTable.mp4 30 MB 17. Excel PivotTables/2. Creating an Excel PivotTable.vtt 8.3 KB 17. Excel PivotTables/3. Modifying Excel PivotTable Calculations.mp4 26.6 MB 17. Excel PivotTables/3. Modifying Excel PivotTable Calculations.vtt 8.9 KB 17. Excel PivotTables/4. Grouping PivotTable Data.mp4 17.2 MB 17. Excel PivotTables/4. Grouping PivotTable Data.vtt 17.2 MB 17. Excel PivotTables/5. Formatting PivotTable Data.mp4 19.5 MB 17. Excel PivotTables/5. Formatting PivotTable Data.vtt 6.2 KB 17. Excel PivotTables/6. Drilling Down into PivotTable Data.mp4 21.1 MB 17. Excel PivotTables/6. Drilling Down into PivotTable Data.vtt 4.4 KB 17. Excel PivotTables/7. Creating PivotCharts.mp4 22.5 MB 17. Excel PivotTables/7. Creating PivotCharts.vtt 6 KB 17. Excel PivotTables/8. Filtering PivotTable Data.mp4 17.2 MB 17. Excel PivotTables/8. Filtering PivotTable Data.vtt 5.1 KB 17. Excel PivotTables/9. Filtering with the Slicer Tool.mp4 18.1 MB 17. Excel PivotTables/9. Filtering with the Slicer Tool.vtt 4.5 KB 18. Working with Excel's PowerPivot Tools/1. Why PowerPivot.mp4 32.6 MB 18. Working with Excel's PowerPivot Tools/1. Why PowerPivot.vtt 5.9 KB 18. Working with Excel's PowerPivot Tools/2. Activating the Excel PowerPivot AddIn.mp4 8.1 MB 18. Working with Excel's PowerPivot Tools/2. Activating the Excel PowerPivot AddIn.vtt 3.1 KB 18. Working with Excel's PowerPivot Tools/3. Creating Data Models with PowerPivot.mp4 45.8 MB 18. Working with Excel's PowerPivot Tools/3. Creating Data Models with PowerPivot.vtt 8.4 KB 18. Working with Excel's PowerPivot Tools/4. Creating PivotTables based on Data Models.mp4 20.4 MB 18. Working with Excel's PowerPivot Tools/4. Creating PivotTables based on Data Models.vtt 5.1 KB 18. Working with Excel's PowerPivot Tools/5. PowerPivot Calculated Fields.mp4 24 MB 18. Working with Excel's PowerPivot Tools/5. PowerPivot Calculated Fields.vtt 4.9 KB 18. Working with Excel's PowerPivot Tools/6. PowerPivot KPIs.mp4 35.9 MB 18. Working with Excel's PowerPivot Tools/6. PowerPivot KPIs.vtt 9 KB