Excel File & Workbook
Excel file, workbook aur worksheet ko simple way mein samjhein.
📘 Excel File Kya Hoti Hai?
Excel mein jab hum apna data save karte hain, to woh ek Excel file ke andar save hota hai.
Excel ki normal file ka extension .xlsx hota hai.
Example: Agar aap kisi company ka sales data Excel mein bana rahe hain, to us file ka naam sales-data.xlsx ho sakta hai.
📂 Workbook Kya Hai?
Excel mein jo complete file hoti hai, use Workbook kaha jata hai.
Ek workbook ke andar ek ya ek se zyada worksheets ho sakti hain.
Example
Yahan Company.xlsx ek workbook hai aur iske andar multiple worksheets hain.
📄 Worksheet Kya Hai?
Workbook ke andar jo individual sheet hoti hai, use Worksheet kaha jata hai.
Excel open karne par neeche Sheet1, Sheet2 jaise tabs dikh sakte hain.
Example
✏️ Worksheet Ka Naam Change Karna
Excel mein worksheet ka naam change karna bahut simple hai.
- Sheet tab par Right Click karein.
- Rename option select karein.
- Naya naam type karein.
- Enter press karein.
Example
➕ New Excel Workbook
Naya Excel workbook create karne ke liye Excel open karke Blank Workbook select kar sakte hain.
Keyboard shortcut:
Isse ek new workbook create ho sakta hai.
📂 Excel File Open Karna
Existing Excel file open karne ke liye keyboard shortcut use kar sakte hain.
Iske baad computer mein saved Excel file select karke open kar sakte hain.
💾 Save As
Agar aap Excel file ko kisi naye naam ya naye location par save karna chahte hain, to Save As use kar sakte hain.
Example
📊 Multiple Worksheets
Ek workbook mein multiple worksheets rakhna business data ke liye bahut useful hota hai.
Business Example
Isse different types ka data ek hi workbook mein organized rakha ja sakta hai.
📁 Important Excel File Types
- .xlsx — Modern Excel workbook
- .xls — Older Excel workbook format
- .csv — Comma Separated Values data file
📝 Lesson Summary
- Excel file mein data save hota hai.
- Excel file ka common extension .xlsx hai.
- Workbook complete Excel file hoti hai.
- Worksheet workbook ke andar ek sheet hoti hai.
- Ek workbook mein multiple worksheets ho sakti hain.
- Worksheet ka naam change kiya ja sakta hai.
- Ctrl + N se new workbook create kiya ja sakta hai.
- Ctrl + O se file open ki ja sakti hai.
- Ctrl + Shift + S se Save As kiya ja sakta hai.