Day 1: Excel Interface aur Basic Navigation
1. Excel Interface ko Samajhna (The Layout)
Jab aap Excel open karte hain, toh sabse pehle in main cheezon se samna hota hai:
- Ribbon: Sabse upar ka menu bar jahan saare tools (Home, Insert, Page Layout) hote hain.
- Workbook vs Worksheet: Poori file ko Workbook kehte hain, aur uske andar jo alag-alag pages hote hain unhe Worksheet (ya Sheet) kehte hain.
- Rows, Columns, aur Cells:
- Vertical (khadi) lines ko Columns kehte hain (A, B, C…).
- Horizontal (leti hui) lines ko Rows kehte hain (1, 2, 3…).
- Jahan Row aur Column milte hain, us dibbe ko Cell kehte hain (jaise Column A aur Row 1 milkar banate hain Cell A1).
2. Basic Data Entry (Data Kaise Likhein)
- Kisi bhi cell par click karke aap type karna shuru kar sakte hain.
- Enter dabane se aap niche wale cell me chale jayenge.
- Tab dabane se aap aage (right side) wale cell me chale jayenge.
3. File ko Save aur Open Karna
- Apne kaam ko safe rakhne ke liye
Ctrl + Sdabakar file ko save karna seekhein. - New file ke liye
Ctrl + Naur purani file open karne ke liyeCtrl + Oka use hota hai.
💡 Day 1 Pro-Tip: Excel me excel karne ka sabse bada secret hai ki aap mouse ka use kam se kam karein. Pehle din se hi keyboard ke arrow keys ($\leftarrow, \uparrow, \downarrow, \rightarrow$) se cells me ghoomna shuru kijiye.
| Shortcut Key | Action / Function | Category |
|---|---|---|
| Enter | Niche wale cell me jaane ke liye (Move down) | Basic Navigation & Data Entry |
| Tab | Aage (Right side) wale cell me jaane ke liye (Move right) | Basic Navigation & Data Entry |
| Ctrl + S | File ko save karne ke liye (Save Workbook) | File Management |
| Ctrl + N | New file (Workbook) open karne ke liye | File Management |
| Ctrl + O | Purani file open karne ke liye | File Management |
| Arrow Keys (←, ↑, ↓, →) | Cells me ghoomne ke liye (Mouse ke bina navigation) | Basic Navigation |