Skip to main content

📊 Class-01: Microsoft Excel-āĻāϰ āĻ“āĻ­াāϰāĻ­িāω āϞে-āφāωāϟ : Microsoft Excel Overview.


📊 Microsoft Excel-āĻāϰ āĻ“āĻ­াāϰāĻ­িāω āϞে-āφāωāϟ


🔷 1. āϟাāχāϟেāϞ āĻŦাāϰ (Title Bar)

  • āĻāĻ•্āϏেāϞেāϰ āωāĻĒāϰেāϰ āĻ…ংāĻļে, āϝেāĻ–াāύে āĻĢাāχāϞেāϰ āύাāĻŽ āĻĨাāĻ•ে।

  • āĻĄাāύ āĻĒাāĻļে: Save, Undo, Redo āĻŦোāϤাāĻŽ āĻĨাāĻ•ে।


🔷 2. āĻŽেāύু āĻŦা āϰিāĻŦāύ (Ribbon Menu)

Excel-āĻāϰ āĻĒ্āϰāϧাāύ āĻĢিāϚাāϰ āĻ“ āϟুāϞāĻ—ুāϞো āĻāĻ–াāύে āĻĨাāĻ•ে। āĻāϟি āĻ•ā§ŸেāĻ•āϟি āϟ্āϝাāĻŦে āĻŦিāĻ­āĻ•্āϤ:

📁 Home Tab

  • āĻĢāϰāĻŽ্āϝাāϟিং: āĻĢāύ্āϟ, āĻ•াāϞাāϰ, āĻ…āϞাāχāύāĻŽেāύ্āϟ

  • āĻ•āĻĒি/āĻĒেāϏ্āϟ, āϏেāϞ āĻŽাāϰ্āϜ

  • āĻ…āϟো āϏাāĻŽ (AutoSum)

Insert Tab

  • āϚাāϰ্āϟ (Chart), āϟেāĻŦিāϞ, āĻĒিāĻ­āϟ āϟেāĻŦিāϞ, āĻ›āĻŦি, āĻļেāĻĒāϏ āχāϤ্āϝাāĻĻি

📐 Page Layout

  • āĻĒেāϜ āĻŽাāϰ্āϜিāύ, āĻ“āϰি⧟েāύ্āϟেāĻļāύ, āĻĒ্āϰিāύ্āϟ āĻāϰি⧟া

📊 Formulas

  • āĻĢাংāĻļāύ āϞাāχāĻŦ্āϰেāϰি, āύাāĻŽ āĻĄিāĻĢাāχāύ, āϤ্āϰুāϟি āϚেāĻ• āχāϤ্āϝাāĻĻি

🧩 Data

  • āĻĢিāϞ্āϟাāϰ, āϏāϰ্āϟ, āĻĄেāϟা āχāĻŽ্āĻĒোāϰ্āϟ, āĻĄেāϟা āϟুāϞāϏ (Remove duplicates)

🔒 Review

  • Spell check, Comment, Sheet protect

👀 View

  • Zoom, Gridlines, Page Break View, Freeze Panes


🔷 3. āύাāĻŽ āĻŦāĻ•্āϏ āĻ“ āĻĢাংāĻļāύ āĻŦাāϰ (Name Box & Formula Bar)

  • Name Box: āĻ•োāύ āϏেāϞ āϏিāϞেāĻ•্āϟ āĻ•āϰা āĻšā§ŸেāĻ›ে āϤা āĻĻেāĻ–া⧟ (āϝেāĻŽāύ: A1)

  • Formula Bar: āĻĢāϰ্āĻŽুāϞা āĻŦা āĻĄাāϟা āĻāĻĄিāϟ āĻ•āϰাāϰ āϜা⧟āĻ—া


🔷 4. āĻ“ā§Ÿাāϰ্āĻ•āĻļিāϟ āĻāϰি⧟া (Worksheet Area)

  • Row (āϏাāϰি): 1, 2, 3,...

  • Column (āĻ•āϞাāĻŽ): A, B, C,...

  • āĻĒ্āϰāϤিāϟি āϏেāϞ (Cell) āĻāĻ•āϟি āύিāϰ্āĻĻিāώ্āϟ Row āĻ“ Column āĻĻ্āĻŦাāϰা āύিāϰ্āĻĻেāĻļিāϤ āĻšā§Ÿ, āϝেāĻŽāύ: B4


🔷 5. āĻļিāϟ āϟ্āϝাāĻŦ (Sheet Tabs)

  • āĻāĻ•্āϏেāϞেāϰ āύিāϚে āĻĨাāĻ•ে

  • āφāĻĒāύি āĻāĻ•াāϧিāĻ• āĻ“ā§Ÿাāϰ্āĻ•āĻļিāϟ āϤৈāϰি āĻ•āϰāϤে āĻĒাāϰেāύ (Sheet1, Sheet2...)


🔷 6. āϏ্āϟ্āϝাāϟাāϏ āĻŦাāϰ (Status Bar)

  • āĻāĻ•্āϏেāϞেāϰ āύিāϚে āĻĨাāĻ•ে

  • āĻāĻ–াāύে Sum, Average, Count āχāϤ্āϝাāĻĻি āĻ…āϟো-āĻļো āĻ•āϰে āϝāĻ–āύ āφāĻĒāύি āĻāĻ•াāϧিāĻ• āϏেāϞ āϏিāϞেāĻ•্āϟ āĻ•āϰেāύ

Comments