Microsoft Excel Beginner Guide
1. Getting Started
- Workbook: Your Excel file
- Worksheet: Each tab in Excel
- Cell: A single box (e.g., A1)
- Ribbon: Toolbar at the top
2. Basic Data Entry
- Click on a cell and type
- Press Enter to go down
- Use Tab to move right
3. Formatting Data
- Change font, size, color using the Home tab
- Use Bold (Ctrl+B), Italic (Ctrl+I)
- Format numbers: %, Currency, Date
4. Basic Formulas
- Start with '=' to write a formula
- Example: =A1+B1 (adds two cells)
- Common functions:
=SUM(A1:A5)
=AVERAGE(A1:A5)
5. Charts
- Select data, then go to Insert tab and choose chart (Bar, Pie, Line)
6. Saving & Printing
- File > Save As to save your work
- File > Print to print
- Use Print Preview to check layout
7. Keyboard Shortcuts
- Ctrl + C: Copy
- Ctrl + V: Paste
- Ctrl + Z: Undo
- Ctrl + S: Save
Tip: Practice makes perfect! Start using Excel for small tasks like budgets, to-do lists, or simple data
tables.