Course Content
Introduction
In this section you will learn the course agenda and structure
0/2
What Will I Learn?
02:07
Course Introduction
02:17
Logical Functions
In this section you will learn Microsoft Excel logical functions
0/2
IFERROR and XOR Functions
12:23
AND and IF Functions
09:41
Financial Functions
In this section you will learn advanced financial functions
0/6
PV and FV Functions
14:59
Your feedback
02:00
PMT-PPMT-PRICE-YIELD Functions
11:40
PRICE-COUPONDAYS-ACCRINT-ACCRINTM Functions
10:28
Depreciation Lecture
07:43
SLN-SYD-DB-DDB-VDB Functions
13:46
Text Functions
In this section you will lean advanced TEXT functions
0/2
TEXT and CONCATENATE Functions
11:09
PROPER-UPPER-LOWER-SUBSTITUTE Functions
10:13
Lookup & Reference Function
In this section you will learn Microsoft Excel advanced LOOKUP and REFERENCE functions
0/3
LOOKUP Function Lecture
04:58
Working with Advanced VLOOKUP
12:17
HLOOKUP-INDEX-MATCH Functions
17:45
Bonus and Resources
In this section you will find bonus and other resources
0/4
Modifying Existing Templates
11:06
Copying Macros Between Workbooks
04:24
Working with External Data Sources
10:15
Exploring Tracking Changes Feature
11:50
Conclusion
In this section you will go through the course recap
0/1
Conclusion
02:33
Top 25 Microsoft Excel Advanced Formulas Course
Previous
Next
0% Complete