Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Master Excel Functions: Unlock the Power of Formulas for Enhanced Data Analysis
Introduction to the Course
1. Introduction to the Course (8:47)
2. Introduction of the instructor (3:30)
3. Course requirements (4:04)
4. How to get Excel (9:33)
Source Files
Excel Logic and Lookup Functions Projects
1. What will we learn in this section (1:33)
2. Create An If() Function (3:24)
3. Nest And() Andor Or() Functions Within Reference Functions (6:37)
4. Work With Choose(), Vlookup(), Index(), And Match() Functions (6:19)
5. Create A Vlookup() Function (3:32)
6. Section Summary (9:37)
Source Files
Excel Math and Finance Functions Projects
1. What will we learn in this section (2:23)
2. Aggregate Data Using Both The Sum And Subtotal Functions (5:15)
3. Calculate minimums, maximums and averages from data sets (3:39)
4. Use the Forecast function to forecast numbers along a trend (6:57)
5. Generate a net present value using a formula (6:13)
6. Section Summary (7:38)
Source Files
Excel Date and Time Functions Projects
1. What will we learn in this section (1:14)
2. Work with Excel’s date manipulation functions (10:10)
3. Build a holiday date calculator (6:09)
4. Section Summary (4:43)
Source Files
Excel Text and Information Functions Projects
1. What will we learn in this section (3:46)
2. Split textual data apart (4:00)
3. Manipulate textual data (5:47)
4. Replace portions of textual data (4:42)
5. Put textual data back together with formulae (6:18)
6. Work with key informational functions for evaluating and responding correctly to errors in routine Excel calculations (12:00)
7. Use the Hyperlink function to build navigational menus inside an Excel Worksheet (4:35)
8. Section Summary (6:26)
Source Files
Excel Lists
1. What will we learn in this section (4:08)
2. How to filter items in a list (8:24)
3. Sorting List without messing up the data (10:09)
4. How to freeze rows or columns (9:53)
5. Remove duplicates from a list (6:52)
6. Section Summary (6:32)
Source Files
Other Excel useful functions
1. What will we learn in this section (2:09)
2. COUNT, COUNTA and COUNTIF Functions (11:57)
3. Create a drop down list (11:38)
4. Work with ISNUMBER and SEARCH functions within text functions (11:19)
5. Format row based on a cell value (10:54)
6. Create an invoice template in Excel (24:17)
7. Section Summary (4:46)
Source Files
Conclusion
1. Course Summary and Next Steps (23:32)
7. Use the Hyperlink function to build navigational menus inside an Excel Worksheet
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock