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
CONCATENATE()
Text FunctionsJoins text strings together
Syntax:
=CONCATENATE(text1, [text2], ...)Examples:
=CONCATENATE(A1, " ", B1) Join cells with space
=CONCATENATE("Hello ", A1) Join text with cell value
=A1&" "&B1 Alternative using & operator
Note: Use & operator as alternative. CONCAT() available in newer versions
CONCAT()
Text FunctionsJoins text from multiple ranges and/or strings
Syntax:
=CONCAT(text1, [text2], ...)Examples:
=CONCAT(A1:A3) Concatenate range A1:A3
=CONCAT("Hello ", A1, " World") Mix text and cell references
=CONCAT(A1:A5, " | ", B1:B5) Concatenate multiple ranges
Note: Replaces CONCATENATE. Available in Excel 2016+. Can handle ranges
UPPER()
Text FunctionsConverts text to uppercase
Syntax:
=UPPER(text)Examples:
=UPPER(A1) Convert cell A1 to uppercase
=UPPER("hello world") Returns 'HELLO WORLD'
=UPPER(B2&" "&C2) Convert concatenated text to uppercase
Note: Only affects alphabetic characters
TRIM()
Text FunctionsRemoves extra spaces from text
Syntax:
=TRIM(text)Examples:
=TRIM(A1) Remove leading/trailing/extra spaces from A1
=TRIM(" hello world ") Returns 'hello world'
=TRIM(A1&" "&B1) Trim concatenated text
Note: Leaves single spaces between words
Master Excel formulas with practice and repetition. Bookmark this page for quick reference!