Guides

Excel for Beginners: Your First Hour, Step by Step

Brand new to Excel? Learn the screen, how to enter and format data, select cells and write your first formula in about an hour.

By ExcelPanda Team · Published · 5 min read

What you are looking at

The main parts of the Excel window

PartWhat it is
CellOne box in the grid, such as B2
Name BoxShows which cell is selected (top left)
Formula barShows and edits what is inside the selected cell
RibbonThe tabs and buttons across the top
Sheet tabsSwitch between sheets at the bottom

Enter and edit data

Click a cell and start typing. Press Enter to confirm and move down, or Tab to confirm and move right. Press F2 to edit a cell without retyping it, and Delete to clear it. Keep each kind of data in its own column with a heading on top, for example Date, Item, Amount.

Select and move around

Use the arrow keys to move one cell at a time. Hold Shift with an arrow to select a range. Click a column letter or row number to select the whole column or row. Picking the right cells quickly is a skill worth building early.

Format your data

  • Bold the headings so they stand out (Ctrl+B, or Cmd+B on a Mac).
  • Set number formats for currency, percentages or dates from the Home tab, rather than typing symbols.
  • Widen columns by double-clicking the border between two column letters.

Your first formula

Put numbers in B2 to B6, click B7, type =SUM(B2:B6) and press Enter. Excel adds the five cells. Change one of them and the total updates. That is the idea behind everything else in Excel. Continue with Excel formulas for beginners.

Save your work

Save with Ctrl+S (Cmd+S on a Mac) and give the file a clear name. If you use Excel through OneDrive, it saves automatically. Press Ctrl+Z (Cmd+Z) to undo a mistake.

What to learn next

Follow the 30-day plan, or jump to the functions worth learning first.

Frequently asked questions

How long does it take to learn the basics of Excel?

Most people can enter data, format it and write simple formulas within a few hours of practice. Getting fluent takes longer and comes from using Excel on real tasks.

What is the difference between a workbook and a worksheet?

A workbook is the whole Excel file. A worksheet is one tab (sheet) inside it.

Do I need to buy Excel to learn it?

No. Excel for the web is free with a Microsoft account, and it covers the basics in this guide. You can also practise in the ExcelPanda lessons.

Should I learn shortcuts straight away?

Learn a few early, like moving with the arrow keys and fill down, then add more over time. See Excel keyboard shortcuts.

Sources and disclaimers

ExcelPanda is not affiliated with or endorsed by Microsoft. Microsoft and Excel are trademarks of the Microsoft group of companies.