Data Entry & Basic Formulas in Excel – Complete Beginner Guide

After understanding the basic Excel Window, the next important step is learning
Data Entry and Basic Formulas in Excel. Data entry is one of the most common tasks
performed in Microsoft Excel, while basic formulas help you work with the information entered into
your worksheet.

In this beginner-friendly guide, you will learn how to enter different types of data in Excel,
edit and organize that data, and use simple formulas for everyday calculations. The concepts are
explained step by step so that a beginner can easily follow them.

What is Data Entry in Excel?

Data Entry in Excel means entering information into the cells of an Excel worksheet.
The information may include names, numbers, dates, addresses, quantities, prices and other useful details.

For example, suppose you want to create a simple student record. You can enter information like:

Each piece of information is entered into a separate cell. This makes the information easy to read
and manage.

Types of Data You Can Enter in Excel

Excel allows you to enter different types of information into cells. Some of the most common types
are text, numbers and dates.

1. Text Data

Text data includes names, addresses, subjects, cities and other words or characters.

Examples:

• Rahul Sharma
• Computer Science
• Narmadapuram
• Excel Training

2. Number Data

Numbers can be entered into cells for representing quantities, marks, prices and other numerical
information.

Examples:

• 100
• 2500
• 85
• 75.50

3. Date Data

Excel can also store dates. Dates are commonly used when maintaining records, schedules and other
information.

Examples:

• 01/09/2026
• 15/08/2026
• 25/12/2026

How to Enter Data in Excel

Entering data into Excel is simple. Follow these steps:

1. Open Microsoft Excel.
2. Open a new workbook.
3. Click the cell where you want to enter data.
4. Type the required information.
5. Press the Enter key.

For example, click cell A1 and type Name. After pressing Enter,
the information will be stored in that cell.

How to Edit Data in Excel

Sometimes you may need to correct or change information that has already been entered.
Excel provides simple ways to edit cell contents.

Method 1 – Double Click

Double-click the cell containing the information and make the required changes.

Method 2 – Formula Bar

Select the cell and edit its content using the Formula Bar.

Method 3 – F2 Key

Select the cell and press the F2 key to edit its contents directly.

How to Delete Data from a Cell

To remove information from a cell:

1. Select the cell.
2. Press the Delete key.

The contents of the selected cell will be removed.

What is a Formula in Excel?

A Formula in Excel is an expression used to perform a calculation using values
or cell references.

An Excel formula normally begins with an equals sign (=).

Example:

=10+20

The result of this formula is 30.

Instead of directly entering numbers, you can also use cell references.

=A1+B1

Here Excel adds the values stored in cells A1 and B1.

Basic Arithmetic Operators in Excel

Excel provides basic mathematical operators that can be used in formulas.

Basic Formulas in Excel

Now let’s look at some simple formulas that beginners commonly use in Excel.

1. Addition Formula

The addition operator + is used to add values.

=A1+B1

If A1 contains 50 and B1 contains 30, the result will be 80.

2. Subtraction Formula

The subtraction operator – is used to subtract one value from another.

=A1-B1

If A1 contains 100 and B1 contains 40, the result will be 60.

3. Multiplication Formula

The multiplication operator * is used to multiply values.

=A1*B1

If A1 contains 10 and B1 contains 5, the result will be 50.

4. Division Formula

The division operator / is used to divide one value by another.

=A1/B1

If A1 contains 100 and B1 contains 4, the result will be 25.

Using Cell References in Formulas

One of the useful features of Excel is that formulas can work with cell references instead of manually
typing numbers.

Suppose:

• A1 contains 100
• B1 contains 50

You can enter the following formula in C1:

=A1+B1

Excel will calculate the result automatically.

If you later change the value in A1 or B1, Excel will automatically update the result of the formula.

Using SUM for Simple Addition

Excel also provides the SUM function for adding multiple values.

=SUM(A1:A5)

This formula adds all values from cell A1 through A5.

For beginners, understanding the basic idea of SUM is useful because it avoids writing a long addition
formula for every individual cell.

Simple Data Entry and Calculation Example

Let’s understand the concept with a simple example.

If Quantity is stored in column B and Price is stored in column C, you can calculate Amount in column D
using:

=B2*C2

This is a simple example of how Data Entry and Basic Formulas in Excel can work together.

Important Tips for Excel Data Entry

• Always check the information before entering it.
• Keep column headings clear and meaningful.
• Enter similar types of information consistently.
• Avoid unnecessary blank rows inside a data table.
• Check numbers and dates carefully.
• Use cell references when creating simple formulas.
• Save your workbook regularly.

Common Beginner Mistakes in Excel

1. Forgetting the Equals Sign

A formula normally begins with =. For example:

=A1+B1

2. Using the Wrong Cell Reference

Always check that the cells used in the formula contain the information you actually want to calculate.

3. Entering Numbers as Text

Sometimes numbers may be stored as text. This can affect calculations, so beginners should pay attention
to how data is entered.

4. Incorrect Formula Operator

Remember the basic operators:

• + for addition
• – for subtraction
• * for multiplication
• / for division

Frequently Asked Questions

What is Data Entry in Excel?

Data Entry in Excel means entering information such as text, numbers and dates into worksheet cells.

What is a Formula in Excel?

A formula is an expression used to perform calculations in Excel. A formula normally begins with an
equals sign (=).

What is the basic formula for adding two cells?

The basic formula is:

=A1+B1

Which symbol is used for multiplication in Excel?

The asterisk symbol * is used for multiplication.

Which function is commonly used for adding a range of cells?

The SUM function is commonly used to add values from a range of cells.

Conclusion

Data Entry and Basic Formulas in Excel are essential skills for beginners.
Data entry helps you create and organize information, while basic formulas allow you to perform
simple calculations using that information.

In this guide, we learned how to enter and edit data, understand different types of data, use basic
arithmetic operators, create simple formulas, use cell references and perform basic calculations.

A strong understanding of these basics will make it easier to work confidently with Excel worksheets
and prepare for the next stage of Excel learning.