MS Excel for Beginners

MS Excel is a spreadsheet program that arranges data in a grid of rows and columns. Every box in that grid is a cell, and each cell has an address made from its column letter and row number, like A1 or B5. You type numbers, text and dates into cells, then let Excel calculate, sort and chart them for you. This lesson gets you comfortable with the screen before you touch a single formula.

Why learn Excel

Almost every office job in India expects some Excel. Shopkeepers use it for stock, teachers for marksheets, accountants for daily sales. Once you understand the grid, the rest of Excel is just building on top of it.

The Excel screen, part by part

Open Excel and start a Blank workbook. Here's what you're looking at:

• Ribbon — the strip of tabs at the top (Home, Insert, Page Layout…). Each tab holds related buttons.
• Name Box — the small box on the left that shows the address of the cell you've clicked.
• Formula Bar — the long bar next to it, where you see and edit what's inside a cell.
• Columns — the vertical strips labelled A, B, C across the top.
• Rows — the horizontal strips numbered 1, 2, 3 down the side.
• Sheet tabs — at the bottom, where you switch between sheets in the same file.

Rows, columns and cells

A column runs top to bottom and is named with a letter. A row runs left to right and is named with a number. Where a column and a row cross, you get a cell. Click any cell and its address shows in the Name Box.

The cell you've clicked is the active cell. Whatever you type goes there.

Step by step: enter your first data

1. Click cell A1.
2. Type Name and press Tab. The active cell moves right to B1.
3. Type Marks and press Enter.
4. Click A2, type a student's name, press Tab, type their marks, press Enter.
5. Keep going down the list.

Tab moves you right, Enter moves you down. That rhythm is how you fill a table quickly.

Worked example (a small class list)

Here the heading row is row 1, and each student sits in their own row. Column A holds text, column B holds numbers. Excel treats them differently: it can add up column B, but not column A.

Save your work

Press Ctrl + S. The first time, Excel asks where to save and what to name the file. Excel files end in .xlsx. After that, Ctrl + S saves silently as you work. Get into the habit of pressing it often.

Handy shortcuts to start with

Pro tips

• Keep one heading in each cell of row 1. Clean headings make sorting, filtering and pivot tables work later.
• Don't leave blank rows inside a table. Excel treats a blank row as the end of your data.
• Widen a column by double-clicking the line between two column letters. It auto-fits to the longest entry.

Common mistakes

• Typing numbers as text. If a number sits on the left of the cell, Excel is treating it as text and won't calculate it. Numbers align right by default.
• Merging cells too early. Merged cells look neat but break sorting and formulas. Avoid them while learning.
• Forgetting to save. Excel doesn't autosave to your computer by default. Press Ctrl + S.

Key takeaways

• Excel stores data in cells, each with an address like A1.
• Columns are letters, rows are numbers.
• Tab moves right, Enter moves down.
• Save with Ctrl + S; files are .xlsx.

Practice task

Make a table with three columns: Item, Quantity, Price. Enter five grocery items. Save the file as my-first-sheet.xlsx. You'll use this same sheet in the next lessons on formulas.

Want to go from basics to job-ready Excel with a trainer guiding you? The ADCA (AI Integrated) program at HCI teaches Excel hands-on.