Top 25 Microsoft Excel Advanced Formulas Course
Course Introduction
Top 25 Microsoft Excel Advanced Formulas Course
0%
Completed
Introduction
In this section you will learn the course agenda and structure
What Will I Learn?
Video - 00:2:07 mins
Course Introduction
Video - 00:2:17 mins
Logical Functions
In this section you will learn Microsoft Excel logical functions
IFERROR and XOR Functions
Video - 00:12:23 mins
AND and IF Functions
Video - 00:9:41 mins
Financial Functions
In this section you will learn advanced financial functions
PV and FV Functions
Video - 00:14:59 mins
Your feedback
Video - 00:2:00 mins
PMT-PPMT-PRICE-YIELD Functions
Video - 00:11:40 mins
PRICE-COUPONDAYS-ACCRINT-ACCRINTM Functions
Video - 00:10:28 mins
Depreciation Lecture
Video - 00:7:43 mins
SLN-SYD-DB-DDB-VDB Functions
Video - 00:13:46 mins
Text Functions
In this section you will lean advanced TEXT functions
TEXT and CONCATENATE Functions
Video - 00:11:09 mins
PROPER-UPPER-LOWER-SUBSTITUTE Functions
Video - 00:10:13 mins
Lookup & Reference Function
In this section you will learn Microsoft Excel advanced LOOKUP and REFERENCE functions
LOOKUP Function Lecture
Video - 00:4:58 mins
Working with Advanced VLOOKUP
Video - 00:12:17 mins
HLOOKUP-INDEX-MATCH Functions
Video - 00:17:45 mins
Bonus and Resources
In this section you will find bonus and other resources
Modifying Existing Templates
Video - 00:11:06 mins
Copying Macros Between Workbooks
Video - 00:4:24 mins
Working with External Data Sources
Video - 00:10:15 mins
Exploring Tracking Changes Feature
Video - 00:11:50 mins
Conclusion
In this section you will go through the course recap
Conclusion
Video - 00:2:33 mins
More
Announcements
Course Info
Finish Course Early?
You have not completed all required lessons and assessments.
Your Progress
0%
Go Back to Course
Complete Anyway