PV
calculates the present value of a loan or an investment, based on a constant interest rate, ((rate, nper, pmt, [fv], [type])
FV
calculates the future value of an investment based on a constant interest rate. =FV(rate,nper,pmt,[pv],[type])
PMT
calculates the payment for a loan based on constant payments and a constant interest rate. =PMT(rate, nper, pv, [fv], [type])
IFERROR
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula. =IFERROR(value, value_if_error)
IPMT
Returns the interest payment for a given period. =IPMT(rate, per, nper, pv, [fv], [type])
PPMT
Returns the payment on the principal for a given period. =PPMT(rate, per, nper, pv, [fv], [type])
CUMIPMT
Returns the cumulative interest paid on a loan between start_period and end_period. = CUMIPMT(rate, nper, pv, start_period, end_period, type)
CUMPRINC
Returns the cumulative principal paid on a loan between start_period and end_period. = CUMPRINC(rate, nper, pv, start_period, end_period, type)
RATE
Returns the interest rate per period of an annuity. = RATE(nper, pmt, pv, [fv], [type], [guess])
NPER
Returns the number of periods for an investment. = NPER(rate,pmt,pv,[fv],[type])
CONCATENATE
allows you to combine text from different cells into one cell.
&
another way to concatenate cells
SUBSTITUTE
replaces old text with new text. =SUBSTITUTE (text, old_text, new_text, [instance])
PROPER
Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase. =PROPER(text)
UPPER
converts all text to uppercase. UPPER(text)
LOWER
converts all text to lowercase. =LOWER(text)
MID
returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify. = MID(text, start_num, num_chars)
CLEAN
Removes all nonprintable characters from text. =CLEAN(text)
TRIM
Remove extra spaces from text. =TRIM(text)
LEFT
returns the first character or characters in a text string, based on the number of characters you specify. = LEFT(text, [num_chars])
RIGHT
returns the last character or characters in a text string, based on the number of characters you specify. =RIGHT(text, [num_chars])
Text-To-Columns
opposite of concatenate, this is called parsing, Go to Data > Text to Columns
Goal Seek
in the Set cell box, enter the reference for the cell that contains the formula that you want to resolve. In the To value box, type the formula result that you want. In the By changing cell box, enter the reference for the cell that contains the value tha
3D
references cell on another worksheet
Structured Table
A table with a defined structure, style, and organization. GO to insert table and pick style
Data Table
Created to analyze one or two variables in a spreadsheet module; one of the What If data tools