Last seen: 13 days ago
2 way look up in excel can be done with the use of Index and Match Formula . To...
In this video Guru tells how to use the combination of Index and Match formula to...
Learn how to use the combination of Index and Match formula to look up a value with...
Learn to use the combination of Index and Match formula to look up a value with...
In Excel learn how to use the combination of Index and Match formula to look up...
In Excel learn how to use the Index Formula to lookup a value. INDEX formula gives...
Learn Excel How to use the Match formula with the approximate and the exact options...
In this video Guru tells how to use the Match formula with text . Also explained...
"In this video Guru tells how to use the Match formula with the approximate and...
EOMONTH calculates the last date of a month from a start date. It can calculate...
Datevalue formula converts a given date in Numeric value . The DATEVALUE formula...
Edate Calculates the date that would be if a ceratin number of months were to added...
Datedif Formula In Excel calculates the differnce between 2 date in 6 variations....
PMT Formula allows you to calculate the EMI for a loan. The training file shown...
IPMT Formula allows you to calculate the interest paid on each EMI for a loan. The...
Use the SLN formula of Excel to determine the straight line depreciation of an asset...
