Tutorials›Excel›Excel Introduction
🟢 Free Demo
Excel TutorialTopic 1 of 31

Excel Introduction

What Excel is, how it is structured, and why it is the most essential tool for data analysts in India.

✅ What You Will Learn

›What a workbook, worksheet, row, column, and cell are
›How to navigate Excel using keyboard shortcuts
›The difference between a value, a formula, and a function
›How to enter and edit data in cells
›Why Excel remains the most in-demand skill for analysts in 2026

Microsoft Excel is a spreadsheet application that organises data into a grid of rows and columns. Each intersection of a row and column is called a cell, and every cell can hold a number, text, date, or a formula that calculates a result automatically.

Excel is used across every industry — finance, marketing, operations, HR, healthcare — and it is consistently listed as the number one required skill in data analyst job descriptions across India. Whether you are analysing sales figures, building MIS reports, tracking inventory, or creating dashboards, Excel is where the work happens.

A single Excel file is called a workbook. Inside a workbook you can have multiple worksheets (the tabs at the bottom). Columns are labelled A, B, C… and rows are numbered 1, 2, 3… so every cell has a unique address like B4 or G12. This address system is what makes formulas possible.

📋 Sample spreadsheet — monthly sales data

MonthRegionProductUnits SoldRevenue (₹)Target (₹)
JanNorthLaptop4218900002000000
JanSouthMobile13011700001000000
FebNorthLaptop3817100002000000
FebEastTablet7511250001200000
MarSouthMobile15814220001500000

Examples

Example 1Your first formula — adding two cells
=B2+C2
OUTPUT
Result: the sum of whatever numbers are in B2 and C2
💡

Every formula in Excel starts with an equals sign (=). Without it, Excel treats what you type as plain text.

Example 2Using the SUM function on a range
=SUM(E2:E6)
OUTPUT
7317000
💡

A range like E2:E6 means "all cells from E2 down to E6". SUM adds them all at once — far faster than =E2+E3+E4+E5+E6.

📌 Key Points to Remember

  • ✓Columns are letters (A–XFD), rows are numbers (1–1,048,576) — every cell has a unique address
  • ✓All formulas start with = — without it Excel treats the entry as text
  • ✓Use Tab to move right, Enter to move down — faster than clicking
  • ✓Ctrl+Z undoes any mistake — always safe to experiment
  • ✓Excel files are saved as .xlsx (modern format) — avoid old .xls for large files

🏢 Real-World Application

At companies like Infosys, HCL and Genpact, analysts use Excel daily to clean raw data exported from ERP systems, build weekly MIS reports for management, and track KPIs using pivot tables. Even teams that use Power BI or Tableau start their analysis in Excel — it is the universal staging area for business data.

⚠️ Common Mistakes to Avoid

WRONGTyping a formula without = (e.g. SUM(A1:A10))
FIXAlways start with = — write =SUM(A1:A10). Without the equals sign Excel stores it as text.
WRONGMixing number formats — storing "1,234" as text instead of a number
FIXNumbers should never have quote marks. If a column shows left-aligned numbers, they are stored as text and SUM will ignore them.
WRONGPutting data across multiple sheets and then struggling to combine it
FIXFor analysis keep raw data on one sheet, calculations on another, and the final report on a third. Label them clearly.
✏️Test Yourself

Which of the following correctly references the cell in column D, row 7?

❓ Frequently Asked Questions

Do I need to buy Excel separately?

Excel is part of Microsoft 365. Many offices already have a license. You can also use Excel Online for free at office.com with a Microsoft account — it covers most features used in this tutorial series.

Is Excel still relevant when tools like Python and Power BI exist?

Absolutely. Excel is used in over 90% of analyst roles and is always the first tool listed in job descriptions. Python and Power BI complement Excel — they do not replace it.

What is the maximum size of an Excel file?

A single worksheet can hold 1,048,576 rows and 16,384 columns. For datasets larger than about 500,000 rows, Power Query or SQL is more practical.

✏️ Practice Exercise

Open a blank Excel sheet. In column A enter the numbers 10, 20, 30, 40, 50 (one per row). In cell B1 write a formula using SUM to add all five numbers. Then in B2 write a formula using the + operator to do the same thing manually. Confirm both give 150.

Next →Cell References
🎓 Level Up Faster

Learn Excel with Live Trainer Guidance

These tutorials give you the foundations. Our live Excel course at EVIKA Academy, Noida teaches you to build real dashboards on actual business data — with a trainer who uses Excel professionally every day.