Need Help Understanding Basic Features in Microsoft Excel

Question

Hi everyone,

I’m completely new to Microsoft Excel and still learning the basics. I’m trying to understand how to use it properly, but I’m getting confused with some of the features and settings.

I would really appreciate beginner-friendly guidance or simple step-by-step instructions. If there are any tutorials or tips that helped you when you started, please share them as well.

Thanks in advance for your patience and help!

Answer 1

Hi tech with lib

Thank you for reaching out to the Microsoft Q&A forum.

If you're just getting started with Excel, I’d recommend first reviewing the Q&A Assist response below, which covers some helpful beginner basics such as:

• Rows, columns, and cells
• Entering and formatting data
• Simple formulas like SUM and AVERAGE
• Sorting and filtering data
• Saving and printing workbooks

You can also refer to the official Microsoft Excel learning page here: Excel help & learning

If there’s a specific feature or task you’re confused about, please feel free to share more details and I’ll be happy to help further.

Have a great day.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".      

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Here are some beginner-friendly basics and steps to get started with Excel.

1. Open Excel and create a workbook

• On Windows: Press the Windows key, type Excel, and press Enter.
• To create a new blank workbook:
  • When Excel opens, on the Home menu press Alt+H, Y, 2, or
  • If Excel is already open, press Ctrl+N to create a new workbook.
• Excel files are called workbooks. Each workbook contains one or more worksheets (tabs at the bottom). Use Shift+F11 to quickly add a new worksheet.

2. Understand cells, rows, and columns

• A worksheet is a grid of columns (A, B, C, …) and rows (1, 2, 3, …).
• Each box is a cell, identified by its column and row, for example A1.
• On a new sheet, A1 is usually the first active cell.

3. Enter basic data

• Click or move to an empty cell (for example A1).
• Type text or a number.
• Press Enter to move down or Tab to move right.
• To quickly fill a series (like months or years):
  1. Type Jan in one cell and Feb in the next, or 2014 and 2015 in two cells.
  2. Select both cells.
  3. Drag the small square (fill handle) at the bottom-right corner across or down to fill the pattern.

4. Do simple calculations with formulas Excel can add, subtract, multiply, and divide.

Basic steps:

1. Click the cell where the result should appear.
2. Type an equal sign = (this tells Excel it’s a formula).
3. Type numbers and operators:
   • + for addition
   • - for subtraction
   • * for multiplication
   • / for division
4. Press Enter.

Examples:

• =2+4
• =4-2
• =2*4
• =4/2

5. Quickly add a list of numbers with AutoSum If there is a column or row of numbers:
6. Click the cell directly below (for a column) or to the right (for a row) of the numbers.
7. On the Home tab, in the Editing group, click AutoSum.
8. Press Enter to accept the suggested range and see the total.
9. Format numbers (currency, dates, percentages) To make numbers easier to read:
10. Select the cells with numbers.
11. On the Home tab, in the Number group, click the arrow in the General box.
12. Choose a format such as Currency, Percentage, or Date.
13. Add borders and shading for readability

• Borders:
  1. Select the cell or range.
  2. On the Home tab, in the Font group, click the arrow next to Borders.
  3. Choose a border style (e.g., All Borders).
• Shading (fill color):
  1. Select the cell or range.
  2. On the Home tab, in the Font group, click the arrow next to Fill Color.
  3. Pick a color under Theme Colors or Standard Colors.

8. Save and print your work (basics)

• Use Ctrl+S to save for the first time and choose a file name and location.
• To print, use Ctrl+P and review the print preview before sending to the printer.

9. Learn with built-in templates and tutorials

• In Excel, go to File > New and search for words like learning or tutorial to find guided templates.
• There are also walkthrough templates such as:
  • Excel Formulas (common formulas with real examples)
  • Excel PivotTables (for summarizing data)

10. If using a screen reader Excel supports screen readers on Windows, macOS, and mobile:

• On Windows, use keyboard shortcuts like Shift+F11 to add a sheet, Ctrl+N for a new workbook, and Alt key sequences to navigate the ribbon.
• On Mac with VoiceOver, open Excel from Finder (Shift+Command+A, then find Microsoft Excel) and create a new workbook with Command+N.
• On mobile, use touch gestures plus the on-screen keyboard to enter data and menus to apply number formats like Currency or Percentage.

For more structured learning, step-by-step training is available for Excel, Word, PowerPoint, and Outlook in the official help and learning pages.

---

References:

• Video: Intro to Office Basics
• Quick tips: Get work done with Excel for Windows
• Basic tasks in Excel
• Try it with templates
• Basic tasks using a screen reader with Excel