আসুন কম্পিউটার শিখি,ডিজিটাল বাংলাদেশ গড়ে তুলি ।: Microsoft Excel XP

Microsoft Excel XP

Created By: Md. Helal uddin Computer Education Centre

** Introduction **

What Is Excel (G‡·j wK) t

_ EXCEL t EXCEL k‡ãi AvwfavwbK evsjv A_© n‡”Q †kªôZ¡ jvf Kiv ev ¸‡b AwZ_g Kiv| EXCEL n‡jv GKwU

Windows wfwËK Application Program hv Microsoft Corporation KZ„K evRviRvZK…Z| GwU GK cªKvi

Spread Sheet Analysis Program (†¯cÖWkxU G¨vbvjvBwmm †cÖvMÖvg)| Lotus Gai‡bi Avi GKwU Spread Sheet

Analysis Program (†¯cÖWkxU G¨vbvjvBwmm †cÖvMÖvg)| g~jZ EXCEL Gi mvnv‡h¨ hveZxq wnmve wbKvk mn Data

Entry Ges Data Analysis Dfq myweav AR©b Kiv hvq|

What Is Spreadsheet (‡¯cÖWkxU wK) t

_ Spread Sheet t Spread Sheet k‡ãi AvwfavwbK evsjv A_© n‡jv Qov‡bv cvZv (Spread A_© Qov‡bv Ges Sheet

A_© cvZv)| MÖvd KvM‡Ri b¨vq X A¶ Ges Y A¶ eivei †Lvc †Lvc N‡ii b¨vq A‡bK Ni m¤^wjZ eo kxU‡K ejv nq

Spread Sheet. Excel Gi mywekvj ‡¯cÖWkxUwU‡Z wewfboe ai‡bi Z_¨ msi¶Y Ges MvwYwZK cwiMYbv Kiv hvq|

Starting The Excel (G‡·j Pvjy Kiv) t

_ c~‡e©B Avgiv †R‡bwQ Microsoft EXCEL n‡jv GKwU Windows wfwËK Application Program myZivs

Microsoft EXCEL Gi g‡a¨ cÖ‡ek Kivi Rb¨ cÖ_‡gB Operating System Windows Gi Screen Open K‡i

Gi Aaxb¯’

_ Start Click

_ Programs G gvDm wb‡q Select Kivi ci †h ‡gbywU †ei n‡e †mLvb †_‡K

_ Microsoft Excel G Click Ki‡j Microsort Excel Pvjy n‡e| wb‡P Excel Program Window Gi Qwe

I cwiwPwZ †`Iqv nj|

Title Bar

Menu Bar

Standard Tool Bar

Formating Tool Bar

Close Button

Mazimize Button

Mininize Button

Formula Bar

Cursor

Worksheet

Sheet

Horizontal Scroll Bar

Vertical Scroll Bar

Status Bar

Windows Task Bar

AvkvKwi Dc‡i D‡j−wLZ ¯OExb Gi mv‡_ fvjfv‡e cwiwPZ n‡q‡Qb| g‡b ivL‡eb GB ¯OEx‡bi mv‡_ hZ fvj cwiPq _vK‡e

KvR Ki‡Z ZZB mnvqZv cv‡eb| Zvn‡j Avmyb Avgiv Aci c„óvq wM‡q we¯—vwiZ Rvbvi †Póv Kwi|

[ N.B: Microsoft Word G †hgb †jLvi hvqMv‡K A_©vr KvR Kivi RvqMv‡K Working Space (IqvwK©s

†¯úm) ejv nq, †Zgwb Microsoft Excel G †jLvi hvqMv‡K A_©vr KvR Kivi RvqMv‡K Worksheet (IqvK©kxU) ejv

nq| Microsoft Excel Gi GKwU Worksheet (IqvK©kxU) ‡K Avgiv Microsoft Word Gi GKwU †Uwe‡ji mv‡_

Zzjbv Ki‡Z cvwi| Microsort Excel 2000 G †h †Kvb dvB‡j cª_‡gB wZbwU Worksheet (IqvK©kxU) _v‡K Ges

cÖ‡Z¨KwU Worksheet (IqvK©kxU) 256 wU Kjvg Ges 65536 wU †iv _v‡K| cª‡Z¨KwU †m‡j mvaviYZ 8wU A¶i a‡i,

Z‡e A¶‡ii mvB‡Ri Dci wbf©i K‡i G msL¨v Kg - †ekx n‡Z cv‡i| ¯^vfvweK Ae¯’vq Excel G Cursor (Kvm©i) †`Lv

hvq bv, ïay gvÎ †jLvi mgq Cursor (Kvm©i) †`Lv hvq Ab¨vb¨ mgq Kvm©i †h †m‡j _v‡K †mB †mjwUi cv‡k GKwU eW©vi

†`Lv hvq - G‡K †mj c‡q›Uvi e‡j| GQvov gvDm c‡q›UviwU EXCEL G c−vm wP‡ýi (+) gZ †`Lvq| ]

Microsoft Excel XP

Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

_ CURSOR MOVEMENT (Kvm©i ¯’vbvš—i Kiv) t

mywcÖq cÖwk¶bv_©xMb, AvkvKwi Avcbviv Key Board Gi Aš—M©Z Cursor Key Gi mwnZ fvjfv‡e cwiwPZ| GB

Cursor Key ¸‡jvi mnvqZvq Cursor Movement Ki‡Z nq| hw` †KD Cursor Key Gi mwnZ cwiwPZ bv _v‡Kb Z‡e

wk¶‡Ki mvnvh¨ wbb| Ges wb‡Pi Cursor Movement ms_vš— m~Î¸‡jv fvjfv‡e AvqË Ki“b| g‡b ivL‡eb KvR Kivi mgq

hZ ZvovZvox Cursor Movement Ki‡Z cvi‡eb KvR ZZB ZvovZvwo Ges mnR n‡e| Gevi wb‡Pi m~Î¸‡jv AvqË Kivi

Rb¨ †h †Kvb RvqMvq Cursor †i‡L,

Right Arrow Key Press Ki‡j Cursor wU GK Cell Wv‡b hv‡e|

Left Arrow Key Press Ki‡j Cursor wU GK Cell ev‡g hv‡e |

Up Arrow Key Press Ki‡j Cursor wU GK Cell Dc‡i hv‡e|

Down Arrow Key Press Ki‡j Cursor wU GK Cell wb‡P hv‡e|

Home Key Press Ki‡j Cursor wU H Row Gi cÖ_g Cell Gi g‡a¨ P‡j hv‡e|

End Key ‡Z GKevi Press K‡i mv‡_ mv‡_ Right Arrow Key Press Ki‡j Cursor wU H Row Gi ‡k‡l hv‡e|

End Key ‡Z GKevi Press K‡i mv‡_ mv‡_ Left Arrow Key Press Ki‡j Cursor wU H Row Gi ïi“‡Z P‡j hv‡e|

End Key ‡Z GKevi Press K‡i mv‡_ mv‡_ Down Arrow Key Press Ki‡j Cursor wU H Column Gi ‡k‡l hv‡e|

End Key ‡Z GKevi Press K‡i mv‡_ mv‡_ Up Arrow Key Press Ki‡j Cursor wU H Column Gi ïi“‡Z P‡j hv‡e|

Page Up Key Press Ki‡j Cursor wU GK ¯OExb Dc‡ii †m‡j hv‡e|

Page Down Key Press Ki‡j Cursor wU GK ¯OExb wb‡Pi †m‡j hv‡e|

Ctrl + Home Key Press Ki‡j Cursor wU dvB‡ji ïi“‡Z hv‡e|

Ctrl + End Key Press Ki‡j Cursor wU dvB‡ji ‡k‡l hv‡e|

[ NB t D‡j−L¨ †h, GLv‡b GK ¯OExb ej‡Z GKev‡i gwbU‡ii ¯OEx‡b IqvK©kx‡Ui hZUzKz †`Lv hvq Zv‡K eySv‡bv n‡q‡Q| ]

***********

Microsoft Excel XP

Created By: Md. Helal uddin Computer Education Centre

** File Menu **

1. To Create A New Book (GKwU bZzb eB ˆZix Kiv) t

_ File Click

_ New Click

_ Ok Click Ki‡jB bZzb GKwU eB ˆZix n‡e| Microsoft Word Program Gi g‡a¨ hv Avgiv Document

wnmv‡e wP‡bwQjvg|

[ NB t To Create A New Book (GKwU bZzb eB ˆZix Kiv) GB KvRwU Avgiv Ab¨fv‡eI Ki‡Z cvwi †hgb

Standard Tool Bar Gi New Icon Gi g‡a¨ Click K‡i A_ev KeyBoard Key Ctrl + N Press Gi gva¨‡g| ]

2. Save to the Book (msi¶b Kiv) t

_ cÖ_‡g msi¶b Kivi Rb¨ †Kvb wKQy ˆZix K‡i Zvici †h †Kvb RvqMvq Cursor ‡i‡L

_ File Click

_ Save Click Ki‡j mv‡_ mv‡_ Save As Dialog Box Avm‡e ZLb Save As Type Box G Microsoft Excel

Workbook Select K‡i File Name Box Gi g‡a¨ †h bv‡g Save Ki‡Z PvB †mB bvgwU wj‡L

_ Save Click Ki‡jB H bv‡g msiw¶Z n‡e| cieZ©x‡Z Open K‡i ‡`L‡Z cvwi|

[ NB t Save As Dialog Box wU Avgiv Ab¨fv‡eI Avb‡Z cvwi †hgb Standard Tool Bar Gi Save Icon Gi

g‡a¨ Click K‡i A_ev KeyBoard Key G Ctrl + S Press Gi gva¨‡g| cieZ©x KvR¸‡jv GKB iKg Ki‡Z n‡e|

we¯—vwiZ wk¶‡Ki wbKU †_‡K †R‡b wbb| ]

3. To Close A File Or Book (GKwU dvBj ev eB eÜ Kiv) t

_ ‡Kvb GKwU File ev Book Open _vKve¯’vq

_ File G Click

_ Close Click Ki‡jB Open K„Z File ev Book wU Close n‡e| Z‡e Close Click KivgvÎB Yes/No K_vwU mn

WvqvjM e· Avm‡Z cv‡i ZLb hw` H File ev Book wU Save (msi¶b) Ki‡Z PvB Z‡e

_ Yes Click Ki‡jB msi¶b Kivi Rb¨ Save As Dialog Box Avm‡e ZLb msi¶b Kivi c×wZg‡Zv msi¶b Kiv

hv‡e Z‡e hw` msi¶b Ki‡Z bv PvB ZLb

_ No Click Ki‡jB File ev Book wU Close n‡e|

[ NB t Close Avgiv Ab¨fv‡eI Ki‡Z cvwi †hgb Standard Tool Bar Gi g‡a¨ Close hw` †jLv _v‡K Z‡e GB Close G

Click K‡i A_ev KeyBoard Key Alt + F4 Press Gi gva¨‡g| cieZ©x KvR¸‡jv GKB iKg Ki‡Z n‡e| we¯—vwiZ wk¶‡Ki

wbKU †_‡K †R‡b wbb| ]

4. To Open A File (GKwU dvBj †Lvjv ev ¯OEx‡b wb‡q Avmv) t

_ cÖ_‡g Open Kivi Dc‡hvMx K‡i GKwU Book †K Save K‡i File G cwibZ Kwi Zvici

_ File G Click

_ Open Click Ki‡j Open Dialog Box Avm‡e ZLb †h bv‡gi File wU Open Ki‡Z PvB †mB File wU Location

g‡Zv Lyu‡R †ei K‡i Select Kivi ci

_ Open Click Ki‡jB Save K…Z File wU Open n‡e|

[ NB t Open Dialog Box wU Avgiv Ab¨fv‡eI Avb‡Z cvwi †hgb Standard Tool Bar Gi Open Icon Gi g‡a¨ Click

K‡i A_ev KeyBoard Key Ctrl + O Press Gi gva¨‡g| cieZ©x KvR¸‡jv GKB iKg Ki‡Z n‡e| we¯—vwiZ wk¶‡Ki wbKU

†_‡K †R‡b wbb| ]

Microsoft Excel XP

Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

5. Save As (GKwU dvBj Ab¨ †Kvb bv‡g Kwcc~e©K msi¶b Kiv) t

_ cÖ_‡g †h dvBjwU Kwcc~e©K msi¶b Ki‡Z PvB †mwU Open Ki‡Z n‡e Zvici

_ File Click

_ Save As Click Ki‡j mv‡_ mv‡_ Save As Dialog Box Avm‡e ZLb Save As Type Box G MicroSoft Excel

Workbook Select K‡i File Name Box Gi g‡a¨ †h bv‡g Kwcc~e©K msi¶b Ki‡Z PvB †mB bvgwU wj‡L

_ Save Click Ki‡jB H bv‡g Open Kiv File Gi GKwU Copy msiw¶Z n‡e| cieZ©x‡Z Open K‡i ‡`L‡Z cvwi|

6. Save As Web Page (I‡qe mvB‡W msi¶b Kiv) t

_ ‰ZixK…Z File wU Web Page Gi g‡a¨ msi¶b Ki‡Z n‡j GB Save As Web Page Option wUi mvnvh¨ wb‡Z nq

A_©vr GB Option wUi mnvqZvq ‰ZixK…Z File wU Web Page Gi g‡a¨ msi¶b Kiv hvq| hw` Avcbvi Computer

wU‡Z Internet Gi ms‡hvM †`Iqv _v‡K Ges Internet m¤ú‡K© hw` Avcbvi my¯úó avibv _v‡K Z‡e wk¶‡Ki wbKU †_‡K

†R‡b wbb|

7. Save As Workspace (GKvwaK dvBj GKwÎZ K‡i msi¶b Kiv) t

_ cÖ_‡g †h KqwU (GKvwaK) dvBj GKwÎZ K‡i Save (msi¶b) Ki‡Z PvB †mB KwU dvBj‡K Open Kwi Zvici

dvBj¸‡jv Open _vKve¯’vq

_ File Click

_ Save As Workspace Click Ki‡j Save Workspace Dialog Box Avm‡e Ges Save As Type Box G Workspace

‡jLv _v‡K GB Ae¯’vq File Name Box Gi g‡a¨ †h bv‡g GKvwaK GKwÎZ K‡i msi¶b Ki‡Z PvB †mB bvgwU wj‡L

_ Save Click Ki‡j Open Kiv dvBj¸wj H bv‡g GKwÎZ n‡q Save (msi¶b) n‡e|

8. To See Web Page Preview (I‡qe †cBR †`Lv) t

_ cÖ_‡g I‡qe †cB‡R †`Lvi Rb¨ GKwU dvBj ˆZix Kwi Zvici

_ File Click

_ Web Page Preview Click Ki‡j Internet Mode G Microsoft Internet Explorer Open n‡e| mv‡_

mv‡_ ˆZixK…Z File ev Book wU c`wk©Z n‡e|

9. Page Setup (c„óvi gvwR©b, mvBR BZ¨vw` †mwUs Kiv) t

_ cÖ_‡g Page Setup Kivi Rb¨ Page Gi g‡a¨ †Kvb wKQy wj‡L Zvici

_ File Click

_ Page Setup Click Ki‡j mv‡_ mv‡_ Page Setup Dialog Box Avm‡e ZLb Page Tab Gi g‡a¨ Click K‡i,

_ Potrait Click Ki‡j Page wU Lvovfv‡e Print n‡e Ges Landscape Click Ki‡j Page wU evuKvfv‡e Print n‡e

(Lvov Ges evuKv Ae¯’v `ywU bv eyS‡j wk¶K‡K wRÁvmv Ki“b)

_ Paper Size Box Gi g‡a¨ Click K‡i Avgiv †h Size Gi Paper Gi g‡a¨ Print Kie †mB Size Gi Paper

Select Ki‡Z cvwi|

_ Print Quality Box Gi g‡a¨ Click K‡i Avgiv KZ dpi ‡Z Print Kie Zv Select Ki‡Z cvwi| cieZ©x‡Z

Margins Tab Gi g‡a¨ Click K‡i,

_ Top, Buttom, Left, Right, Header, Footer, BZ¨vw`i Margin Setup Ki‡Z cvwi|

_ Center Of Page Box Gi g‡a¨ Horizontally ‡Z Click c~e©K (_) wPý w`‡j †jLv¸‡jv Horizontally

Center n‡e Aciw`‡K Vertically ‡Z Click c~e©K (_) wPý w`‡j †jLv¸‡jv Vertically Center n‡e| Zvici

cÖ‡qvRb‡ev‡a GB Page Setup Box ‡_‡K Avgiv Print Preview ‡`L‡Z cvwi Ges Print Ki‡Z cvwi| cieZ©x‡Z

_ Ok Click Ki‡j g‡bi B‡”QgZ ‰Zix Kiv Page Setup Apply n‡e hv Avgiv c‡i ‡h †Kvb mgq Print Preview

‡`L‡Z cvwi|

[ NB t GB Page Setup Box ‡_‡K Avgiv Header & Footer Ki‡Z cvwi| Z‡e Microsoft Excel Gi g‡a¨ View Menu ‡Z

Header & Footer m¤ú‡K© Av‡jvPbv Kiv n‡q‡Q| ZvB G m¤ú‡K© View Menu ‡Z we¯—vwiZ Rvb‡Z cvie| ]

Microsoft Excel XP

Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

10. To Create Print Area (†Kvb c„óvi wbw`ªó wKQy ¯’vb wcÖ‡›Ui Rb¨ ˆZix Kiv) t

_ ‡Kvb GKwU Page Gi ga¨ †_‡K hw` wbw`ªó wKQy RvqMv Avjv`vfv‡e Print (wcÖ›U) Ki‡Z PvB Zvn‡j †h RvqMvUzKy

Avjv`vfv‡e Print (wcÖ›U) Ki‡Z PvB †mB RvqMvUzKz Block c~e©K Select K‡i

_ File Click

_ Print Area Click

_ Set Print Area Click Ki‡j H RvqMvUzKz Print (wcÖ›U) Kivi Rb¨ ˆZix n‡e| hv Avgiv Print (wcÖ›U) Kivi Av‡MB

Print Preview Click K‡i ‡`L‡Z cvwi| cieZ©x‡Z hLb wbw`ªó RvqMvUzKz Print (wcÖ›U) Kiv †kl n‡q hv‡e ZLb hw`

Avevi Print Area wU ev` w`‡q m¤ú~b© Page wU Print (wcÖ›U) Kivi cÖ‡qvRb nq Z‡e H RvqMvUzKz Block c~e©K Select

K‡i ev Gi cv‡k Cursor ‡i‡L

_ File Click

_ Print Area Click

_ Clear Print Area Click Ki‡j H RvqMvUzKz ‡_‡K Print Area Delete n‡e Ges m¤ú~b© Page wU Avevi Print

(wcÖ›U) Kivi Rb¨ ˆZix n‡e|

11. Print Preview (wcÖ›U Kivi Av‡M cª`k©b) t

_ ‡h dvBj ev eBwU Print (wcÖ›U) Ki‡Z PvB †mwU Open Kwi| Print (wcÖ›U) Kivi ci GwU wKfv‡e c`wk©Z n‡e Zv

†`Lvi Rb¨

_ File Click

_ Print Preview Click A_ev Standard Toolbar Gi Print Preview Icon Gi g‡a¨ Click Ki‡j Print

Preview ‡Z Page wU †QvU AvKv‡i c`wk©Z n‡e| c`k©b †k‡l Print Preview Toolbar ‡_‡K Close Button

Click Ki‡j Print Preview eÜ n‡q Worksheet Gi g‡a¨ P‡j Avm‡e|

12. Print (ˆZixK…Z Kv‡Ri AvDUcyU †`Iqv) t

_ Print Kivi we¯—vwiZ c×wZ wk¶‡Ki wbKU †_‡K †R‡b wbb| (Rvbv AZ¨vek¨K)

13. Send To (¯’vbvši— cÖm½) t

_ Open K…Z File ‡K GK¯’vb †_‡K Ab¨¯’v‡b ¯’vbvš—i Kivi Rb¨ Send To Menu Gi Awab¯’ wewfboe Sub Menu ¸‡jv

e¨envi Kiv n‡q _v‡K| Gi Rb¨ Internet Connection / Network cÖ‡qvRb nq| we¯—vwiZ wk¶‡Ki wbKU †_‡K †R‡b wbb|

14. Properties (dvBj m¤ú‡K© we¯v— wiZ Rvbv) t

_ Open K…Z File m¤ú‡K© we¯—vwiZ Rvbvi Rb¨ D³ Sub Menu wU e¨envi Kiv n‡q _v‡K| we¯—vwiZ e¨envi wk¶‡Ki wbKU

†_‡K †R‡b wbb|

15. Exit (cÖ¯’vb Kiv) t

_ KvR‡k‡l Spreadsheet Analysis Software (Microsoft Excel) ‡_‡K cÖ¯’vb Ki‡Z n‡j

_ File Click

_ Exit Click A_ev KeyBoard Gi ga¨ †_‡K Alt + F4 Press KivgvÎB Yes/No K_vwU mn WvqvjM e· Avm‡Z

cv‡i ZLb hw` H File ev Book wU Save (msi¶b) Ki‡Z PvB Z‡e

_ Yes Click Ki‡jB msi¶b Kivi Rb¨ Save As Dialog Box Avm‡e ZLb msi¶b Kivi c×wZg‡Zv msi¶b Kiv

hv‡e Z‡e hw` msi¶b Ki‡Z bv PvB ZLb

_ No Click Ki‡jB File ev Book wU Close n‡e Ges Operating System Gi Screen wU Open n‡e|

*********************

Microsoft Excel XP

Created By: Md. Helal uddin Computer Education Centre

** Edit menu **

_ BLOCK Kiv t ‡h †jLv e−K Ki‡Z Pvb †mj c‡q›Uvi †m †jLvi ïi“‡Z wb‡q gvD‡mi evg ‡evZvg †P‡c a‡i Drag

Ki‡j ‡jLv e−K n‡e| A_ev Shift Kx †P‡c a‡i ‡i‡L †h ‡Kvb Arrow Kx Pvc w`‡j †h Arrow Kx Pvc w`‡eb †mB w`‡Ki

†jLv e−K n‡e| GLv‡b D‡j−L¨ †h, e−K Ki‡j Ab¨ †mj ¸‡jv Kvj †`Lv‡jI cÖ_g †h Cell wU e−K Kiv nq †mwU mv`v †`Lv hvq|

Z‡e a‡i wb‡Z n‡e H cÖ_g Cell wU Block Kiv n‡q ‡M‡Q|

_ BLOCK Zz‡j †`Iqv t Worksheet Gi †h ‡Kvb hvqMvq gvDm wK¬K Ki‡j A_ev †h ‡Kvb Arrow

Kx Pvc w`‡j Block (e−K) D‡V hv‡e|

1. Cut & Paste (‡jLv‡K ¯’vbvši— Kiv) t

‡h mg¯’ Cell Gi †jLv‡K ¯’vbvš—i Ki‡Z PvB †mB Cell ¸‡jv Block (e−K) K‡i

_ Edit Click

_ Cut Click Ki‡j H †jLv¸‡jvi Pvicv‡k GKiKg Lighting cª`wk©Z n‡e ZLb †h RvqMvq ¯’vbvš—i Ki‡Z PvB †mB

Cell Gi g‡a¨ Cursor ‡i‡L

_ Edit Click

_ Paste Click Ki‡jB Block (e−K) Kiv †jLv¸‡jv ¯’vbvš—i n‡q Cursor ‡h RvqMvq ivLv n‡qwQj †mB RvqMvq

¯’vwcZ n‡e|

NB t Avgiv AviI A‡bK c×wZ‡Z †jLv‡K ¯’vbvš—‡ii KvR Ki‡Z cvwi| cÖ_gZ t Standard Tool Bar Gi gva¨‡g

Ges wØZxqZ t Key Board e¨envi K‡i| cÖ‡qvRb g‡b Ki‡j c×wZ¸‡jv wk¶‡Ki wbKU †_‡K †R‡b wbb|

2. Copy & Paste (GKB ‡jLv‡K GKvwaKevi ¯’vcb Kiv) t

_ ‡h mg¯’ Cell Gi †jLv‡K GKvwaKevi ¯’vcb Ki‡Z PvB †mB Cell ¸‡jv Block (e−K) K‡i

_ Edit Click

_ Copy Click Ki‡j H †jLv¸‡jvi Pvicv‡k GKiKg Lighting cª`wk©Z n‡e ZLb †h RvqMvq GKvwaKevi ¯’vcb

Ki‡Z PvB †mB Cell Gi g‡a¨ Cursor ‡i‡L

_ Edit Click

_ Paste Click Ki‡jB Block (e−K) Kiv †jLv¸‡jv Cursor ‡h RvqMvq ivLv n‡qwQj †mB RvqMvq GKvwaKevi ¯’vwcZ

n‡e|

NB t Avgiv AviI A‡bK c×wZ‡Z †jLv‡K GKvwaKevi ¯’vc‡bi KvR Ki‡Z cvwi| cÖ_gZ t Standard Tool Bar Gi gva¨‡g

Ges wØZxqZ t Key Board e¨envi K‡i| cÖ‡qvRb g‡b Ki‡j c×wZ¸‡jv wk¶‡Ki wbKU †_‡K †R‡b wbb|

3. Paste Special (Ab¨ †Kvb †cÖvMÖvg †_‡K G‡b G‡·‡j †c÷ Kiv) t

_ Spreadsheet Analysis Software Microsoft Excel Gi g‡a¨ KvR Kivi mgq A‡bKmgqB Microsoft

Word Or Microsoft Access ‡_‡K †jLv‡K ‡có Kiv hvq| †h WvqvjM e· Avm‡e Zv‡Z Ok Click Ki‡jB

wbw`ªó Mode G Paste n‡e|

4. Paste As Hyperlink (nvBcviwj¼ Gi g‡a¨ †c÷ Kiv) t

_ GB Option wU Internet (B›Uvi‡bU) Gi Rb¨ cÖ‡qvRb nq| Internet (B›Uvi‡bU) ms‡hvM bv _vK‡j GB Option

wUi KvR Kiv m¤¢e b‡n| mPivPi GB Option wUi cÖ‡qvRb nq bv|

Microsoft Excel XP

Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

5. Clear (†jLv ev Ae‡R± †gvQv) t

_ cÖ_‡g †h †jLv ev Ae‡R±‡K †gvQ‡Z PvB †mwU Block/Select Kwi Zvici

_ Edit Click

_ Clear Gi g‡a¨ Mouse Pointer wb‡q

_ All Click Ki‡jB Block/Select Kiv †jLv ev Ae‡R±wU †gv‡Q hv‡e| GB ‡gvQvi KvRwU Avgiv Ab¨ c×wZ‡Z

Ki‡Z n‡j †jLv ev Ae‡R±‡K Block/Select Kivi ci KeyBoard Gi Delete Key Press Ki‡jB †jLv ev

Ae‡R±wU †gv‡Q hv‡e|

6. Undo (KgvÛ evwZj Kiv) t

_ GBgvÎ cÖ‡qvM Kiv †Kvb Command (KgvÛ) evwZj Ki‡Z n‡j Avgiv Undo Gi mvnvh¨ wb‡Z cvwi

_ Edit Click

_ Undo Click Ki‡j Clear/Delete Gi gva¨‡g †gv‡Q †djv †jLvwU wd‡i Avm‡e A_ev GB GKB Command

(KgvÛ) Gi gva¨‡g me©‡kl †`Iqv †h ‡Kvb Command (KgvÛ)B evwZj n‡q hv‡e|

NB t Avgiv AviI A‡bK c×wZ‡Z KgvÛ evwZj Kivi KvR Ki‡Z cvwi| cÖ_gZ t Standard Tool Bar Gi gva¨‡g

Ges wØZxqZ t Key Board e¨envi K‡i| cÖ‡qvRb g‡b Ki‡j c×wZ¸‡jv wk¶‡Ki wbKU †_‡K †R‡b wbb|

7. Redo (evwZj Kiv KgvÛ †dir wb‡q Avmv) t

_ Undo Gi gva¨‡g †Kvb Command (KgvÛ) †K evwZj Kivi ci hw` GiKg g‡b nq †h Command (KgvÛ)wU

evwZj Kiv wVK nqwb ZLb

_ Edit Click

_ Redo Click Ki‡jB evwZj Kiv KgvÛwU †dir P‡j Avm‡e|

NB t Avgiv AviI A‡bK c×wZ‡Z evwZj Kiv KgvÛ †dir wb‡q Avm‡Z cvwi| cÖ_gZ t Standard Tool Bar Gi gva¨‡g

Ges wØZxqZ t Key Board e¨envi K‡i| cÖ‡qvRb g‡b Ki‡j c×wZ¸‡jv wk¶‡Ki wbKU †_‡K †R‡b wbb|

8. Delete …(CELL, ROW & COLUMN miv‡bv I ‡gvQv) t

_ wbw`©ó ‡mj gy‡Q Wv‡b cv‡ki †jLv ev‡g mviv‡bv t

_ ‡h Cell wU †gvQ‡Z PvB †mwU Select K‡i

_ Edit Click

_ Delete Click

_ Shift Cell Left Click

_ Ok Click Ki‡jB Cursor ‡h Cell Gi g‡a¨ wQj †mB Cell wU †gv‡Q hv‡e Ges H Row Gi Aš—M©Z

Wvb w`‡Ki Ab¨vb¨ Cell ¸‡jv G‡m †gv‡Q hvIqv Cell wU c~ib Ki‡e|

_ wbw`©ó ‡mj gy‡Q wb‡Pi †jLv Dc‡i DVv‡bv t

_ ‡h Cell wU †gvQ‡Z PvB †mwU Select K‡i

_ Edit Click

_ Delete Click

_ Shift Cell Up Click

_ Ok Click Ki‡jB Cursor ‡h Cell Gi g‡a¨ wQj †mB Cell wU †gv‡Q hv‡e Ges H Column Gi

Aš—M©Z wb‡Pi w`‡Ki Ab¨vb¨ Cell ¸‡jv G‡m †gv‡Q hvIqv Cell wU c~ib Ki‡e|

_ wbw`©ó GKwU †iv †gvQv t

_ ‡h Row wU †gvQ‡Z PvB †mB Row Gi Aš—M©Z †h †Kvb GKwU Cell Gi g‡a¨ Cursor ‡i‡L

_ Edit Click

_ Delete Click

_ Entire Row Click

_ Ok Click Ki‡jB Cursor ‡h Row Gi g‡a¨ wQj †mB Row wU †gv‡Q hv‡e Ges wb‡Pi w`K †_‡K

Row ¸‡jv G‡m †gv‡Q hvIqv Row wU c~ib Ki‡e|

Microsoft Excel XP

Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

_ wbw`©ó GKwU Kjvg †gvQv t

_ ‡h Column wU †gvQ‡Z PvB †mB Column Gi Aš—M©Z †h †Kvb GKwU Cell Gi g‡a¨ Cursor ‡i‡L

_ Edit Click

_ Delete Click

_ Entire Column Click

_ Ok Click Ki‡jB Cursor ‡h Column Gi g‡a¨ wQj †mB Column wU †gv‡Q hv‡e Ges Wvb w`K

†_‡K Column ¸‡jv G‡m †gv‡Q hvIqv Column wU c~ib Ki‡e|

9. Delete Sheet (IqvK©kxU †gvQv) t

_ Avgiv Rvwb †h †Kvb GKwU Book/File Gi g‡a¨ mvavibZ wZbwU Worksheet _v‡K| cieZ©x‡Z Avgiv Bnv bZzb K‡i ˆZix

Ki‡Z cvwi, ‡gvQ‡Z cvwi Ges GKB kx‡Ui GKvwaK Kwc ˆZix Ki‡Z cvwi| GQvovI kx‡Ui AviI A‡bK wKQy Kiv hvq| Avgiv

GLb †gvQv wkLe Ges kx‡Ui Ab¨vb¨ KvR wkLe cieZ©x‡Z| Worksheet †gvQvi Rb¨ Avgiv †h Worksheet wU †gvQ‡Z PvB

†mwU Select K‡i Zvici

_ Edit Click

_ Delete Sheet Click

_ Ok Click Ki‡jB Select Kiv Worksheet wU †gv‡Q hv‡e| †gvQv Worksheet KLbI †dir Avbv hvq bv|

10. Move Or Copy Sheet (GKB kx‡Ui GKvwaK Kwc ˆZix Kiv) t

_ Avgiv Rvwb †h †Kvb GKwU Book/File Gi g‡a¨ mvavibZ wZbwU Worksheet _v‡K| cieZ©x‡Z Avgiv Bnv bZzb K‡i ˆZix Ki‡Z

cvwi, ‡gvQ‡Z cvwi Ges GKB kx‡Ui GKvwaK Kwc ˆZix Ki‡Z cvwi| GQvovI kx‡Ui AviI A‡bKwKQy Kiv hvq| Avgiv GLb GKB

kx‡Ui GKvwaK Kwc ˆZix Kiv wkLe Ges kx‡Ui Ab¨vb¨ KvR wkLe cieZ©x‡Z| GKB kx‡Ui GKvwaK Kwc ˆZix Kivi Rb¨ Avgiv †h

Worksheet Gi GKvwaK Kwc ˆZix Ki‡Z PvB †mwU Select K‡i Zvici

_ Edit Click

_ Move Or Copy Sheet Click Ki‡j Move Or Copy Dialog Box Avm‡e ZLb †h Book/File Gi g‡a¨

KvR Kiv n‡”Q †mwU Select K‡i Gi Aaxb¯’ †Kvb Sheet Copy Kie †mwU Select K‡i Zvici

_ Create A Copy Box G (_) wPý w`‡q

_ Ok Click Ki‡jB H kx‡Ui Abyiƒc Av‡iKwU Kwc ˆZix n‡e| Gi d‡j hw` GKwU Worksheet Delete n‡q hvq

Z‡e Kwc Kiv Ab¨ Worksheet wU w`‡q KvR Kiv hv‡e|

11. Find (kã †LuvRv) t

_ ‡jLv ev dvB‡ji ïi“‡Z Cursor ‡i‡L

_ Edit Click

_ Find Click Ki‡j Find Dialog Box Avm‡e ZLb Find What Box Gi g‡a¨ †h Word wU LyuR‡Z n‡e Zv wj‡L

_ Find Next Click Ki‡j hw` H Word wU Luy‡R cvIqv hvq Zvn‡j Word wU †h Cell Gi g‡a¨ Av‡Q Cursor H

Cell Gi g‡a¨ P‡j hv‡e| cieZ©x‡Z c~bivq

_ Find Next Click Ki‡j hw` H Word wU GKvwaKevi _v‡K Ges Luy‡R cvIqv hvq Zvn‡j Word wU †h †h Cell

Gi g‡a¨ Av‡Q Cursor H mKj Cell Gi g‡a¨ G‡K G‡K P‡j hv‡e| †LvRv †kl n‡j

_ Close Click Ki‡jB Find Dialog Box P‡j hv‡e|

[ NB t Find KgvÛ Avgiv Key Board Gi gva¨‡g w`‡Z cvwi| Find KgvÛ Gi Key Board Key n‡jv Ctrl + F ]

Microsoft Excel XP

Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

12. Replace (kã cÖwZ¯’vcb Kiv) t

_ ‡jLv ev dvB‡ji ïi“‡Z Cursor ‡i‡L

_ Edit Click

_ Replace Click Ki‡j Replace Dialog Box Avm‡e ZLb Find What Box Gi g‡a¨ †h Word wU cÖwZ¯’vcb

Ki‡Z n‡e Zv wj‡L Ges Replace With Box Gi g‡a¨ cÖwZ¯’vcb K‡i hv emv‡Z PvB Zv wj‡L

_ Find Next Click Ki‡j hw` H Word wU Luy‡R cvIqv hvq Zvn‡j Word wU †h Cell Gi g‡a¨ Av‡Q Cursor H

Cell Gi g‡a¨ P‡j hv‡e| cieZ©x‡Z

_ Replace Click Ki‡j †h Cell Gi g‡a¨ Cursor _vK‡e H Cell Gi †jLvwU cÖwZ¯’vwcZ n‡e| Ges Replace All

Click Ki‡j †h Cell Gi g‡a¨ Cursor _vK‡e H Cell Gi †jLvwU GKvwaKevi _vK‡j me¸‡jv GKmv‡_ cÖwZ¯’vwcZ

n‡e| g‡bi B‡”QgZ cÖwZ¯’vcb Kiv †kl n‡j

_ Close Click Ki‡jB Replace Dialog Box P‡j hv‡e|

NB t Replace KgvÛ Avgiv Key Board Gi gva¨‡g w`‡Z cvwi| Replace KgvÛ Gi Key Board Key n‡jv Ctrl + H

13. Go To (wbw`©ó †Kvb †m‡j hvIqv) t

_ Avgiv Rvwb Spreadsheet Analysis Software Microsoft Excel Gi g‡a¨ cÖ‡Z¨KwU Worksheet (IqvK©kxU)

G 256 wU Column (Kjvg) Ges 65536 wU Row (†iuv) _v‡K| KvR Kivi mgq Avgv‡`i Lye ZvovZvwo †h †Kvb

Cell (†mj) Gi g‡a¨ hvIqvi cÖ‡qvRb n‡e| GRb¨

_ Edit Click

_ Go To Click Ki‡j Go To Dialog Box Avm‡e ZLb Reference Box Gi g‡a¨ †h Cell G †h‡Z PvB †mB

Cell Address wj‡L

_ Ok Click Ki‡jB Cell Address Abymv‡i Cursor wbw`ªó Cell Gi g‡a¨ P‡j hv‡e|

[ NB t Go To KgvÛ Avgiv Key Board Gi gva¨‡g w`‡Z cvwi| Go To KgvÛ Gi Key Board Key n‡jv Ctrl + G. ]

****************************

Microsoft Excel XP

Created By: Md. Helal uddin Computer Education Centre

** view menu **

1. Page Break Preview (c„óv ˆZix Kivi ci we¯v— wiZ †`Lv) t

_ cÖ_‡g Worksheet Gi g‡a¨ †Kvb wKQy wj‡L †jLvi g‡a¨ Cursor ‡i‡L Normal Mode G _vKve¯’vq

_ View Click

_ Page Break Preview Click

_ Ok Click Ki‡jB ˆZixK…Z Page ¸‡jv fv½v Ae¯’vq †`Lv hv‡e| GLv‡b †h Ae¯’vq †`Lv hv‡e wVK †mB Ae¯’v‡ZB

Print (wcÖ›U) n‡e| GKB c„óvi Awa‡b KZ¸‡jv Row ev Column Print (wcÖ›U) n‡e Zv GB Page Break

Preview †Z Ae¯’vbKv‡j fvjfv‡e ‡`Lv hvq|

2. Normal (c„óv‡K ¯^vfvweK Ae¯’vq wb‡q Avmv) t

_ Excel Gi File/Book Page Break Preview ‡Z _vKve¯’vq

_ View Click

_ Normal Click Ki‡jB Worksheet Normal Mode G P‡j hv‡e|

3. Toolbars (wewfboe Uzjevi †Lvjv Ges eÜ Kiv) t

_ KvR Kivi mgq Menu bar ‡_‡K wewfboe Command bv w`‡q Toolbar Gi mvnv‡h¨ H GKB Command w`‡j

A‡bK `ª“Z KvR m¤úv`b Kiv hvq| Avgiv

_ View Click K‡i Mouse Pointer Toolbars Gi g‡a¨ wb‡q †M‡j Gi Awab¯’ wewfboe Toolbars List ‡`Lv hv‡e| GB

Ae¯’vq †h me Toolbars Gi ev‡g (_) wPý ‡`Iqv Av‡Q a‡i wb‡Z n‡e †m¸‡jv Screen (¯OExb) Gi g‡a¨ Active (¯^w_q)

Ae¯’vq Av‡Q| Aciw`‡K †h mKj Toolbars Gi ev‡g (_) wPý ‡`Iqv †bB a‡i wb‡Z n‡e †m¸‡jv Screen (¯OExb) Gi g‡a¨

Inactive (wb®OExq) Ae¯’vq Av‡Q| cieZ©x‡Z †h mKj Toolbars Gi ev‡g (_) wPý ‡`Iqv Av‡Q †m¸‡jvi g‡a¨ Mouse

Pointer Øviv c~bivq Click Ki‡j (_) wPý P‡j hv‡e Ges Inactive (wb®OExq) n‡q hv‡e Aciw`‡K †h mKj Toolbars Gi

ev‡g (_) wPý ‡`Iqv †bB †m¸‡jvi g‡a¨ Mouse Pointer Øviv c~bivq Click Ki‡j (_) wPý P‡j Avm‡e Ges Active

((¯^w_q) n‡q hv‡e| Gfv‡e Toolbars On/Off Kiv hvq|

4. Formula Bar (dg©~jvevi †Lvjv Ges eÜ Kiv) t

_ Microsoft Excel Program Gi g‡a¨ KvR Kivi mgq †h †Kvb Cell Gi g‡a¨ wK Av‡Q Zv (Cell Contant)

‡`Lvi Rb¨ GB Formula Bar (dg©~jvevi) e¨envi Kiv nq|

_ View Click Kivi ci Formula Bar (dg©~jvevi) Gi evg cv‡ki N‡i hw` (_) wPý ‡`Iqv _v‡K Zvn‡j a‡i wb‡Z n‡e

Formula Bar (dg©~jvevi) Screen (¯OExb) Gi g‡a¨ Active (¯^w_q) Ae¯’vq Av‡Q Aciw`‡K Formula Bar

(dg©~jvevi) Gi evg cv‡ki N‡i hw` (_) wPý ‡`Iqv bv _v‡K Zvn‡j a‡i wb‡Z n‡e Formula Bar (dg©~jvevi) Screen

(¯OExb) Gi g‡a¨ Inactive (wb®OExq) Ae¯’vq Av‡Q| cieZ©x‡Z Formula Bar (dg©~jvevi) Gi g‡a¨ Click K‡i

Toolbars Gi g‡ZvB Formula Bar (dg©~jvevi) †K On/Off Kiv hvq|

5. Status Bar (‡÷Uvmevi †Lvjv Ges eÜ Kiv) t

_ Microsoft Excel Program Gi g‡a¨ KvR Kivi mgq ‡h †Kvb Program Gi †÷Uvm m¤ú‡K© avibv cvIqvi Rb¨

GB Status Bar (‡÷Uvmevi) e¨envi Kiv nq|

_ View Click Kivi ci Status Bar (‡÷Uvmevi) Gi evg cv‡ki N‡i hw` (_) wPý ‡`Iqv _v‡K Zvn‡j a‡i wb‡Z

n‡e Status Bar (‡÷Uvmevi) Screen (¯OExb) Gi g‡a¨ Active (¯^w_q) Ae¯’vq Av‡Q Aciw`‡K Status Bar

(‡÷Uvmevi) Gi evg cv‡ki N‡i hw` (_) wPý ‡`Iqv bv _v‡K Zvn‡j a‡i wb‡Z n‡e Status Bar (‡÷Uvmevi)

Screen (¯OExb) Gi g‡a¨ Inactive (wbw®OEq) Ae¯’vq Av‡Q| cieZ©x‡Z Status Bar (‡÷Uvmevi) Gi g‡a¨ Click

K‡i Toolbars Gi g‡ZvB Status Bar (‡÷Uvmevi) †K On/Off Kiv hvq|

Microsoft Excel XP

Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

6. Header & Footer (c„óvi ‡nWvi I dzUvi †`Iqv) t

_ View Click

_ Header & Footer Click Ki‡j Page Setup Dialog Box Avm‡e (hvi gva¨‡g Avgiv c~‡e© File Menu ‡Z

Page & Margin Setup wk‡LwQjvg) Zvici

_ Header & Footer Tab Select Kiv bv _vK‡j Select K‡i

_ Custom Header Click Ki‡j Header Box Avm‡e ZLb g‡bi B‡”QgZ Left Section, Center Section &

Right Section BZ¨vw`‡Z wjL‡Z cvwi, Toolbar Gi mnvqZvq †jLv wWRvBb, Page No, Date, Time, File

Name, Sheet Name BZ¨vw` Select Ki‡Z cvwi| Gme KvR wVKgZ Kivi ci

_ Ok Click Ki‡j Header Setting n‡q hvq| cieZ©x‡Z

_ Custom Footer Click Ki‡j Footer Box Avm‡e ZLb g‡bi B‡”QgZ Left Section, Center Section &

Right Section BZ¨vw`‡Z wjL‡Z cvwi, Toolbar Gi mnvqZvq †jLv wWRvBb, Page No, Date, Time, File

Name, Sheet Name BZ¨vw` Select Ki‡Z cvwi| Gme KvR wVKgZ Kivi ci

_ Ok Click Ki‡j Footer Setting n‡q hvq| Dc‡i D‡j−wLZ wbqgvbymv‡i Custom Header & Custom Footer

Setting Kiv †kl n‡j

_ Ok Click K‡i Print Preview Click Ki‡j Header & Footer h_v¯’v‡b cÖ`wk©Z n‡e|

7. Comments (gše— ¨ Kiv) t

NB t Spreadsheet Analysis Software (Microsoft Excel) Gi g‡a¨ KvR Kivi mgq A‡bK mgqB wewfboe

wel‡qi Dci ev wewfboe †jv‡Ki m¤ú‡K© gš—e¨ Kivi cÖ‡qvRb nq| Comments (gš—e¨ Kiv) Option wUi KvR Avgiv

View & Insert GB `yB Menu ‡_‡KB Ki‡Z cvwi| Z‡e View Menu ‡_‡KB Lye mn‡R KvRwU m¤úv`b Kiv hvq|

Avgiv †h †Kvb Cell Gi g‡a¨ Cursor ‡i‡LB Comments (gš—e¨ Kiv) Ki‡Z cvwi| A_©vr KvR Kivi Av‡M †h Cell

Gi g‡a¨ Cursor ivLv n‡e †mB Cell Gi g‡a¨B Comments (gš—e¨ Kiv) n‡e| Zvn‡j Avmyb Avgiv gš—e¨ Kiv wkwL

View Click

Comments Click Ki‡jB Reviewing Toolbar On n‡e (Avgiv View Menu Gi Aš—M©Z Toolbars

‡_‡KI Reviewing Toolbar On Ki‡Z cvwi)| cieZ©x‡Z †h Cell Gi g‡a¨ Comments (gš—e¨ Kiv) Ki‡Z PvB

†mB Cell Gi g‡a¨ Cursor ‡i‡L Reviewing Toolbar Gi Aaxb¯’

(K). cÖ_g Option (New Comment) Gi g‡a¨ Click Ki‡j Cursor ‡h Cell Gi g‡a¨ wQj †mB Cell wUi g‡a¨ GKwU Comment Box ‰Zix

n‡e| Avgiv GB Box Gi g‡a¨ gš—e¨ wjL‡Z cvwi| Gfv‡e †h †Kvb Cell Gi g‡a¨ Cursor ‡i‡L Reviewing Toolbar Gi Aaxb¯’ cÖ_g Option

(New Comment) Gi mvnv‡h¨ gš—e¨ Ki‡Z cvwi|

(L). wØZxq Option (Previous Comment) Gi g‡a¨ Click Ki‡j Cursor eZ©gv‡b ‡h Cell Gi g‡a¨ Av‡Q †mB Cell Gi c~e©eZ©x †hme Cell ¸‡jv‡Z Comments (gš—e¨

Kiv) Kiv Av‡Q †m¸‡jv G‡K G‡K †`Lv‡e|

(M). Z„Zxq Option (Next Comment) Gi g‡a¨ Click Ki‡j Cursor eZ©gv‡b ‡h Cell Gi g‡a¨ Av‡Q †mB Cell Gi cieZ©x †hme Cell ¸‡jv‡Z Comments (gš—e¨

Kiv) Kiv Av‡Q †m¸‡jv G‡K G‡K †`Lv‡e|

(N). PZz_© Option (Hide Comment) Gi g‡a¨ Click Ki‡j Cursor eZ©gv‡b ‡h Cell Gi g‡a¨ Av‡Q †mB Cell Gi g‡a¨ gš—e¨ Kiv _vK‡j Zv jywK‡q hv‡e|

†jvKv‡bv Ae¯’vq H Cell Gi Dc‡ii Wvb †Kv‡b jvj wPý cÖ`wk©Z n‡e| cieZ©x‡Z Avevi wdwi‡q Avb‡Z n‡j H Cell Gi g‡a¨ Cursor †i‡L H GKB Option

(Show Comment) Gi g‡a¨ Click Ki‡j gš—e¨ cÖ`wk©Z n‡e| A_©vr PZz_© Option wU †h †Kvb GKwU Cell Gi g‡a¨ ˆZix Kiv gš—e¨ cÖ`k©b Kiv Ges †jvKv‡bvi

Rb¨ e¨envi Kiv nq| gš—e¨ †jvKv‡bv _vK‡j Bnv Show Comment Ges cÖ`wk©Z _vK‡j Hide Comment Shaport K‡i|

(O). cÂg Option (Hide All Comment) Gi g‡a¨ Click Ki‡j Worksheet Gi g‡a¨ gš—e¨ Kiv _vK‡j me¸‡jv gš—e¨B jywK‡q hv‡e| †jvKv‡bv

Ae¯’vq ‡hme Cell Gi g‡a¨ gš—e¨ Kiv Av‡Q †mme Cell Gi Dc‡ii Wvb †Kv‡b jvj wPý cÖ`wk©Z n‡e| cieZ©x‡Z Avevi me¸‡jv gš—e¨ wdwi‡q Avb‡Z

n‡j ‡h †Kvb ¯’v‡b Cursor †i‡L H GKB Option (Show All Comment) Gi g‡a¨ Click Ki‡j me¸‡jv gš—e¨ cÖ`wk©Z n‡e| A_©vr cÂg Option

wU †h †Kvb Worksheet Gi g‡a¨ ˆZix Kiv GKvwaK gš—e¨ cÖ`k©b Kiv Ges †jvKv‡bvi Rb¨ e¨envi Kiv nq| gš—e¨ †jvKv‡bv _vK‡j Bnv Show All

Comment Ges cÖ`wk©Z _vK‡j Hide All Comment Shaport K‡i|

(P). 6ó Option (Delete Comment) Gi g‡a¨ Click Ki‡j Cursor eZ©gv‡b ‡h Cell Gi g‡a¨ Av‡Q †mB Cell Gi g‡a¨ gš—e¨ Kiv _vK‡j Zv

†gv‡Q hv‡e| GKvwaK gš—e¨ GKmv‡_ †gvQ‡Z n‡j †h¸‡jv ‡gvQ‡Z PvB †m¸‡jv Block/Select K‡i Delete Comment Click Ki‡Z n‡e|

NBt Reviewing Toolbar Gi Aaxb¯’ mßg, Aóg Ges beg Option ¸‡jv Internet (B›Uvi‡bU) Gi Kv‡R e¨envi Kiv nq|

Microsoft Excel XP

Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

8. Custom View t

------ wb®cÖ‡qvRb| -----

9. Full Screen (cy‡iv ¯OExbRy‡i †`Lv) t

_ View Click

_ Full Screen Click Ki‡j ˆZixK…Z dvBjwU cy‡iv ¯OExbRy‡i †`Lv hv‡e| ceeZ©x‡Z Screen ¯^vfvweK Ki‡Z PvB‡j

Avevi

_ View Click

_ Full Screen Click Ki‡j A_ev Close Full Screen Click Ki‡j Screen wU ¯^vfvweK Ae¯’vq cÖ`wk©Z n‡e|

10. Zoom (¯OEx‡bi cÖ`k©b mvBR cwieZ©b Kiv) t

_ View Click

_ Zoom Click Ki‡j Zoom Dialog Box Avm‡e ZLb †h cvi‡m›U(%) G cÖ`k©b Ki‡Z PvB Zv Click c~e©K

Select K‡i

_ Ok Click Ki‡jB wbw`ªó cvi‡m›U(%) Abymv‡i ¯OEx‡bi AvKvi †QvU/eo n‡e|

NB t g‡b ivL‡Z n‡e Avgiv Standard Toolbar Gi mvnv‡h¨ Lye mn‡RB ¯OEx‡bi cÖ`k©b mvBR cwieZ©b Ki‡Z cvwi|

¯OEx‡bi ¯^vfvweK cÖ`k©b mvBR n‡”Q 100%|

***************

Microsoft Excel XP

Created By: Md. Helal uddin .Computer Education Centre

Insert menu

1. Cells (bZzb CELL, ROW I COLUMN ‡hvM Kiv) t

NB t Spreadsheet Analysis Software (Microsoft Excel) Gi g‡a¨ KvR Kivi mgq A‡bK mgqB bZzb

K‡i Cell, Row I Column ‡hvM Kivi cÖ‡qvRb nq| †h †Kvb Kvi‡b †jLvi g‡a¨ bZzb K‡i Cell, Row I

Column ‡hvM Ki‡Z PvB‡j GB KgvÛ Gi mvnv‡h¨ Zv Kiv m¤¢e| †Kvb wKQy †jLv _vK‡j †mme Cell Gi g‡a¨ bZzb

K‡i Cell, Row I Column ‡hvM Ki‡j KvRwU n‡q‡Q wKbv Zv Lye mn‡RB †evSv hvq| Aciw`‡K K‡qKwU Lvwj

Cell Gi g‡a¨ KvRwU Ki‡j cwieZ©b¸‡jv †evSv hvq bv| ZvB K‡qKwU Row (†iv) Ges Column (Kjvg) Gi g‡a¨

wKQy wj‡L wb‡Pi KvR¸‡jv Kwi|

_ evg cv‡k Cell (†mj) ms‡hvM Kiv t-

_ ‡h Cell wUi evg cv‡k GKwU Cell (†mj) ms‡hvM Kiv cÖ‡qvRb †mB Cell wU Select K‡i

_ Insert Click

_ Cells Click

_ Shift Cell Right Click

_ Ok Click Ki‡jB Cursor ‡h Cell Gi g‡a¨ wQj †mB Cell wU GK Cell Wv‡b P‡j hv‡e Ges evg

cv‡k GKwU Cell ms‡hvM n‡e| GKvwaK Cell Ki‡Z PvB‡j Block/Select Ki‡Z n‡e|

_ Dc‡i Cell (†mj) ms‡hvM Kiv t-

_ ‡h Cell wUi Dc‡ii w`‡K GKwU Cell (†mj) ms‡hvM Kiv cÖ‡qvRb †mB Cell wU Select K‡i

_ Insert Click

_ Cells Click

_ Shift Cell Down Click

_ Ok Click Ki‡jB Cursor ‡h Cell Gi g‡a¨ wQj †mB Cell wU GK Cell wb‡P P‡j hv‡e Ges

Dc‡ii w`‡K GKwU Cell ms‡hvM n‡e| GKvwaK Cell Ki‡Z PvB‡j Block/Select Ki‡Z n‡e|

_ Dc‡ii w`‡K GKwU Row (‡iuv) ms‡hvM Kiv t-

_ ‡h Row wUi Dc‡ii w`‡K GKwU Row (‡iuv) ms‡hvM Kiv cÖ‡qvRb †mB Row (‡iuv) wU‡Z Cursor ‡i‡L

_ Insert Click

_ Cells Click

_ Entire Row Click

_ Ok Click Ki‡jB Cursor ‡h Row (‡iuv) Gi g‡a¨ wQj †mB Row (‡iuv) wU wb‡Pi Row (‡iuv) †Z

P‡j hv‡e Ges Dc‡ii w`‡K GKwU Row (‡iuv) ms‡hvM n‡e| GKvwaK Row (‡iuv) Ki‡Z PvB‡j

Block/Select Ki‡Z n‡e|

_ evg w`‡K GKwU Column (Kjvg) ms‡hvM Kiv t-

_ ‡h Column wUi evg w`‡K GKwU Column (Kjvg) ms‡hvM Kiv cÖ‡qvRb †mB Column (Kjvg)

wU‡Z Cursor ‡i‡L

_ Insert Click

_ Cells Click

_ Entire Column Click

_ Ok Click Ki‡jB Cursor ‡h Column (Kjvg) Gi g‡a¨ wQj †mB Column (Kjvg) wU Wv‡bi

Column (Kjvg) Gi g‡a¨ P‡j hv‡e Ges evg w`‡K GKwU Column (Kjvg) ms‡hvM n‡e| GKvwaK

Column (Kjvg) Ki‡Z PvB‡j Block/Select Ki‡Z n‡e|

Microsoft Excel XP

Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

2. Rows (GK ev GKvwaK †iv ms‡hvM Kiv) t-

NB t K‡qKwU Row (‡iv) Gi g‡a¨ wKQy †jLv _vK‡j †mme Row (‡iv) †Z bZzb K‡i Row (‡iv) ms‡hvM Ki‡j KvRwU n‡q‡Q wKbv

Zv Lye mn‡RB ‡evSv hvq| Aciw`‡K K‡qKwU Lvwj Row (‡iv) Gi g‡a¨ hw` bZzb K‡i Row (‡iv) ms‡hvM Kiv hvq Zvn‡j †Kvb

cwieZ©b j¶ Kiv hvq bv| ZvB K‡qKwU Row (†iv) Gi g‡a¨ wKQy wj‡L wb‡Pi KvR¸‡jv Kwi|

_ GK ev GKvwaK †h KqwU Row (†iv) ms‡hvM Ki‡Z PvB †mB KqwU Block/Select K‡i

_ Insert Click

_ Row Click Ki‡jB bZzb Row (†iv) ms‡hvM n‡e|

g‡b ivL‡eb, †h KqwU Row (†iv) Block/Select Kiv _vK‡e Zvi wVK Dc‡ii w`‡K wVK ZZwU bZzb Row (†iv)

ms‡hvM n‡e|

3. Columns (GK ev GKvwaK Kjvg ms‡hvM Kiv) t-

NB t K‡qKwU Columns (Kjvg) Gi g‡a¨ wKQy †jLv _vK‡j †mme Columns (Kjvg) Gi g‡a¨ bZzb K‡i Columns

(Kjvg) ms‡hvM Ki‡j KvRwU n‡q‡Q wKbv Zv Lye mn‡RB ‡evSv hvq| Aciw`‡K K‡qKwU Lvwj Columns (Kjvg) Gi

g‡a¨ hw` bZzb K‡i Columns (Kjvg) ms‡hvM Kiv hvq Zvn‡j †Kvb cwieZ©b j¶ Kiv hvq bv| ZvB K‡qKwU Columns

(Kjvg) Gi g‡a¨ wKQy wj‡L wb‡Pi KvR¸‡jv Kwi|

_ GK ev GKvwaK †h KqwU Columns (Kjvg) ms‡hvM Ki‡Z PvB †mB KqwU Block/Select K‡i

_ Insert Click

_ Columns Click Ki‡jB bZzb Columns (Kjvg) ms‡hvM n‡e|

g‡b ivL‡eb, †h KqwU Columns (Kjvg) Block/Select Kiv _vK‡e Zvi wVK evg w`‡K wVK ZZwU bZzb Columns

(Kjvg) ms‡hvM n‡e|

4. Worksheet (bZzb IqvK©kxU ˆZix Kiv) t-

†Lvc N‡ii b¨vq A‡bK Ni m¤^wjZ eo kxU‡K ejv nq Spread Sheet. Excel Gi mywekvj ‡¯cÖWkxUwU‡Z wewfboe

ai‡bi Z_¨ msi¶Y Ges MvwYZK cwiMYbv Kiv hvq|

3. Starting The Excel (G‡·j Pvjy Kiv) t

c~‡e©B Avgiv †R‡bwQ Microsoft EXCEL n‡jv GKwU Windows wfwËK Application Program myZivs

Microsoft EXCEL Gi g‡a¨ cÖ‡ek Kivi Rb¨ cÖ_‡gB Operating System Windows Gi Screen

Open G †_‡K cÖ‡qvRbg‡Zv Chart Type Ges Chart Sub-Type Select Ki‡Z n‡e| A_ev GB Dialog

Box Gi g‡a¨B Custom Type Select K‡i Chart Type List ‡_‡K †h †Kvb GKwU Chart Type Gi g‡a¨

Click Ki‡j Wvb cv‡ki N‡i Symple ‡`Lv hv‡e ZLb cQ›`gZ Select K‡i Zvici

_ Next Click K‡i Pv‡U©i cÖ‡qvRbg‡Zv Series in ‡_‡K Row Or Column Select Ki‡Z n‡e| GLv‡b

Avgv‡`i Z_¨¸‡jvi †¶‡Î Rows Select Ki‡j cÖ‡Z¨KwU wel‡qi wfwË‡Z wewfboe QvÎ-QvÎx‡`i b¤^i¸‡jv †`Lv

hv‡e| Aciw`‡K Columns Select Ki‡j QvÎ-QvÎxiv cÖ‡Z¨‡K wewfboe wel‡q †h b¤^i †c‡q‡Q Zv GKmv‡_

†`Lv hv‡e| Row Or Column Select Kivi ci

_ Next Click K‡i Chart Title Box G Click K‡i Chart Gi Rb¨ †Kvb bvg w`‡Z PvB‡j Zv wjL‡Z n‡e|

(Avgv‡`i QK Abymv‡i bvg n‡e Student Performance)| wb‡Pi w`‡K Catagory (X) Axis Box Gi

g‡a¨ Click K‡i (X) A¶ eivei †Kvb Z_¨ w`‡Z PvB‡j Zv wjL‡Z n‡e Ges Value (Y) Axis Box Gi

g‡a¨ Click K‡i (Y) A¶ eivei †Kvb Z_¨ w`‡Z PvB‡j Zv wjL‡Z n‡e| (Avgv‡`i QK Abymv‡i GB `yB

A‡¶ †jLv n‡e Subject & Marks)| cieZ©x‡Z

_ Next Click K‡i As New Sheet Select Ki‡j ˆZixK…Z PvU©wU m¤ú~b© bZzb GKwU Worksheet Gi g‡a¨

P‡j hv‡e| Ges QKwenxb ïay Chart wUB Print (wcÖ›U) n‡e| Aciw`‡K As Object in Select Ki‡j

ˆZixK…Z PvU©wU GKwU Object wnmv‡e Av‡Mi gZ Avm‡e| GB c×wZ‡Z ˆZix Ki‡j QKmn ev QKwenxb PvU©

Print (wcÖ›U) n‡e| D‡j−L¨ †h, Chart wU Select Kiv Ae¯’vq Print (wcÖ›U) Ki‡j ïaygvÎ Chart wU

QKwenxb Print (wcÖ›U) n‡e| QKmn Chart wU Print (wcÖ›U) Ki‡Z PvB‡j Q‡Ki Dci Cursor ‡i‡L Print

(wcÖ›U) Ki‡Z n‡e| Chart ‰Zix Kivi ci Design Kivi we¯—vwiZ c×wZ wk¶‡Ki wbKU †_‡K †R‡b wbb|

Microsoft Excel XP

Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

6. Page Break (c„óv fv½v) t-

NB t Avgiv Rvwb GKwU Worksheet Gi g‡a¨ hLb ‡ekx ‡jLv nq ZLb avivevwnKfv‡e Page (c„óv) ˆZix n‡Z

_v‡K| KvR Kivi mgq A‡bK †¶‡ÎB GKB Page (c„óv) †K wewfboe Page (c„óv) Gi g‡a¨ cÖ‡qvRbg‡Zv Print

Kivi `iKvi nq ZLb †h †Kvb Page Gi ga¨eZ©x †h †Kvb RvqMvq Cursor ‡i‡L

_ Insert Click

_ Page Break Click Ki‡j D³ Page wU †f‡½ `yB fvM n‡q hv‡e Gfv‡e Cursor ivLvi gva¨‡g †h †Kvb

Page ‡K A‡bK¸‡jv As‡k fvM Kiv hvq| cieZ©x‡Z Page Break ‡Zv‡j †`Iqv ev Av‡Mi Ae¯’vq wd‡i

hvIqvi Rb¨ †h Cell Gi g‡a¨ Cursor ‡i‡L Page Break K‡iwQjvg †mB Cell Gi g‡a¨ Cursor ‡i‡L

_ Insert Click

_ Remove Page Break Click Ki‡jB c~e©ve¯’vq wd‡i hv‡e|

7. Function (wnmve Kiv) t-

NB t Spreadsheet Analysis Software (Microsoft Excel) Gi g~j cÖ‡qvMB n‡”Q wewfboe cÖKvi wnmve Kiv|

Function e¨envi K‡i †hvM, we‡qvM, ¸b, fvM BZ¨vw` wewfboe iKg wnmve Lye mn‡RB Kiv hvq| Function e¨envi

K‡i Avgiv †h KvR¸‡jv Ki‡Z cvwi wVK †mB KvR¸‡jvB KeyBoard e¨envi K‡i Kiv hvq| GB `yB c×wZi g‡a¨

KeyBoard e¨envi K‡i KvR KivB DËg| Kvib Function e¨envi K‡i GB KvR¸‡jv Kivi g‡a¨ A‡bK

cÖwZeÜKZv Av‡Q| wnmve Kivi Rb¨ wKQy Z_¨ cÖ‡qvRb nq| wb‡æ ewb©Z Q‡Ki mvnv‡h¨ Avgiv Z_¨¸‡jv wjwce× Kwi|

A B C D E F G H I J K

1 No-1 No-2 No-3 Sum Average Maximum Minimum Root Multiply Dividing Mixed

2 D2 E2 F2 G2 H2 I2 J2 K2

AvkvKwi Dc‡ii Z_¨¸‡jv wVKg‡Zv w`‡q‡Qb| Avgiv Gevi KeyBoard e¨envi K‡i wewfboe iKg wnmve wkLe|

‡hvM t D2 Cell G Cursor ‡i‡L wjL‡Z n‡e =SUM(Start Cell.End Cell)_

Mo t E2 Cell G Cursor ‡i‡L wjL‡Z n‡e =Average(Start Cell.End Cell)_

eo msL¨v t F2 Cell G Cursor ‡i‡L wjL‡Z n‡e =MAX(Start Cell.End Cell)_

‡QvU msL¨vt G2 Cell G Cursor ‡i‡L wjL‡Z n‡e =MIN(Start Cell.End Cell)_

eM©g~j t H2 Cell G Cursor ‡i‡L wjL‡Z n‡e =SQRT(Any One Cell)_

¸b t I2 Cell G Cursor ‡i‡L wjL‡Z n‡e =Cell*Cell*Cell_

fvM t J2 Cell G Cursor ‡i‡L wjL‡Z n‡e =+Cell/Cell_

‡hvM we‡qvM t K2 Cell G Cursor ‡i‡L wjL‡Z n‡e =+Cell+Cell-Cell_

NB t g‡b ivL‡eb wnmve Kivi mgq dzjóc (.) ej‡Z †_‡K Ges Kgv (,) ej‡Z Ges wnmv‡e a‡i †bIqv nq|

_To Copy The Formula (dg©~jv Kwc Kiv) t

NB t Avgiv GZ¶b (A2, B2, C2) GB wZbwU Cell Gi Dci wfwË K‡i D2 Cell ‡_‡K ïi“

K‡i K2 Cell ch©š— AvU cÖKvi dvskb e¨envi K‡i wnmve Kiv wkLjvg| wKš‘ wb‡Pi w`‡K A_©vr (A3–C6) ch©š—

†h bv¤^vi¸‡jv †`Iqv Av‡Q ev Gi wb‡Pi w`‡K hw` AviI A‡bK bv¤^vi †`Iqv _v‡K Z‡e †m¸‡jvi wnmve †ei Kie

wKfv‡e ? wbðqB ej‡eb wb‡Pi¸‡jvI m~Î cÖ‡qvM K‡i †ei Ki‡Z n‡e| wKš‘ bv dg©~jv Kwc Kivi gva¨‡g Avgiv Lye

mn‡RB GB KvRwU Ki‡Z cvwi| GRb¨

D2 Cell ‡_‡K ïi“ K‡i K2 Cell ch©š— Block/Select K‡i Copy Comand cÖ‡qvM Kwi

Zvici D3 Cell ‡_‡K ïi“ K‡i K3 Cell ch©š— ev wb‡Pi w`‡K hw` AviI _v‡K Zvn‡j me¸‡jv GKmv‡_

Block/Select K‡i Paste Comand cÖ‡qvM Kwi| d‡j dg©~jv¸‡jv Copy (Kwc) n‡q me KvR GKmv‡_

m¤úv`b n‡q hv‡e|

NUMBER

Microsoft Excel XP

Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

8. Name t

-> cÖ‡qvRb †bB|

9. Comment (gše— ¨ Kiv) t-

NB t Avgiv Comment (gš—e¨ Kiv) m¤ú‡K© we¯—vwiZ View Menu ‡Z Av‡jvPbv K‡iwQ| Gi mvnv‡h¨ †Kvb Cell Gi

g‡a¨ Cursor ‡i‡L †h †Kvb wel‡qi Dci gš—e¨ Kiv hvq| GB KvRwU Avgiv Insert Menu ‡_‡KI Ki‡Z cvwi| G wel‡q

GLv‡b Avi Av‡jvPbv Kiv n‡jv bv| hw` g‡b bv _v‡K Z‡e View Menu ‡Z wM‡q †`Lyb, bv cvi‡j wk¶‡Ki mvnvh¨ wbb|

10. To Insert Picture (Qwe Avbv) t

NB t Spreadsheet Analysis Software (Microsoft Excel) Program ïi“ Kivi Av‡M wbðqB Word

Processing Software (Microsoft Word) Program wU K‡i‡Qb| Zvn‡j wbðqB Microsoft Word Gi g‡a¨

Insert Picture (Qwe Avbv), Modify Picture (Qwe ms‡kvab), Movement Picture (Qwe ¯’vbvš—i), Ges Delete

Picture (Qwe †gvQv) BZ¨vw` wk‡L‡Qb e‡j Avgvi wek¦vm| Microsoft Word Gi g‡Zv Microsoft Excel Gi g‡a¨

wewfboe c×wZ‡Z Qwe Avbv hvq| †hgb t

1. Clip Art System 2. From File System 3. Auto Shape System 4. Organization Chart System

5. Word Art System 6. From Scanner Or, Camera System.

D³ c×wZ¸‡jvi mvnv‡h¨ Qwe Avbv hvq| †h c×wZ‡ZB Qwe Avbv †nvK bv †Kb me©`v g‡b ivL‡Z n‡e, †h †Kvb c×wZ‡Z Qwe

Avb‡j Qwe Avbvi ci Qwe‡K ms‡kvab, ¯’vbvš—i Ges †gvQvi c×wZ GKB iKg| hw` bv cv‡ib Z‡e wk¶‡Ki mvnvh¨ wbb|

11. Object (m¤úK© ¯’vcb) t-

_ Insert Click

_ Object Click Ki‡j Object Dialog Box Avm‡e ZLb Gi Aaxb¯’

_ Create New Tab Select K‡i Avgiv †h †Kvb GKwU Object Type Select Kivi gva¨‡g H Object ‡_‡K †Kvb

wKQy Import Ki‡Z cvwi| Gmgq Display As Icon Box G Click Kiv _vK‡j †h Object Type Select Kiv _vK‡e

‡mB Object Gi Icon wU Import n‡e| Aciw`‡K Dialog Box Avmvi ci

_ Create From File Tab Select K‡i Browse Gi gva¨‡g Avgiv Excel ev Ab¨vb¨ Program ‡_‡K ˆZix Kiv

wKQy Import Ki‡Z cvwi| Z‡e GB c×wZ‡Z hvnv Import Kie Zvnv Picture Mode G Import n‡e|

12. Hyperlink (nvBcviwj¼) t

Bnv Internet (B›Uvi‡bU) Gi Kv‡R e¨envi Kiv nq|

****************

এম ডি হেলাল উদ্দিন . মোবাইল 01820218661

** format menu **

1. Cell (‡mj msSvš— wewfboe †mwUs) t

Spreadsheet Analysis Software (Microsoft Excel) Gi g‡a¨ KvR Kivi mgq wewfboe †mj‡K g‡bi B‡”QgZ

†mwUs Ki‡Z nq| †h †Kvb GKwU Kv‡Ri di‡gU ˆZix Kivi Rb¨ Format Menu Gi Aaxb¯’ Cell Gi mvnvh¨ wb‡Z

cvwi| Gi gva¨‡g Avgiv Number Setting, Alignment, Font, Border, Pattern, Protection BZ¨vw` KvR Ki‡Z

cvwi| g‡b ivL‡Z n‡e †h †h KqwU Cell ‡K wb‡q †mwUs Ki‡Z PvB †mB Cell ¸‡jv‡K Block/Select Ki‡Z n‡e|

_ Format Click

_ Cells Click Ki‡j Format Cells Dialog Box Avm‡e ZLb GB Dialog Box Gi g‡a¨ Avjv`v

Avjv`v fv‡e QqwU U¨ve cÖ`wk©Z n‡e| GB QqwU U¨v‡ei mvnv‡h¨ Qq cÖKv‡ii Cell Setting Kiv hvq| Avmyb Avgiv Gevi

†`wL GB QqwU U¨v‡ei †KbwUi mvnv‡h¨ wK KvR Kiv hvq|

(A) To Use Number Tab (bv¤^vi U¨v‡ei e¨envi) t Gi mvnv‡h¨ Avgiv bv¤^vi †mwUs Ki‡Z cvwi| bv¤^v‡ii †¶‡Î

`kwg‡Ki ci KZ¸‡jv ïb¨ (0) n‡e, msL¨v‡Z Currency wPý †`Iqv, msL¨v‡Z Purcentage wPý †`Iqv,

msL¨v‡K Neumaric ‡_‡K Text G cwieZ©b Kiv, msL¨v‡K Customize Kiv BZ¨vw` KvR Ki‡Z cvwi| msL¨v‡K

c~e©ve¯’vq wdwi‡q Avbvi Rb¨ Block/Select _vKve¯’vq GB Tab (U¨ve) Gi Aaxb¯’ General Click K‡i Ok

Click Ki‡Z n‡e|

(B) To Use Alignment Tab (G¨vjvBb‡g›U U¨v‡ei e¨envi) t †h †Kvb Text Or Number ‡K Block/Select

K‡i GB U¨v‡ei mvnv‡h¨ wewfboe G¨v‡½‡j mvRv‡bv hvq| Text Or Number ‡K c~e©ve¯’vq wdwi‡q †bIqvi Rb¨

Block/Select _vKve¯’vq GB Tab (U¨ve) Gi Aaxb¯’ 0 (ïb¨) Degrees Select K‡i Ok Click Ki‡Z n‡e|

wWRvBb Kivi KvR Avgiv Microsoft Word G wk‡LwQ | GLv‡bI wVK GKB c×wZ‡Z Block/Select _vKve¯’vq

Font Tab Select Kivi ci †jLv‡K wewfboe iKg wWRvBb K‡i g‡bi B‡”QgZ Format ‰Zix Kiv hvq| c~e©ve¯’vq

wd‡i Avmvi Rb¨ Block/Select _vKve¯’vq GB GB Tab (U¨ve) Gi Aaxb¯’ Normal Font Gi evg w`‡K wVK

wPý w`‡q Ok Click Ki‡Z n‡e|

(D) To Use Border Tab (eW©vi U¨v‡ei e¨envi) t Format Menu Gi Aš—M©Z Border & Shading Gi

mvnv‡h¨ †jLv‡K wewfboe iKg Border †`Iqvi KvR Avgiv Microsoft Word G wk‡LwQ | GLv‡bI wVK GKB

c×wZ‡Z Block/Select _vKve¯’vq Border Tab Select Kivi ci †jLv‡K wewfboe iKg wWRvBb K‡i g‡bi

B‡”QgZ Border †`Iqvi KvR Kiv hvq| c~e©ve¯’vq wd‡i Avmvi Rb¨ Block/Select _vKve¯’vq GB GB Tab

(U¨ve) Gi Aaxb¯’ None Click K‡i Ok Click Ki‡Z n‡e|

(E) To Use Pattern Tab (c¨vUvb© U¨v‡ei e¨envi) t Format Menu Gi Aš—M©Z Border & Shading Gi

Shading Tab Gi mvnv‡h¨ †jLvi Background Gi g‡a¨ wewfboe iKg Color (is) Kivi KvR Avgiv

Microsoft Word G wk‡LwQ | GLv‡bI wVK GKB c×wZ‡Z Block/Select _vKve¯’vq Pattern Tab Select

Kivi ci †jLvi Background Gi g‡a¨ wewfboe iKg Color (is) K‡i g‡bi B‡”QgZ Format ‰Zix Kiv hvq|

c~e©ve¯’vq wd‡i Avmvi Rb¨ Block/Select _vKve¯’vq GB GB Tab (U¨ve) Gi Aaxb¯’ No Color Click K‡i

Ok Click Ki‡Z n‡e|

(F) To Use Protection Tab (‡cÖv‡UKkb U¨v‡ei e¨envi) t cÖ‡qvRb †bB|

2. Row (†iv msSvš— wewfboe KvR) t

(K) To Change Row Height (†iv Gi D”PZv cwieZ©b Kiv) t

_ ‡h Row ¸‡jvi D”PZv cwieZ©b Ki‡Z PvB †m¸‡jv Block/Select K‡i

_ Format Click, Row Select K‡i

_ Height Click K‡i cÖ‡qvRbgZ D”PZv wj‡L w`‡q

_ Ok Click Ki‡j Block/Select K…Z Row ¸‡jvi D”PZv cwieZ©b n‡e|

NB t g‡b ivL‡Z n‡e †h, cÖwZwU Row Gi ¯^vfvweK D”PZv 12.75|

Microsoft Excel XP

Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

(L). To Normal Row Height (†iv Gi D”PZv ¯^vfvweK Kiv) t

_ ‡h Row (†iv) ¸‡jvi D”PZv ¯^vfvweK Ki‡Z PvB †mB Row (†iv) ¸‡jvi D”PZv A¯^vfvweK _vKve¯’vq

Block/Select K‡i

_ Format Click

_ Row Select K‡i

_ Auto Fit Click Ki‡jB Block/Select K…Z Row ¸‡jvi D”PZv ¯^vfvweK n‡e| A_ev c~bivq Height Box

Open K‡i 12.75 wj‡L Ok Click Ki‡j Block/Select K…Z Row ¸‡jvi D”PZv ¯^vfvweK n‡e|

(M). To Hide Row (†iv jywK‡q ivLv) t

_ ‡h Row (†iv) ¸‡jv jywK‡q ivL‡Z PvB †m¸‡jv Block/Select K‡i

_ Format Click

_ Row Select K‡i

_ Hide Click Ki‡j Block/Select K…Z Row ¸‡jv jywK‡q hv‡e|

(N). To Unhide Row (jywK‡q ivLv †iv wdwi‡q Avbv) t

_ ‡h Row (†iv) ¸‡jv wdwi‡q Avb‡Z PvB †m¸‡jvi c~e©eZ©x I cieZ©x Row (†iv) `ywU Block/Select K‡i

_ Format Click

_ Row Select K‡i

_ Unhide Click Ki‡j Aš—eZ©x jywK‡q ivLv Row (†iv) ¸‡jv wd‡i Avm‡e Ges `„k¨gvb n‡e|

3. Column (Kjvg msSvš— wewfboe KvR) t

(K) To Change Column Hidth (Kjvg Gi cÖ¯’ cwieZ©b Kiv) t

_ ‡h Column (Kjvg) ¸‡jvi cÖ¯’ cwieZ©b Ki‡Z PvB †m¸‡jv Block/Select K‡i

_ Format Click

_ Column (Kjvg) Select K‡i

_ Height Click K‡i cÖ‡qvRbgZ cÖ¯’ wj‡L w`‡q

_ Ok Click Ki‡j Block/Select K…Z Column (Kjvg) ¸‡jvi cÖ¯’ cwieZ©b n‡e|

NB t g‡b ivL‡Z n‡e †h cÖwZwU Column (Kjvg) Gi ¯^vfvweK cÖ¯’ 8.43|

(L). To Normal Column Hidth (Kjvg Gi cÖ¯’ ¯^vfvweK Kiv) t

_ ‡h Column (Kjvg) ¸‡jvi cÖ¯’ ¯^vfvweK Ki‡Z PvB †mB Column (Kjvg) ¸‡jvi cÖ¯’ A¯^vfvweK _vKve¯’vq

Block/Select K‡i

_ Format Click

_ Column (Kjvg) Select K‡i

_ Height Click K‡i 8.43 wj‡L Ok Click Ki‡j Block/Select K…Z Column (Kjvg) ¸‡jvi cÖ¯’ ¯^vfvweK n‡e|

Aciw`‡K Column (Kjvg) ¸‡jvi cÖ¯’ A¯^vfvweK _vKve¯’vq Block/Select K‡i

_ Format Click

_ Column (Kjvg) Select K‡i

_ AutoFit Selection Click Ki‡j Column (Kjvg) ¸‡jvi g‡a¨ ‡jLvi Dci wfwË K‡i Column (Kjvg) Gi cÖ¯’

wba©vwiZ n‡e|

(M). To Hide Column (Kjvg jywK‡q ivLv) t

_ ‡h Column (Kjvg) ¸‡jv jywK‡q ivL‡Z PvB †m¸‡jv Block/Select K‡i

_ Format Click

_ Column (Kjvg) Select K‡i

_ Hide Click Ki‡j Block/Select K…Z Column (Kjvg) ¸‡jv jywK‡q hv‡e|

Microsoft Excel XP

Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

(N). To Unhide Column (jywK‡q ivLv Kjvg wdwi‡q Avbv) t

_ ‡h Column (Kjvg) ¸‡jv wdwi‡q Avb‡Z PvB †m¸‡jvi c~e©eZ©x I cieZ©x Column (Kjvg) `ywU Block/Select

K‡i

_ Format Click

_ Column (Kjvg) Select K‡i

_ Unhide Click Ki‡j Aš—eZ©x jywK‡q ivLv Column (Kjvg) ¸‡jv wd‡i Avm‡e Ges `„k¨gvb n‡e|

(O). To See Column Standard width (Kjv‡gi ¯^vfvweK cÖ¯’ †`Lv) t

_ KvR Ki‡Z A‡bK mgq Avgv‡`i Column (Kjvg) Gi ¯^vfvweK cÖ¯’ KZ Zv g‡b bvI _vK‡Z cv‡i| GB Ae¯’vq

Column (Kjvg) Gi ¯^vfvweK cÖ¯’ †`Lvi Rb¨

_ Format Click

_ Column (Kjvg) Select K‡i

_ Standard width Click Ki‡jB Standard width Dialog Box Avm‡e Ges GB Ae¯’vq Avgiv Column

(Kjvg) Gi ¯^vfvweK cÖ¯’ †`L‡Z cvwi|

4. Sheet (IqvK©kxU msSvš— wewfboe KvR) t

(K) To Rename Worksheet (IqvK©kx‡Ui bvg cwieZ©b Kiv) t

_ ‡h Worksheet Gi bvg cwieZ©b Ki‡Z PvB †mB Worksheet Gi g‡a¨ Cell Pointer ‡i‡L

_ Format Click

_ Sheet Select K‡i

_ Rename Click K‡i cwieZ©xZ bvgwU wj‡L Worksheet Gi †h †Kvb RvqMvq Click Ki‡jB Worksheet Gi bvg

cwieZ©xZ n‡e|

(L). To Hide Worksheet (IqvK©kxU‡K jywK‡q ivLv) t

_ ‡h Worksheet wU jywK‡q ivL‡Z PvB †mB Worksheet Gi g‡a¨ Cell Pointer ‡i‡L

_ Format Click

_ Sheet Select K‡i

_ Hide Click Ki‡j Worksheet wU jywK‡q hv‡e| g‡b ivL‡Z n‡e †h, me©‡kl Worksheet wU jywK‡q ivLv hv‡e bv|

(M). To Unhide Worksheet (jywK‡q ivLv IqvK©kxU‡K wdwi‡q Avbv) t

_ Worksheet jyKv‡bv Av‡Q GiKg GKwU Book/File G _vKve¯’vq

_ Format Click

_ Sheet Select K‡i

_ Unhide Click Ki‡jB Unhide Dialog Box Avm‡e ZLb ‡h bv‡gi Worksheet wU wdwi‡q Avb‡Z PvB †mB

bv‡gi Dci Click (wK¬K) K‡i

_ Ok Click Ki‡jB jywK‡q ivLv IqvK©kxUwU wd‡i Avm‡e|

(N). To Create Worksheet Background (IqvK©kx‡Ui e¨vKMÖvDÛ †`Iqv) t

_ ‡h Worksheet wUi e¨vKMÖvDÛ w`‡Z PvB †mB Worksheet Gi g‡a¨ Cell Pointer ‡i‡L

_ Format Click

_ Sheet Select K‡i

_ Background Click Ki‡j Sheet Background Dialog Box Avm‡e ZLb From File ‡_‡K †h †Kvb GKwU

Qwe cQ›`gZ Select K‡i

_ Insert Click Ki‡j m¤ú~b© Worksheet Gi Background Gi g‡a¨ Select K…Z QwewU P‡j hv‡e| Z‡e H QwewU

ïaygvÎ Normal Mode G cÖ`wk©Z n‡e| A_©vr H QwewU Print Preview Mode G cÖ`wk©Z n‡e bv| cieZ©x‡Z

_ Format Click

_ Sheet Select K‡i

_ Delete Background Click Ki‡j Worksheet wU c~e©ve¯’vq P‡j hv‡e| A_©vr Background Gi QwewU gy‡Q

hv‡e|

Microsoft Excel XP

Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

5. AutoFormat (†Uwej‡K wewfboe iKg wWRvBb Kiv) t

(K). To Create AutoFormat (wWRvBb ˆZix Kiv) t

_ ‡h KqwU Cell ‡K wb‡q AutoFormat (wWRvBb) Ki‡Z PvB †mB Cell ¸‡jv‡K Block/Select K‡i

_ Format Click

_ AutoFormat Click Ki‡j AutoFormat Dialog Box Avm‡e ZLb Table Format List ‡_‡K cQ›`gZ

Style Select K‡i

_ Ok Click Ki‡j Block/Select K…Z Cell ¸‡jv cQ›`gZ AutoFormat n‡q hv‡e|

(L). To Delete AutoFormat (wWRvBb ev` †`Iqv) t

_ c~‡e© AutoFormat Kiv _vK‡Z n‡e| Zvici

_ ‡h KqwU Cell Gi AutoFormat (wWRvBb) ev` w`‡Z PvB †mB Cell ¸‡jv‡K Block/Select K‡i

_ Format Click

_ AutoFormat Click Ki‡j AutoFormat Dialog Box Avm‡e ZLb Table Format List ‡_‡K None

Select K‡i

_ Ok Click Ki‡j Block/Select K…Z Cell ¸‡jv †_‡K AutoFormat ev` n‡q hv‡e|

6. Style (wbR¯^ di‡gwUs wWRvBb ˆZix Kiv) t

(K). To Create Style (óvBj ˆZix Kiv) t

_ Format Click

_ Style Click Ki‡j Style Dialog Box Avm‡e ZLb †h †Kvb GKwU bvg wj‡L

_ Modify Click Ki‡j Cells Dialog Box Avm‡e ZLb GB Box Gi mnvqZvq †h mKj KvR c~‡e© wk‡LwQ meB

Kiv hv‡e| g‡bi B‡”QgZ me¸‡jv Style Setting K‡i `yBevi Ok Click Ki‡jB óvBj ˆZix n‡q hv‡e| cÖ‡qvRb n‡j

ˆZixK…Z Style (wWRvBb) wU c~bivq Modify (ms‡kvab) Ki‡Z cvwi|

(L). To Apply The Style (wWRvB‡bi e¨envi Kiv) t

_ ‡h Cell ¸‡jvi g‡a¨ Style (wWRvBb) Gi e¨envi Ki‡Z PvB †mB Cell ¸‡jv‡K Block/Select K‡i Zvici

_ Format Click

_ Style Click Ki‡j Style Dialog Box Avm‡e ZLb †h bv‡gi Style (wWRvBb) Gi e¨envi Ki‡Z PvB †mB bvgwU

Select K‡i Zvici

_ Ok Click Ki‡Z n‡e| d‡j ˆZixK…Z Style (wWRvBb) Gi e¨envi n‡e|

(M). To Delete Style (wWRvBb †gvQv) t

_ c~‡e© Style (wWRvBb) ˆZix Kiv _vK‡Z n‡e Zvici

_ Format Click

_ Style Click Ki‡j Style Dialog Box Avm‡e ZLb Style Name List ‡_‡K †h bv‡gi Style (wWRvBb) wU

†gvQ‡Z PvB †mB bvgwU Select K‡i Zvici

_ Delete Click

_ Ok Click Ki‡jB ˆZixK…Z Style (wWRvBb) wU †gv‡Q hv‡e|

*******************

Microsoft Excel XP

Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

** tools menu **

1. Spelling (evbvb ï× Kiv) t

_ ‡jLvi g‡a¨ evbvb ev MÖvgvi ms_vš— †Kvb fyj _vK‡j Zv †PK Kiv ev wVK Kivi Rb¨ Cell Pointer File/Book Gi

ïi“‡Z †i‡L

_ Tools Click

_ Spelling Click Or Keyboard Key F7 Press Ki‡j H File/Book Gi Awab¯’ †Kvb evbvb fyj e‡j g‡b n‡j

Zv ï× Kivi Rb¨ Spelling Dialog Box Avm‡e ZLb H File/Book Gi Awab¯’ †h Word wU fyj e‡j g‡b n‡e †mB

Word Gi g‡a¨ Cell Pointer P‡j hv‡e| GB Ae¯’vq hw` H Word wUi ï× evbvb Computer Dictionary ‡Z _v‡K

Z‡e Suggestions Box Gi g‡a¨ †mB Word wUi m¤¢ve¨ ï× evbvb¸wj †`Lv‡e| ZLb hw` ï× evbvb Ly‡R cvIqv bv hvq

ev bv _v‡K Z‡e Change To Box Gi g‡a¨ ï× evbvbwU wj‡L Zvici

_ Change Click Ki‡j ïay H evbvbwU ï× n‡e|

_ Change All Click Ki‡j H evbvbwU hZevi D‡j−L Kiv Av‡Q me¸‡jv GKmv‡_ ï× n‡e|

_ Ignore Click Ki‡j H evbv‡bi †Kvb cwieZ©b n‡e bv A_©vr †hfv‡e Av‡Q wVK †mfv‡eB _vK‡e|

_ Ignore All Click Ki‡j H evbvbwU hZevi D‡j−L Kiv Av‡Q me¸‡jvB c~e©ve¯’vq _vK‡e|

_ Gfv‡e me¸‡jv evbvb ï× Kiv †kl n‡j GKwU Dialog Box Avm‡e ZLb

_ Ok Click Ki‡Z n‡e|

2. Auto Correct (¯^qswSqfv‡e ms‡kvab nIqv) t

_ Tools Click

_ Auto Correct Click Ki‡j Auto Correct Dialog Box Avm‡e| ZLb Replace Box G Type Ki“b N Ges with box

G Type Ki“b National Computer Training Center Zvici

_ Add Click

_ Ok Click Ki‡Z n‡e| cieZ©x‡Z †h †Kvb Cell Gi g‡a¨ Cell Pointer ‡i‡L N Type K‡i Spacebar Pvc‡jB

National Computer Training Center wjLv n‡q hv‡e|

3. Protection (wbivcËv †`Iqv) t

_ Spreadsheet Analysis Software (Microsoft Excel) G KvR Kivi mgq A‡bK mgqB e¨vw³MZ A‡bK KvR

Ki‡Z nq| GmKj Kv‡Ri g‡a¨ hw` †KD †Kvb cwieZ©b K‡i Z‡e A‡bK eo iK‡gi ¶wZ n‡q †h‡Z cv‡i| ZvB Avgiv †h

Worksheet Gi g‡a¨ KvR Kie †mB Worksheet wUi wbivcËv weavb Kiv cÖ‡qvRb nq GRb¨ †h Worksheet wUi

wbivcËv weavb Kiv cÖ‡qvRb †mB Worksheet Gi g‡a¨ Cell Pointer ‡i‡L

_ Tolls Click

_ Protection Select K‡i

_ Protect Sheet Click Ki‡j Protect Sheet Dialog Box Avm‡e ZLb Password Box G †h Password wU

w`‡Z PvB †mB Password wU wj‡L

_ Ok Click K‡i cieZ©x Box G H GKB Password wj‡L

_ Ok Click Ki‡j H Worksheet wUi wbivcËv weavb n‡e Gevi H Worksheet wU‡Z ‡Kvb wKQy cwieZ©b Ki‡Z †Póv

Ki“b| cieZ©x‡Z c~bivq KvR Ki‡Z n‡j Avevi

_ Tools Click

_ Protection Select K‡i

_ Unprotect Sheet Click K‡i †h Word w`‡q H Worksheet wU Protect Kiv Av‡Q †mB Word wU wj‡L

_ Ok Click K‡i cieZ©x‡Z H Worksheet wU‡Z ‡Kvb wKQy cwieZ©b Ki‡Z †Póv Kwi|

4. Goal Seek (j¶¨ wba©vib Kiv) t

Microsoft Excel XP

Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

cÖkoe t GKwU Kw¤úDUvi _q Ki‡Z n‡e| Z‡e Gi Rb¨ kZ© n‡jv e‡Kqv UvKvi 10% my`| ‡gvU g~‡j¨i 45% bM` w`‡Z n‡e

Ges cÖwZ gv‡m 7,000 UvKv cwi‡kva Ki‡Z n‡e| m‡e©v”P wKw¯— 12wU| GLb wbw`ªó kZ©mv‡c‡¶ ‡gvU _q g~j¨, e‡Kqv UvKv

Ges bM` UvKvi cwigvb †ei Ki“b ?

DËi t Dc‡ii cÖkoe †_‡K Avgiv hv †cjvg Zvi cwi‡cÖw¶‡Z hv †ei Ki‡Z n‡e Zv Avgiv Goal Seek c×wZi Aej¤^‡b

‡ei Ki‡Z cvie| ‡m‡¶‡Î cÖ‡koe cÖvß Z_¨¸‡jv wb‡Pi QK Abymv‡i wj‡L †djyb|

A B C D E

1 Interest Terms P. Price L. Amount F. Payment

2 10% 12

Gevi †mj c‡q›Uvi D2 Cell G †i‡L wjLyb = C2*55% _

Ges †mj c‡q›Uvi E2 Cell G †i‡L wjLyb = C2*45% _

Zvici †mj c‡q›Uvi C3 Cell G †i‡L wjLyb = PMT(A2/12, B2,-D2) _

Zvici †mj c‡q›Uvi C3 Cell G †i‡L

_ Tools Click

_ Goal Seek Click Ki‡j Goal Seek Dialog Box Avm‡e ZLb Gi Awab¯’ Set Cell G wjLyb C3, To

Value: G wjLyb 7000, By Changing Cell G wjLyb C2, Gevi `yBevi OK ‡Z Click Ki“b| AvkvKwi Gevi

‡gvU _q g~j¨, e‡Kqv UvKv Ges bM` UvKvi cwigvb Rvb‡Z ‡c‡i‡Qb| †Kvb mgm¨v _vK‡j wk¶‡Ki mvnvh¨ wbb|

5. SCENARIOS (`„k¨ cUvqb) t

cÖkoe& t Mvox †Kbvi Rb¨ FY wb‡Z n‡e| Z‡e Gi Rb¨ kZ© n‡jv, my‡`i nvi 10%, ‡gvU g~‡j¨i 30% bM` w`‡Z n‡e| F‡Yi

cwi‡kva n‡e m‡e©v”P 15-30 erm‡ii g‡a¨| g‡b Kwi Mvoxi g~j¨ I F‡Yi †gqv` t

30,00,000 UvKv 15 eQi| 25,000,00 UvKv 20 eQi |

20,000,00 UvKv 25 eQi| 40,000,00 UvKv 30 eQi |

GLb wbw`ªó kZ©mv‡c‡¶ ‡gvU _q g~j¨, e‡Kqv UvKv Ges bM` UvKvi cwigvb †ei Ki“b ?

DËi t Dc‡ii cÖkoe †_‡K Avgiv hv †cjvg Zvi cwi‡cÖw¶‡Z hv †ei Ki‡Z n‡e Zv Avgiv SCENARIOS c×wZi Aej¤^‡b ‡ei

Ki‡Z cvie| ‡m‡¶‡Î cÖ‡koe cÖvß Z_¨¸‡jv wb‡Pi QK Abymv‡i wj‡L †djyb|

A B C D E

1 P. Price Interest Terms L. Amount F. Payment

2 10% 15

Gevi †mj c‡q›Uvi D2 Cell G †i‡L wjLyb = A2*70% _

Ges †mj c‡q›Uvi E2 Cell G †i‡L wjLyb = A2*30% _

Zvici †mj c‡q›Uvi C3 Cell G †i‡L wjLyb = PMT(B2/12,C2*12,-D2) _

Zvici †mj c‡q›Uvi C3 Cell G †i‡L

_ Tools Click

_ Secnarios Click Ki‡j Secnario Manager Dialog Box Avm‡e ZLb cÖ_g kZ©wU (3000000 UvKv 15 ermi)

mshy³ Kivi Rb¨

_ Add Click K‡i Dc‡ii Box G k‡Z©i bvg wjLyb 30lac, 15yr Zvici wb‡Pi Box G wjLyb A2,C2 (Purchase

Price,Terms Gi Cell No). Zvici

_ OK Click Ki‡j Scenario Values Dialog Box Avm‡e Dc‡ii Box G wjLyb UvKvi cwigvb (3000000) Ges

wb‡Pi Box G wjLyb H UvKvi Awab¯’ eQ‡ii cwigvb (15). Zvici

mshy³ Kwi| KvR‡k‡l

cÖ`k©b Kwi|

Microsoft Excel XP

Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

_ Dc‡i D‡j−wLZ KvR¸‡jv †kl n‡q †M‡j

_ Tools Click

†mwU Select K‡i

Secnario Manager Dialog Box wU P‡j hv‡e|

_ To Delete The Scenario (m¨vK‡bvwiI †gvQv) t

_ Dc‡ii KvR¸‡jv †kl n‡q †M‡j hLb g‡b n‡e m¨vK‡bvwiI Avi ivLvi cÖ‡qvRb †bB ZLb †gv‡Q †djvi Rb¨

_ Tools Click

_ Secnarios Click Ki‡j Secnario Manager Dialog Box Avm‡e ZLb †h Secnarios wU †gvQ‡Z PvB †mwU

Select K‡i

_ Delete Click Ki‡j Select K…Z Secnario wU ‡gv‡Q hv‡e| ‡gvQv †k‡l Close Click Ki‡j Secnario

Manager Dialog Box wU P‡j hv‡e|

6. Auditing (ms‡kvab Kiv) t

m¤úv`b †k‡l Gi AeKvVv‡gv g‡b bvI _vK‡Z cv‡i| D`vnib¯^iƒc ejv hvq GKvwaK Cell ‡hvM Kivi ci Avgiv nqZ fy‡j

†h‡Z cvwi †hvMdjUv †Kvb †Kvb Cell ‡_‡K cÖvß| GRvZxq mgm¨v ev AviI A‡bK cÖKvi mgm¨v †_‡K gyw³ cvIqvi Rb¨

Avgiv Tools Menu Gi Auditing Sub Menu wUi mvnvh¨ wb‡Z cvwi| Auditing (ms‡kvab Kiv) Gi wewfboe iKg

e¨envi wk¶‡Ki wbKU †_‡K †R‡b wbb|

7. To Create a Macro (GKwU g¨v‡Sv ‰Zwi Kiv) t

_ Tools Click

_ Macro Select K‡i

_ Racord New Macro Click Ki‡j Racord Macro Dialog Box Avm‡e ZLb Macro Name Box Gi g‡a¨

‡h bv‡g Macro ‰Zwi Ki‡Z PvB †mB bvgwU wj‡L (D‡j−L¨ †h hw` Shortcut key e¨envi Ki‡Z PvB Z‡e H kay wU

_ Ok Click K‡i Macro wnmv‡e hv PvB Zv GKB Cell G wj‡L Ab¨ †h †Kvb GKwU Cell G Cursor wb‡q

_ Tools Click

_ Macro Select K‡i

_ Stop Recording Click Ki‡jB H bv‡g Macro wnmv‡e wjLvwU Save n‡e|

_ Tools Click

_ Macro Select K‡i

NB t hw` H Macro (g¨v‡_v) wU Create (ˆZix) Kivi mgq †Kvb Shortcut Key e¨envi Kiv n‡q _v‡K Z‡e †h Cell Gi g‡a¨

Microsoft Excel XP

Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

_ To Delete The Macro (g¨v‡_v ‡gvQv) t

_ Dc‡i D‡j−wLZ KvR¸‡jv †kl n‡q †M‡j hLb ˆZix Kiv Macro (g¨v‡_v) wU AcÖ‡qvRbxq e‡j g‡b n‡e ZLb ‡h †Kvb

GKwU Cell G Cursor ‡i‡L

_ Tools Click

_ Macro Select K‡i

n‡e GB Ae¯’vq †h Macro (g¨v‡_v) wU ‡gvQ‡Z PvB †mB Macro (g¨v‡_v) Gi bvgwU Select K‡i

cvwi|

8. To Use Add Ins (G¨vW BÝ Gi e¨envi) t-

_ Tools Click

_ Add-ins Click Ki‡j mv‡_ mv‡_ Add-ins Dialog Box Avm‡e ZLb

_ Auto Save Add-ins Click K‡i wUK (_) wPý w`‡q

_ Tools Click

_ Auto Save Click K‡i

_ Ok Click Ki‡j wbw`ªó mgq ci ci File Save Dialog Box wU Avm‡e|

_ To Delete Auto Save (A‡Uv‡mf ev` †`Iqv) t

_ Tools Click

_ Add-ins Click Ki‡j mv‡_ mv‡_ Add-ins Dialog Box Avm‡e ZLb

_ Auto Save Add-ins Click K‡i wUK (_) wPý ‡Zv‡j w`‡q

*********************

Microsoft Excel XP

Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

** Data menu **

1. Sort (WvUv mvRv‡bv) t

NB t A‡bK mgqB Avgv‡`i KvR Kivi †¶‡Î †h †Kvb Column (Kjvg) †K †QvU †_‡K eo A_ev eo †_‡K †QvU AvKv‡i

†`Lvi cÖ‡qvRb nq| Gi mvnv‡h¨ Avgiv Column (Kjvg) wfwËK †h †Kvb wKQy Ly‡R †ei Ki‡Z cvwi| GB KvRwU Kivi

Rb¨ Avgiv wbæiƒc GKwU QK ‰Zix Kwi|

A B C D E F G

1 SL_NO NAME BASIC H-RENT M-ALU LUNCH TOTAL

2 001 Azibor Number Number Number Number Formula

3 002 Chand Number Number Number Number Formula

4 003 Rajon Number Number Number Number Formula

5 004 Rakib Number Number Number Number Formula

Data Click

Sort Click

Sort By Button Click Ki‡j ‰ZixK…Z Field (wdì) ¸‡jv ‡`Lv hv‡e ZLb †h †Kvb GKwU Field (wdì) Click

(wK¬K) K‡i

Ascending Click Kwi (hw` Select K…Z Column wU †QvU †_‡K eo AvKv‡i †`L‡Z PvB)

Desceding Click Kwi (hw` Select K…Z Column wU eo †_‡K †QvU AvKv‡i †`L‡Z PvB)

2. FILTER (‡WUv †LvuRv) t

Data Click

Filter Click

Auto Filter Click Ki‡j cª‡Z¨‡KwU dx‡ìi (Field) bv‡gi cv‡k wdëvi evUb P‡j Avm‡e ZLb †h †Kvb GKwU

Data Click

Filter Click

Show All Click Ki‡Z n‡e| A_ev H Field Button Click K‡i

_ To Create Custom Filter (Kvóg wdëvi ‰Zwi) t

Custom Filter Ki‡Z n‡j KZ¸‡jv Relation Operator Gi `iKvi nq| †hgb t

= Equal

> Greater Than

< Less Than

>= Greater Than or Equal To

<= Not Equal To

<> Not Equal To BZ¨vw`|

Custom Filter Gi wewfboe cÖKvi e¨envi Av‡Q| G¸‡jv wk¶‡Ki wbKU †_‡K fvjK‡i †R‡b wbb| GQvovI wewfboe cÖKvi

Microsoft Excel XP

Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

_ To Delete Auto Filter (A‡Uv wdëvi †gvQv) t

_ Custom Filter Kiv †kl n‡q †M‡j hLb wdëvi evUb †gvQvi cÖ‡qvRb n‡e ZLb

_ Data Click

_ Filter Click

_ Auto Filter Click K‡i wVK wPý (_) †Zv‡j w`‡Z n‡e| wVK wPý (_) †Zv‡j w`‡j wdëvi evUb _vK‡e bv|

_ To Create Advanced Filter (G¨vWfvÝ wdëvi ‰Zwi) t

NB t Advanced Filter Gi gva¨‡g Avgiv g‡bi B‡”QgZ wbw`ªó wKQy Cell ‡K Copy K‡i H Worksheet Gi Awab¯’

†h †Kvb wVKvbvq cvVv‡Z cvwi| GRb¨

_ Data Click

_ Filter Select Kivi ci

_ Advanced Filter Click Ki‡j Advanced Filter Dialog Box Avm‡e ZLb

_ Copy To Another Location Click K‡i List Range, Criteria Range & Copy To c~ib Kivi ci

(cÖ‡qvR‡b wk¶‡Ki mvnvh¨ wbb)

_ Ok Click Ki‡jB wbw`ªó Z_¨¸‡jv wVKvbvgZ †cŠ‡Q hv‡e| cix¶v K‡i †`L‡Z cv‡ib|

3. FORM........ : ‡WUv Gw›Uªi KvR

_ wKQy Record Entry Kiv _vKve¯’vq

_ Data Click

_ Form Click Ki‡j GKwU Dialog Box Avm‡e ZLb

_ New Click K‡i bZzb †WUv UvBc Ki‡Z n‡e| Zvi ci

_ Close Click Ki‡jB †`Lv hv‡e bZzb K‡i Entry Kiv Data ¸‡jv mshy³ n‡q‡Q|

_ wKQy Record Entry Kiv _vKve¯’vq

_ Data Click

_ Form Click Ki‡j GKwU Dialog Box Avm‡e ZLb

_ wKQy Record Entry Kiv _vKve¯’vq

_ Data Click

_ Form Click Ki‡j GKwU Dialog Box Avm‡e ZLb

_ Delete Click

_ Close Click Ki‡jB Dialog Box wU P‡j hv‡e|

Microsoft Excel XP

Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

4. TEXT TO COLUMNS (GKB †m‡ji g‡a¨i †jLv‡K wfboe wfboe Kjv‡g wb‡q hvIqv)

wb‡æ Aw¼Z QKwUi Abyiƒc GKwU QK ˆZix Ki‡Z n‡e| †m‡ji †jLv¸‡jvi g‡a¨ GKB mgvb Spacebar w`‡Z n‡e| Zvn‡j

Avmyb wb‡æ Aw¼Z QKwU ˆZix Kwi|

A B C D E

1 NAME BASIC H-RENT M-ALU GROSS

2 TUTUL 8000 600 400 9000

3 RAKIB 5000 500 400 5900

4 RAJON 6000 400 300 6700

5 CHAND 7000 650 400 8050

_ Gevi cÖ_‡g †jLv¸‡jv e−K K‡i Zvici

_ Data Click K‡i, Text To Columns Click, Delimited Click K‡i, Next Click

_ Space Click K‡i, Next Click, Text Click K‡i

_ Finish Click Ki‡jB cÖ_g Kjv‡gi †jLv¸‡jv avivevwnKfv‡e wfboe wfboe Kjv‡g P‡j hv‡e|

** Window menu **

1. NEW WINDOW (GKB dvB‡ji GKvwaK Kwc) t

_ Window Click K‡i

_ New Window Click Ki‡j GKB dvB‡ji GKvwaK Kwc ‰Zwi n‡q wfboe wfboe DB‡Ûv‡Z †`Lv‡e|

2. ARRANGE (I‡cb Kiv me dvBj¸‡jv GKmv‡_ †`Lv) t

_ Window Click, Arrange Click K‡i ‡h‡Kvb GKwU

_ Option Click Kivi ci, Ok Click Ki‡jB Open Kiv File ¸‡jv GKmv‡_ †`Lv‡e|

3. Hide Window (†Lvjv DB‡Ûv jywK‡q ivLv) t

_ Window Click, Hide Click Ki‡j Open Kiv Window wU jywK‡q hv‡e|

4. Unhide Window (jywK‡q ivLv DB‡Ûv wdwi‡q Avbv) t

_ Window Click, Unhide Click Ki‡j Unhide Dialog Box Avm‡e ZLb jywK‡q ivLv †h WorkBook wU

wdwj‡q Avb‡Z PvB †mwU Select K‡i

_ Ok Click Ki‡jB Hide Kiv Window wU wd‡i Avm‡e|

5. SPLIT (¯OExb †K K‡qKwU fv‡M fvM Kiv) t

_ Window Click, Split Click Ki‡jB ¯OExbwU fvM n‡q hv‡e|

5(a). To Delete SPLIT (¯OExb‡K GKwÎZ Kiv) t

_ Window Click, Remove Split Click Ki‡jB ¯OExbwU GKwÎZ n‡q hv‡e|

6. FREEZE PANES (‡iv w¯’i K‡i ivLv) t

_ ‡h Row ‡K Freeze Ki‡ev Pointer ‡m Row Gi wb‡P †i‡L

_ Window Click, Freeze Panes Click

6(a). To Delete FREEZE (wd«R DwV‡q †`Iqv) t

Window Click, Unfreeze Panes Click

************

Microsoft Excel XP

Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

To Create A Salary Sheet (‡Kvb cÖwZôv‡bi ‡eZ‡bi wnmve †ei Kiv) t

Rent, Medical Alaunce, Lunch, BZ¨vw` †`Iqv nq Ges Profidient Fund, Income Tax, Group Insurence

ˆZix K‡i †eZ‡bi wnmve †ei Kiv wkwL|

A B C D E F G H I J K

1 Name Basic H-Rent Medical Lunch Gross P-Fund I-Tax G-INS T-Deduct Net Pay

2 Tutul 8000

3 Chand 9000

4 Rakib 7000

5 Rajon 6500

C2 Cell G Mouse Pointer ‡i‡L t

=IF(B2>=8000,B2*45%,IF(B2>=6000,B2*35%,IF(B2>=4000,B2*22%,B2*15%)))

D2 Cell G Mouse Pointer ‡i‡L t

=IF(B2>=8000,B2*40%,IF(B2>=4500,B2*28%,B2*18%))

E2 Cell G Mouse Pointer ‡i‡L t

=IF(B2>=8000,B2*34%,B2*22%)

F2 Cell G Mouse Pointer ‡i‡L t

=SUM(B2.E2) A_ev =B2+C2+D2+E2

G2 Cell G Mouse Pointer ‡i‡L t

=B2*12%

H2 Cell G Mouse Pointer ‡i‡L t

=IF(B2<5000,0,IF(B2<8000,(B2-5000)*1%,(B2-5000)*2%+90))

I2 Cell G Mouse Pointer ‡i‡L t

=IF(B2>=7000,B2*22%,B2*8%)

J2 Cell G Mouse Pointer ‡i‡L t

=SUM(G2.I2) A_ev =G2+H2+I2

K2 Cell G Mouse Pointer ‡i‡L t

=+F2-J2

bv‡gi †eZ‡bi wnmve Kijvg| wKš‘ wb‡Pi w`‡K we`¨gvb Ab¨vb¨‡`i wnmv‡ei wK n‡e? hw` ejv nq mevi wnmveB m~Î

cª‡qv‡Mi gva¨‡g Ki‡Z n‡e Zvn‡j Aek¨B fq cv‡eb| hw` cuvP nvRvi †jvK _v‡K Zvn‡j LyeB mgm¨v ZvB bv? Gevi

Avgiv wkLe wKfv‡e Lye Kg mg‡q m~Î Kwc Kivi gva¨‡g mevi wnmve †ei Kiv hvq| wewfboe c×wZ‡Z Avgiv KvRwU Ki‡Z

cvwi| Rvbv bv _vK‡j me¸‡jv c×wZ wk¶‡Ki wbKU †_‡K †R‡b wbb|

Microsoft Excel XP

Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

To Create A Result Sheet (QvÎ/QvÎx‡`i cix¶vi djvdj †ei Kiv) t

NB t †Kvb wk¶v cÖwZôv‡b KvR Ki‡Z n‡j QvÎ/QvÎx‡`i cix¶vi djvdj †ei Ki‡Z nq| hw` cÖwZôv‡b A‡bK QvÎ/QvÎx

_v‡K Z‡e Kw¤úDUvi Qvov mevi djvdj †ei Kiv A‡bK KóKi Ges A‡bK mg‡qi KvR| ZvB GB KvRwU Lye mn‡R

QvÎ/QvÎxi cix¶vi djvdj †ei Kiv hvq Zv wkwL|

A B C D E F G H I J

1 Sl-No Name Reg No Rool No Ban-1 Ban-2 Total Eng-1 Eng-2 Total

2 001 Rakib 32598 05894 Formula Formula

3 002 Rajon 32599 05895 Formula Formula

4 003 Rafiq 32600 05896 Formula Formula

K L M N O P Q R S T

Math Econo Civics Logic History Geography Total Division P/F Avg

Formula Formula Formula Formula

D³ QKwU h_vixwZ ˆZix Kivi ci QvÎ/QvÎx‡`i cÖvß b¤^i wVKgZ emv‡Z n‡e| QvÎ/QvÎx‡`i cÖvß b¤^i ¯^t ¯^t N‡i emv‡bvi

cÖ‡qvM Kivi ci Inter Press Ki‡Z n‡e|

G2 Cell G Mouse Pointer ‡i‡L t

=SUM(E2,F2) A_ev =E2+F2

J2 Cell G Mouse Pointer ‡i‡L t

=SUM(H2,I2) A_ev =H2+I2

Q2 Cell G Mouse Pointer ‡i‡L t

=SUM(G2+J2+K2+L2+M2+N2+O2+P2) (SUM e¨envi wb®cÖ‡qvRb)

R2 Cell G Mouse Pointer ‡i‡L t

=IF(Q2>=890,“STAND”,IF(Q2>=750,“STAR”,IF(Q2>=600,“FIRST”,IF(Q2>=450,“SECOND”,IF(Q2>=330,“THIRD”,“FAIL”)))))

S2 Cell G Mouse Pointer ‡i‡L t

=IF(OR(G2<66,J2<66,K2<33,L2<33,M2<33,N2<33,O2<33,P2<33),“FAIL”,“PASS”)

T2 Cell G Mouse Pointer ‡i‡L t

=Q2/10

A B C D E

1 Sl-No Code No Name Total Sale Commission

2 001 BG-501 Md. Chand Ali 85000 Formula

3 002 BG-502 Rafiqul Islam 52050 Copy Formula

4 003 BG-503 Mr. Rajon 35000 Copy Formula

5 004 BG-504 Mr. Rakib 7000 Copy Formula

6 005 BG-505 Md. Kamal Hossain 47000 Copy Formula

E2 Cell G Mouse Pointer ‡i‡L:

=IF(D2<15000,D2*6%,IF(D2<30000,D2*12%,IF(D2<50000,D2*20%,IF(D2<75000,D2*25%,IF(D2>=75000,D2*30%)))))

cÖ‡qvM K‡i‡Qb Zv eyS‡Z †c‡i‡Qb e‡j Avgvi wek¦vm| †Kvb mgm¨v _vK‡j wk¶‡Ki mnvqZvq mgvavb Ki“b|

Microsoft Excel XP

Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

To Create A Electric Bill (we`y¨r wej ‰Zix Kiv) t

BDwb‡Ui wb‡P LiP Ki‡j Zvi wej n‡e 1.2 UvKv nv‡i| 210 BDwb‡Ui wb‡P LiP Ki‡j Zvi wej n‡e 1.75 UvKv nv‡i| 350

BDwb‡Ui wb‡P LiP Ki‡j Zvi wej n‡e 2.1 UvKv nv‡i| 500 BDwb‡Ui wb‡P LiP Ki‡j Zvi wej n‡e 2.7 UvKv nv‡i| Ges

cÖ‡qvR‡b wk¶‡Ki wbKU †_‡K cÖkoevbymv‡i m~‡Îi cÖ‡qvM ey‡S wbb|

A B C D E

1 Sl-No Meter No Customer Name Total Unit Total Bill

2 001 10001 Md. Sazzed Hossain (Chad) 850 Formula

3 002 10002 Rakib Hasan 350 Copy Formula

4 003 10003 Mr. Rajon 480 Copy Formula

5 004 10004 Mr. Rafiqul Islam 290 Copy Formula

6 005 10005 Md. Azibor 100 Copy Formula

E2 Cell G Mouse Pointer ‡i‡L:

=IF(D2<120,D2*1.2,IF(D2<210,D2*1.75,IF(D2<350,D2*2.1,IF(D2<500,D2*2.7,IF(D2>500,D2*3.1)))))

D³ m~ÎwU cÖ‡qvM Kiv n‡q †M‡j Enter Press Ki“b| AvkvKwi djvdj ‡c‡q †M‡Qb| Gevi Formula Copy Ki“b|

wbðqB mevi djvdj †c‡q‡Qb| Gfv‡eB A‡bK MÖvn‡Ki we`y¨r wej ˆZix Kiv hvq|

***************

To Create A Wage Sheet (gRyix mxU ‰Zix Kiv) t

n‡e| GB 8 N›Uv Kv‡Ri cÖwZ N›Uvi Rb¨ Zv‡`i‡K 20 UvKv K‡i †eZb cÖ`vb Kiv n‡e| Avi GB 8 N›Uvi AwZwi³ †h hZ

A B C D E F

1 Sl-No Code No Name Working Hour Over Time Total Payment

2 001 IIT-101 Kamrul Islam 15 Formula Formula

3 002 IIT-102 Razzak Ali 12 Copy Formula Copy Formula

4 003 IIT-103 Babul Ali Khan 8 Copy Formula Copy Formula

5 004 IIT-104 Rabiul Mia 18 Copy Formula Copy Formula

6 005 IIT-105 Zafor Bhuiyan 16 Copy Formula Copy Formula

E2 Cell G Mouse Pointer ‡i‡L: =IF(D2>=8,D2-8,0)

F2 Cell G Mouse Pointer ‡i‡L: =IF(E2>0,8*20+E2*25,D2*20)

D³ m~ÎwU cÖ‡qvM Kiv n‡q †M‡j Enter Press Ki“b| AvkvKwi djvdj ‡c‡q †M‡Qb| Gevi Formula Copy Ki“b|

wbðqB mevi djvdj †c‡q‡Qb| Gfv‡eB A‡bK kªwg‡Ki gRyix mxU ˆZix Kiv hvq|

***************

Microsoft Excel XP

Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

Premium n‡e 2000 UvKv| eqm 45 eQ‡ii wb‡P n‡j Premium n‡e 2400 UvKv| eqm 45 eQ‡ii Dc‡i hZB †nvK Gi

A B C D E

1 Sl-No Code No Name Age Premium

2 001 TU-1001 Md. Rahim Ali Khan 85 Formula

3 002 TU-1002 Rafiqul Islam 52 Copy Formula

4 003 TU-1003 Mr. Rajon 35 Copy Formula

5 004 TU-1004 Mr. Rakib 7 Copy Formula

6 005 TU-1005 Md. Kamal Hossain 28 Copy Formula

E2 Cell G Mouse Pointer ‡i‡L: =IF(D2<15,1500,IF(D2<30,2000,IF(D2<45,2400,2800)))

K‡i‡Qb Zv eyS‡Z †c‡i‡Qb e‡j Avgvi wek¦vm| †Kvb mgm¨v _vK‡j wk¶‡Ki mnvqZvq mgvavb Ki“b|

A B C D E F G H I J

1 Sl-No Code No Name of Item Quantity Unit Price Total Price Commission Payment Paid Return

2 001 MB-501 Rice 8 220 2000

3 002 MB-502 Tea 5 56 500

4 003 MB-503 Sugar 7 850 6000

5 004 MB-504 Soap 3 105 500

6 005 MB-505 Fish 15 85 1500

F2 Cell G Mouse Pointer ‡i‡L: =D2*E2 G2 Cell G Mouse Pointer ‡i‡L: =F2*5%

H2 Cell G Mouse Pointer ‡i‡L: =F2-G2 J2 Cell G Mouse Pointer ‡i‡L: =I2-H2

K‡i‡Qb Zv eyS‡Z †c‡i‡Qb e‡j Avgvi wek¦vm| †Kvb mgm¨v _vK‡j wk¶‡Ki mnvqZvq mgvavb Ki“b|

To Create A Bank Pass Book (e¨vsK cvm eB ‰Zix Kiv) t

A B C D E

1 Date & Time Previous Balance Deposit Withdraw Current Balance

2 05/06/02 5000 Formula

3 06/08/02 Formula 6500 500 Copy Formula

4 08/09/02 Copy Formula 5000 Copy Formula

5 12/12/02 Copy Formula 4000 Copy Formula

6 02/02/03 Copy Formula 10000 Copy Formula

E2 & B3 Cell G Mouse Pointer ‡i‡L: =B2+C2 -D2

D³ m~ÎwU cÖ‡qvM Kiv n‡q †M‡j Inter Press Ki“b| AvkvKwi djvdj ‡c‡q †M‡Qb| Gevi Formula Copy Ki“b| UvKv

Rgv I DVv‡bvi ci wKfv‡e Zv cÖ‡qvM Ki‡Z n‡e we¯—vwiZ wk¶‡Ki wbKU †_‡K †R‡b wbb|__

বিঃ দ্রঃ ভিবিন্ন ফন্টের কারনে ভিবিন্ন অক্ষর বেজা না যেতে পারে তার জন্য শিক্ষকের জাছে ভাল বাবে জেনে নিবেন বলে আসা করছি

এম,ডি,হেলাল উদ্দিন,,,,, মোবাইলঃ-01820218661

ইমেলঃ-helaluddin321@gmail.com

আসুন কম্পিউটার শিখি,ডিজিটাল বাংলাদেশ গড়ে তুলি ।

রবিবার, ১ জানুয়ারী, ২০১২

Microsoft Excel XP

1 টি মন্তব্য: