Excel for beginners can feel intimidating at first, with its endless grid of cells and mysterious buttons, but the core skills are surprisingly easy to learn. Microsoft Excel is the world’s most widely used spreadsheet program, trusted for budgets, schedules, invoices, data tracking, and analysis in homes and offices everywhere. Once you understand a handful of basics, you can build genuinely useful spreadsheets in minutes.
This complete guide starts at the very beginning: how the Excel screen is laid out, how to enter and edit data, how to write your first formulas, and how to format a spreadsheet so it looks clean and professional. Every example is concrete and something you can try yourself, so by the end you will have real, transferable skills rather than just theory.
Understanding the Excel Screen
When you open Excel, you see a grid made of cells. Columns run vertically and are labeled with letters (A, B, C), while rows run horizontally and are numbered (1, 2, 3). Each cell has a unique address like C5. At the top is the Ribbon, a toolbar organized into tabs such as Home, Insert, and Formulas. Just below it, the Name Box shows the address of the selected cell, and the Formula Bar shows what that cell contains. At the bottom, sheet tabs let you keep several spreadsheets inside one file.
How to Enter and Edit Data
Getting information into a spreadsheet is the first real skill.
- Select a cell. Click any cell, for example A1, to make it active. A green border shows which cell is selected.
- Type your data. Enter text, numbers, or dates. Press Enter to move down or Tab to move to the right.
- Edit existing content. Double-click a cell to edit inside it, or click it once and retype to replace it completely.
- Use autofill. Type a value, then drag the small square at the bottom-right corner of the cell to copy it or continue a series like Jan, Feb, Mar.
- Adjust column width. If text is cut off, double-click the line between column letters to auto-fit, or drag it to resize manually.
- Save your workbook. Press Ctrl+S, choose a location such as OneDrive or your computer, and give the file a name.
- Undo mistakes. Press Ctrl+Z to undo the last action, which is your safety net while learning.
Writing Your First Formulas
Formulas are the heart of Excel. Every formula starts with an equals sign, which tells Excel to calculate rather than display text. You can do basic math by typing =5+3 or reference cells with =A1+A2. Functions are pre-built shortcuts for common tasks. The essential starter functions are SUM to total numbers, AVERAGE for the mean, COUNT to count entries, and MAX and MIN for the highest and lowest values.
Relative vs Absolute References
When you copy a formula, Excel adjusts cell references automatically. Copying =A1*B1 down a column becomes =A2*B2, then =A3*B3, which is exactly what you want for row-by-row math. To keep a reference fixed, add dollar signs to make it absolute, like =A2*$B$1. Now B1 stays locked no matter where you copy the formula, which is perfect for a single shared value such as a tax rate. Press the F4 key while editing to add the dollar signs instantly.
Practice entering a simple list, like a weekly budget, and total it with =SUM. Getting comfortable with typing data, pressing Enter, and reading cell addresses builds the foundation for everything else.
Once totals feel easy, explore the IF function for decisions, sorting and filtering to organize data, and charts under the Insert tab to turn numbers into a visual.
Formatting Your Spreadsheet
Formatting makes data readable and professional. From the Home tab you can bold headers, change fonts and colors, and apply number formats like currency, percentage, or date. Use borders to define the edges of a table and shading to highlight important rows. Conditional formatting, found on the Home tab, automatically changes a cell’s color based on its value, such as turning low stock numbers red so problems jump out instantly.
Essential Excel Shortcuts
| Action | Windows | Mac |
|---|---|---|
| Save | Ctrl + S | Cmd + S |
| Copy | Ctrl + C | Cmd + C |
| Paste | Ctrl + V | Cmd + V |
| Undo | Ctrl + Z | Cmd + Z |
| Lock reference (F4) | F4 | Cmd + T |
Want to keep building your skills? Explore more tutorials in our how-to guides collection.
Frequently Asked Questions
Is Excel hard to learn for beginners?
No. The basics of entering data, writing simple formulas, and formatting cells can be learned in a few hours. Excel gets deep with advanced features, but everyday tasks are approachable for anyone willing to practice.
Do I have to pay for Excel?
The full desktop app requires a Microsoft 365 subscription or a one-time Office purchase. However, Excel for the web is free with a Microsoft account, and it covers the beginner features described in this guide.
What does the equals sign do in Excel?
The equals sign tells Excel that the cell contains a formula to calculate, not plain text. Typing =2+2 shows 4, while typing 2+2 without the equals sign just displays the text “2+2.”
How do I add up a column quickly?
Click the cell below your numbers and press Alt and the equals sign together (AutoSum). Excel guesses the range and inserts a SUM formula. Press Enter to confirm and see the total.
What is the difference between a workbook and a worksheet?
A workbook is the entire Excel file, while a worksheet is a single tabbed page inside it. One workbook can contain many worksheets, which is handy for keeping related data, like monthly budgets, in one file.
