Lesson 1: Excel Interface Explained for Beginners

Imagine your manager sends you a sales file and says, “Please check the figures and share the summary.” You open Excel and see a grid, tabs, buttons, formulas, and sheet names. Before formulas or dashboards, your first skill is simple: know where you are and what you are looking at.

What Excel is really used for

Microsoft Excel is a spreadsheet tool used to enter data, calculate numbers, clean information, create reports, and build charts. In real offices, Excel is used for sales reports, attendance trackers, inventory sheets, expense records, invoices, MIS reports, and quick business analysis.

The Excel screen may look crowded at first, but it is organized. Once you understand the main areas, you can start working with confidence instead of clicking randomly.

Excel screen at a glance

Microsoft Excel — Monthly Sales Report.xlsx

HomeInsertFormulasDataView

Sales Report

Date

Region

Sales

Profit

Status

01-Jul

West

5000

1200

Closed

Workbook vs worksheet

An Excel file is called a workbook. Inside the workbook, you can have one or more worksheets. Think of the workbook as a notebook and each worksheet as a page inside that notebook.

For example, a monthly sales workbook may contain separate worksheets named Raw Data, Summary, and Dashboard.

1Workbook = Excel file

1+Worksheets inside workbook

A1First cell address

Rows, columns and cells

Excel stores data in a grid. Columns run vertically and are named with letters like A, B, C. Rows run horizontally and are numbered 1, 2, 3. A cell is where a row and column meet.

The cell address is written using the column letter first and row number second. For example, B5 means column B, row 5.

Beginner rule: Whenever you are unsure where you are, look at the Name Box. It tells you the address of the selected cell.

Ribbon and tabs

The ribbon is the command area at the top of Excel. It is divided into tabs such as Home, Insert, Page Layout, Formulas, Data, Review, and View.

The Home tab is where beginners spend most of their time. It contains common actions like copy, paste, font formatting, alignment, number formatting, insert rows, delete columns, and AutoSum.

Name box and formula bar

The Name Box appears near the top-left of the worksheet area and shows the selected cell address. The Formula Bar shows the actual content of the selected cell.

This matters because a cell can display one thing and contain another. A cell may show ₹5,000 but actually contain a formula like =B2*C2.

💡

Office tip: When reviewing someone else’s sheet, always check the formula bar before trusting a value. It helps you identify whether the number is typed manually or calculated.

Sheet tabs and status bar

Sheet tabs are shown at the bottom of the workbook. They help you move between worksheets. The status bar is at the bottom of Excel and shows quick information such as Ready mode, average, count, and sum for selected cells.

🧪 Practice Lab