Filename | Size |
| 1. Introduction to the Course/1. Excel 2016 Introduction - What You'll Learn.mp4 | 54.8 MB |
| 1. Introduction to the Course/1. Excel 2016 Introduction - What You'll Learn.vtt | 7.5 KB |
| 1. Introduction to the Course/2. How to Get the Most Out of This Course.mp4 | 14.4 MB |
| 1. Introduction to the Course/2. How to Get the Most Out of This Course.vtt | 7.5 KB |
| 1. Introduction to the Course/3. Take a Tour of the Excel Dashboard - How to Use the Tabs and Ribbon.mp4 | 31.9 MB |
| 1. Introduction to the Course/3. Take a Tour of the Excel Dashboard - How to Use the Tabs and Ribbon.vtt | 11.8 KB |
| 1. Introduction to the Course/4. Using Excel Templates to Save Time and Effort.mp4 | 36.3 MB |
| 1. Introduction to the Course/4. Using Excel Templates to Save Time and Effort.vtt | 10.5 KB |
| 1. Introduction to the Course/5. Test Your Knowledge.html | 169 B |
| 10. New Features for Excel 2016/1. What's New in Excel 2016.mp4 | 20.7 MB |
| 10. New Features for Excel 2016/1. What's New in Excel 2016.vtt | 6.3 KB |
| 10. New Features for Excel 2016/2. 6 New Chart Types for 2016.mp4 | 27 MB |
| 10. New Features for Excel 2016/2. 6 New Chart Types for 2016.vtt | 12.9 KB |
| 10. New Features for Excel 2016/3. Tell Me What You Want To Do - The New Help Feature.mp4 | 9.6 MB |
| 10. New Features for Excel 2016/3. Tell Me What You Want To Do - The New Help Feature.vtt | 4.4 KB |
| 10. New Features for Excel 2016/4. 1-Click Forecasting.mp4 | 22.3 MB |
| 10. New Features for Excel 2016/4. 1-Click Forecasting.vtt | 7.5 KB |
| 10. New Features for Excel 2016/5. 3D Maps.mp4 | 53.3 MB |
| 10. New Features for Excel 2016/5. 3D Maps.vtt | 13.8 KB |
| 11. Saving Your Work/1. Saving as CSV, Text and PDF.mp4 | 43.2 MB |
| 11. Saving Your Work/1. Saving as CSV, Text and PDF.vtt | 13.2 KB |
| 11. Saving Your Work/2. Saving Backups of Your Excel Files.mp4 | 9.1 MB |
| 11. Saving Your Work/2. Saving Backups of Your Excel Files.vtt | 3.5 KB |
| 11. Saving Your Work/3. Using the AutoRecover Feature.mp4 | 20.1 MB |
| 11. Saving Your Work/3. Using the AutoRecover Feature.vtt | 7.2 KB |
| 12. Importing and Printing Your Work/1. Import from Web, CopyPaste, and Cleaning Up Data.mp4 | 21.9 MB |
| 12. Importing and Printing Your Work/1. Import from Web, CopyPaste, and Cleaning Up Data.vtt | 7.9 KB |
| 12. Importing and Printing Your Work/2. Import from CSV file and Excel Workbook.mp4 | 24 MB |
| 12. Importing and Printing Your Work/2. Import from CSV file and Excel Workbook.vtt | 8.4 KB |
| 12. Importing and Printing Your Work/3. Import from Access Database.mp4 | 21.8 MB |
| 12. Importing and Printing Your Work/3. Import from Access Database.vtt | 5.4 KB |
| 12. Importing and Printing Your Work/4. Print Your Excel Document.mp4 | 14.4 MB |
| 12. Importing and Printing Your Work/4. Print Your Excel Document.vtt | 5.8 KB |
| 13. Keyboard Shortcuts/1. Excel Keyboard Shortcuts.mp4 | 25.7 MB |
| 13. Keyboard Shortcuts/1. Excel Keyboard Shortcuts.vtt | 10.5 KB |
| 13. Keyboard Shortcuts/1.1 Excel Shortcut Keys List.pdf.pdf | 288.4 KB |
| 13. Keyboard Shortcuts/2. ALT Key Shortcuts.mp4 | 11.5 MB |
| 13. Keyboard Shortcuts/2. ALT Key Shortcuts.vtt | 5.4 KB |
| 14. TEXT Functions in Excel/1. TEXT.mp4 | 14.7 MB |
| 14. TEXT Functions in Excel/1. TEXT.vtt | 8.7 KB |
| 14. TEXT Functions in Excel/2. REPT - Repeat.mp4 | 14.2 MB |
| 14. TEXT Functions in Excel/2. REPT - Repeat.vtt | 5 KB |
| 14. TEXT Functions in Excel/3. UPPER, LOWER and PROPER.mp4 | 6.7 MB |
| 14. TEXT Functions in Excel/3. UPPER, LOWER and PROPER.vtt | 3.2 KB |
| 14. TEXT Functions in Excel/4. TRIM - Remove Extra Spaces.mp4 | 14.6 MB |
| 14. TEXT Functions in Excel/4. TRIM - Remove Extra Spaces.vtt | 6.7 KB |
| 14. TEXT Functions in Excel/4.1 TRIM Function Download.xlsx.xlsx | 9.6 KB |
| 14. TEXT Functions in Excel/5. Combining LEFT, MID, FIND and TRIM.mp4 | 23.3 MB |
| 14. TEXT Functions in Excel/5. Combining LEFT, MID, FIND and TRIM.vtt | 10 KB |
| 14. TEXT Functions in Excel/5.1 LEFT and MID Function Download.xlsx.xlsx | 9.6 KB |
| 14. TEXT Functions in Excel/6. HYPERLINK - Create a Table of Contents for Your Worksheets.mp4 | 18.6 MB |
| 14. TEXT Functions in Excel/6. HYPERLINK - Create a Table of Contents for Your Worksheets.vtt | 8.7 KB |
| 15. MATH Functions/1. RAND and RANDBETWEEN - Random Numbers.mp4 | 3.9 MB |
| 15. MATH Functions/1. RAND and RANDBETWEEN - Random Numbers.vtt | 2 KB |
| 15. MATH Functions/2. ROUND.mp4 | 6.9 MB |
| 15. MATH Functions/2. ROUND.vtt | 4.1 KB |
| 15. MATH Functions/3. INT - Integer.mp4 | 5.6 MB |
| 15. MATH Functions/3. INT - Integer.vtt | 3 KB |
| 15. MATH Functions/3.1 INT Function Download.xlsx.xlsx | 8.1 KB |
| 15. MATH Functions/4. MOD - Remainder.mp4 | 4.4 MB |
| 15. MATH Functions/4. MOD - Remainder.vtt | 2.2 KB |
| 15. MATH Functions/4.1 MOD Function Download.xlsx.xlsx | 8.5 KB |
| 16. DATE and TIME Functions/1. DATE and DATEVALUE.mp4 | 14.8 MB |
| 16. DATE and TIME Functions/1. DATE and DATEVALUE.vtt | 7.7 KB |
| 16. DATE and TIME Functions/1.1 DATE and DATEVALUE Download.xlsx.xlsx | 10.7 KB |
| 16. DATE and TIME Functions/2. TIME.mp4 | 7.4 MB |
| 16. DATE and TIME Functions/2. TIME.vtt | 3.3 KB |
| 16. DATE and TIME Functions/2.1 TIME Download.xlsx.xlsx | 10.6 KB |
| 16. DATE and TIME Functions/3. TODAY and NOW.mp4 | 4.8 MB |
| 16. DATE and TIME Functions/3. TODAY and NOW.vtt | 2.8 KB |
| 16. DATE and TIME Functions/4. YEAR, MONTH, DAY, HOUR, MINUTE and SECOND.mp4 | 7.2 MB |
| 16. DATE and TIME Functions/4. YEAR, MONTH, DAY, HOUR, MINUTE and SECOND.vtt | 3.6 KB |
| 16. DATE and TIME Functions/5. WEEKDAY and WEEKNUM.mp4 | 6 MB |
| 16. DATE and TIME Functions/5. WEEKDAY and WEEKNUM.vtt | 3 KB |
| 16. DATE and TIME Functions/5.1 WEEKDAY WEEKNUM Download.xlsx.xlsx | 8.6 KB |
| 17. LOGIC Functions/1. IFERROR.mp4 | 7.6 MB |
| 17. LOGIC Functions/1. IFERROR.vtt | 5 KB |
| 17. LOGIC Functions/2. LARGE and SMALL.mp4 | 12.6 MB |
| 17. LOGIC Functions/2. LARGE and SMALL.vtt | 5.8 KB |
| 18. Nested Functions/1. INDEX and MATCH.mp4 | 24 MB |
| 18. Nested Functions/1. INDEX and MATCH.vtt | 11.4 KB |
| 18. Nested Functions/1.1 INDEX MATCH Download.xlsx.xlsx | 10.3 KB |
| 18. Nested Functions/2. Nested INDEX, MATCH, IF and IFERROR.mp4 | 9.1 MB |
| 18. Nested Functions/2. Nested INDEX, MATCH, IF and IFERROR.vtt | 3.3 KB |
| 18. Nested Functions/2.1 Nested INDEX, MATCH, IF and IFERROR Download.xlsx.xlsx | 11.4 KB |
| 18. Nested Functions/3. Nested IF, AND and OR Functions.mp4 | 14.1 MB |
| 18. Nested Functions/3. Nested IF, AND and OR Functions.vtt | 6.9 KB |
| 18. Nested Functions/3.1 Nested IF AND and OR Download.xlsx.xlsx | 8.8 KB |
| 19. Introduction to Macros/1. Record Your First Macro.mp4 | 28.6 MB |
| 19. Introduction to Macros/1. Record Your First Macro.vtt | 13.1 KB |
| 19. Introduction to Macros/2. Saving Your Macro and Security.mp4 | 12.4 MB |
| 19. Introduction to Macros/2. Saving Your Macro and Security.vtt | 5.6 KB |
| 19. Introduction to Macros/3. Use a Macro to Create a Kitchen Remodel Costs Template.mp4 | 13 MB |
| 19. Introduction to Macros/3. Use a Macro to Create a Kitchen Remodel Costs Template.vtt | 4.5 KB |
| 19. Introduction to Macros/4. How to Use Relative Cell References.mp4 | 47.2 MB |
| 19. Introduction to Macros/4. How to Use Relative Cell References.vtt | 14.4 KB |
| 19. Introduction to Macros/5. An Easy Cell-Formatting Macro.mp4 | 15.4 MB |
| 19. Introduction to Macros/5. An Easy Cell-Formatting Macro.vtt | 5 KB |
| 2. Creating Your First Excel Document/1. Saving Your Document Where You Can Find It.mp4 | 7.1 MB |