← Back
LESSON 01

Excel Basics

Excel kya hai, iska use kahan hota hai aur Excel ka basic interface kaise samjhein.

📘 Excel Kya Hai?

Hindi: Microsoft Excel ek spreadsheet software hai. Iska use data ko store, organize, calculate aur analyze karne ke liye kiya jata hai.

English: Microsoft Excel is a spreadsheet application used to store, organize, calculate and analyze data.

💡 Excel Ka Use Kahan Hota Hai?

Excel ka use bahut saare business aur office kaamon mein hota hai.

• Sales Data
• Employee Data
• Customer Data
• Lead Data
• Expenses
• Salary Records
• Stock Management
• Reports
• Dashboards

📂 Workbook Kya Hai?

Hindi: Excel mein jo complete file hoti hai, use Workbook kaha jata hai.

Example:

Sales_Report.xlsx

Ye ek Excel Workbook hai.

📄 Worksheet Kya Hai?

Ek Excel Workbook ke andar multiple Worksheets ho sakti hain.

Example:

Sheet1
Sheet2
Sheet3

Har worksheet mein alag data rakha ja sakta hai.

➡️ Row Kya Hai?

Excel mein horizontal line ko Row kaha jata hai.

Rows numbers se identify hoti hain.

Row 1
Row 2
Row 3
Row 4

⬇️ Column Kya Hai?

Excel mein vertical line ko Column kaha jata hai.

Columns letters se identify hote hain.

Column A
Column B
Column C
Column D

🔲 Cell Kya Hai?

Row aur Column ke intersection ko Cell kaha jata hai.

Example:

A1
B2
C3
D4

A1 ka matlab hai Column A aur Row 1.

📊 Excel Mein Data

Excel mein different types ka data enter kiya ja sakta hai.

Name Age City
Rahul 22 Kanpur
Amit 24 Delhi
Priya 21 Lucknow

🖥️ Excel Interface

Excel open karne par aapko kuch important parts dikhai dete hain.

• Ribbon
• Toolbar
• Formula Bar
• Name Box
• Rows
• Columns
• Cells
• Sheet Tabs

✍️ Excel Mein First Data

Kisi cell par click karke data type kiya ja sakta hai.

A1 → Name
A2 → Som Prakash
A3 → Rahul
A4 → Amit

Enter press karne par data cell mein save ho jata hai.

💾 Excel File Save Karna

Excel file save karne ke liye:

Ctrl + S

Pehli baar save karte waqt file ka naam aur location choose karni hoti hai.

⚠️ Important Note

Excel seekhne ke liye sabse pehle Workbook, Worksheet, Row, Column aur Cell ko achhe se samajhna important hai.

Ye Excel ke basic building blocks hain.

🎓 Lesson Summary

Is lesson mein humne seekha:

✅ Excel kya hai
✅ Workbook
✅ Worksheet
✅ Row
✅ Column
✅ Cell
✅ Excel Data
✅ Excel Interface
✅ File Save Karna

← All Courses Next Lesson →