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