Filename Size 1. Microsoft Excel 101 Course Introduction/1. Ask Questions.mp4 71.3 MB 1. Microsoft Excel 101 Course Introduction/1. Ask Questions.srt 6.4 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.srt 5 KB 1. Microsoft Excel 101 Course Introduction/2.1 MonthlyBudget-BasicFormulas-01.xlsx.xlsx 13.7 KB 1. Microsoft Excel 101 Course Introduction/2.10 MonthlyBudget-Count-01.xlsx.xlsx 14.3 KB 1. Microsoft Excel 101 Course Introduction/2.11 MonthlyBudget-ReferenceTypes-01.xlsx.xlsx 13.7 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-Template-01.xlsx.xlsx 14.5 KB 1. Microsoft Excel 101 Course Introduction/2.4 MonthlyBudget-SUMFunction-01.xlsx.xlsx 13.8 KB 1. Microsoft Excel 101 Course Introduction/2.5 MonthlyBudget-01.xlsx.xlsx 14.3 KB 1. Microsoft Excel 101 Course Introduction/2.6 MonthlyBudget-MIN-MAXFunctions-01.xlsx.xlsx 14 KB 1. Microsoft Excel 101 Course Introduction/2.7 MonthlyBudget-AutoSUM-01.xlsx.xlsx 14.1 KB 1. Microsoft Excel 101 Course Introduction/2.8 MonthlyBudget-AverageFunction-01.xlsx.xlsx 14.1 KB 1. Microsoft Excel 101 Course Introduction/2.9 MonthlyBudget-AutoFill-01.xlsx.xlsx 13.8 KB 1. Microsoft Excel 101 Course Introduction/3. Certificate of Completion.mp4 39.7 MB 1. Microsoft Excel 101 Course Introduction/3. Certificate of Completion.srt 3.6 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.srt 2.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.srt 8.6 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.srt 7 KB 11. Congratulations! You've Built a Solid Microsoft Excel Foundation/1. Congratulations!.mp4 5.6 MB 11. Congratulations! You've Built a Solid Microsoft Excel Foundation/1. Congratulations!.srt 1.3 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 Excel102Exercises.xlsx.xlsx 136 KB 12. Microsoft Excel 102 Course Introduction/1.2 Excel102Exercises.txt.txt 25.5 KB 12. Microsoft Excel 102 Course Introduction/1.3 NorthwindDB.zip.zip 392.3 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.srt 8.5 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.srt 5.5 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.srt 5.2 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.srt 6.7 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.srt 7.3 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.srt 10.4 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.srt 11.7 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.srt 5.5 KB 13. Working with an Excel List/9. Removing Duplicates.mp4 22.9 MB 13. Working with an Excel List/9. Removing Duplicates.srt 6 KB 14. Excel List Functions/1. Excel Function DSUM().mp4 39.6 MB 14. Excel List Functions/1. Excel Function DSUM().srt 9.4 KB 14. Excel List Functions/2. Excel Function DAVERAGE().mp4 17.6 MB 14. Excel List Functions/2. Excel Function DAVERAGE().srt 4 KB 14. Excel List Functions/3. Excel Function DCOUNT().mp4 19.3 MB 14. Excel List Functions/3. Excel Function DCOUNT().srt 4.5 KB 14. Excel List Functions/4. Excel Function SUBTOTAL().mp4 40.6 MB 14. Excel List Functions/4. Excel Function SUBTOTAL().srt 9.3 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.srt 7.4 KB 15. Excel Data Validation/2. Creating a Validation List.mp4 26 MB 15. Excel Data Validation/2. Creating a Validation List.srt 8.1 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.srt 6.4 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.srt 6 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.srt 8.2 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.srt 6.2 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.srt 6.2 KB 17. Excel PivotTables/1. Understanding Excel PivotTables.mp4 23.3 MB 17. Excel PivotTables/1. Understanding Excel PivotTables.srt 5.4 KB 17. Excel PivotTables/2. Creating an Excel PivotTable.mp4 30 MB 17. Excel PivotTables/2. Creating an Excel PivotTable.srt 9.3 KB 17. Excel PivotTables/3. Modifying Excel PivotTable Calculations.mp4 26.6 MB 17. Excel PivotTables/3. Modifying Excel PivotTable Calculations.srt 10.1 KB 17. Excel PivotTables/4. Grouping PivotTable Data.mp4 17.2 MB 17. Excel PivotTables/4. Grouping PivotTable Data.srt 7.1 KB 17. Excel PivotTables/5. Formatting PivotTable Data.mp4 19.5 MB 17. Excel PivotTables/5. Formatting PivotTable Data.srt 7 KB 17. Excel PivotTables/6. Drilling Down into PivotTable Data.mp4 21.1 MB 17. Excel PivotTables/6. Drilling Down into PivotTable Data.srt 4.9 KB 17. Excel PivotTables/7. Creating PivotCharts.mp4 22.5 MB 17. Excel PivotTables/7. Creating PivotCharts.srt 6.8 KB 17. Excel PivotTables/8. Filtering PivotTable Data.mp4 17.2 MB 17. Excel PivotTables/8. Filtering PivotTable Data.srt 5.7 KB 17. Excel PivotTables/9. Filtering with the Slicer Tool.mp4 18.1 MB 17. Excel PivotTables/9. Filtering with the Slicer Tool.srt 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.srt 6.6 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.srt 3.4 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.srt 9.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.srt 5.6 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.srt 5.4 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.srt 10.1 KB