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)
6. Work with key informational functions for evaluating and responding correctly to errors in routine Excel calculations
Lesson content will be unlocked within 30 minutes.
Teachable is working on this bug.
No further action will be required on your part
.
Thank you for your patience