Basic Excel Formulas: How to Write Your First Formulas

Basic Excel formulas are instructions that begin with an equals sign (=) and tell Excel to perform a calculation. The most essential ones are SUM, AVERAGE, MIN, MAX, COUNT and IF. They let you add numbers, find averages, count entries and apply conditional logic without manual arithmetic, forming the foundation of all spreadsheet work in data and MIS roles.

  • Key Takeaway 1: Every formula must begin with = or Excel ignores it as a calculation.
  • Key Takeaway 2: You can reference cells by address (e.g., A1, B3) so your results update automatically when data changes.
  • Key Takeaway 3: Functions like SUM, AVERAGE, COUNT, MIN and MAX handle the most common data tasks without any manual arithmetic.
  • Key Takeaway 4: The most common beginner mistake is forgetting the = sign, which makes your formula display as text.
  • Key Takeaway 5: Excel skills are consistently listed among the top requirements in Indian data analyst and MIS job postings on LinkedIn and Naukri.com.

Every Formula Starts with =

When you open a cell in Excel and type =, you are switching from text mode to formula mode. Excel knows to evaluate everything that follows as a mathematical or logical instruction. This is true for every version of Excel, from Excel 2007 right through to Microsoft 365 today.

The = sign is what Microsoft’s own documentation calls the “formula prefix.” It is non-negotiable. If you type SUM(A1:A10) without the equals sign, Excel displays that string of characters as text. Type =SUM(A1:A10) and it adds up every value in that range and shows you the total. Understanding this single rule unlocks every basic Excel formula you will ever write.

Operators You Will Use Inside Formulas

After the =, you can use arithmetic operators to build your own expressions before you even touch a built-in function. The four most common ones are + (addition), – (subtraction), * (multiplication) and / (division). A formula like =B2*C2 multiplies whatever is in cell B2 by whatever is in C2.

You can also use the comparison operators >, <, >=, <= and = (equality check) when you need to test conditions. These become essential once you start writing IF formulas, which is a natural next step after you are comfortable with the basics.

Cell References: The Real Power of a Data Formula in Excel

A cell reference is just the address of a cell, like A1 or D5. When you use a reference instead of a hardcoded number, the formula updates automatically whenever the source data changes. This is what makes a data formula in Excel so much more useful than a calculator.

For example, if your monthly sales figures live in column B and you write =SUM(B2:B13), updating any cell in that column instantly recalculates your annual total. No manual re-entry needed. In a real MIS or analyst role at companies like Infosys, TCS or any Pune-based startup, this saves hours every reporting cycle.

Writing and Entering Basic Excel Formulas

Knowing how to write formulas in Excel comes down to a four-step habit. Follow it every time and you will avoid 90% of beginner errors.

  1. Click the cell where you want the result to appear.
  2. Type = to enter formula mode. The formula bar at the top of your screen will show what you are typing.
  3. Type your function name or expression, for example =SUM(, then click or type the range you want, like A2:A10, and close the bracket: ).
  4. Press Enter. Excel calculates and displays the result. Press Esc instead if you want to cancel without saving.

One practical tip from real-world spreadsheet work: click cells rather than typing their addresses manually. When you type =SUM( and then click cell A2, Excel inserts the reference for you. Then hold Shift and click A10 to capture the whole range. It is faster and eliminates typos in cell addresses.

How to Put a Formula in an Excel Sheet Using AutoSum

If you are learning how to put a formula in an Excel sheet for the first time, AutoSum is your fastest shortcut. Select the cell directly below a column of numbers (or to the right of a row), then press Alt + = on Windows. Excel guesses the range you want to sum and writes the formula for you. Hit Enter to confirm.

You will find the AutoSum button on the Home tab in the Editing group, and also on the Formulas tab. Clicking the dropdown arrow next to it gives you quick access to AVERAGE, COUNT, MAX and MIN as well, so you do not have to type those manually either.

Using the Formula Bar

The formula bar sits above your spreadsheet grid and shows the raw formula in any selected cell, even when the cell itself is displaying a result. This is where you edit an existing formula. Click the cell, look at the formula bar, make your change, and press Enter. If you ever see a number in a cell but suspect it was manually typed rather than calculated, the formula bar tells you instantly.

10 Basic Excel Formulas for Beginners to Know

These ten cover the vast majority of tasks in entry-level data roles, MIS reporting and academic Excel exams. Mastering these basic Excel formulas puts you in a strong position before you move on to more advanced functions like VLOOKUP, INDEX-MATCH or pivot tables.

Formula Syntax Example What It Does
SUM =SUM(A2:A10) Adds all numbers in a range.
AVERAGE =AVERAGE(B2:B10) Returns the arithmetic mean of a range.
MIN =MIN(C2:C10) Finds the smallest value in a range.
MAX =MAX(C2:C10) Finds the largest value in a range.
COUNT =COUNT(D2:D10) Counts cells that contain numbers.
COUNTA =COUNTA(E2:E10) Counts all non-empty cells, including text.
IF =IF(A2>50,”Pass”,”Fail”) Returns one value if a condition is true, another if false.
CONCATENATE / & =A2&” “&B2 Joins text from two or more cells.
LEN =LEN(A2) Returns the number of characters in a cell.
TODAY =TODAY() Inserts the current date, updated daily.

According to Microsoft’s Excel Tech Community blog, SUM is the single most-used function across Excel globally. That is not surprising. Whether you are totalling student marks at a Delhi university, calculating monthly expenses for a Pune startup, or summing inventory counts for a Mumbai retailer, SUM shows up in almost every spreadsheet.

NASSCOM’s 2023 India Digital Talent Report noted that spreadsheet proficiency, including basic data analysis in Excel, is listed as a required skill in over 60% of data-related job postings across Indian IT and BFSI sectors. If you are thinking about data analyst kaise bane, getting these formulas right is step one.

LinkedIn’s Jobs on the Rise India 2024 report placed Data Analyst roles in the top five fastest-growing positions, with Excel consistently appearing in the skills section of those listings. That is a concrete reason to take basic Excel formulas seriously, not just for exams but for actual hiring conversations.

A Realistic Example: Student Marks Sheet

Say you have student names in column A and marks out of 100 in column B, rows 2 through 31 (30 students). Here is how the formulas map to real tasks, the kind used daily in school administrative offices, college MIS departments and coaching institutes across India:

  • =SUM(B2:B31) gives the total marks across all students.
  • =AVERAGE(B2:B31) gives the class average.
  • =MAX(B2:B31) finds the top scorer’s marks.
  • =MIN(B2:B31) finds the lowest score.
  • =COUNT(B2:B31) confirms how many students actually have a mark entered.
  • =IF(B2>=40,”Pass”,”Fail”) in column C, copied down, labels each student automatically.

Once you can build this sheet from scratch, you are ready to move into more complex data work. This same logic applies to CA Foundation exam prep, UPSC data interpretation practice and any entry-level analyst role in India’s IT or BFSI sectors.

Avoiding Beginner Errors in Excel Formulas

The single most common mistake when learning basic Excel formulas is forgetting the = sign. You type SUM(A1:A5), press Enter, and the cell shows exactly that text back at you. It looks like a bug. It is not. Excel just treated your input as a text label. Add the = and it works immediately.

The second most common issue is the #VALUE! error. This appears when Excel expects a number but finds text instead, usually because a cell in your range has a word or a space typed into it accidentally. Click the cell showing #VALUE!, check which cells it references in the formula bar, and look for any non-numeric content in that range.

Why Your Formula Is Showing as Text

There is a specific scenario worth knowing about. If a cell is formatted as Text before you type a formula, Excel will display the formula as text even with the = sign. To fix it, change the cell format to General (right-click the cell, Format Cells, Number tab, select General), then re-enter the formula. This catches a lot of beginners off guard.

Circular References and How to Spot Them

A circular reference happens when a formula refers back to the cell it is in, directly or through a chain. For example, if you are in cell B5 and you write =SUM(B1:B5), you have included B5 in its own calculation. Excel flags this with a warning dialog and often shows 0 or an unexpected result. The fix is to adjust the range so it excludes the formula cell itself.

If you are preparing for a data analyst role and want to see what kinds of formula questions come up in interviews, the data analyst interview questions guide on 3.0 University covers this territory in detail. Knowing the difference between a #VALUE! and a #REF! error, for instance, is a common screening question.

It is also worth knowing that Excel skills pair directly with broader tech careers. Analysts who filter log data, build security dashboards or track anomalies in a SOC environment use the same formula logic you are learning here. If that path interests you, check out what entry-level tech jobs are growing this year and where data skills fit in.

For a broader picture of where Excel fits among the highest-paying tech skills in 2026, the answer is clear: data proficiency is a foundation, not a ceiling. Professionals who combine Excel with Python, SQL or BI tools consistently earn more according to Glassdoor India’s 2024 salary data.

If you are still deciding whether a data analyst path is right for you versus a data science track, the comparison between data analyst vs data scientist roles breaks down the differences in responsibilities, tools and salary expectations clearly.

Frequently Asked Questions

What does an Excel formula start with?

Every Excel formula starts with an equals sign (=). This character signals to Excel that the cell contains a calculation rather than plain text or a label. Without it, Excel displays whatever you type exactly as written and performs no calculation at all.

How do I write a formula in Excel?

Click the cell where you want the result, type =, then type your function name or expression (for example, =SUM(A2:A10)), and press Enter. You can click cells to insert their references rather than typing addresses manually, which reduces errors and speeds up the process significantly.

What are basic Excel formulas?

Basic Excel formulas include SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, IF, CONCATENATE, LEN and TODAY. These cover addition, statistical summaries, conditional logic, text handling and date functions. They are the starting point for any data work in Excel and appear in the vast majority of real-world spreadsheet tasks.

How do I put a formula in an Excel sheet?

Select the target cell, type your formula starting with =, and press Enter. For quick column or row totals, use the AutoSum shortcut (Alt + = on Windows), which detects your data range automatically and writes the SUM formula for you. You can also find AutoSum on the Home and Formulas tabs.

Why is my formula showing as text?

This usually happens when the cell is pre-formatted as Text before you enter the formula. Excel treats the input as a string instead of a calculation. Fix it by changing the cell format to General via Format Cells, then re-type or re-enter the formula. Also check that you have not accidentally omitted the = sign at the start.

These ten basic Excel formulas give you a working toolkit for most entry-level data tasks, from student mark sheets to monthly sales reports, and they are the foundation every more advanced formula is built on. Here are three things you can do this week to move forward:

  1. Build a practice sheet today. Open a blank Excel file, enter 20 random numbers in column A, and write SUM, AVERAGE, MIN, MAX and COUNT formulas in the cells below. Then add an IF formula in column B that labels each number as “High” or “Low” based on whether it is above the average.
  2. Explore free certified learning. If you want structured guidance with a credential at the end, browse free online courses with certificate to find data and Excel-focused options that fit your schedule.
  3. Think about where these skills take you. Data skills are not limited to analyst roles. Security operations centre (SOC) analysts use the same formula logic to filter log data, flag anomalies and build monitoring dashboards every day. If you want to combine data literacy with a cybersecurity career, look at the EC-Council Certified SOC Analyst course at 3.0 University, or explore the 3.0 University online certification courses in Cybersecurity, AI, Ethical Hacking and Blockchain to find your next step.

Last updated: October 2026. Reviewed by the 3University editorial team.

We create, review, and maintain educational content covering Cybersecurity, Ethical Hacking, Artificial Intelligence, Blockchain, Web3, and emerging technologies.

Read More Articles