Excel Lookup Series #10: INDEX function 2nd Example
by
ExcelIsFun
on
Youtube
Duration:
0.07 hours
See how to use the INDEX function to look up a value from multiple tables. See how to use the INDEX function to indicate a row position, a column position, and ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Lookup Series #11: INDEX & MATCH functions Two 2 Way Lookup
by
ExcelIsFun
on
Youtube
Duration:
0.08 hours
See how to use the INDEX & MATCH functions together to lookup something in a table given a row position and column position. Yes, it's true: You can look ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Lookup Series #12: INDEX & MATCH functions Example 2!
by
ExcelIsFun
on
Youtube
Duration:
0.08 hours
See how to use the INDEX & MATCH functions together when VLOOKUP or LOOKUP will not do the job! See how use the INDEX & MATCH functions together to ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Lookup Series #13: INDEX & MATCH functions Example 3!
by
ExcelIsFun
on
Youtube
Duration:
0.18 hours
See how to use the INDEX & 3 MATCH functions in one formula to look up a value from 1 of 3 different tables! Also see how adding Names & a Data Validation ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Lookup Series #14: CHOOSE function
by
ExcelIsFun
on
Youtube
Duration:
0.06 hours
See how to use the CHOOSE function to select an item from a list. This function is useful if you want to type the lookup table into the function itself! In this Series ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Finance Trick #1: FV PV & Time Value Of Money
by
ExcelIsFun
on
Youtube
Duration:
0.08 hours
FV = Future Value. PV = Present Value. Learn about the Time Value of Money. See how the concept of "Time Value of Money" is a fundamental idea in Finance.
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Finance Trick #3: PMT function Lender or Borrower
by
ExcelIsFun
on
Youtube
Duration:
0.15 hours
See how to use the PMT function for the Lender or Borrower. Cash Flows matters in Finance and so using the PMT function is very different for the Lender and ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Finance Trick #4: PMT function & Balloon payment
by
ExcelIsFun
on
Youtube
Duration:
0.06 hours
See how to use the PMT function & a Balloon payment. When you have to make Period payments on a loan contract and a lump sum payment at the end of the ...
See how to use the FV function. See the math formula for calculating Future Value and for calculating the effective interest rate. Also see long hand how ...
See how to use the PMT & FV function together to calculate a delayed PMT payment amount. See how to use the PMT function to calculate a payment amount ...
