Beginner’s Guide to Excel Formulas

By Study Rhino

Welcome to Study Rhino, where learning meets clarity and confidence. Whether you’re managing budgets, analyzing student grades, or organizing data for a project, Microsoft Excel is an essential tool. But the real power of Excel lies in its formulas — the magic that transforms numbers into insights.

This guide is designed especially for beginners. By the time you’re done reading, you’ll be able to understand, write, and apply basic Excel formulas to simplify your daily tasks. Let’s get started!

🧾 What Is a Formula in Excel?

A formula in Excel is an instruction you give to the software to perform calculations. These calculations can be as simple as adding two numbers or as complex as analyzing data across multiple sheets.

Important: Every formula in Excel begins with an equals sign (=). This tells Excel that what follows should be calculated, not just displayed.

For example:

CopyEdit

=5 + 3

Excel will calculate this and show 8 in the cell.

✨ Why Use Formulas?

Using formulas helps you:

• Save time on manual calculations
• Minimize errors
• Analyze and compare data easily
• Automate repetitive tasks
• Create interactive spreadsheets

In short, formulas make Excel smart, and you the master of your data.

🔍 Understanding the Structure of a Formula

Let’s break down what a formula can include:

• = (Equal Sign): Always the first character
• Operands: These are numbers or cell references (like A1, B3, etc.)
• Operators: Symbols such as + (add), – (subtract), * (multiply), / (divide), ^ (power)
• Functions: Pre-built formulas like SUM(), AVERAGE(), and IF()

Example formula:

makefile

CopyEdit

=SUM(A1:A5) + B1

This formula adds all values from A1 to A5, then adds the value in B1.

📚 Common Excel Functions for Beginners

Here are some essential formulas that will boost your Excel skills from day one:

1. SUM(): Add Values

Example:
=SUM(A1:A5)

Adds up all the numbers from A1 to A5.

2. AVERAGE(): Calculate the Mean

Example:
=AVERAGE(B1:B4)

Returns the average (mean) of the selected numbers.

3. MIN() and MAX(): Smallest and Largest

Examples:
=MIN(C1:C10) – Finds the smallest number
=MAX(C1:C10) – Finds the largest number

4. COUNT(): Count Numbers

Example:
=COUNT(D1:D10)

Counts how many numeric entries are in the given range.
Use =COUNTA() to count both numbers and text.

5. IF(): Make a Decision

Example:
=IF(E1>=60, “Passed”, “Failed”)

Checks whether the value in E1 is 60 or more. If true, returns “Passed”, otherwise “Failed”.

6. TODAY() and NOW(): Insert Date and Time

• =TODAY() — Returns today’s date
• =NOW() — Returns the current date and time

Great for time-stamping your reports.

7. CONCAT() / TEXTJOIN(): Combine Text

Example:
=CONCAT(A1, ” “, B1) – Joins text from two cells with a space in between.
TEXTJOIN allows you to use a delimiter more easily:
=TEXTJOIN(“, “, TRUE, A1:A3)

8. TRIM(): Remove Extra Spaces

Example:
=TRIM(A1)

Cleans up any extra spaces before or after the text.

9. ROUND(): Round Numbers

Example:
=ROUND(A1, 2)

Rounds the value in A1 to 2 decimal places.
Also check: ROUNDUP(), ROUNDDOWN()

10. VLOOKUP(): Find Data by Searching

Example:
=VLOOKUP(“Alice”, A2:C10, 2, FALSE)

Searches the name “Alice” in the first column of your table (A2 to A10), and returns the value from the second column in the same row.

📌 Understanding Cell References

When writing formulas, you’ll refer to other cells. Excel uses relative, absolute, and mixed references:

• Relative Reference (=A1) — Changes automatically when copied to another cell.
• Absolute Reference (=$A$1) — Stays fixed no matter where it’s copied.
• Mixed Reference (=A$1 or =$A1) — Only part of the reference remains fixed.

Tip: Press F4 while selecting a cell in a formula to toggle between these types.

🧠 Useful Text Functions

Excel isn’t just for numbers! Here are a few handy formulas for working with text:

1. LEFT(text, num_chars)

Gets characters from the beginning of a string.
Example: =LEFT(“StudyRhino”, 5) returns “Study”

2. RIGHT(text, num_chars)

Gets characters from the end.
Example: =RIGHT(“StudyRhino”, 5) returns “Rhino”

3. LEN(text)

Counts the number of characters in a cell.
Example: =LEN(“Excel”) returns 5

4. SEARCH(find_text, within_text)

Finds the position of a character or word in a cell.
Example: =SEARCH(“y”, “Rhino”) returns #VALUE! (because there’s no “y” in “Rhino”)

🔧 Troubleshooting Common Errors

You may encounter a few errors while working with formulas. Here’s what they usually mean:

Quick Fix: Use the IFERROR() function to handle errors neatly.
Example: =IFERROR(A1/B1, “Invalid”)

📝 Practice Scenario

Let’s say you’re managing student marks in Excel:

Goal: Show “Passed” if marks ≥ 50, else “Failed”

Formula in C2:

arduino

CopyEdit

=IF(B2>=50, “Passed”, “Failed”)

Now drag it down to C4 — and just like that, you’ve automated your grading!

📖 Tips to Use Formulas Efficiently

• ✅ Double-click the fill handle to auto-fill formulas down a column.
• ✅ Use parentheses to control the order of operations.
• ✅ Keep formulas short and clear — break complex ones into steps if needed.
• ✅ Check formula bar to troubleshoot unexpected results.
• ✅ Label your data properly for easier referencing.

🚀 What’s Next?

Now that you’ve mastered the basics, you can explore:

• Conditional Formatting using formulas
• Advanced lookup functions like INDEX and MATCH
• Using named ranges for cleaner formulas
• PivotTables and dashboard creation

Excel has countless features, but understanding formulas is like having the keys to a high-speed engine. With practice, your spreadsheets will become smarter, more efficient, and more impressive.

🦏 Final Words from Study Rhino

At Study Rhino, we believe in making learning clear, practical, and powerful. Excel may seem overwhelming at first, but remember — every expert once started as a beginner.

So open Excel, test these formulas, and watch your confidence grow. You’ve got this!

Would you like a downloadable practice sheet to go along with this guide? Or a follow-up article on intermediate Excel techniques? Just say the word