# Introduction to Excel

Course: [Excel](https://www.devtutorials.ai/learn/excel) · Section: Getting Started
Source: https://www.devtutorials.ai/learn/excel/getting-started/introduction-to-excel

> What Excel is, what it can do, where it's used, and why it's worth learning. Then create your first workbook with a formula that updates itself.

Have you ever used a notebook to track expenses, create a timetable, or record scores? Excel takes those simple lists and turns them into powerful spreadsheets that can perform calculations, organize information, and create charts automatically. In this lesson, you'll learn what Excel is, where it is used, and why it is one of the most valuable digital skills to have. You'll also create your first workbook and enter your first formula.

## What is Excel?

Excel is a **spreadsheet application** used to store, organize, calculate, and analyze data.

A spreadsheet consists of a large grid made up of **rows** and **columns**. The box where a row and column meet is called a **cell**. You can enter text, numbers, dates, and formulas into these cells.

Think of Excel as an intelligent digital worksheet. Instead of recalculating everything manually, Excel updates results automatically whenever the source data changes.

An Excel file is known as a **workbook** and is usually saved with the **.xlsx** file extension, such as `SalesReport.xlsx`. Each workbook can contain multiple **worksheets**, allowing related information to be organized in separate sheets within the same file.

You do not need Microsoft Excel installed on your computer to complete this course. Every lesson includes an **Excel sandbox** that runs directly in your browser. Open it using the **Open the Excel sandbox** button at the bottom-right of the page, or press **Ctrl + backtick** (Cmd + backtick on Mac). The sandbox behaves like Excel, so the skills you learn here can be applied directly to Microsoft Excel.

## Features of Excel

Excel provides a wide range of tools that help you work with information efficiently.

| Feature | Purpose | Example |
|---|---|---|
| Data Entry | Store information in cells | Student names and marks |
| Formulas | Perform calculations using cell values | Calculate total expenses |
| Functions | Use built-in calculations | Find average exam marks |
| Formatting | Improve appearance of data | Display currency values |
| Sorting and Filtering | Organize and display selected data | Show only current month's expenses |
| Charts | Create visual representations of data | Monthly sales chart |
| Conditional Formatting | Apply automatic formatting based on values | Highlight low scores in red |
| Data Validation | Restrict allowed input values | Department drop-down list |
| Printing and Exporting | Share or print workbook data | Export reports as PDF |

## Common Uses of Excel

People use Excel for many everyday and professional tasks, including:

- **Budget planning** for tracking income and expenses
- **Managing lists** such as contacts, inventory, and tasks
- **Student records** including marks, grades, and attendance
- **Sales tracking** and order management
- **Scheduling** activities, shifts, and project timelines
- **Creating reports** with summaries and charts

## Why Learn Excel?

### 1. Excel Is Widely Used

Businesses, schools, government offices, hospitals, and many other organizations rely on spreadsheets every day.

### 2. Excel Skills Are Valuable

Many employers expect candidates to have at least basic spreadsheet skills because Excel is commonly used in the workplace.

### 3. Excel Saves Time

Instead of performing calculations manually, you can use formulas to complete repetitive work quickly and accurately.

### 4. Excel Helps You Understand Data

Features such as sorting, filtering, calculations, and charts make it easier to identify trends and patterns in information.

### 5. Excel Skills Transfer Easily

Many spreadsheet applications, including Google Sheets and LibreOffice Calc, use similar concepts. Learning Excel makes it easier to work with those tools as well.

## Applications of Excel

| Area | Typical Uses |
|---|---|
| Business | Budgets, invoices, forecasts, sales reports |
| Education | Attendance records, grade books, timetables |
| Finance and Accounting | Expense tracking, accounts, loan calculations |
| Healthcare | Patient records, appointments, inventory tracking |
| Scientific Research | Data collection and chart creation |
| Personal Use | Household budgets, shopping lists, savings plans |

Excel is more than a tool for entering information into cells. Its real strength comes from connecting data. One cell can contain a price, another a quantity, and a formula can instantly calculate the total. When data works together, Excel becomes a powerful problem-solving tool.

## Creating Your First Workbook

Let's create a simple workbook using the Excel sandbox.

### Understanding the Workspace

When the workbook opens, you'll see several important parts of the Excel window:

- The **Ribbon**, which contains commands organized into tabs such as **Home**, **Insert**, and **Formulas**
- The **Formula Bar**, which displays the contents of the currently selected cell
- The **Worksheet Grid**, made up of rows and columns
- The **Sheet Tabs** at the bottom, where worksheets are listed

You will learn about each of these areas in detail later. For now, focus on the worksheet grid.

### Entering Data

Each cell has a unique location called a **cell address**.

Cell addresses use:

- A column letter
- Followed by a row number

For example, the top-left cell is **A1**.

1. Select cell **A1** and type `Fruit`, then press **Enter**.
2. In the cells below, enter:
   - `Apples`
   - `Bananas`
   - `Cherries`
3. Select cell **B1** and type `Price`.
4. In cells **B2**, **B3**, and **B4**, enter:
   - `3`
   - `2`
   - `5`

Notice that:

- Text is usually aligned to the **left**
- Numbers are usually aligned to the **right**

This helps you quickly identify how Excel is interpreting the data.

Press **Enter** to move to the cell below. Press **Tab** to move to the cell on the right. If you make a mistake, press **Esc** before confirming the entry, or use **Ctrl + Z** to undo after entering it.

### Creating Your First Formula

Now you'll create a simple calculation.

1. Click cell **A5** and type `Total`.
2. Click cell **B5** and enter:

```excel
=B2+B3+B4
```

3. Press **Enter**.

Excel displays the result:

```text
10
```

Select cell **B5** again and look at the Formula Bar.

You'll notice:

- The cell shows the result (**10**)
- The Formula Bar shows the actual formula (**=B2+B3+B4**)

Now change the value in **B2** from: 3 to 6

The result in **B5** automatically changes from: 10 to 13

This automatic updating is one of the most important features of spreadsheets.

### Saving Your Workbook

In the Excel sandbox:

- **Save draft** stores your work within the lesson.
- **Save** downloads a real Excel workbook (`.xlsx`).

In Microsoft Excel:

1. Press **Ctrl + S**
2. Choose a save location
3. Enter a file name
4. Click **Save**

## Common mistakes

| Mistake | Result | Solution |
|---|---|---|
| Forgetting the `=` sign | Formula displays as text | Start the formula with `=` |
| Entering totals manually | Totals do not update automatically | Use a formula instead |
| Typing values such as `5 apples` | Excel treats the entry as text | Place numbers and labels in separate cells |
| Using the wrong cell | Data appears in the wrong location | Verify the cell address before typing |
| Closing without saving | Work is lost | Save frequently |

## Exercise

Complete the following activities in the Excel sandbox. Click **Reset** before starting if you want a blank worksheet.

## What to Remember

- Excel is a **spreadsheet program** used to organize and calculate data.
- Worksheets consist of **rows**, **columns**, and **cells**.
- Excel files are called **workbooks** and use the **.xlsx** extension.
- Every cell has a unique **cell address**, such as **A1** or **C4**.
- Text is usually aligned to the left, while numbers are aligned to the right.
- Formulas always begin with **=**.
- Formula results update automatically when the referenced values change.
- **Enter** moves down, **Tab** moves right, and **Ctrl + Z** undoes your last action.

In the next lesson, you'll explore the Excel interface in more detail, including the Ribbon, Formula Bar, Name Box, and Sheet Tabs.