Excel Tutorial for Beginners: Learn Microsoft Excel Step by Step

Microsoft Excel is the world’s most widely used spreadsheet application, with more than 1.2 billion Microsoft Office users globally. Whether you need to track a household budget, manage customer data, or build a business report, this Excel tutorial walks you through everything you need — from opening the program for the first time to writing your first formula. No experience required.

Key Takeaways

• Microsoft Excel organizes data in rows, columns, and cells inside a workbook — mastering this grid is the first step.
• Six core functions — SUM, AVERAGE, COUNT, MIN, MAX, IF — handle 80% of everyday spreadsheet tasks.
• A genuine one-time license from The Software City gives you Microsoft Excel permanently, starting from $49.99, with no monthly subscription.

---

What Is Microsoft Excel?

Microsoft Excel is a spreadsheet program included in the Microsoft Office suite, first released in 1985 and now part of Microsoft 365. It stores data in a grid of rows and columns, lets you calculate values with formulas and functions, and visualizes data through charts and pivot tables.

Excel runs on Windows, macOS, iOS, and Android. The desktop version — available through Microsoft Office 2021 or Microsoft Office 2024 — offers the most complete feature set, including advanced data analysis tools, Power Query, and, as of January 2026, Agent Mode for AI-assisted automation.

Excel is used across virtually every industry. According to Microsoft’s own research, more than 750 million people use Excel or compatible spreadsheet tools in their professional lives. For beginners, the core skills covered in this guide are enough to handle the majority of real-world tasks.

---

How Do I Get Microsoft Excel?

You can get Microsoft Excel through a one-time license purchase or a Microsoft 365 subscription. A one-time purchase means you pay once and own the software permanently — no recurring fees.

Option 1: One-Time License (Recommended for Most Users)

The Software City sells genuine Microsoft Office licenses at significant savings versus retail pricing. All keys are 100% authentic, delivered digitally within 15–45 minutes, and backed by a 180-day warranty.

Product	Price	Best For
Microsoft Office 2024 Professional Plus	$199.99	Power users, full Office suite with Access and Publisher
Microsoft Office 2024 Home & Business	$189.99	Small business owners, includes Outlook
Microsoft Office Home 2024 (Windows)	$139.99	Home users who need Word, Excel, and PowerPoint
Microsoft Office 2021 Professional Plus	$64.99	Budget-conscious users who want a permanent license
Microsoft Office 2021 Home & Student	$49.99	Students and home users on a tight budget

For a deeper look at what each version includes, see our Office 2024 lifetime license guide or browse our selection of affordable Microsoft Office keys.

Option 2: Microsoft 365 Subscription

Microsoft 365 Personal costs $69.99 per year (approximately $5.83/month) and includes the latest Excel version plus cloud storage. A subscription makes sense if you want automatic feature updates or need to share licenses across multiple devices. If you prefer to pay once and be done with it, a one-time license is more economical over a 3–5 year period.

---

How Do I Start Learning Excel as a Beginner?

Start by learning the four core parts of the Excel interface: the Ribbon, cells, worksheets, and the workbook. Once you can navigate these confidently, every other skill builds naturally on top.

The Ribbon

The Ribbon is the toolbar at the top of the Excel window. It is organized into tabs — Home, Insert, Page Layout, Formulas, Data, Review, and View — each grouping related commands. The Home tab is where you will spend most of your time as a beginner: it contains formatting controls, alignment options, and the clipboard.

To use the Ribbon, click a tab to reveal its commands. For example, clicking Formulas shows all formula-related tools including the Function Library, which lists every built-in Excel function by category.

Cells, Rows, and Columns

The spreadsheet grid is made up of cells — the individual boxes where you enter data. Each cell has a unique address called a cell reference, formed by combining the column letter and the row number. For example:

• A1 = column A, row 1
• B3 = column B, row 3
• C10 = column C, row 10

Columns run vertically (A through XFD — 16,384 total). Rows run horizontally (1 through 1,048,576 total). A single Excel worksheet can therefore hold over 17 billion individual cells.

To navigate, click any cell to select it, or use the arrow keys on your keyboard. The Name Box (top-left corner, above column A) always shows the address of the currently selected cell.

Worksheets and Workbooks

A workbook is the Excel file itself (saved as .xlsx). Each workbook can contain multiple worksheets — the individual tabs at the bottom of the screen. By default, a new workbook opens with one sheet named “Sheet1.”

To add a new worksheet, click the + button next to the last sheet tab. To rename a sheet, double-click its tab and type a new name. Keeping related data on separate sheets — for example, one sheet per month — is a common and effective way to stay organized.

The Formula Bar

The Formula Bar sits just above the grid, below the Ribbon. When you click a cell, the Formula Bar shows the cell’s contents — either a typed value or a formula. You can also type and edit directly in the Formula Bar.

---

How to Enter and Format Data in Excel

Click a cell and start typing to enter data. Press Enter to confirm and move down one row, or press Tab to confirm and move right one column.

Data Types

Microsoft Excel recognizes three primary data types:

Data Type	Examples	How Excel Treats It
Numbers	42, 3.14, -100	Aligned right; usable in calculations
Text	“Revenue”, “John Smith”	Aligned left; not used in math
Dates & Times	4/5/2026, 9:00 AM	Stored as numbers; display format applies

Excel auto-detects the type when you type. If a number is stored as text (common when importing CSV files), formulas will not calculate it correctly. To convert, select the cells, click the warning icon, and choose Convert to Number.

Number Formatting

Raw numbers are hard to read without formatting. Select the cells you want to format, then use the Number Format dropdown in the Home tab’s Number group:

• General — Default, no specific format
• Number — Decimal places (e.g., 1,234.56)
• Currency — Adds $ symbol (e.g., $1,234.56)
• Percentage — Multiplies by 100 and adds % (e.g., 0.85 → 85%)
• Date — Displays date values in readable format (e.g., April 5, 2026)

For quick access, the Home tab shows dedicated buttons for Currency ($), Percentage (%), and Comma (,) formatting. You can also press Ctrl+1 to open the full Format Cells dialog for precise control.

Text and Alignment Formatting

Select the cells you want to style, then use the Home tab:

• Bold / Italic / Underline — Ctrl+B, Ctrl+I, Ctrl+U
• Font Size — Click the size box and type a number
• Fill Color — Click the paint bucket dropdown to add a background color
• Alignment — Left, Center, Right, or the Merge & Center button to combine cells across columns for headers

Adjusting Column Width and Row Height

If text appears cut off or numbers show as #####, the column is too narrow. Double-click the column border in the header row to auto-fit, or drag it manually to the desired width.

---

What Are the Basic Excel Formulas I Should Know?

The six most essential Excel formulas are SUM, AVERAGE, COUNT, MIN, MAX, and IF — these cover the majority of everyday calculation tasks for beginners and intermediate users alike.

All Excel formulas start with an equals sign (=). Everything after the = is the formula expression.

SUM — Add Numbers Together

Syntax: =SUM(number1, [number2], ...)

Adds all values in a range. This is the most-used formula in Microsoft Excel.

=SUM(B2:B10)       → Adds all values from B2 through B10
=SUM(B2, B5, B8)   → Adds only the specific cells listed

Tip: Select a range and press Alt+= to insert a SUM formula instantly.

AVERAGE — Calculate the Mean

Syntax: =AVERAGE(number1, [number2], ...)

Returns the arithmetic mean (sum divided by count) of a range.

=AVERAGE(C2:C20)   → Average of all values in C2 through C20

COUNT — Count Cells with Numbers

Syntax: =COUNT(value1, [value2], ...)

Counts how many cells in a range contain numeric values. Text cells are ignored.

=COUNT(D2:D50)     → Returns the number of cells in D2:D50 that contain numbers

Note: Use =COUNTA(D2:D50) to count cells that contain any value, including text.

MIN and MAX — Find Lowest and Highest Values

Syntax: =MIN(number1, [number2], ...) and =MAX(number1, [number2], ...)

=MIN(E2:E100)      → Returns the smallest value in the range
=MAX(E2:E100)      → Returns the largest value in the range

IF — Make Logical Decisions

Syntax: =IF(logical_test, value_if_true, value_if_false)

Returns one value if a condition is true and another if it is false. IF is the foundation of decision-making in Excel.

=IF(F2>=60, "Pass", "Fail")
→ If the value in F2 is 60 or more, display "Pass"; otherwise display "Fail"

=IF(G2>1000, G2*0.9, G2)
→ Apply a 10% discount if the value exceeds 1000; otherwise keep the original value

Quick Reference: Core Formulas

Formula	Purpose	Example
=SUM(A1:A10)	Total of a range	Monthly sales total
=AVERAGE(B1:B10)	Mean of a range	Average exam score
=COUNT(C1:C10)	Count numeric cells	Number of orders placed
=MIN(D1:D10)	Smallest value	Lowest price
=MAX(D1:D10)	Largest value	Highest score
=IF(E1>100,"Yes","No")	Conditional result	Bonus eligibility check

---

What Is the Difference Between Excel Formulas and Functions?

A formula is any expression that starts with = and performs a calculation. A function is a pre-built, named operation built into Microsoft Excel — like SUM or IF — that you use inside a formula.

Put another way: all functions are used inside formulas, but not all formulas use functions.

Formula without a function:

=A1+A2+A3

This is a valid formula. It adds three cells manually. No function is used.

Formula with a function:

=SUM(A1:A3)

This uses the SUM function to do the same thing — more efficiently, and scalable to any number of cells.

Formula combining multiple functions:

=IF(SUM(A1:A10)>1000, "Target Met", "Below Target")

This formula uses two functions — IF and SUM — nested together.

According to Microsoft’s official Excel documentation, Microsoft Excel 2024 contains over 500 built-in functions across 12 categories including Math, Statistical, Logical, Text, Date & Time, Lookup, and Financial. As a beginner, you only need a handful.

---

How to Create Charts and Graphs in Excel

Charts turn raw numbers into visuals that are easier to understand at a glance. Microsoft Excel supports 17 chart types including column, bar, line, pie, and scatter.

Step-by-Step: Insert a Chart

1. Select the data you want to chart, including headers. For example, select A1:B7 if column A has labels and column B has values.
2. Click the Insert tab in the Ribbon.
3. In the Charts group, choose a chart type. For beginners, Column Chart (vertical bars) or Line Chart (trends over time) are the most intuitive starting points.
4. Excel inserts the chart directly into the worksheet. Click and drag it to reposition.

Customizing Your Chart

Once the chart is selected, two new Ribbon tabs appear: Chart Design and Format.

• Chart Design → Add Chart Element — Add or remove a title, axis labels, data labels, and a legend.
• Chart Design → Change Chart Type — Switch between column, bar, pie, and other types without rebuilding.
• Format — Adjust colors, borders, and text styles for individual chart elements.

Best practice: Always add a chart title and label your axes. A chart without labels is difficult for anyone else — including yourself — to interpret later.

Choosing the Right Chart Type

Chart Type	Best For
Column / Bar	Comparing values across categories
Line	Showing trends over time
Pie	Showing parts of a whole (use for 5 or fewer slices)
Scatter	Showing the relationship between two numeric variables

---

How to Sort and Filter Data in Excel

Sorting and filtering let you reorder and narrow down large datasets without deleting any data.

Sorting Data

1. Click any cell inside the column you want to sort by.
2. Go to the Data tab.
3. Click Sort A to Z (ascending) or Sort Z to A (descending).

For multi-level sorting — for example, sort by Department first, then by Last Name within each department — click the Sort button (not the quick buttons) to open the full Sort dialog. Use Add Level to add secondary and tertiary sort criteria.

Filtering Data

Filters let you show only the rows that meet specific criteria.

1. Click any cell inside your data table.
2. Go to the Data tab and click Filter. Dropdown arrows appear in the header row.
3. Click a dropdown arrow on any column header to filter by that column’s values.
4. Check or uncheck values, or use Number Filters / Text Filters for conditions like “greater than 500” or “contains the word ‘North’.”

To remove all filters and show all rows again, click Filter in the Data tab a second time to toggle it off.

Tip: Use Ctrl+Shift+L to toggle filters on and off quickly.

---

How to Use Conditional Formatting in Excel

Conditional formatting automatically changes a cell’s appearance — color, font, or icon — based on its value. It is one of the fastest ways to make patterns and outliers visible in a dataset.

Apply a Basic Rule

1. Select the range you want to format (e.g., B2:B20).
2. Go to Home → Conditional Formatting → Highlight Cells Rules.
3. Choose a rule type, such as:
4. Greater Than — Highlight cells above a threshold (e.g., sales over $10,000 shown in green)
5. Less Than — Highlight cells below a threshold (e.g., scores below 60 shown in red)
6. Duplicate Values — Flag repeated entries

Color Scales and Data Bars

Two especially useful options for beginners:

• Color Scales (Home → Conditional Formatting → Color Scales) — Applies a gradient from one color to another across the selected range. A green-to-red scale, for example, instantly shows which values are highest and lowest without reading every number.
• Data Bars (Home → Conditional Formatting → Data Bars) — Inserts a mini bar chart inside each cell, proportional to its value.

Managing Rules

To edit or delete existing rules, go to Home → Conditional Formatting → Manage Rules. This opens a dialog showing all rules applied to the current selection, with options to edit, delete, or change priority order.

---

Essential Excel Keyboard Shortcuts

Learning keyboard shortcuts is one of the fastest ways to work faster in Microsoft Excel. The shortcuts below cover navigation, selection, formatting, and data entry.

Action	Windows Shortcut	Mac Shortcut
Select entire column	Ctrl+Space	Control+Space
Select entire row	Shift+Space	Shift+Space
Select all cells (Ctrl+A)	Ctrl+A	Command+A
Move to last used cell	Ctrl+End	Command+End
Move to cell A1	Ctrl+Home	Command+Home
Jump to edge of data	Ctrl+Arrow key	Command+Arrow key
Insert SUM formula	Alt+=	Command+Shift+T
Bold selected cells	Ctrl+B	Command+B
Open Format Cells dialog	Ctrl+1	Command+1
Copy	Ctrl+C	Command+C
Paste	Ctrl+V	Command+V
Undo	Ctrl+Z	Command+Z
Find & Replace	Ctrl+H	Command+H
Save workbook	Ctrl+S	Command+S
Add new worksheet	Shift+F11	Fn+Shift+F11
Toggle AutoFilter	Ctrl+Shift+L	Command+Shift+F

Pro tip: Press F2 to enter edit mode on the selected cell — useful when you need to modify a formula without retyping it from scratch.

---

What Are the Next Steps After Learning Excel Basics?

Once you are comfortable with the core skills in this tutorial, four areas will significantly expand what you can do in Microsoft Excel.

Pivot Tables

Pivot tables are the single most powerful data analysis tool in Excel for non-programmers. They let you summarize thousands of rows in seconds — grouping, counting, and totaling data by any dimension without writing a single formula. A future post in this Excel cluster will walk through pivot tables step by step.

VLOOKUP and XLOOKUP

Lookup functions let you pull data from one table into another by matching on a key value — for example, looking up a product name by its ID number. VLOOKUP has been the standard for decades; XLOOKUP (introduced in Microsoft Excel 2019) is more flexible and easier to use. Both are essential for anyone who works with relational data.

Macros and VBA

Macros record repetitive actions and replay them with a single click. For tasks you perform identically every week — formatting a report, importing a file, running calculations — a macro can save hours per month. Microsoft Excel’s built-in Macro Recorder requires no programming experience to use.

Power Query

Power Query is a data transformation tool built into Microsoft Excel 2016 and later. It connects to external data sources — databases, web pages, CSV files, SharePoint lists — cleans and reshapes the data, and loads it into Excel automatically. As of 2026, Power Query web connections are generally available in all Microsoft 365 and Office 2024 editions according to Microsoft’s release notes. It is the tool that bridges everyday Excel work with professional-grade data workflows.

---

Frequently Asked Questions

---