đģ āĻāĻŽ্āĻĒিāĻāĻাāϰ, āĻুāĻāϞ āĻĄāĻ্āϏ, āĻāĻŦং āĻāĻ্āϏেāϞ āĻļীāĻ āĻļেāĻাāϰ āϏāĻŽ্āĻĒূāϰ্āĻŖ āĻাāĻāĻĄ
āĻāĻŽ্āĻĒিāĻāĻাāϰ āĻļিāĻāϤে āĻেāϞে āĻŽূāϞāϤ āϤিāύāĻি āĻŦিāώāϝ় āĻাāϞোāĻাāĻŦে āĻাāύা āĻāϰুāϰি:
āĻāĻŽ্āĻĒিāĻāĻাāϰ āĻŦেāϏিāĻ
āĻুāĻāϞ āĻĄāĻ্āϏ (Google Docs)
āĻāĻ্āϏেāϞ āĻļীāĻ (Microsoft Excel / Google Sheets)
āĻāĻ āĻāϰ্āĻিāĻেāϞāĻি Step-by-Step āϏাāĻাāύো āĻšāϝ়েāĻে Beginner āĻĨেāĻে Advanced āĻĒāϰ্āϝāύ্āϤ।
ā§§️⃣ āĻāĻŽ্āĻĒিāĻāĻাāϰ āĻŦেāϏিāĻ
đš āĻিāĻŦোāϰ্āĻĄ āĻāĻŦং āĻŽাāĻāϏ āĻŦ্āϝāĻŦāĻšাāϰ
āĻিāĻŦোāϰ্āĻĄ: āĻাāĻāĻĒিং, āĻļāϰ্āĻāĻাāĻ (Ctrl+C, Ctrl+V, Ctrl+Z)
āĻŽাāĻāϏ: āĻ্āϞিāĻ, āĻĄাāĻŦāϞ-āĻ্āϞিāĻ, āĻĄ্āϰ্āϝাāĻ & āĻĄ্āϰāĻĒ
đš Desktop āĻāĻŦং Window Management
Desktop: Shortcuts, Icons
Taskbar: Active Programs āĻĻেāĻা, Minimize/Maximize
File Explorer: āĻĢাāĻāϞ āĻোঁāĻা, āĻĢোāϞ্āĻĄাāϰ āϤৈāϰি, āĻāĻĒি-āĻĒেāϏ্āĻ, āĻĄিāϞিāĻ
đš Software Installation
Microsoft Office, Browser, Antivirus
Updates & Driver Install
⧍️⃣ āĻুāĻāϞ āĻĄāĻ্āϏ (Google Docs)
Google Docs āĻšāϞো Online Word Processor, āϝা Microsoft Word-āĻāϰ āĻ āύāϞাāĻāύ āϏংāϏ্āĻāϰāĻŖ।
Step-by-Step āĻļেāĻাāϰ āϧাāĻĒ
ā§§. Google Docs āĻুāϞা
Google Chrome āĻāĻĒেāύ āĻāϰুāύ
https://docs.google.com� āĻ āϝাāύ
Gmail Account āĻĻিāϝ়ে āϞāĻāĻāύ āĻāϰুāύ
Blank Document āĻŦা Template āύিāϰ্āĻŦাāĻāύ āĻāϰুāύ
⧍. Basic Tools
Title Rename: Top-left Name āĻ্āϞিāĻ āĻāϰে āύাāĻŽ āĻĻিāύ
Text Typing: āĻিāĻŦোāϰ্āĻĄ āĻĻিāϝ়ে āϞিāĻুāύ
Formatting:
Bold → Ctrl + B
Italic → Ctrl + I
Underline → Ctrl + U
Font Change → Toolbar āĻĨেāĻে Font Dropdown
Font Size → Toolbar
ā§Š. Paragraph & Alignment
Left / Center / Right Alignment
Line Spacing
Bullets & Numbering
ā§Ē. Insert Items
Image → Insert → Image → Upload / Web
Table → Insert → Table → Rows & Columns
Link → Ctrl + K
Header & Footer → Insert → Header/Footer
ā§Ģ. Sharing & Collaboration
Share Button Click
Email āĻĻিāϝ়ে Invite
Can Edit / Can Comment / Can View
ā§Ŧ. Advanced Features
Voice Typing → Tools → Voice Typing
Explore → Automatic Suggestions
Add-ons → Extra Features
ā§Š️⃣ āĻāĻ্āϏেāϞ āĻļীāĻ (Microsoft Excel / Google Sheets)
āĻāĻ্āϏেāϞ āĻļীāĻ āĻšāϞো Data Management Tool, āϝা āĻšিāϏাāĻŦ, āϰিāĻĒোāϰ্āĻ, āĻ্āϰাāĻĢ, āĻāĻŦং āĻŦিāĻļ্āϞেāώāĻŖ āϤৈāϰি āĻāϰāϤে āϏাāĻšাāϝ্āϝ āĻāϰে।
Step-by-Step āĻļেāĻাāϰ āϧাāĻĒ
ā§§. Excel/Sheets Open
Microsoft Excel: Start → Excel → Blank Workbook
Google Sheets: https://sheets.google.com�
⧍. Cells & Worksheets
Cell: Row & Column-āĻāϰ Intersection
Active Cell: āϝেāĻাāύে āĻাāĻāĻĒ āĻāϰāĻŦেāύ
Sheet Tabs: āύিāĻে Sheet1, Sheet2
ā§Š. Basic Operations
Data Typing (Text / Number / Date)
Copy / Paste → Ctrl+C, Ctrl+V
AutoFill → Cell Drag āĻāϰে āĻĒুāύāϰাāĻŦৃāϤ্āϤি
Column/Row Adjust → Resize
ā§Ē. Basic Formulas
SUM: =SUM(A1:A5)
AVERAGE: =AVERAGE(A1:A5)
MIN/MAX: =MIN(A1:A5), =MAX(A1:A5)
Basic Arithmetic: =A1+B1, =A1-B1
ā§Ģ. Formatting
Font, Color, Bold
Conditional Formatting
Borders & Cell Styles
ā§Ŧ. Charts & Graphs
Select Data → Insert → Chart
Column, Pie, Line Charts
Chart Customization (Title, Legend, Color)
ā§. Advanced Excel
IF Formula → =IF(A1>50, "Pass", "Fail")
VLOOKUP → Data Search
Pivot Table → Complex Analysis
Data Validation → Dropdown Lists
Filters & Sorting → Sort A-Z, Z-A, Custom Filter
ā§Ž. Google Sheets Extra Features
Auto Save (Cloud)
Collaboration in Real-Time
ImportRange → Data from other Sheets
Functions like QUERY(), IMPORTRANGE(), GOOGLEFINANCE()
ā§Ē️⃣ Practical Tips
āĻĒ্āϰāϤিāĻĻিāύ ā§Šā§Ļ āĻŽিāύিāĻ āĻাāĻāĻĒিং + ā§Šā§Ļ āĻŽিāύিāĻ Excel/Docs āĻĒ্āϰ্āϝাāĻāĻিāϏ
āĻোāĻ Projects āϤৈāϰি āĻāϰুāύ:
Daily Expense Sheet
To-Do List in Google Docs
Simple Report with Charts
Keyboard Shortcuts āĻŽুāĻāϏ্āĻĨ āĻāϰুāύ → Efficiency āĻŦাā§ে
āĻ āύāϞাāĻāύ Tutorials (YouTube, Coursera) āĻĻিāϝ়ে Advance āĻļিāĻুāύ
ā§Ģ️⃣ Summary Table
Software
Beginner Skills
Intermediate
Advanced
Google Docs
Typing, Formatting, Paragraphs
Insert Table/Image, Links
Collaboration, Add-ons, Voice Typing
Excel
Cells, Rows, Columns, Basic Formulas
Charts, Conditional Formatting
Pivot Table, IF, VLOOKUP, Data Validation
Computer
Desktop, File Explorer, Software Installation
Taskbar, Shortcut Keys
Updates, Driver Install, Multitasking
đĄ Tip:
āύāϤুāύāĻĻেāϰ āĻāύ্āϝ āĻĒ্āϰāĻĨāĻŽে Google Docs āĻļেāĻা āϏāĻšāĻ। āϤাāϰ āĻĒāϰ Excel āĻļেāĻা āĻļুāϰু āĻāϰুāύ। āĻোāĻ āĻোāĻ Projects āĻĻিāϝ়ে āĻĒ্āϰ্āϝাāĻāĻিāϏ āĻāϰুāύ।
đ Md Sagor Digital Agency – āĻŦাংāϞাāĻĻেāĻļ
āĻŦাংāϞাāĻĻেāĻļে āĻĒ্āϰāĻĨāĻŽāĻŦাāϰেāϰ āĻŽāϤো āĻŦিāĻļ্āĻŦāϏ্āϤ āĻ āĻāϧুāύিāĻ āĻĄিāĻিāĻাāϞ āϏেāĻŦা āύিāϝ়ে āĻšাāĻিāϰ Md Sagor Digital Agency।
āĻāĻŽāϰা āĻŦিāĻļ্āĻŦাāϏ āĻāϰি – āĻĻāĻ্āώāϤা āĻŦাāĻĄ়āϞে āϏāĻĢāϞāϤা āύিāĻļ্āĻিāϤ।
āϤাāĻ āĻāĻŽāϰা āĻļুāϧু āĻাāĻāĻ āĻāϰি āύা, āĻāĻĒāύাāϰ āϏ্āĻিāϞ āĻ āĻŦ্āϝāĻŦāϏাāϰ āĻŽাāύāĻ āĻŦাāĻĄ়িāϝ়ে āĻĻেāĻ।
đ āĻেāύ āĻāĻŽাāĻĻেāϰ āϏāĻ্āĻে āĻাāĻ āĻāϰāĻŦেāύ?
✅ āĻŦিāĻļ্āĻŦāϏ্āϤ āĻ āύিāϰ্āĻāϰāϝোāĻ্āϝ āϏেāĻŦা
✅ āĻĒ্āϰāĻĢেāĻļāύাāϞ āĻিāĻŽ āϏাāĻĒোāϰ্āĻ
✅ āϏāĻŽāϝ়āĻŽāϤো āĻাāĻ āĻĄেāϞিāĻাāϰি
✅ āϏ্āĻিāϞ āĻĄেāĻেāϞāĻĒāĻŽেāύ্āĻ āĻাāĻāĻĄāϞাāĻāύ
✅ āύāϤুāύāĻĻেāϰ āĻāύ্āϝ āϏāĻšāĻ āϏাāĻĒোāϰ্āĻ
āĻāĻĒāύি āϝāĻĻি āύিāĻেāϰ āĻĻāĻ্āώāϤা āĻŦাāĻĄ়াāϤে āĻাāύ āĻ āĻĨāĻŦা āĻāĻĒāύাāϰ āĻŦ্āϝāĻŦāϏাāĻে āĻĄিāĻিāĻাāϞāĻাāĻŦে āĻāĻিāϝ়ে āύিāϤে āĻাāύ — āϤাāĻšāϞে āĻāϰ āĻĻেāϰি āĻেāύ?
đ āĻāĻāĻ āϝোāĻাāϝোāĻ āĻāϰুāύ
đą WhatsApp: +8801798102959
đ§ Email: officialmdsagor@gmail.com
đ Website: https://mdsagordigitalagency.blogspot.com/?m=1�
✨ Md Sagor Digital Agency
āĻāĻĒāύাāϰ āϏāĻĢāϞāϤাāϰ āĻĄিāĻিāĻাāϞ āĻĒাāϰ্āĻāύাāϰ।
.png)