Excel Formulas for Beginners
Master essential Excel formulas including SUM, AVERAGE, IF, and VLOOKUP to boost your productivity.
Before you begin
- Basic Excel navigation
The walkthrough
Step by step.
Step 1 of 5
Understanding Formula Basics
All Excel formulas start with an equals sign (=). After the =, you type the formula name followed by parentheses. Inside the parentheses, you specify the cells or values to calculate.
=SUM(A1:A10)
=AVERAGE(B1:B20)
=MAX(C1:C50)- Press F4 to toggle between absolute and relative references
- Use cell references instead of hardcoding values
Step 2 of 5
SUM and AVERAGE Functions
SUM adds numbers together. AVERAGE calculates the mean. Click a cell, type =SUM( then select your range, and close with ). Press Enter to execute.
=SUM(A1:A10) // Adds all values from A1 to A10
=AVERAGE(A1:A10) // Calculates average of A1 to A10
=SUM(A1, C1, E1) // Adds specific cells- Select your range before typing the formula for faster input
- Use AutoSum button (Σ) in the toolbar for quick SUM formulas
Step 3 of 5
The IF Function
IF allows conditional logic. Syntax: =IF(condition, value_if_true, value_if_false). This is incredibly powerful for decision-making in spreadsheets.
=IF(A1>100, "High", "Low")
=IF(B1="Yes", 1, 0)
=IF(C1>=90, "A", IF(C1>=80, "B", "C"))- Nest IF statements for multiple conditions
- Use AND/OR for complex logic
Step 4 of 5
VLOOKUP for Data Lookup
VLOOKUP searches for a value in the first column of a table and returns a value in the same row from another column. Syntax: =VLOOKUP(lookup_value, table_array, column_index, [range_lookup])
=VLOOKUP(A2, D1:F100, 3, FALSE)
// Looks for A2 in column D, returns value from column F- Use FALSE for exact matches
- Ensure your lookup column is the leftmost column
Step 5 of 5
COUNTIF and SUMIF
COUNTIF counts cells that meet a criteria. SUMIF sums cells that meet a criteria. Perfect for analyzing datasets.
=COUNTIF(A1:A100, ">50") // Counts values greater than 50
=SUMIF(B1:B100, "Completed", C1:C100) // Sums C values where B is "Completed"- Use wildcards (* and ?) in criteria for text matching
- Combine with other functions for powerful analysis
Guide complete
