Filename | Size |
| 1. Course Introduction/1. Introduction.mp4 | 3.9 MB |
| 1. Course Introduction/1. Introduction.vtt | 4.8 KB |
| 2. Managing & Enriching Data in Excel/1. Introduction to working with data in Excel.mp4 | 3.4 MB |
| 2. Managing & Enriching Data in Excel/1. Introduction to working with data in Excel.vtt | 5.1 KB |
| 2. Managing & Enriching Data in Excel/10. More Formulas.mp4 | 20.9 MB |
| 2. Managing & Enriching Data in Excel/10. More Formulas.vtt | 20.7 KB |
| 2. Managing & Enriching Data in Excel/10.1 Excel Guru Other Formulas.xlsx | 9.8 KB |
| 2. Managing & Enriching Data in Excel/11. Mathematical Functions Quiz.html | 126 B |
| 2. Managing & Enriching Data in Excel/12. Learn any function.mp4 | 8.8 MB |
| 2. Managing & Enriching Data in Excel/12. Learn any function.vtt | 8.4 KB |
| 2. Managing & Enriching Data in Excel/13. Using Paste Special.mp4 | 9.7 MB |
| 2. Managing & Enriching Data in Excel/13. Using Paste Special.vtt | 9.5 KB |
| 2. Managing & Enriching Data in Excel/14. Cell validation.mp4 | 7.4 MB |
| 2. Managing & Enriching Data in Excel/14. Cell validation.vtt | 7.9 KB |
| 2. Managing & Enriching Data in Excel/14.1 Excel Guru Cell Validation.xlsx | 8.9 KB |
| 2. Managing & Enriching Data in Excel/15. Cell styles.mp4 | 5.7 MB |
| 2. Managing & Enriching Data in Excel/15. Cell styles.vtt | 5.3 KB |
| 2. Managing & Enriching Data in Excel/15.1 Excel Guru Cell Styles.xlsx | 9.9 KB |
| 2. Managing & Enriching Data in Excel/16. Formatting data as a table.mp4 | 8.9 MB |
| 2. Managing & Enriching Data in Excel/16. Formatting data as a table.vtt | 9.4 KB |
| 2. Managing & Enriching Data in Excel/16.1 Excel Guru Tables.xlsx | 15.3 KB |
| 2. Managing & Enriching Data in Excel/17. Using named ranges.mp4 | 8 MB |
| 2. Managing & Enriching Data in Excel/17. Using named ranges.vtt | 7.5 KB |
| 2. Managing & Enriching Data in Excel/17.1 Excel Guru Named Ranges.xlsx | 9 KB |
| 2. Managing & Enriching Data in Excel/18. Freeze Panes - navigating large data sheets.mp4 | 5.8 MB |
| 2. Managing & Enriching Data in Excel/18. Freeze Panes - navigating large data sheets.vtt | 5.1 KB |
| 2. Managing & Enriching Data in Excel/18.1 Excel Guru Freeze Panes.xlsx | 902.6 KB |
| 2. Managing & Enriching Data in Excel/19. File Types - how to save your work in the right format.mp4 | 4.2 MB |
| 2. Managing & Enriching Data in Excel/19. File Types - how to save your work in the right format.vtt | 7.6 KB |
| 2. Managing & Enriching Data in Excel/2. Some basic best practice principles.mp4 | 7.6 MB |
| 2. Managing & Enriching Data in Excel/2. Some basic best practice principles.vtt | 8.7 KB |
| 2. Managing & Enriching Data in Excel/20. All Excel keyboard shortcuts cheat sheet.pdf | 94.5 KB |
| 2. Managing & Enriching Data in Excel/21. All Excel functions and formulas cheat sheet.pdf | 181.6 KB |
| 2. Managing & Enriching Data in Excel/3. NEW The 10 immutable laws of structuring data in Excel.html | 7.3 KB |
| 2. Managing & Enriching Data in Excel/4. NEW VLOOKUP & HLOOKUP Functions.mp4 | 21.4 MB |
| 2. Managing & Enriching Data in Excel/4. NEW VLOOKUP & HLOOKUP Functions.vtt | 9.4 KB |
| 2. Managing & Enriching Data in Excel/4.1 VLOOKUP-HLOOKUP-Lesson-Examples.xlsx.xlsx | 30.1 KB |
| 2. Managing & Enriching Data in Excel/5. NEW Challenge Add data from another table using VLOOKUP.html | 353 B |
| 2. Managing & Enriching Data in Excel/5.1 CHALLENGE - Add data from another table using VLOOKUP.xlsx.xlsx | 18.5 KB |
| 2. Managing & Enriching Data in Excel/6. IF.mp4 | 7.3 MB |
| 2. Managing & Enriching Data in Excel/6. IF.vtt | 6.7 KB |
| 2. Managing & Enriching Data in Excel/6.1 Excel Guru IF.xlsx | 9.9 KB |
| 2. Managing & Enriching Data in Excel/7. IFERROR.mp4 | 8.4 MB |
| 2. Managing & Enriching Data in Excel/7. IFERROR.vtt | 7.8 KB |
| 2. Managing & Enriching Data in Excel/7.1 Excel Guru IFERROR.xlsx | 9.7 KB |
| 2. Managing & Enriching Data in Excel/8. ISERROR.mp4 | 6.7 MB |
| 2. Managing & Enriching Data in Excel/8. ISERROR.vtt | 6.5 KB |
| 2. Managing & Enriching Data in Excel/8.1 Excel Guru ISERROR.xlsx | 9.9 KB |
| 2. Managing & Enriching Data in Excel/9. Choosing the correct function.html | 126 B |
| 3. Data Analysis in Excel/1. Introduction to Analysis in Excel.mp4 | 1.7 MB |
| 3. Data Analysis in Excel/1. Introduction to Analysis in Excel.vtt | 2 KB |
| 3. Data Analysis in Excel/2. Conditional formatting basics.mp4 | 17.7 MB |
| 3. Data Analysis in Excel/2. Conditional formatting basics.vtt | 14.9 KB |
| 3. Data Analysis in Excel/2.1 Excel Guru Conditional Formatting.xlsx | 11.1 KB |
| 3. Data Analysis in Excel/3. An introduction to pivot tables.mp4 | 19.7 MB |
| 3. Data Analysis in Excel/3. An introduction to pivot tables.vtt | 20.4 KB |
| 3. Data Analysis in Excel/3.1 Excel Guru Pivot Tabes Basic.xlsx | 1.1 MB |
| 3. Data Analysis in Excel/4. Advanced pivot tables.mp4 | 28.1 MB |
| 3. Data Analysis in Excel/4. Advanced pivot tables.vtt | 20.9 KB |
| 3. Data Analysis in Excel/4.1 Excel Guru Pivot Tables Advanced.xlsx | 1.1 MB |
| 3. Data Analysis in Excel/5. Pivot slicers.mp4 | 6.9 MB |
| 3. Data Analysis in Excel/5. Pivot slicers.vtt | 6.4 KB |
| 3. Data Analysis in Excel/5.1 Excel Guru Slicers.xlsx | 1.2 MB |
| 4. Presentation in Excel/1. Introduction to Presentation in Excel.mp4 | 1.8 MB |
| 4. Presentation in Excel/1. Introduction to Presentation in Excel.vtt | 3.2 KB |
| 4. Presentation in Excel/2. Basic Charts in Excel.mp4 | 10.4 MB |
| 4. Presentation in Excel/2. Basic Charts in Excel.vtt | 10.4 KB |
| 4. Presentation in Excel/2.1 Excel Guru Basic Charts.xlsx | 17.8 KB |
| 4. Presentation in Excel/3. NEW Scatter & Bubble Charts.mp4 | 22.1 MB |
| 4. Presentation in Excel/3. NEW Scatter & Bubble Charts.vtt | 10.2 KB |
| 4. Presentation in Excel/3.1 Scatter & Bubble Chart Lesson Example.xlsx.xlsx | 31.7 KB |
| 4. Presentation in Excel/4. Pivot charts.mp4 | 9.6 MB |
| 4. Presentation in Excel/4. Pivot charts.vtt | 8.4 KB |
| 4. Presentation in Excel/4.1 Excel Guru Pivot Charts.xlsx | 1.1 MB |
| 4. Presentation in Excel/5. Password protecting the workbook.mp4 | 9 MB |
| 4. Presentation in Excel/5. Password protecting the workbook.vtt | 9.4 KB |
| 4. Presentation in Excel/6. Designing Dashboards (Part 1).mp4 | 8.4 MB |
| 4. Presentation in Excel/6. Designing Dashboards (Part 1).vtt | 8.7 KB |
| 4. Presentation in Excel/6.1 Excel Guru Dashboards.xlsx | 1.2 MB |
| 4. Presentation in Excel/7. Designing Dashboard (Part 2).mp4 | 20.5 MB |
| 4. Presentation in Excel/7. Designing Dashboard (Part 2).vtt | 15.4 KB |
| 4. Presentation in Excel/8. Hiding gridlines for presentation.mp4 | 1.5 MB |
| 4. Presentation in Excel/8. Hiding gridlines for presentation.vtt | 1.4 KB |
| 5. Automation in Excel/1. Introduction to Automation in Excel.mp4 | 3.9 MB |
| 5. Automation in Excel/1. Introduction to Automation in Excel.vtt | 6.3 KB |
| 5. Automation in Excel/10. A useful VBA tool you can use to improve your pivot tables..mp4 | 5.9 MB |
| 5. Automation in Excel/10. A useful VBA tool you can use to improve your pivot tables..vtt | 6 KB |
| 5. Automation in Excel/11. VBA Forms - creating interactive forms for your spreadsheet.mp4 | 14.3 MB |
| 5. Automation in Excel/11. VBA Forms - creating interactive forms for your spreadsheet.vtt | 16.2 KB |
| 5. Automation in Excel/12. Bonus Lecture.html | 468 B |
| 5. Automation in Excel/2. VBA Introduction.mp4 | 4.7 MB |
| 5. Automation in Excel/2. VBA Introduction.vtt | 6.7 KB |
| 5. Automation in Excel/3. Using the Macro Recorder.mp4 | 10.5 MB |
| 5. Automation in Excel/3. Using the Macro Recorder.vtt | 12.1 KB |
| 5. Automation in Excel/4. VBA Referencing.mp4 | 6.2 MB |
| 5. Automation in Excel/4. VBA Referencing.vtt | 9 KB |
| 5. Automation in Excel/5. VBA Variables.mp4 | 6.2 MB |
| 5. Automation in Excel/5. VBA Variables.vtt | 8.3 KB |
| 5. Automation in Excel/6. VBA IFs.mp4 | 3.7 MB |