Excel Formulas Cheat Sheet
Master Excel with our comprehensive formulas reference guide. From basic math to advanced lookup functions, find syntax, examples, and expert tips for all essential Excel formulas.
Excel Mastery Guide
Beginner
Start with basic calculations and data organization
Intermediate
Master lookup functions and data analysis
Excel Pro Tips
F4 Key: Toggle between absolute and relative references ($A$1, A$1, $A1, A1)
Ctrl + Shift + Enter: Enter array formulas (older Excel versions)
F9 Key: Calculate formulas manually when set to manual calculation mode
Ctrl + `: Toggle between formula view and result view
PMT()
Financial FunctionsCalculates payment for loan or investment
Syntax:
=PMT(rate, nper, pv, [fv], [type])Examples:
=PMT(5%/12, 60, 20000) Monthly payment for $20,000 loan at 5% for 5 years
=PMT(0.08/12, 30*12, 300000) Monthly mortgage payment
=PMT(A1/12, B1*12, C1) Using cell references for loan calculation
Note: Result is negative (payment going out)
PV()
Financial FunctionsCalculates present value of investment
Syntax:
=PV(rate, nper, pmt, [fv], [type])Examples:
=PV(5%/12, 60, -500) Present value of $500/month for 5 years at 5%
=PV(0.08, 10, -1000, 0, 0) PV of $1000 payments for 10 years at 8%
=PV(A1/12, B1*12, -C1) Using cell references
Note: Payments are negative, receipts are positive
FV()
Financial FunctionsCalculates future value of investment
Syntax:
=FV(rate, nper, pmt, [pv], [type])Examples:
=FV(5%/12, 60, -500) Future value of $500/month for 5 years at 5%
=FV(0.08, 10, -1000, 0, 0) FV of $1000 payments for 10 years at 8%
=FV(A1/12, B1*12, -C1, -D1) FV with present value included
Note: Use for calculating investment growth
Master Excel formulas with practice and repetition. Bookmark this page for quick reference!