Filename Size 1. Introduction/1. Introduction.mp4 72 MB 1. Introduction/1. Introduction.srt 7.5 KB 1. Introduction/2. Introduction of the instructor.mp4 20.5 MB 1. Introduction/2. Introduction of the instructor.srt 2.7 KB 1. Introduction/3. Course requirements.mp4 23.6 MB 1. Introduction/3. Course requirements.srt 3 KB 1. Introduction/4. How to get Excel.mp4 50.8 MB 1. Introduction/4. How to get Excel.srt 7.1 KB 1. Introduction/5. Source Files.html 26 B 1. Introduction/5.1 01 Source Files.zip 13.1 KB 2. Introduction to Excel/1. Introduction To Excel.mp4 136.7 MB 2. Introduction to Excel/1. Introduction To Excel.srt 22.4 KB 2. Introduction to Excel/2. Introduction To Graphs.mp4 55.2 MB 2. Introduction to Excel/2. Introduction To Graphs.srt 6.5 KB 2. Introduction to Excel/3. Adding In Multiple Sheets.mp4 54.5 MB 2. Introduction to Excel/3. Adding In Multiple Sheets.srt 6.7 KB 2. Introduction to Excel/4. Making A Simple But Effective Income Statement.mp4 88.8 MB 2. Introduction to Excel/4. Making A Simple But Effective Income Statement.srt 12 KB 2. Introduction to Excel/5. Making A Productivity Chart In Excel.mp4 73.7 MB 2. Introduction to Excel/5. Making A Productivity Chart In Excel.srt 12.2 KB 2. Introduction to Excel/6. Making A Budget.mp4 53.7 MB 2. Introduction to Excel/6. Making A Budget.srt 8 KB 3. Excel Logic and Lookup Functions Projects/1. What will we learn in this section.mp4 16.8 MB 3. Excel Logic and Lookup Functions Projects/1. What will we learn in this section.srt 1 KB 3. Excel Logic and Lookup Functions Projects/2. Create An If() Function.mp4 37.7 MB 3. Excel Logic and Lookup Functions Projects/2. Create An If() Function.srt 2.5 KB 3. Excel Logic and Lookup Functions Projects/3. Nest And() Andor Or() Functions Within Reference Functions.mp4 70.6 MB 3. Excel Logic and Lookup Functions Projects/3. Nest And() Andor Or() Functions Within Reference Functions.srt 4.7 KB 3. Excel Logic and Lookup Functions Projects/4. Work With Choose(), Vlookup(), Index(), And Match() Functions.mp4 69.1 MB 3. Excel Logic and Lookup Functions Projects/4. Work With Choose(), Vlookup(), Index(), And Match() Functions.srt 4.3 KB 3. Excel Logic and Lookup Functions Projects/5. Create A Vlookup() Function.mp4 38.9 MB 3. Excel Logic and Lookup Functions Projects/5. Create A Vlookup() Function.srt 2.9 KB 3. Excel Logic and Lookup Functions Projects/6. Section Summary.mp4 81.8 MB 3. Excel Logic and Lookup Functions Projects/6. Section Summary.srt 6.5 KB 3. Excel Logic and Lookup Functions Projects/7. Source Files.html 26 B 3. Excel Logic and Lookup Functions Projects/7.1 02 Source Files.zip 46.6 KB 4. Excel Math and Finance Functions Projects/1. What will we learn in this section.mp4 22.9 MB 4. Excel Math and Finance Functions Projects/1. What will we learn in this section.srt 1.6 KB 4. Excel Math and Finance Functions Projects/2. Aggregate Data Using Both The Sum And Subtotal Functions.mp4 63.9 MB 4. Excel Math and Finance Functions Projects/2. Aggregate Data Using Both The Sum And Subtotal Functions.srt 4 KB 4. Excel Math and Finance Functions Projects/3. Calculate minimums, maximums and averages from data sets.mp4 33.4 MB 4. Excel Math and Finance Functions Projects/3. Calculate minimums, maximums and averages from data sets.srt 3.1 KB 4. Excel Math and Finance Functions Projects/4. Use the Forecast function to forecast numbers along a trend.mp4 58.3 MB 4. Excel Math and Finance Functions Projects/4. Use the Forecast function to forecast numbers along a trend.srt 5.3 KB 4. Excel Math and Finance Functions Projects/5. Generate a net present value using a formula.mp4 48.1 MB 4. Excel Math and Finance Functions Projects/5. Generate a net present value using a formula.srt 4.1 KB 4. Excel Math and Finance Functions Projects/6. Section Summary.mp4 63.7 MB 4. Excel Math and Finance Functions Projects/6. Section Summary.srt 5.5 KB 4. Excel Math and Finance Functions Projects/7. Source Files.html 26 B 4. Excel Math and Finance Functions Projects/7.1 03 Source Files.zip 51.3 KB 5. Excel Date and Time Functions Projects/1. What will we learn in this section.mp4 13 MB 5. Excel Date and Time Functions Projects/1. What will we learn in this section.srt 969 B 5. Excel Date and Time Functions Projects/2. Work with Excel’s date manipulation functions.mp4 84 MB 5. Excel Date and Time Functions Projects/2. Work with Excel’s date manipulation functions.srt 7.3 KB 5. Excel Date and Time Functions Projects/3. Build a holiday date calculator.mp4 41.7 MB 5. Excel Date and Time Functions Projects/3. Build a holiday date calculator.srt 3.9 KB 5. Excel Date and Time Functions Projects/4. Section Summary.mp4 40.8 MB 5. Excel Date and Time Functions Projects/4. Section Summary.srt 3.2 KB 5. Excel Date and Time Functions Projects/5. Source Files.html 26 B 5. Excel Date and Time Functions Projects/5.1 04 Source Files.zip 24.7 KB 6. Excel Text and Information Functions Projects/1. What will we learn in this section.mp4 33 MB 6. Excel Text and Information Functions Projects/1. What will we learn in this section.srt 3.1 KB 6. Excel Text and Information Functions Projects/2. Split textual data apart.mp4 33.8 MB 6. Excel Text and Information Functions Projects/2. Split textual data apart.srt 3.3 KB 6. Excel Text and Information Functions Projects/3. Manipulate textual data.mp4 44.8 MB 6. Excel Text and Information Functions Projects/3. Manipulate textual data.srt 4.6 KB 6. Excel Text and Information Functions Projects/4. Replace portions of textual data.mp4 42 MB 6. Excel Text and Information Functions Projects/4. Replace portions of textual data.srt 3.8 KB 6. Excel Text and Information Functions Projects/5. Put textual data back together with formulae.mp4 51.7 MB 6. Excel Text and Information Functions Projects/5. Put textual data back together with formulae.srt 4.8 KB 6. Excel Text and Information Functions Projects/6. Work with key informational functions for evaluating and responding correctly to.mp4 102.2 MB 6. Excel Text and Information Functions Projects/6. Work with key informational functions for evaluating and responding correctly to.srt 9.2 KB 6. Excel Text and Information Functions Projects/7. Use the Hyperlink function to build navigational menus inside an Excel Worksheet.mp4 37.8 MB 6. Excel Text and Information Functions Projects/7. Use the Hyperlink function to build navigational menus inside an Excel Worksheet.srt 3.3 KB 6. Excel Text and Information Functions Projects/8. Section Summary.mp4 53 MB 6. Excel Text and Information Functions Projects/8. Section Summary.srt 5 KB 6. Excel Text and Information Functions Projects/9. Source Files.html 26 B 6. Excel Text and Information Functions Projects/9.1 05 Source Files.zip 73.1 KB 7. Excel Lists/1. What will we learn in this section.mp4 44.9 MB 7. Excel Lists/1. What will we learn in this section.srt 2.9 KB 7. Excel Lists/2. How to filter items in a list.mp4 79.7 MB 7. Excel Lists/2. How to filter items in a list.srt 6.1 KB 7. Excel Lists/3. Sorting List without messing up the data.mp4 103 MB 7. Excel Lists/3. Sorting List without messing up the data.srt 8.1 KB 7. Excel Lists/4. How to freeze rows or columns.mp4 110.2 MB 7. Excel Lists/4. How to freeze rows or columns.srt 7 KB 7. Excel Lists/5. Remove duplicates from a list.mp4 66 MB 7. Excel Lists/5. Remove duplicates from a list.srt 4.8 KB 7. Excel Lists/6. Section Summary.mp4 65.1 MB 7. Excel Lists/6. Section Summary.srt 4.3 KB 7. Excel Lists/7. Source Files.html 26 B 7. Excel Lists/7.1 06 Source Files.zip 47.6 KB 8. Other Excel useful functions/1. What will we learn in this section.mp4 23.2 MB 8. Other Excel useful functions/2. COUNT, COUNTA and COUNTIF Functions.mp4 135.3 MB 8. Other Excel useful functions/3. Create a drop down list.mp4 79.4 MB 8. Other Excel useful functions/4. Work with ISNUMBER and SEARCH functions within text functions.mp4 86.2 MB 8. Other Excel useful functions/5. Format row based on a cell value.mp4 108 MB 8. Other Excel useful functions/6. Create an invoice template in Excel.mp4 155.2 MB 8. Other Excel useful functions/7. Section Summary.mp4 43.6 MB