How to Use Basic Formulas in Excel: A Friendly Guide
By Jason Bingham · August 31, 2026
Jason has spent 16 years helping everyday people get comfortable with technology.
Getting Comfortable with Basic Formulas in Excel
Feeling a bit overwhelmed by Excel? You're not alone! Many people face confusion when they first encounter spreadsheets and formulas, wondering what all the symbols and numbers mean. But don't worry! Today, we're going to break this down together in simple terms. You’ll soon find that using basic formulas in Excel is not as daunting as it seems. Imagine being able to organize your expenses, track your diet, or even plan a garden—all with just a few simple formulas!
Understanding Basic Formulas
A formula in Excel is simply a way to perform calculations on your data. For instance, you can add numbers, find averages, or even calculate percentages. The good news is that once you learn a few basics, you'll be able to tackle a lot of everyday tasks. Let’s dive into how to use basic formulas step by step.
Step-by-Step Guide to Using Basic Formulas
Here’s how to start working with basic formulas in Excel:
- Open Excel: If you haven’t already, find and open Microsoft Excel on your computer. You might see a blank spreadsheet waiting for you.
- Enter Your Data: Click on a cell (you’ll see boxes labeled with letters and numbers) and start typing your data. For example, if you want to track your monthly expenses, type the amounts in one column.
- Select a Cell for Your Formula: Click on another empty cell where you want the result of your calculation to appear. For instance, if you want to add up your expenses, choose a cell below your amounts.
- Start Your Formula: Type an equal sign (=) in the chosen cell. This tells Excel you’re about to enter a formula.
- Enter Basic Commands: If you want to add numbers, type SUM followed by an open parenthesis. For example, type SUM( .
- Select Your Data Range: Now, click and drag over the cells with the numbers you want to add. Excel will show the range (like A1:A5) in your formula. After you've selected your data, type a closing parenthesis ).
- Press Enter: Once you've entered the formula, hit the Enter key on your keyboard. The sum of your numbers will appear in the cell you selected.
Congratulations! You’ve just created your first formula. But that’s just the beginning; there are other useful formulas to know!
Common Tips for Using Formulas
Here are a few extra tips to help you on your journey:
- Always start formulas with the equal sign (=). Without it, Excel won’t know you’re doing a calculation.
- Use parentheses to group calculations. For example, to calculate an average and then multiply it, you might write =(SUM(A1:A5)/COUNT(A1:A5)*2).
- Practice makes perfect. Don’t hesitate to experiment with different formulas and see the results.
Common Mistakes to Avoid
Even the best of us make mistakes, but here are a few to watch out for:
- Forget to include the equal sign at the start of your formula. This will prevent Excel from interpreting it as a formula.
- Mixing up cell references (like A1 and B1). Double-check to make sure you're selecting the correct cells.
- Not updating your formulas when you change your data. Always make sure your ranges match your current data.
Encouraging Your Progress
Remember, learning Excel is a journey, and you’re already taking great steps forward! With practice, you’ll find that these formulas become second nature. Don’t be afraid to try out new formulas and see how they can enhance your work or personal projects. Celebrate each small success along the way—you’re doing fantastic! If you have any questions or need guidance, reach out to a friend, or don’t hesitate to search for more resources online. Happy Excel-ing!