Excel Tutorial for Beginners (2025): Learn Excel Step by Step

Microsoft Excel is the world's most widely used spreadsheet software — a skill that appears in almost every job posting in finance, marketing, operations, HR, and data analysis. This tutorial takes you from opening Excel for the first time to building real dashboards and automating repetitive tasks.

What you'll learn

Why learn Excel?

Excel is used by over 750 million people worldwide. It's the #1 tool requested in non-technical job descriptions.

Setup: Getting Excel

For this tutorial, any version from Excel 2016 onward works. Excel Online (office.com) is free with a Microsoft account.

Part 1: The Excel Interface

Workbook vs worksheet

• Workbook — the .xlsx file itself
• Worksheet (sheet) — one tab inside the workbook (Sheet1, Sheet2, etc.)
• You can have multiple sheets in one workbook

Key interface elements

Cell addresses

Each cell has a unique address: column letter + row number.

Part 2: Entering and Editing Data

Basic data entry

1. Click a cell
2. Type your data
3. Press Enter (move down) or Tab (move right) to confirm and move

Data types

Keyboard shortcuts (essential)

AutoFill

Excel can predict series automatically:

1. Type 1 in A1, 2 in A2
2. Select both cells
3. Drag the small square at the bottom-right corner (fill handle) down
4. Excel fills in 3, 4, 5, 6…

AutoFill also works for: days of the week, months, dates, custom lists.

Part 3: Formatting

Number formats

Select cells → Home tab → Number group → choose format:

Shortcut: Ctrl+1 opens the Format Cells dialog for full control.

Cell formatting

Column width and row height

• Double-click column border in header → auto-fit to content
• Right-click column/row header → Column Width / Row Height → enter value
• Select multiple columns → resize all at once

Part 4: Formulas and Functions

Every formula starts with =.

Basic arithmetic

=A1+B1          → add
=A1-B1          → subtract
=A1*B1          → multiply
=A1/B1          → divide
=A1^2           → power (A1 squared)
=SQRT(A1)       → square root

SUM — add a range

=SUM(A1:A10)          → sum of A1 through A10
=SUM(A1,B1,C1)        → sum of three specific cells
=SUM(A:A)             → sum of entire column A (use carefully)

AVERAGE, MIN, MAX, COUNT

=AVERAGE(B2:B100)     → mean of range
=MIN(C2:C50)          → smallest value
=MAX(C2:C50)          → largest value
=COUNT(D2:D100)       → count of numeric cells
=COUNTA(D2:D100)      → count of non-empty cells
=COUNTBLANK(D2:D100)  → count of empty cells

Cell references: relative vs absolute

Rule of thumb: Use $ when referencing a fixed value (like a tax rate or a total) that shouldn't change when you copy the formula.

Tip: Press F4 while editing a cell reference to cycle through reference types.

=B2*$C$1        → B2 adjusts, but C1 (tax rate) stays fixed

IF — logical test

=IF(condition, value_if_true, value_if_false)

=IF(A1>100, "High", "Low")
=IF(B2="", "Missing", B2)
=IF(C3>=0.9, "Pass", IF(C3>=0.7, "Review", "Fail"))   → nested IF

Nested IF vs IFS (Excel 2016+)

=IFS(C3>=0.9, "A", C3>=0.8, "B", C3>=0.7, "C", TRUE, "F")

IFS is cleaner than deeply nested IF.

COUNTIF / COUNTIFS

=COUNTIF(A2:A100, "Apples")         → count cells equal to "Apples"
=COUNTIF(B2:B100, ">1000")          → count cells > 1000
=COUNTIF(C2:C100, "<>"&"")          → count non-empty cells

=COUNTIFS(A2:A100, "Apples", B2:B100, ">1000")   → multiple conditions

SUMIF / SUMIFS

=SUMIF(A2:A100, "Apples", C2:C100)          → sum C where A = "Apples"
=SUMIFS(C2:C100, A2:A100, "Apples", B2:B100, ">1000")

Part 5: VLOOKUP and INDEX-MATCH

VLOOKUP

Look up a value in the first column of a table and return something from another column.

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Example: Look up product price by ID:

=VLOOKUP(A2, $F$2:$H$100, 3, FALSE)

• Searches A2 value in column F
• Returns value from column H (3rd column of range F:H)
• FALSE = exact match

VLOOKUP limitations

INDEX-MATCH — more powerful

=INDEX(return_range, MATCH(lookup_value, lookup_range, 0))

• MATCH finds the row number of the lookup value
• INDEX returns the value at that row from a different column

=INDEX(C2:C100, MATCH(A2, B2:B100, 0))

Can look left, right, or in any direction. Doesn't break when columns are inserted.

XLOOKUP (Excel 2019+, Microsoft 365)

=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found])

=XLOOKUP(A2, F2:F100, H2:H100, "Not found")

Simpler syntax than VLOOKUP + handles errors gracefully.

Part 6: Text Functions

Part 7: Date and Time Functions

Calculate age:

=DATEDIF(B2, TODAY(), "Y")   → complete years

Days until deadline:

=A1-TODAY()    → format result as Number

Part 8: Conditional Formatting

Automatically highlight cells based on rules.

How to apply:

1. Select your data range
2. Home → Conditional Formatting → choose a rule type

Common rule types

Formula-based rule example

Highlight entire row if status is "Overdue":

1. Select data range (e.g., A2:E100)
2. Home → Conditional Formatting → New Rule
3. Choose Use a formula to determine which cells to format
4. Formula: =$D2="Overdue" ($ locks column D, not row)
5. Set fill color → OK

Part 9: Charts

Create a chart

1. Select your data (include headers)
2. Insert tab → Charts group
3. Choose chart type
4. Use Chart Design / Format tabs to customize

Chart types

Chart best practices

• Give every chart a clear title
• Label axes with units
• Remove unnecessary gridlines and borders
• Use color intentionally (highlight one key bar)
• Don't use 3D charts — they distort perception
• Pie charts: max 5–6 slices, always sorted largest to smallest

Part 10: Pivot Tables

Pivot tables summarize large datasets without formulas.

Create a pivot table

1. Click anywhere inside your data
2. Insert → PivotTable → OK (puts it on new sheet)
3. Drag fields from the field list into areas:

Example: Sales by Region and Product

Raw data columns: Date, Region, Product, Units, Revenue

Drag:

• Region → Rows
• Product → Columns
• Revenue → Values (Sum)

Result: a cross-tab showing total revenue per region × product.

Value field settings

Right-click a value in the pivot → Value Field Settings:

Refresh a pivot table

When source data changes: PivotTable Analyze → Refresh (or Alt+F5).

Slicers

Visual filter buttons for pivot tables: PivotTable Analyze → Insert Slicer → choose field → click buttons to filter.

Part 11: Data Tools

Sort

1. Click anywhere in your data
2. Data → Sort
3. Choose column + order (A→Z, Z→A, or custom)

Multiple-level sort: sort by Region first, then by Revenue descending.

Filter

1. Select header row
2. Data → Filter (or Ctrl+Shift+L)
3. Click dropdown arrows on headers to filter

Advanced filter tricks:

• Filter by color
• Number filters: Top 10, Above Average, Between
• Text filters: Contains, Begins With
• Clear filter: Alt+D+F+F or Data → Clear

Remove Duplicates

Data → Remove Duplicates → select columns → OK

Text to Columns

Split one column into multiple (e.g., "John Doe" → "John" | "Doe"): Data → Text to Columns → Delimited (space) or Fixed Width

Flash Fill (Excel 2013+)

Excel learns your pattern:

1. In column B, type the first transformed value (e.g., extract first name from "John Doe" → "John")
2. Start typing the second
3. Press Ctrl+E — Excel fills the rest automatically

Data Validation

Restrict what users can enter in a cell:

1. Select cells
2. Data → Data Validation
3. Settings → Allow: List → Source: Yes,No (or a range)

Creates a dropdown. Also works for: whole numbers only, dates in range, text length limits.

Part 12: Real-World Projects

Project 1: Personal Budget Tracker

Columns: Date | Category | Description | Amount | Type (Income/Expense)

Key formulas:

Total Income:   =SUMIF(E2:E100, "Income", D2:D100)
Total Expenses: =SUMIF(E2:E100, "Expense", D2:D100)
Balance:        =Income - Expenses
By category:    =SUMIF(B2:B100, "Food", D2:D100)

Add a Pivot Table: Category → Rows, Amount → Values (Sum) for instant spending breakdown.

Project 2: Sales Report with Dashboard

Sheet 1 — Raw data: Date | Rep | Region | Product | Units | Price | Revenue

Sheet 2 — Summary:

Total revenue:     =SUM(Sheet1!G2:G1000)
Revenue this month: =SUMIFS(Sheet1!G:G, Sheet1!A:A, ">="&DATE(YEAR(TODAY()),MONTH(TODAY()),1))
Top product:       =INDEX(Sheet1!D:D, MATCH(MAX(Sheet1!G:G), Sheet1!G:G, 0))

Add:

• Pivot table: Revenue by Region and Product
• Bar chart: Revenue by Rep
• Line chart: Revenue over time
• Slicer: filter by Region

Project 3: Employee Roster with Lookup

Sheet 1 (Employee DB): ID | Name | Department | Manager | Start Date | Salary

Sheet 2 (Search tool):

A1: Enter Employee ID
B1: =XLOOKUP(A1, Sheet1!A:A, Sheet1!B:B, "Not found")   → Name
B2: =XLOOKUP(A1, Sheet1!A:A, Sheet1!C:C, "")             → Department
B3: =XLOOKUP(A1, Sheet1!A:A, Sheet1!E:E, "")             → Start Date
B4: =DATEDIF(B3, TODAY(), "Y")&" years"                   → Tenure

Common Excel Mistakes

Excel vs Google Sheets

Rule of thumb: Excel for serious data work and finance; Google Sheets for collaboration and automation via Sheets API.

Learning Path

Next steps

Once you're comfortable with Excel basics:

• Excel Formulas Cheat Sheet — complete formula reference
• Excel Interview Questions — prepare for Excel-heavy job interviews
• Excel to CSV Converter — convert Excel files instantly

FAQ

Do I need to pay for Excel to follow this tutorial? No. Excel Online is free at office.com. Google Sheets is also free and supports nearly all the formulas covered here.

What's the difference between a formula and a function? A formula is any expression starting with =. A function is a built-in named operation (SUM, VLOOKUP, IF). Most formulas use functions.

Should I learn VLOOKUP or XLOOKUP? If you have Excel 2019 or Microsoft 365, learn XLOOKUP — it's simpler and more powerful. Learn VLOOKUP too since you'll encounter it in older workbooks.

How do I protect a sheet so others can't edit it? Review → Protect Sheet → set a password and choose what's allowed. To protect the entire file: File → Info → Protect Workbook.

What's the fastest way to learn Excel? Practice on real data. Import a CSV of your actual expenses, sales, or work data and build something useful. Passive tutorials don't stick — building a real tracker does.

What's Power Query? Power Query (Data → Get & Transform) lets you import, clean, and reshape data from files, databases, and web sources without writing formulas. It's Excel's built-in ETL tool and one of the most valuable skills for data-heavy roles.