Skip to content
Tutorials Center
My learning

Topics

Lesson 1 of 93 ยท Getting Started

What Is Excel and What Is It For

Learn what Microsoft Excel is, how workbooks, worksheets and cells fit together, what people use it for, and how the desktop, web and Mac versions differ.

Microsoft Excel is a spreadsheet program: a large grid where you type numbers, text and dates, and where formulas calculate new values from what you typed. Change one number and every result that depends on it updates at once. That one idea, a grid that recalculates itself, is why Excel has been the most widely used business tool for decades.

People use Excel for far more than "tables of numbers". A shop owner tracks stock in it, a student keeps a grade calculator, an accountant builds a budget, and an analyst summarizes a hundred thousand sales rows into a chart. In this tutorial you will learn the program from the first click to PivotTables, dynamic arrays and automation.

A word about this site: Excel itself cannot run inside a web page here. So every lesson shows Excel's features in plain text, and where it helps, adds small stand-ins: live code (JavaScript or Python) that behaves the way Excel does inside. Each lesson tells you which part is the real Excel and which part is the stand-in.

What people do with Excel

Track Budgets, stock lists, timesheets.
Calculate Totals, loans, grades, forecasts.
Analyze Summaries, pivots and charts.
Clean Fix messy data before use.

One tool, four everyday jobs.

1 / 2

Workbooks, worksheets and cells

A workbook is the file you save, usually ending in .xlsx. Think of it as a binder. Inside the binder are worksheets (also called sheets): the individual pages, each with its own grid. A new workbook typically starts with one sheet named Sheet1, and you can add as many as memory allows.

A worksheet is a grid of cells. Columns are labeled with letters (A, B, ... Z, AA, AB, ...) and rows with numbers (1, 2, 3, ...). Every cell has an address made of its column letter and row number: B3 is column B, row 3. A modern worksheet has 16,384 columns (the last one is XFD) and 1,048,576 rows, so there are over 17 billion cells available on each sheet.

A cell holds one of a few things:

  • A constant: text (Pen), a number (1.5), a date, or a logical value (TRUE).
  • A formula: anything that starts with an equals sign, like =B2*C2. The cell shows the result, while the formula stays visible in the formula bar.
  • Nothing: an empty cell, which many functions treat differently from zero.

You can also attach formatting, comments and validation rules to a cell, but the content is always one of the three above.

A first model of a sheet

Here is how a program can represent a worksheet: a dictionary from addresses to contents. This stand-in is not how Excel stores things internally, but it captures the user's view: addresses on the left, a constant or a formula on the right. The formulas are evaluated by a tiny helper that knows + - * /, cell references and SUM.

JS A worksheet as address โ†’ content

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Each line shows the address, what Excel would display in the cell, and what the cell actually holds. Cell D6 displays a number but stores =SUM(D2:D4). Cell A5 and the rest of row 5 do not appear at all, because empty cells take no space in a file.

What the grid looks like

Real Excel draws the cells as a table. This second stand-in prints the same model as a grid with column letters and row numbers, which is what you see on screen. Numbers align to the right and text to the left, exactly as Excel does by default.

JS Draw the grid with letters and numbers

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Notice B3 is the second column of the third row. Spreadsheet addresses put the column first, which is the opposite order of many programming languages that index row, column.

Typical uses

You do not need to be an accountant to benefit. Common uses include:

  • Lists and trackers: contacts, tasks, inventory, a reading list. Filtering and sorting make lists searchable. See Sorting Data later in the course.
  • Calculations and models: budgets, loan payments, invoices, grade books. Formulas are the heart of Excel; start with Your First Formulas.
  • Reports and dashboards: PivotTables summarize big tables in seconds, and charts turn numbers into pictures.
  • Data cleaning: imported files are rarely tidy. Excel can trim, split and reshape them; see Cleaning Messy Data.
  • Light automation: macros, Power Query and Office Scripts repeat boring work for you.

When Excel is not the right tool

Excel is not a database. It is a poor choice when many people must edit the same records at the same moment, when you need strict rules about relationships between tables, or when you have more rows than a sheet can hold (about one million). For those jobs, a real database or a program written in Python or SQL is better. Excel is excellent as the front end where people look at, check and adjust numbers.

Desktop, web and Mac

Excel comes in several editions, and knowing the differences saves confusion later:

Edition Where it runs Notes
Excel for Windows Desktop app The most complete: all features, Power Pivot, full VBA support.
Excel for Mac Desktop app Very close to Windows; a few features (such as some Power Query and ActiveX items) lag behind and keyboard shortcuts use Cmd instead of Ctrl.
Excel for the web Browser Free with a Microsoft account; good for viewing, light editing and co-authoring, but without macros and with fewer advanced tools.
Excel mobile Phone and tablet Handy for checking or small edits.

Newer functions such as XLOOKUP, FILTER and LET exist only in Microsoft 365 and Excel 2021 or later. When a lesson uses one, it says so. Older stand-alone versions (2016, 2019) lack them, and the lesson shows the older alternative where one exists.

Look at the title bar of your own Excel before following later lessons: File โ†’ Account shows the version you have. Everything in the Getting Started chapter works in every edition.

How this tutorial works

The course moves from the grid itself to formulas, then to lookups, text and dates, statistics, tables, dynamic arrays, charts, PivotTables, data import, automation and finally projects and practice sets. Each lesson has short quizzes so you can check yourself. Use the stand-ins to experiment: change the numbers, add a row, break a formula on purpose and watch what happens. Experimenting is the fastest way to learn a spreadsheet.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. What is a workbook in Excel?

    The workbook is the file you save (for example an .xlsx file). It contains worksheets, and worksheets contain cells.
  2. 2. Which cell is in column C, row 7?

    Excel addresses put the column letter first and the row number second, so the cell is C7.
  3. 3. A cell shows 55 but the formula bar shows =SUM(A1:A3). What does the cell contain?

    A cell displays the result of its formula, while the formula itself is stored in the cell and shown in the formula bar.
  4. 4. Which feature is available only in Microsoft 365 and Excel 2021 or later?

    XLOOKUP and other dynamic-array functions were added in newer versions. Older versions such as 2016 and 2019 do not have them.

Summary

  • Excel is a spreadsheet: a grid of cells whose formulas recalculate automatically.
  • A workbook (file) contains worksheets, which contain cells addressed by column letter and row number, such as B3.
  • A cell holds a constant (text, number, date, logical), a formula that starts with =, or nothing.
  • Excel suits lists, models, reports and cleaning, but it is not a multi-user database.
  • Desktop Windows is the most complete edition; Mac, web and mobile have fewer features, and newer functions need Microsoft 365 or Excel 2021+.

Next: A Tour of the Excel Interface.