Excel Formula Exercises 1
I am starting a new series of posts for you to sharpen your skills with Excel formulas. Each post will include 4-5 excel formula exercises...
Category: Formulas
Extract Text From String With Known Position
You may need to get a part of a text string from within another text string. If you know starting position of the text you...
Hiding Excel Formulas
Sometimes you may not want users to see your formulas for a number of reasons. If that is the case, I have good news for...
Nper Function
Nper Function is used for calculating number of periods for an investment based on periodic, constant payments and constant interest rate.
PMT Function
Pmt function is used for calculating payment of a loan based on constant payments and constant interest rate. In other words, it helps you calculate...
