Udemy - Complete Excel Functions – From Beginner to Mastery

Files:

• 1. Introduction.mp4 (72.0 MB)
• 4. How to get Excel.mp4 (50.8 MB)
• 3. Course requirements.mp4 (23.6 MB)
• 2. Introduction of the instructor.mp4 (20.5 MB)
• 5.1 01 Source Files.zip (13.1 KB)
• 1. Introduction.srt (7.5 KB)
• 4. How to get Excel.srt (7.1 KB)
• 3. Course requirements.srt (3.0 KB)
• 2. Introduction of the instructor.srt (2.7 KB)
• 5. Source Files.html (0.0 KB)

• 1. Introduction To Excel.mp4 (136.7 MB)
• 4. Making A Simple But Effective Income Statement.mp4 (88.8 MB)
• 5. Making A Productivity Chart In Excel.mp4 (73.7 MB)
• 2. Introduction To Graphs.mp4 (55.2 MB)
• 3. Adding In Multiple Sheets.mp4 (54.5 MB)
• 6. Making A Budget.mp4 (53.7 MB)
• 1. Introduction To Excel.srt (22.4 KB)
• 5. Making A Productivity Chart In Excel.srt (12.2 KB)
• 4. Making A Simple But Effective Income Statement.srt (12.0 KB)
• 6. Making A Budget.srt (8.0 KB)
• 3. Adding In Multiple Sheets.srt (6.7 KB)
• 2. Introduction To Graphs.srt (6.5 KB)

• 6. Section Summary.mp4 (81.8 MB)
• 3. Nest And() Andor Or() Functions Within Reference Functions.mp4 (70.6 MB)
• 4. Work With Choose(), Vlookup(), Index(), And Match() Functions.mp4 (69.1 MB)
• 5. Create A Vlookup() Function.mp4 (38.9 MB)
• 2. Create An If() Function.mp4 (37.7 MB)
• 1. What will we learn in this section.mp4 (16.8 MB)
• 7.1 02 Source Files.zip (46.6 KB)
• 6. Section Summary.srt (6.5 KB)
• 3. Nest And() Andor Or() Functions Within Reference Functions.srt (4.7 KB)
• 4. Work With Choose(), Vlookup(), Index(), And Match() Functions.srt (4.3 KB)
• 5. Create A Vlookup() Function.srt (2.9 KB)
• 2. Create An If() Function.srt (2.5 KB)
• 1. What will we learn in this section.srt (1.0 KB)
• 7. Source Files.html (0.0 KB)

• 2. Aggregate Data Using Both The Sum And Subtotal Functions.mp4 (63.9 MB)
• 6. Section Summary.mp4 (63.7 MB)
• 4. Use the Forecast function to forecast numbers along a trend.mp4 (58.3 MB)
• 5. Generate a net present value using a formula.mp4 (48.1 MB)
• 3. Calculate minimums, maximums and averages from data sets.mp4 (33.4 MB)
• 1. What will we learn in this section.mp4 (22.9 MB)
• 7.1 03 Source Files.zip (51.3 KB)
• 6. Section Summary.srt (5.5 KB)
• 4. Use the Forecast function to forecast numbers along a trend.srt (5.3 KB)
• 5. Generate a net present value using a formula.srt (4.1 KB)
• 2. Aggregate Data Using Both The Sum And Subtotal Functions.srt (4.0 KB)
• 3. Calculate minimums, maximums and averages from data sets.srt (3.1 KB)
• 1. What will we learn in this section.srt (1.6 KB)
• 7. Source Files.html (0.0 KB)

• 2. Work with Excel’s date manipulation functions.mp4 (84.0 MB)
• 3. Build a holiday date calculator.mp4 (41.7 MB)
• 4. Section Summary.mp4 (40.8 MB)
• 1. What will we learn in this section.mp4 (13.0 MB)
• 5.1 04 Source Files.zip (24.7 KB)
• 2. Work with Excel’s date manipulation functions.srt (7.3 KB)
• 3. Build a holiday date calculator.srt (3.9 KB)
• 4. Section Summary.srt (3.2 KB)
• 1. What will we learn in this section.srt (0.9 KB)
• 5. Source Files.html (0.0 KB)

• 6. Work with key informational functions for evaluating and responding correctly to.mp4 (102.2 MB)
• 8. Section Summary.mp4 (53.0 MB)
• 5. Put textual data back together with formulae.mp4 (51.7 MB)
• 3. Manipulate textual data.mp4 (44.8 MB)
• 4. Replace portions of textual data.mp4 (42.0 MB)
• 7. Use the Hyperlink function to build navigational menus inside an Excel Worksheet.mp4 (37.8 MB)
• 2. Split textual data apart.mp4 (33.8 MB)
• 1. What will we learn in this section.mp4 (33.0 MB)
• 9.1 05 Source Files.zip (73.1 KB)
• 6. Work with key informational functions for evaluating and responding correctly to.srt (9.2 KB)
• 8. Section Summary.srt (5.0 KB)
• 5. Put textual data back together with formulae.srt (4.8 KB)
• 3. Manipulate textual data.srt (4.6 KB)
• 4. Replace portions of textual data.srt (3.8 KB)
• 7. Use the Hyperlink function to build navigational menus inside an Excel Worksheet.srt (3.3 KB)
• 2. Split textual data apart.srt (3.3 KB)
• 1. What will we learn in this section.srt (3.1 KB)
• 9. Source Files.html (0.0 KB)

• 4. How to freeze rows or columns.mp4 (110.2 MB)
• 3. Sorting List without messing up the data.mp4 (103.0 MB)
• 2. How to filter items in a list.mp4 (79.7 MB)
• 5. Remove duplicates from a list.mp4 (66.0 MB)
• 6. Section Summary.mp4 (65.1 MB)
• 1. What will we learn in this section.mp4 (44.9 MB)
• 7.1 06 Source Files.zip (47.6 KB)
• 3. Sorting List without messing up the data.srt (8.1 KB)
• 4. How to freeze rows or columns.srt (7.0 KB)
• 2. How to filter items in a list.srt (6.1 KB)
• 5. Remove duplicates from a list.srt (4.8 KB)
• 6. Section Summary.srt (4.3 KB)
• 1. What will we learn in this section.srt (2.9 KB)
• 7. Source Files.html (0.0 KB)

• 6. Create an invoice template in Excel.mp4 (155.2 MB)
• 2. COUNT, COUNTA and COUNTIF Functions.mp4 (135.3 MB)
• 5. Format row based on a cell value.mp4 (108.0 MB)
• 4. Work with ISNUMBER and SEARCH functions within text functions.mp4 (86.2 MB)
• 3. Create a drop down list.mp4 (79.4 MB)
• 7. Section Summary.mp4 (43.6 MB)
• 1. What will we learn in this section.mp4 (23.2 MB)
• 8.1 07 Source Files.zip (60.3 KB)
• 6. Create an invoice template in