Technoloy Navigation Ground E-18/3, Middle Badda, Gulshan, Dhaka-1212 Mobile: 01911563761, email:
[email protected] Microsoft Excel cªMÖvgwU Pvjy Kivi wbqgtStart > Programs > Microsoft Excel
Microsoft Excel Page 1 of 13
Saiful wjLyb>G›Uvi Pvcyb>me cvZv †`Lv‡e>Ctrl+Home hw` Avcwb Avevi Av‡Mi gZ Normal K‡i G‡·‡j Rvbvi welqtw`‡Z Pvb Zvn‡j G‡·j cÖMªvgwU ‡Lvjvi c‡iB A‡b‡K †Kgb View > Normal w`b| †hb A¯^w¯— †eva Ki‡Z _v‡Kb| Zviv wPš— 4. bx‡Pi w`‡K †`Lyb wZbwU Sheet v Ki‡Z _v‡Kb GLv‡b ïay Kjvg Avi †iv †`Lv i‡q‡Q hv †`L‡Z wVK GB iKg| hv‡”Q, g‡b g‡b ej‡Z _v‡Kb Ò†Kv_vq wK wjLe? wKQz&B eyS‡Z cviwQ bv|Ó Iqv‡W©i gZ cvZv Avjv`v Avjv`v cvZvi bgybv †`L‡Z PvB‡j bx‡Pi WvUv¸‡jv UvBc cÖwZwU kx‡U i‡q‡Q 36435 wU K‡i cvZv| Ki“b| Zvi A_© `vovq Avcbvi GB mvBdzj bvgK Name Age Sex Position Income dvB‡j cÖvq 1 jv‡Li Dc‡i cvZv i‡q‡Q| Jamal 65 M Engineer 6547 Asraf 26 M Engineer 6000 Yasin 45 M Officer 5000 Mayna 46 F Officer 8000 Columns eo ev †QvU Kivi wbqgtKalam 60 M Officer 4000 gvDm c‡q›Uvi A Ges B Kjvg `yÕwUi 1. File > Save ms‡hvM¯’‡j wb‡q †M‡j c‡q›Uvi Giƒc 2. Kx‡evW© n‡Z Saiful ev (Avcbvi bvg) n‡q hv‡e| wVK ZLbB gvDm c‡q›Uvi †P‡c wjLyb| a‡i Wv‡b-ev‡g WªvM K‡i Kjvg eo ev †QvU 3. gvD‡mi gva¨‡g Save evU‡b wUcyb| Kiv hv‡e| 4. File>Printpreview>cvZvi AvK„wZUv †`L‡Z cve>close Row eo ev †QvU Kivi wbqgtgvDm c‡q›Uvi 4 Ges 5 †jLv †iv `yÕwUi AviI GKwU mgm¨v Zviv Abyfe K‡i, †mwU ms‡hvM¯’‡j wb‡q †M‡j c‡q›Uvi Giƒc n‡jv wm‡j± Kivi mgm¨v| ‡jLv KZUzKz n‡q hv‡e| wVK ZLbB gvDm c‡q›Uvi †P‡c wm‡j± Ki‡Z †M‡j †`Lv hvq cÖ_g NiwU a‡i Dc‡i-bx‡P WªvM K‡i ‡iv eo ev †QvU mv`v †`Lvq| †jv‡Kiv g‡b K‡i m¤¢eZ cÖ_g Kiv hv‡e| NiwU wm‡j± nqwb| wKš‘y bv, G‡·‡j m¤ú~Y© Row ev Columns wm‡j± Kivi wm‡jK&kvb Gfv‡eB Ki‡Z nq| wbqgt1, 2, 3 BZ¨vw` msL¨v ¸wji Dci wK¬K Ki‡j G‡·‡j Rvbvi welqtm¤ú~Y© †iv wm‡j± n‡q hv‡e| Avevi A, 1. j¤^vjw¤^ Columns i‡q‡Q 256 wU B,C A¶i ¸wji Dci wK¬K Ki‡j m¤ú~Y© Kjvg wm‡j± n‡q hv‡e| Kx †evW© †_‡K Ctrl + → Pvc w`b me© †kl Kjv‡g †h‡Z cvi‡eb Row Ges Columns Gi wWdë AvK…wZt2. ‡kvq‡bv Row i‡q‡Q 65536 wU Row = 12.75, Columns = 8.43 Kx †evW© †_‡K Ctrl+↓ Pvc w`b me© †kl ♦ A Ges B Kjvg `yÕwUi ms‡hvM¯’‡j ‡iv ‡Z †h‡Z cvi‡eb| wK¬K Ki“b| Kjv‡gi AvK…wZ †`Lv‡e 8.43 Kx †evW© †_‡K Ctrl+Home Pvc w`b cvZvi ♦ 4 Ges 5 †jLv †iv `yÕwUi ms‡hvM¯’‡j cÖ_‡g†h‡Z cvi‡eb| wK¬K Ki“b| †iv Gi AvK…wZ †`Lv‡e 3. me©‡gvU cvZv i‡q‡Q 36435 wU 12.75 cÖvq| Sheet Gi bvg cwieZ©b Kiv t hw` Avcwb me©‡gvU KZwU cvZv Sheet 1 †jLvwUi Dci Wvej wK¬K Ki“b| Zv i‡q‡Q Zv †`L‡Z Pvb Zvn‡j Kx †evW© w`‡q me©‡kl cvZvq †h‡Z n‡e| ïi“ Ki“b wm‡j± n‡q hv‡e UvBc Ki“b Saiful > G›Uvi Gfv‡e tPvcyb| Sheet 2 †jLvwUi Dci Wvej wK¬K Ki“b| Zv wm‡j± n‡q hv‡e UvBc Ki“b Munna Ctrl+→, Ctrl+↓, View > Page Break Preview, > G›Uvi Pvcyb|
Technoloy Navigation Ground E-18/3, Middle Badda, Gulshan, Dhaka-1212 Mobile: 01911563761, email:
[email protected] K‡qKwU evU‡bi e¨envi Name KjvgwU wm‡j± Ki“b| cÖ_g AvBK‡bi Wvb cv‡ki Zxi K¬xK Ki‡j Wªc WvDb wjó Avm‡e| †mLvb †_‡K †h †Kvb d›U wm‡j± K‡i †jLvi AK…wZ cwieZ©b Ki‡Z cv‡ib| mvaviYZ G‡·‡j Arial d›UwU wWdë _v‡K| wØZxq AvBK‡bi Wvb cv‡ki Zxi K¬xK Ki‡j Wªc WvDb wjó Avm‡e| †mLvb †_‡K †h †Kvb mvBR wm‡j± K‡i †jLv eo ev †QvU Kiv hvq| mvaviYZ G‡·‡j wWdë d›U mvBR _v‡K 10 AviI K‡qKwU evU‡bi e¨envi BwZc~‡e© ‰Zix Kiv †Uwej †_‡K Position KjvgwU wm‡j± Ki“b| ‡jLv‡K wm‡j± K‡i B w`‡j †jLv Bold ev Mv‡ov is n‡e ‡jLv‡K wm‡j± K‡i I w`‡j †jLv Italic ev euvKv n‡e ‡jLv‡K wm‡j± K‡i U w`‡j Underline ev †jLvi bx‡P `vM n‡e K‡qKwU evU‡bi e¨envi BwZc~‡e© ‰Zix Kiv †Uwej †_‡K Sex KjvgwU wm‡j± Ki“b| Dc‡ii 1g AvBKbwU wK¬K Ki‡j †jLv †m‡ji evg w`‡K hv‡e| 2q AvBKbwU wK¬K Ki‡j †jLv ‡m‡ji gvSLv‡b Avm‡e| 3q AvBKbwU wK¬K Ki‡j †jLv ‡m‡ji Wvb w`‡K hv‡e| K‡qKwU Ni GK‡Î wm‡j± K‡i 4_© AvBKbwU wK¬K Ki‡j meKqwU Ni GKwU N‡i cwiYZ n‡e Ges †jLv P‡j Avm‡e N‡ii gvSLv‡b| AviI K‡qKwU evU‡bi e¨envi BwZc~‡e© ‰Zix Kiv †Uwej †_‡K Income Kjv‡gi wbDg¨vwiK AskUzKz wm‡j± Ki“b| 1g AvBK‡bi Dci wK¬K Ki‡j H Kjv‡g Wjvi wPý Avm‡e| 2q AvBK‡b wK¬K Ki‡j kZKiv wPý Avm‡e| 3q AvBK‡b wK¬K Ki‡j cÖwZ nvRv‡ii c‡i Kgv Avm‡e| 4_© AvBK‡b wK¬K Ki‡j `kwg‡Ki c‡ii msL¨v evo‡e| 5g AvBK‡b wK¬K Ki‡j `kwg‡Ki c‡ii msL¨v Kg‡e|
Microsoft Excel Page 2 of 13
AviI K‡qKwU evU‡bi e¨envi BwZc~‡e© ‰Zix Kiv Saiful dvBj I‡cb Ki“b >‡jLv¸‡jv wm‡j± Ki“b > 1g AvBK‡bi Wvb cv‡ki Zx‡i wK¬K Ki‡j A‡bK¸‡jv AvBKb Avm‡e > Zv †_‡K `ywUi e¨envi ejv n‡”Q---- All Border K¬xK K‡i †m‡j eW©vi †`qvi KvR Kiv hvq| --- No Border K¬xK K‡i †m‡ji eW©vi DwV‡q †`qv hvq| ‡jLv¸‡jv wm‡j± Ki“b > 2q AvBK‡bi Wvb cv‡ki Zx‡i K¬xK Ki‡j A‡bK is Avm‡e --- †h †Kvb is Gi Dci wK¬K Ki‡j ÔN‡ii g‡a¨Õ iO n‡q hv‡e| --- Ni‡K Av‡Mi gZ is nxb Ki‡Z n‡j No Fill ‡jLv¸‡jv wm‡j± Ki“b > 3q AvBK‡bi Wvbcv‡ki Zx‡i K¬xK Ki‡j A‡bK is Avm‡e| --- †h †Kvb is Gi Dci wK¬K Ki‡j Ô‡jLvÕ †mB i‡Oi n‡q hv‡e ---‡jLvi is Kv‡jv Ki‡Z n‡j Automatic P‡qR Ki“b|
File dvB‡j cvmIqvW© †`qvi wbqg Avgv‡`i AwZ¸i“Z¡c~Y© A_ev †Mvcbxq dvB‡j cvmIqvW© w`‡q ivL‡Z nq| hv‡Z Ab¨ †KD Zv I‡cb K‡i †`L‡Z bv cv‡i| 1. ‡h dvB‡j cvmIqvW© w`‡eb †mB dvBjwU Open Ki“b| 2. File> Save As> Tools> General Options> Password to open e· Gi mv`v e‡· wK¬K Ki“b> 123 UvBc Ki“b > wZbwU *** Avm‡e > Ok> Confirm Password bv‡g GKwU WvqvjM e· Avm‡e> AveviI 123 UvBc Ki“b> wZbwU *** Avm‡e > Dc‡ii Ok ‡Z wUcyb > Save >Yes dvBjwU‡Z cvmIqvW© †mU n‡q‡Q| 3. gwbU‡ii me© Dc‡i Wvb w`‡K x wP‡ý wK¬K K‡i dvBjwU eÜ Ki“b > bZzb K‡i Zv Open Ki‡Z †M‡j cvmIqvW© PvB‡e| Bs‡iwR evK¨wU n‡jv Enter Password to Open file. Avcbv‡K cvmIqvW© 123 UvBc K‡i OK w`‡Z n‡e > File wU I‡cb n‡e| dvB‡ji cvmIqvW© gy‡Q †`qvi wbqg
Technoloy Navigation Ground E-18/3, Middle Badda, Gulshan, Dhaka-1212 Mobile: 01911563761, email:
[email protected] 1. †h dvB‡j cvmIqvW© †mU Kiv n‡q‡Q Zv eÜ _vK‡j ‡mwU cvmIqvW© wU‡cB Open Ki‡Z nq| dvBjwU I‡cb Ki“b| 2. File > Save As > Tools > General Options > Password to open e· ‡_‡K *** gy‡Q w`b > Ok > Save >Yes
Microsoft Excel Page 3 of 13
Saiful bvgK dvBjwU I‡cb Ki“b| n‡Z cv‡i GLv‡b Avcwb 500 †jv‡Ki WvUv wjL‡jb| wcÖ›U †`qvi mgq cÖwZ cvZvi cÖ_‡g Ô†nwWs †ivÕ wU wcÖ›U nIqv Ri“ix| †m wU Ki‡Z n‡j K) Rows to Repeat at top Lvwj N‡i wUc w`b > Sheet Gi cÖ_g Kjv‡gi 1 Gi Dci wK¬K Page setup ‡`qvi wbqg tKi“b > cÖwZ cvZvi cÖ_‡g GB †iv wU File>Page Setup (GLv‡b 4 wU †Ue i‡q‡Q) wcÖ›U n‡e| ⇒ Page GLv‡b wZbwU KvR Kiv hvq, †hgb:L) Columns to Repeat at left Gi Lvwj N‡i K) Orientation G cZv‡K †kvqv‡bv ev `vo wUc w`b > Sheet Gi cÖ_g Kjvg A Gi Dci Kiv‡bv hvq| Portrait n‡”Q `vo Kiv‡bv, wK¬K Ki“b| Landscape n‡”Q †kvqv‡bv M) Rows and Columns Headings G wUK () L) Scaling G 100% _vKvUvB ¯^vfvweK| gvK© w`‡j A , B, C I 1, 2, 3, wcÖ›U n‡e| cv‡m©‡›UR Kwg‡q A‡bK †jLv cvZvq N) Down, then over ‡`qv _vK‡j, fvwU©Kvwj wb‡q Avmv nq| ZLb †jLv¸‡jv ‡QvU nq| cvZv wcÖ›U n‡e M) Paper Size G wM‡q Letter wm‡j± Ki“b| O) Over, then down ‡`qv _vK‡j cvkvcvwk Awdm Av`j‡Z GB mvBR e¨envi Kiv n‡q wcÖ›U n‡e 1 _v‡K| 8 /2 x 11 BwÂ| AviI GKwU mvBR Print Preview (wcÖ‡›Ui Av‡M †`‡L †bqv) e¨envi Kiv nq hv Legal mvBR| File>Print Preview GLv‡b AvBKb¸‡jv 81/2 x 14 BwÂ| n‡jv.............. ⇒ Margins GLv‡b `ywU KvR Kiv hvq, †hgbtNext c‡ii cvZv †`L‡Z PvB‡j K) gvwR©b KZUzKz n‡e Zv wVK K‡i Previous c~‡e©i cvZv †`L‡Z PvB‡j w`‡Z cv‡ib| mvaviYZ gvc _v‡K Top = 1, Zoom ‡jLv eo ev †QvU K‡i ‡`L‡Z Bottom = 1, Left = 0.75, Right = 0.75 BwÂ| PvB‡j L) WKz‡g‡›U hw` Aí †jLv _v‡K Avi Zv Print ‡jLv wcÖ›U Ki‡Z PvB‡j hw` †ccv‡ii gvSLv‡b wcÖ›U w`‡Z Pvb Setup ‡cR †mUAv‡c †h‡Z PvB‡j Z‡e Horizontally and Vertically G `ywU Close wcÖwfD ‡_‡K ‡ei n‡Z PvB‡j †iwWI evU‡b wUK gvK© w`‡q w`b| Print Kivi wbqg ⇒ Header/Footer 1. File>Print>All>Ok w`‡j mKj cvZv wcÖ›U K) cÖ_g none †jLv RvqMvq WªcWvDb n‡q hv‡e G‡iv‡Z wK¬K Ki“b| Page 1> cÖwZ cvZvi 2. Page (s) From Gi mv`v N‡i 3 wjLyb To Gi cÖ_‡g wmwiqvwj bv¤^vi P‡j Avm‡e| mv`v N‡i 9 wjLyb > Ok w`‡j 3 †_‡K 9 L) wØZxq none †jLv RvqMvq WªcWvDb ch©š— cvZv wcÖ›U n‡e| G‡iv‡Z wK¬K Ki“b| 3. ‡jLv wm‡j± Ki“b > Page 1> cÖwZ cvZvi †k‡l wmwiqvwj File>Print>Selection>Ok hZUzKz wm‡j± bv¤^vi P‡j Avm‡e| Kiv n‡q‡Q ZZUzKzB wcÖ›U n‡e| M) hw` Ggb nq †h Avcwb Avcbvi 4. File>Print>Entire Workbook>Ok w`‡j †Kv¤úvwbi bvg cÖwZ cvZvq wcÖ›U me¸‡jv wk‡Ui hZ †jLv Av‡Q me wcÖ›U w`‡eb Zvn‡j Coustom Header wm‡j± n‡e| Ki“b| gvSLv‡bi mv`v NiwU‡Z Avcbvi 5. File>Print>Active Sheet(s)>Ok w`‡j PjwZ †Kv¤úvwbi bvg Grameen Phone †jLvwU wk‡Ui hZ †jLv wcÖ›U n‡e| wj‡L w`b| cÖwZ cvZvi cÖ_‡g Zv wcÖ›U 6. Number of copies N‡i msL¨v wj‡L w`‡j n‡e| cÖwZ cvZv ZZevi wcÖ›U n‡e| M) cvZvi bv¤^vi hw` DwV‡q w`‡Z Pvb Edit Undo or Redo(fyj KgvÛ ev` w`‡Z):Zvn‡j Avevi Dfq RvqMvq none wm‡j± Avgv‡`i Kw¤úDUv‡i KvR Kivi mgq fyj K‡i K‡i w`b| wKQz gy‡Q w`‡j Zv wdwi‡q Avbv hvq ⇒ Sheet GLv‡b Avcwb cvuPwU KvR Ki‡Z ÔevgÕ cv‡ki evuKv Zxi wU‡Z wK¬K cv‡ib
Technoloy Navigation Ground E-18/3, Middle Badda, Gulshan, Dhaka-1212 Mobile: 01911563761, email:
[email protected]
Microsoft Excel Page 4 of 13
Ki‡j fy‡j gy‡Q †`qv wRwbl wd‡i cvIqv hvq| Ki“b I WªvM K‡i wbw`©ó RvqMvq A_ev †Q‡o w`b| K_vwU‡K Gfv‡eI ejv hvq-- Avcwb †Kvb 6. Link Here wK¬K Ki“b| †m‡j †ekx iKg cwieZ©b K‡i ‡d‡j‡Qb wKš‘y 7. cÖ_gwUi mv‡_ wØZxqwUi wjsK n‡q Avcwb Pv‡”Qb GKUz Av‡M †h KgvÛwU hv‡e| ZvB cÖ_gwU‡Z †Kvb ai‡Yi w`‡q‡Qb ‡mwU wdwi‡q Avb‡eb ZLb Undo cwieZ©b K‡i G›Uvi Pvcvi mv‡_ Gi Rywi †bB| hw` Undo ‡ekx iKg K‡i †d‡jb mv‡_ wØZxqwU‡Z ‡mB cwieZ©b Zvn‡j ÔWvbÕ cv‡ki euvKv Zxi wU‡Z †`Lv hv‡e| wK¬K Ki‡Z n‡e, hvi bvg Redo Find, Replace, Goto Copy paste Kivi 1 bs wbqgt(kã †LvRv, cwieZ©b Kiv, mn‡R wbw`©ó 1. hv‡K Kwc Kie Zv Av‡M wm‡j± Ki‡Z RvqMvq hvIqv) n‡e| A‡bK kã †_‡K `iKvix kã Ly‡R ‡c‡Z n‡j 2. Copy evU‡b wK¬K Ki‡Z n‡e| 1. Edit > Find (†mB kãwU dvB‡j _vK‡Z 3. Kvm©iwU wbw`©ó RvqMvq ivL‡Z n‡e|) n‡e | 2. hv LyR‡Qb †mB kãwU wjLyb >Find Next 4. paste evU‡b wK¬K Ki‡Z n‡e| evUb Pvcyb| Copy paste Kivi 2 bs wbqgt3. Acvbvi Kvmv©iwU ILv‡bB P‡j hv‡e 1. hv‡K Kwc Ki‡eb Zv‡K Av‡M wm‡j± †h kãwU Avcwb LyR‡Qb| Ki“b| 4. GLb Avcwb hw` GwU‡K Ab¨ kã 2. wm‡j±K…Z As‡ki Dc‡i Wvb evU‡b w`†q cwieZ©b Ki‡Z Pvb Zvn‡j Replace wK¬K Ki“b| evU‡b wK¬K Ki“b| 3. Copy wK¬K Ki“b| 5. bZzb GKwU Ni Avm‡e 4. ‡hLv‡b ‡có Ki‡eb †mLv‡b Wvb 6. †mLv‡b Saiful kãwU wjLyb evU‡b wK¬K Ki“b| 7. Replace all evU‡b wK¬K Ki“b | 5. paste wK¬K Ki“b| 8. ‡`Lyb Av‡Mi kãwU Saiful w`‡q Copy paste Kivi 3 bs wbqgtcwieZ©b n‡q †M‡Q| 1. hv‡K Kwc Ki‡eb Zv‡K Av‡M wm‡j± 9. Edit>Goto>C200 wjLyb> Ok evU‡b Ki“b| wK¬K Ki“b| 2. wm‡j±K…Z As‡ki PZzw`©‡Ki C200 e‡· Kvm©i P‡j hv‡e| Gfv‡e cÖ‡qvRbxq eW©v‡ii Dc‡i Wvb evU‡b wK¬K †m‡ji Ki“b I WªvM K‡i wbw`©ó RvqMvq bvg wj‡L G›Uvi Pvc‡j Kvm©i †mB N‡i †Q‡o w`b| g~û‡Z©B P‡j hv‡e 3. Copy Here wK¬K Ki“b| Fill (¯^qswµq fv‡e †m‡ji wfZi ZvwjKv ev Copy paste Kivi 4 bs wbqgtbv¤^vi ‡jLv) 1. hv‡K Kwc Ki‡eb Zv‡K Av‡M wm‡j± C1 ‡m‡ji gv‡S 1 wjLyb > C Gi Dci wK¬K Ki“b| K‡i m¤ú~Y© Kjvg wm‡j± Ki“b > Edit 2. wm‡j±K…Z As‡ki Dc‡i Wvb evU‡b >Fill>Series>bZzb GKwU WvqvjM e· Avm‡e wK¬K Ki“b| >Stop velue N‡i wK¬K K‡i Kvm©i wbb> 50 3. Copy wK¬K Ki“b| wjLyb> OK w`b > †`Lyb 1 †_‡K 50 †jLv 4. ‡hLv‡b ‡có Ki‡eb †mLv‡b Wvb n‡q †M‡Q| evU‡b wK¬K Ki“b| C1 ‡m‡ji gv‡S 1 wjLyb> C Gi Dci wK¬K 5. paste Special >Transpose>ok K‡i m¤ú~Y© Kjvg wm‡j± Ki“b > Edit 6. Kjv‡gi †jLv¸‡jv †iv †Z P‡j Avm‡e| >Fill>Series> bZzb GKwU WvqvjM e· Avm‡e Copy paste Kivi 5 bs wbqgt>Stop velue N‡i wK¬K K‡i Kvm©i wbb> 4. hv‡K Kwc Ki‡eb Zv‡K Av‡M wm‡j± 500 wjLyb> Step Velue N‡i wK¬K K‡i Ki“b| Kvm©i wbb > 5 wjLyb >OK w`b| 5 ev` 5. wm‡j±K…Z As‡ki PZzw`©‡Ki w`‡q w`‡q †jLv n‡q †M‡Q| eW©v‡ii Dc‡i Wvb evU‡b wK¬K Clear (G‡·‡j cÖ‡qvRbxq GKwU KgvÛ)
Technoloy Navigation Ground E-18/3, Middle Badda, Gulshan, Dhaka-1212 Mobile: 01911563761, email:
[email protected] Avgiv G‡·‡j KvR Kivi mgq ‡mj ¸‡jv‡Z A‡bK iKg cwieZ©b G‡b _vwK| †mB cwieZ©b ¸wj `~i Ki‡Z †M‡j ‡mj¸wj wm‡j± K‡i Edit>Clear>Formats w`b|
View Avgv‡`i cÖ‡qvRbxq evi ¸wj hLb wbw`©ó hvqMvq bv cve ZLb Avgiv hv Ki‡Z cvwi 1) View > Toolbars > Standard or Formating 2) View > Fomula bar
Insert Row Avbvi wbqg t- Insert > Row Columns Avbvi wbqg t- Insert> Columns Worksheet Avbvi wbqg t- Insert > Worksheet Chart Avbvi wbqg tAvgiv Rvwb Z_¨ DcvˇK mn‡R cwi‡ek‡bi Rb¨ PvU© `iKvi nq| 2001-2 2002-3 2003-4 2004-5 bx‡Pi WvUv wjLyb| Agriculture Education Defence
562 456 852
452 658 452
562 458 256
698 568 456
Kvm©iwU WvUvi Dci ivLyb| Insert > Chart >Next >Finish GKwU PvU© P‡j Avm‡e| PvU©wU‡K AviI `„wó b›`b Kivi Rb¨ cÖ‡qvRbxq ¯’vb¸‡jv‡Z Wvej wK¬K K‡i K‡i cwieZ©b Kiv hv‡e|
Symbol (cÖZxK ev wPý ms‡hvRb) ‡hLv‡b cÖZxK `iKvi †mLv‡b Kvm©i ivLyb > Insert > Symbol > ‡h †KvbI GKwU wm¤^j wm‡j± K‡i Insert evUb wUcyb| Function(Sum, Count, Average, Max, Min) Avgiv Rvwb G‡·‡j g~jZ MvwYwZK mgvavb Lye `ª“Z Kiv hvq| †hgb eo eo †hvM, we‡qvM, ¸Y, fvM BZ¨vw`| GQvovI Mo, ‡Kvb GKwU wj÷ †_K mePvB‡Z eo msL¨v A_ev †QvU msL¨v wbwg‡lB †ei K‡i w`‡Z cv‡i GB d¨vskvb KgvÛ| Pjyb ïi“ Kiv hvK........................ cÖ_‡gB Sum d¨vskv‡bi e¨venvi----------------
Microsoft Excel Page 5 of 13
BwZc~‡e© ˆZix Kiv Saiful bvgK dvBjwU I‡cb Ki“b| Kvm©i Income Kjv‡gi †hLv‡b 4000 ‡jLv i‡q‡Q †mB N‡ii bx‡Pi †m‡j ivLyb| Insert>Function>Category e· †_‡K All wm‡j± Ki“b> Select Function †_‡K Sum>Ok > Number1 NiwU‡Z †`Lyb E2:E6 wm‡j± Ae¯’vq i‡q‡Q| Zvi A_© `vovq E2 †mj †_‡K ïi“ K‡i E6 ch©š— msL¨v ¸‡jv †hvM Kivi Rb¨ G‡·j cÖ¯‘Z i‡q‡Q, Gevi > Ok w`b > †`Lyb †hvMdj †ei n‡q‡Q| ‡hvM dj gy‡Q w`b| bZzbfv‡e ïi“ Ki“b Ges GKB wbq‡g Average, Min, Max, Count Gai‡bi †h †Kvb GKwU wm‡j± K‡i K‡i †hvM, Mo, †gvUmsL¨v, eo msL¨v, †QvU msL¨v †ei Ki‡Z _vKzb| Name (N‡ii bvg †`qv) eo eo †Kv¤úvwb‡Z GKvD‡Ýi wnmve Ki‡Z nq| †mB mKj wnmve Ki‡Z †M‡j †Kvb GKwU †m‡ji mv‡_ Ab¨ GKwU †m‡ji wjsK Ki‡Z nq| GB KvRwU K‡qK fv‡e Kiv hvq| hw` KvQvKvwQ Ki‡Z nq Zvn‡j mnR `ywU c×wZ Av‡Q| 1. gvD‡mi mvnv‡h¨........................ ‡mj c‡q›Uvi †h †Kvb GKwU mv`v N‡i ivLyb > Kx‡evW© †_‡K = cÖZxK w`b > †mj c‡q›UviwU‡K gvD‡mi gva¨‡g †hLv‡b wKQz †jLv i‡q‡Q Ggb GKwU N‡ii Dci wK¬K Ki“b > G›Uvi w`b| 2. Kx‡ev‡W©i mvnv‡h¨...................... ‡mj c‡q›Uvi †h †Kvb GKwU mv`v N‡i ivLyb > Kx‡evW© †_‡K = cÖZxK w`b > †mj c‡q›UviwU‡K Kx‡ev‡W©i ‡jdU-ivBU Avi Avc-WvDb G‡iv wU‡c †hLv‡b wKQz †jLv i‡q‡Q Ggb GKwU N‡i ivLyb > G›Uvi w`b| 3. wKš‘ Ggb hw` nq GB wjsKwU Ab¨ wk‡U ev Ab¨ `~‡i †Kv_vI w`‡Z n‡e ZLb wb‡Pi wbq‡g Ki‡Z n‡e| BwZc~‡e© ˆZix Kiv Saiful bvgK dvBjwU I‡cb Ki“b| Income Kjv‡g mg¯— Kg©Pvix‡`i †hvM dj †ei Ki“b| >djvdj N‡i ‡mj c‡q›Uvi ivLyb >
Technoloy Navigation Ground E-18/3, Middle Badda, Gulshan, Dhaka-1212 Mobile: 01911563761, email:
[email protected]
Microsoft Excel Page 6 of 13
Gevi †h ‡KvbI GKwU Qwe‡K gvD‡mi gva¨‡g WªvM K‡i cvZvq †Q‡o w`b|
dg©~jv ev‡ii †hLv‡b Name Box i‡q‡Q †mLv‡b wK¬K Ki“b > Saiful wjLyb > G›Uvi w`b > ‡h‡Kvb GKwU Lvwj N‡i wM‡q †mjc‡q›Uvi ivLyb > =Saiful wjLyb > G›Uvi w`b > †hLv‡b †hvMdj Avbv n‡q‡Q †mB N‡ii mv‡_ eZ©gvb N‡ii wjsK n‡q wM‡q‡Q| KvRwU Ab¨fv‡eI Kiv hvq.......................... Comment (gš—e¨ ms‡hvRb Kiv) G‡·j ev IqvW© cÖMÖv‡g gš—e¨ Kivi my‡hvM Av‡Q| GB gš—e¨¸‡jv †Kb wjLe? wjLe GB Kvi‡Y ‡h, ai“b ‡Kv_vI eû †jv‡Ki wj÷ wj‡L‡Qb| a‡i wbw”Q †mLv‡b Yasin bvgwU `yB ev Z‡ZvwaK evi UvB Kiv Av‡Q| GLb Zv‡`i‡K AvB‡Ww›UdvB Kivi Rb¨ Zv‡`i Dci gš—e¨ w`‡q ivL‡j mn‡RB Zvi cwiPq cvIqv †h‡Z cv‡i| GQvov cÖ‡qvRb ey‡S bvbv Kvi‡Y gš—e¨ †jLv ‡h‡Z cv‡i| bx‡P wKfv‡e gš—e¨ wjL‡Z nq Zvi eY©bv Kiv n‡q‡Q|
Insert >Picture>from file>Qwe wm‡j± K‡i >Insert Word Art kã‡K ˆkwíK iƒc `vb Kiv| Insert >Picture>Word Art>Select a WordArt Style wm‡j± K‡i > ok > dhaka UvBc Ki“b >Ok Diagram (Z_¨‡K WvqvMÖvg w`‡q cwi‡ekb Kiv) Awd‡m cÖavb Kg©KZ©vi Awa‡b A‡bK Awdmvi _v‡Kb| a‡i wbw”Q Zvi Awa‡b wZbRb Awdmvi Av‡Qb| WvqvMÖv‡gi gva¨‡g Zv‡`i‡K Dc¯’vcb Kiv †h‡Z cv‡i| wbqg nj--------Insert > Diagram > ‡h †Kvb GKwU wm‡j± Ki“b > Ok e·¸‡jv‡Z wK¬K K‡i Kvm©i wbb I WvqvMÖv‡g Z_¨ w`‡Z _vKzb| Object:Insert >Object >Microsoft Equation >Ok bZzb Avmv eviwU †_‡K cÖ‡qvRbxq KgvÛ w`‡q w`‡q exRMwY‡Zi MvYxwZK wm¤^j Avbv hvq|
BwZc~‡e© ˆZix Kiv Saiful bvgK dvBjwU I‡cb Ki“b| > Yasin Gi Dci †mj c‡q›Uvi ivLyb > Insert>Comment> njy` GKwU e· Avm‡e> †mB e‡· wjLyb He is a good Officer > evB‡i ‡h †Kvb †m‡j wK¬K Ki“b > †`Lyb Yasin Gi cv‡k jvj GKwU G‡iv G‡m‡Q > G‡ivi Dci Kvm©i ivL‡j gš—‡e¨ hv wjLv Av‡Q Zv †`Lv‡e|
Hiperliknk 1. ‡h †KvbI †m‡j Kvm©i ivLyb| 2. Insert > Hyperlink > dvBj wm‡j± K‡i > Insert 3. gvDm c‡q›Uvi wjsK wUi Dci ivL‡j nv‡Zi AvK…wZ ‡`Lv‡e| 4. wjsKwUi Dci wK¬K Ki“b| 5. dvBjwU Ly‡j hv‡e|
gš—e¨wU gy‡Q w`‡Z PvB‡j Yasin Gi Dci Wvb evU‡b wK¬K Ki“b > Popup †gby †_‡K Delete Comments wm‡j± Ki“b|
Format †gby‡Z cell GKwU ¸i“Z¡c~Y© Avskt1. B10 ‡m‡j bx‡Pi jvBbwU wjLyb| Tex 100% Cotton, 1X1 Rib, 240-260 Gsm 3. ‡jLv †k‡l G›Uvi w`b > B10 ‡m‡j Kvm©i ivLyb| 4. Format>Cell>Alignment> Wrap Text >ok 5. ‡`Lyb †jLv¸‡jv †f‡½ GKwU †m‡ji g‡a¨ P‡j G‡m‡Q>Undo 6. Format>Cell>Alignment> Shrink to fit >ok 7. ‡`Lyb †jLv¸‡jv †QvU n‡q †m‡ji g‡a¨ P‡j G‡m‡Q > Undo 8. Format>Cell>Alignment> Lvov K‡i †jLv Text >ok
Picture Qwe ms‡hvM Kiv| ‡hLv‡b Qwe `iKvi †mLv‡b Kvm©i ivLyb| Insert >Picture>ClipArt > ‡h‡Kvb GKwU †KUvMixi Dci wK¬K Kiyb > gvD‡mi gva¨‡g WªvM K‡i cvZvq G‡b †Q‡o w`b| A_ev Insert >Picture>ClipArt >Clip Organizer> Office Collections Gi cvm G wK¬K Ki“b > Buildings
Format
Technoloy Navigation Ground E-18/3, Middle Badda, Gulshan, Dhaka-1212 Mobile: 01911563761, email:
[email protected] 9. ‡`Lyb †jLv¸‡jv †m‡ji g‡a¨ GK GK A¶i n‡q Lvov n‡q‡Q > Undo 10. Format>Cell>Alignment> 90° >ok 11. †jLv¸‡jv †m‡ji g‡a¨ bxP †_‡K Dci †`Lv‡”Q > Undo 12. Format > Cell > Alignment > Horizontal ‡_‡K Center Ges Vertical ‡_‡K Center wm‡j± Ki“b > ok 13. ‡jLv †m‡ji wVK gvSLv‡b P‡j hv‡e|
Microsoft Excel Page 7 of 13
Ki“b> 6000 wjLyb> Format > GKwU WvqvjM e· Avm‡e, Color e· †_‡K jvj is >Ok>Ok w`b| †`Lyb 6000 UvKvi bx‡P hviv Income K‡i Zv‡`i‡K jvj Kvwj †`qv n‡q‡Q|
Tools
Spelling (evbvb wVK Kiv)t‡h †Kvb GKwU †m‡j Picture evbvbwU‡K fyj K‡i Gfv‡e wjLyb Pictore> G›Uvi Pvcyb > kãwU wm‡j± Ki“b > Tools> spelling > GKwU Row, Columns, sheet WvqvjM e· Avm‡e > mwVK evbvb Picture 5 ‡_‡K 3 ch©š— †iv Hide K‡i w`b| Hide wm‡j± n‡q Av‡Q Change evU‡b wUcyb| fyj Kivi Rb¨ hv Ki‡Z n‡e Zv n‡jv 5 I 6 Gi evbvb wVK n‡q hv‡e gvSLv‡b gvDm c‡q›Ui wb‡j c‡q›UviwU G Protection we‡kl cvmIqvW© iKg n‡q hv‡e| ZLbB †P‡c a‡i 3 ch©š ‡Kvb †Kvb Awd‡m GB iKg dvBj ˆZix Ki‡Z — G‡m †Q‡o w`b| nq †h, †mB dvBj †hb Kg©Pvixiv I‡cb K‡i G‡`i‡K Unhide Kivi Rb¨ 1 ‡_‡K 9 ch©š— †`L‡Z cv‡i ev wcÖ›U Ki‡Z cv‡i wKš‘ Zv‡Z me¸‡jv †iv wm‡j± Ki“b> Format > Row > †hb wKQy wjL‡Z bv cv‡i| G R‡b¨ e¨envi Height > 12.75 > Ok Kiv nq we‡kl ai‡bi cvmIqvW©| F ‡_‡K B ch©š— Kjvg Hide K‡i w`b| Hide ‡h dvB‡j cvmIqvW© w`‡eb Zv open Ki“b.............. Kivi Rb¨ hv Ki‡Z n‡e Zv n‡jv F I G Gi Tools>Protection >protect sheet>Password to gvSLv‡b gvDm c‡q›Ui wb‡j c‡q›UviwU G iKg n‡q hv‡e| ZLbB †P‡c a‡i B ch©š unprotect sheet Gi Lvwj e‡· wK¬K K‡i 123 UvBc Ki“b > *** GB iKg wZbwU ÷vi — G‡m †Q‡o w`b| †`Lv‡e Ok w`b > AveviI 123 UvBc Ki“b G‡`i‡K Unhide Kivi Rb¨ A ‡_‡K H ch©š— >*** GB iKg wZbwU ÷vi †`Lv‡eOk me¸‡jv Kjvg wm‡j± w`b>File > Save Ki“b>Format>Column>Width>8.43 > Ok GUv K‡i ivL‡j Avcbvi dvBj †KD bó Ki‡Z Avcwb †h wk‡U KvR Ki‡Qb Zv hw` Hide cvi‡e bv| Zv cix¶v K‡i †`Lvi Rb¨ K‡i w`‡Z Pvb Saiful Islam UvBc Ki‡Z †M‡j †`L‡eb wKQzB ‡jLv Avm‡Q bv| wKQz †jLv wm‡j± K‡i Format > sheet > Hide wWwjU evU‡b Pvcyb| wdwi‡q Avb‡Z n‡j > Format > sheet > n‡Z cv‡i Avcbv‡K GB WKz‡g‡›UB Avevi Unhide evowZ wKQz wjL‡Z n‡e| ZvB Auto Format (my›`i GKwU wWRvBb †`qv) BwZc~‡e© ˆZix Kiv Saiful bvgK dvBjwU WKz‡g›UwU‡K cvmIqvW© gy³ Kiv `iKvi| hv Ki‡Z n‡e I‡cb Ki“b| 1. ‡h dvB‡ji cvmIqvW© DVv‡eb Zv I‡cb Format >Autoformat > ‡h †KvbI GKwU Ki“b.............. wWRvBb wm‡j± Ki“b > ok 2. Tools>Protection >Unprotect sheet>123 UvBc di‡gUwU DwV‡q w`‡Z PvB‡j Format Ki“b > Ok > File > Save >Autoformat > None wm‡j± Ki“b > ok Conditional Formating(kZ©mv‡c‡¶ di‡gU Goal seek j¶¨ Ly‡R †ei Kiv tKiv) bx‡Pi WvUv¸‡jv wjLyb| 1) BwZc~‡e© ˆZix Kiv Saiful bvgK dvBjwU A B I‡cb Ki“b| 1 Bank Amount 900000 2) Income Kjv‡gi wbD‡gwiK Ask UzKz 2 Interest 9% wm‡j± Ki“b| 3 Periods/Year 30 3) Format>Conditional Formating.>between e‡· 4 wK¬K K‡i less then > c‡ii mv`v N‡i wK¬K 5 Payment
Technoloy Navigation Ground E-18/3, Middle Badda, Gulshan, Dhaka-1212 Mobile: 01911563761, email:
[email protected] a‡i wbw”Q e¨vsK Avcbv‡K evox Kivi Rb¨ 900000 UvKv †jvb w`‡e| 9% my` w`‡Z n‡e| my‡`Avm‡j 30 eQ‡i me UvKv e¨vs‡K †diZ w`‡Z n‡e| cÖwZ gv‡m 1wU wKw¯— †`qv n‡j eQ‡i 12wU wKw¯— †`qv hv‡e| G‡·‡j cÖwZUv wKw¯— KZUvKv K‡i w`‡Z n‡e ‡mUv †ei Ki‡Z n‡j †mj c‡q›Uvi B5 N‡i ivLyb I myÎ wjLyb =PMT(B2/12,B3*12,B1) G›Uvi w`b| †iRvë Avm‡e 7241.60 UvKv | A_©vr Avgiv †ei Kijvg cÖwZ gv‡m wKw¯— 7241.60 UvKv| ¯^vfvweK fv‡eB †jv‡K‡`i g‡b cÖkœ Avm‡Z cv‡i †KD hw` cÖwZ gv‡m 5000 UvKv K‡i wKw¯— cwi‡kva Ki‡Z cv‡i e¨vsK H e¨w³‡K KZ UvKv †jvb w`‡e? †mB KvRwU Ki‡ZB Goal seek `iKvi nq| Pjyb Zvn‡j ïi“ Kwi| BwZc~‡e© †h N‡i myÎwU wj‡L‡Qb †mB N‡i ‡mj c‡q›Uvi ivLyb > Tools > Goal seek w`b, c`v©q Avm‡e.............
To velue N‡i Fb MªnxZv cÖwZ gv‡m hZ w`‡Z cvi‡e †mB AsK wjLyb| a‡i wbjvg †m 5000 UvKv cÖwZ gv‡m wKw¯— w`‡Z cvi‡e| myZivs 5000 B UvBc Ki“b| By changing cell N‡i Kvm©i †i‡L B1‡m‡j ‡hLv‡b 900000 †jLv i‡q‡Q †mLv‡b wK¬K Ki“b Ok > Ok Scenarios Avcbviv Rv‡bb e¨vsK wewfbœ UvB‡ci †jv‡bi e¨ve¯’v iv‡L| †hgb Mvoxi R‡b¨ †jvb, e¨emvq Gi R‡b¨ †jvb A_ev evoxi R‡b¨ †jvb ‡`qv nq| Gfv‡e †jvb w`‡q _v‡K| e¨vsK Awdmvi MY Scenarios w`‡q GB KvRwU Zv‡`i Kw¤úDUv‡i K‡i ivL‡Z cv‡ib| KvRwUI cÖvq Gool seek Gi gZB| 1. Gool seek †hLv‡b Gi KvR K‡i‡Qb †mB kxU I‡cb Ki“b 2. †mj c‡q›UviwU m~‡Îi N‡i ivLyb|
Microsoft Excel Page 8 of 13
3. Tools >Scenarios >Add > 4. Home wjLyb>Canging cell Gi N‡i wK¬K K‡i hv Av‡Q gy‡Q w`b> gvD‡mi gva¨‡g B1, B2, B3 GB wZbwU Ni wm‡j± Ki“b > Ok > Add 5. Car wjLyb > Canging cell N‡i hv Av‡Q gy‡Q w`b > B1, B2, B3 GB wZbwU Ni wm‡j± Ki“b > Ok> 1bs N‡i 120000>2bs N‡i 6%>3 bs N‡i 20> Add 6. Business wjLyb >Canging cell wK¬K K‡i hv Av‡Q gy‡Q w`b > B1, B2, B3 GB wZbwU Ni wm‡j± Ki“b > Ok> 1bs N‡i 500000>2bs N‡i 11%>3 bs N‡i 5> Add> cancel Gevi Car wm‡j± Ki“b>show > wk‡U †`Lyb Mvoxi Rb¨ KZ †jvb ‡`qv n‡e Gevi Home > show > wk‡U †`Lyb evoxi Rb¨ KZ †jvb | Gevi Business >show wk‡U †`Lyb e¨emvqi Rb¨ KZ †jvb | A_©vr hv Avcwb GW K‡i ivL‡eb †m¸wj GLv‡b †`L‡Z cv‡eb| g‡b ivL‡eb cÖ_‡g m~ÎwU bv _vK‡j Gme wKQyB n‡Zv bv| Auditing K) J1, K1, L1 N‡i h_vµ‡g 10, 56, 30 wjLyb| L) K10 N‡i Kvm©i ivLyb >m~Î wjLyb =J1+K1+L1 G›Uvi w`b M) †`Lyb Zv‡`i †hvMdj P‡j Avm‡e| N) K10 N‡i ‡hLv‡b †hvMdj i‡q‡Q †mLv‡b †mj c‡q›Uvi ivLyb O) Tools >Auditing >Trace presidents O) G‡iv gyQ‡Z n‡j Tools >Auditing>Remove all arows Coustomize wb‡Ri gZ K‡i AvBKb mvRv‡bvtTools> Coustomize>Toolbars GLv‡b Avcwb Uzjevi ¸‡jvi wjó †`L‡Z cv‡eb| evi ¸‡jvi bv‡gi cv‡k wUK gvK© w`‡q evi Avbv hv‡e Avi wUK gvK© DwV‡q w`‡j evi¸‡jv P‡j hv‡e| GB KvRwU View ‡gby‡Z ‡_‡KI Kiv hvq| Tools> Coustomize>Commands GLv‡b Avcwb wewfbœ KgvÛ AvBKb K¬xK K‡i WªvM Ki“b I †h †Kvb ¯’v‡b †hvM Ki“b| AwfÁZvi Av‡jv‡K †`Lv †M‡Q G‡·‡j KvR Kivi mgq wKQz wKQz AvBKb †gby ev‡i hy³ K‡i ivL‡j cÖ‡qvR‡bi mgq KvR Kiv LyeB mnvqK n‡q _v‡K| Ah_v wK¬K Kivi cwigvY A‡bK K‡g hvq|
Technoloy Navigation Ground E-18/3, Middle Badda, Gulshan, Dhaka-1212 Mobile: 01911563761, email:
[email protected] Tools> Coustomize>Commands>Edit> ClearFormating evUbwU †P‡c a‡i †gbyev‡i G‡b †Q‡o w`b Tools> Coustomize>Commands>Insert> Rows I Columns evUb `ywU †P‡c †gbyev‡i G‡b †Q‡o w`b Tools> Coustomize>Commands>Format> Cells evUbwU †P‡c †gbyev‡i G‡b †Q‡o w`b Options Tools>Options>View--------GLv‡b Acwb Formula bar, Status Bar, Gridlines, Row and Columns Headers, Horizontal Scroll bar, Vertical Scroll bar, Zero values, Sheet tabs GB¸wj Off ev On ivL‡Z cv‡ib| Z‡e g‡b ivLv‡Z n‡e cÖwZevi Ok wU‡c Zvi Kvh©KvwiZv †`L‡Z n‡e|
Data Assending I Desending Kiv tWvUv µgvbymv‡i mvRv‡bvi Rb¨ Assending I Desending Gi PvB‡Z mnR A_P my›`i wbqg Gi GKwUI †bB| Pjyb Zvn‡j ïi“ Kiv hvK| bx‡Pi WvUv¸‡jv wj‡L †djyb| Name Age Sex Position Income Salam 56 M Officer 56565 Barkot 15 M Engineer 45465 Rafique 26 M Teacher 65656 Jabbar 42 M Officer 21322 Solayman 12 M Engineer 32232 Yasin 32 M Teacher 33232 Mizan 45 M Officer 32698 Jesmin 23 F Engineer 56664 Putul 65 F Teacher 56566 Name N‡i ‡mj c‡q›Uvi ivLyb| Gevi wK¬K Ki“b, Zv‡Z WvUv wVK Awfav‡bi wbqg Abymv‡i µgvbymv‡i mw¾Z n‡q hv‡e| A_©vr evsjv ev Bs‡iRx wW‡K‡kbvix‡Z ‡hgb A †_‡K Z ch©š— k㸇jv µgvbymv‡i mvRv‡bv _v‡K †Zgwb mw¾Z n‡q hv‡e| Gevi hw` wVK Zvi D‡ëv KvRwU Ki‡Z hvb Zvn‡j Name N‡i ‡mj c‡q›Uvi ivLyb > GB AvBKbwU‡Z wK¬K Ki“b| Z †_‡K A ch©š— k㸇jv µgvbymv‡i mw¾Z n‡q hv‡e| mv‡_ mv‡_ AviI GKwU welq j¶¨bxq †h, Salam Gi eqm 56†m cyi“l Psition n‡”Q Officer Ges Income = 56565 UvKv GwU wKš‘ Zvi mv‡_ mv‡_B _vK‡Q| Assending ev
Microsoft Excel Page 9 of 13
Desending hvB K‡ib bv †Kb| Age, Sex, Postion, Income Kjvg¸‡jv‡Z Kvm©i ‡i‡L Gi cÖ‡qvM †`L‡Z cv‡ib| GKwU K_v g‡b ivL‡Z n‡e hw` Avcwb WvUv¸‡jv wm‡j± K‡i ‡bb ZLb Sort Warning ‡g‡mR Avm‡e| ‡g‡mRwU ey‡S Ok w`b| Filter (WvUv †Q‡K ‡ei Kiv )t1. WvUvi g‡a¨ c‡q›Uvi ivLyb| 2. Data > Filter > Autofilter 3. ‡`L‡Z cv‡eb WvUvq cÖwZwU Kjv‡gi ïi“‡Z WªcWvDb G‡iv ev Zxi G‡m‡Q| 4. Income Gi Wªc WvDb G‡iv‡Z wK¬K Ki“b>(Custom.....) 5. equals > is less then 6. mvg‡bi Lvwj N‡i wK¬K K‡i 25000 > Ok w`b| 7. cwPk nvRvi UvKvi bx‡P hviv Avq K‡i Zv‡`i wjó †`Lv‡e| 8. mg¯— WvUv wdwi‡q Avb‡Z n‡j >WªcWvDb G‡iv >(All) 9. Position Gi Wªc WvDb G‡iv‡Z wK¬K Ki“b>Engineer ïay BwÄwbqvi‡`i WvUv †`Lv‡e| 10. mg¯— WvUv wdwi‡q Avb‡Z n‡j >WªcWvDb G‡iv >(All) 11. Sex Gi Wªc WvDb G‡iv‡Z wK¬K Ki“b> F > ïay †g‡q‡`i WvUv †`Lv‡e| M wm‡j± K‡i †Q‡j‡`i WvUv †`L‡Z cv‡ib| 12. mg¯— WvUv wdwi‡q Avb‡Z n‡j >WªcWvDb G‡iv >(All) 13. Age Gi Wªc WvDb G‡iv‡Z wK¬K Ki“b>(Custom.....) 5. equals > is Greater then 15. mvg‡bi Lvwj N‡i wK¬K K‡i 30 > Ok w`b| 16. 30 Gi Dc‡i hv‡`i eqm Zv‡`i wjó †`Lv‡e| 17. mg¯— WvUv wdwi‡q Avb‡Z n‡j >WªcWvDb G‡iv >(All) 18. Name Gi Wªc WvDb G‡iv‡Z wK¬K Ki“b>(Custom.....) 19. Lvwj N‡i S* > Ok hv‡`i bv‡gi cÖ_g A¶i S w`‡q ïi“ n‡q‡Q Zv‡`i wjó †`Lv‡e| 20. mg¯— WvUv wdwi‡q Avb‡Z n‡j >WªcWvDb G‡iv >(All) Form
Technoloy Navigation Ground E-18/3, Middle Badda, Gulshan, Dhaka-1212 Mobile: 01911563761, email:
[email protected] A‡bK mgq WvUvi AvB‡Ug hw` †ekx nq ZLb 10/20 Uv Kjvg Ry‡i WvUv BbcyU Ki‡Z nq| evi evi ¯Œj K‡i WvUvi †kl cÖv‡š— hvIqv ev cÖ_‡g Avmv mwZ¨ GK weiw³Ki e¨vcvi| ZLb GB Form e¨envi K‡i Lye mn‡R WvUv BbcyU Kiv hvq| Gevi †`Le wK K‡i Zv Kiv nq| 1. Filter ‡gbyi R‡b¨ ˆZix Kiv WvUv I‡cb Ki“b| 2. WvUvi g‡a¨ †mj c‡q›Uvi ivLyb| 3. Data>Form>GKwU WvqvjM e· Avm‡e >ILv‡b GKwU ¯Œjvi i‡q‡Q>¯Œj K‡i WvUv Ly‡R †ei Kiv hvq| 4. New evU‡b wK¬K Ki“b>AviI bZzb †Kvb WvUv _vK‡j wjLyb >AveviI New evU‡b wK¬K Ki“b>bZzb WvUv¸‡jv c~‡e©i WvUvi mv‡_ GW n‡q hv‡e| 5. ‡Kvb †iKW© Ly‡R †ei K‡i Delete evUb Pvc‡j †iKW© gy‡Q hv‡e| 6. Restore evUb Pvc‡j WvUv wd‡i Avm‡e| Subtotal ( ‡ei Kivi wbqgt-) 1. ‡mj c‡q›Uvi Position Kjv‡g ivLyb 2. Gevi wK¬K Ki“b (Assending ) 3. Data > Subtotals w`b| 4. At each change in e‡· Position 5. Function e‡· Sum 6. Add subtotal to e‡· Income () > Ok 7. ‡`Lyb BwÄwbqvi, Awdmvi G‡`i BbKv‡gi Avjv`v Avjv`v fv‡e Total P‡j G‡m‡Q| 8. Use Function e‡· Average _vK‡j Mo cvIqv †hZ| 9. Use Function e‡· Count _vK‡j msL¨v cvIqv †hZ| 10. Ab¨vb¨ Function ¸‡jvi e¨venvi †`L‡Z _vKzb|
Microsoft Excel Page 10 of 13
1. Kjvg H Gi Dci wK¬K K‡i m¤ú~Y© Kjvg wm‡j± Ki“b| 2. Data>Validation 3. Alow e· †_‡K Decimal 4. Data e· †_‡K is less then 5. Maximum e‡· 10000 > Ok 6. Gevi H Kjv‡g Avcwb 11000 wjLyb I G›Uvi w`b| 7. ‡g‡mRwU c‡o ‡`Lyb Avcbvi 11000 †jLv‡K Invalid ejv n‡q‡Q| GKwU welq †f‡e †`Lyb Avcwb H Kjv‡g 10000 UvKv wjLvi wbqg K‡i w`‡q‡Qb wKš‘y Avcbvi Kg©Pvix †h Avcbvi Awd‡m †mjvwi kxU ‰Zix K‡i wZwb nq‡Zv G welhUv Rv‡b bv †h hvB wjwL 10000 UvKvi bx‡P wjL‡Z n‡e| ZvB H Kjv‡g GKwU ‡g‡mR Szwj‡q ivL‡j g›` nq bv| 8. Kjvg H Gi Dci wK¬K K‡i m¤ú~Y© Kjvg wm‡j± Ki“b| 9. Data>Validation 10. Input message> Input message N‡i is less then 10000 K_vwU wj‡L > Ok w`b AviI GKwU welq wb‡q wPš—v Ki“b| hw` Zvi ciI †KD mxgvi evB‡i wKQz wjL‡Z hvq Z‡e GKwU g¨v‡mR Av‡m| †mB g¨v‡mRwUI Avcwb wb‡Ri gZ K‡i wj‡L w`‡Z cv‡ib| ZvB 11. Kjvg H Gi Dci wK¬K K‡i m¤ú~Y© Kjvg wm‡j± Ki“b| 12. Data>Validation 13. Error Alart> Error message N‡i please write there less then 10000 K_vwU wj‡L > Ok w`b Validation G wjó mshy³ Kivi AckvbI i‡q‡Q| 14. K Kjv‡g 6wU ‡Rjvi bvg wjLyb| Validation †Kvb Kjvg ev †m‡j wbw`©ó 15. Kjvg K Gi Dci wK¬K K‡i gvÎv wVK K‡i ‡`qv m¤ú~Y© Kjvg wm‡j± Ki“b| WvUv‡K hLb wbw`©ó MwÛi g‡a¨ wjL‡Z 16. Data>Validation PvB ZLb GwUi `iKvi nq| AviI mnR K‡i ewj, 17. Alow e· †_‡K List †hgb †KD hw` Zvi Awd‡mi Kg©Pwi‡`i 18. Sourse N‡i wK¬K K‡i 6wU †Rjvi †eZb 10,000 UvKvi Dci w`‡Z ivwR bb| bvg wm‡j± >Ok †mB †¶‡Î fy‡j hv‡Z 10,000 UvKvi Dc‡i Validation ‡ivj cwi®‹vi K‡i w`‡Z PvB‡j ‡Kv_vI UvBc bv n‡q hvq †mB Rb¨ †eZb 19. Kjvg K Gi Dci wK¬K K‡i N‡i wZwb hw` GKwU GKwU aivevav wbqg m¤ú~Y© Kjvg wm‡j± Ki“b| K‡i ‡`b Zvn‡j wZwb wbwðZ n‡Z cvi‡eb †h 20. Data >Validation >Clear All †Kv_vI 10,000 UvKvi Dc‡I UvBc n‡”Q bv| Text to Columns Pjyb Zvn‡j GB †iw÷ªKkvb †`qvi wbqgUv ai“b fyj K‡i GKB ‡mj Gi g‡a¨ K‡qKwU kã wk‡L †bB| wj‡L †d‡j‡Qb hv K‡qKwU Kjv‡gi †m‡j cvkv
Technoloy Navigation Ground E-18/3, Middle Badda, Gulshan, Dhaka-1212 Mobile: 01911563761, email:
[email protected] cvwk †jLv `iKvi wQj | †hgb B17 ‡m‡j Name Age Sex Position Income wjLyb> G›Uvi w`b> B17 ‡m‡j Kvm©i ivLyb| >Data>Text to Columns> Next> Next> Finish Consolidate (msw¶ß Kiv) ai“b Avcbvi wZbwU ‡dvb-d¨v‡·i †`vKvb i‡q‡Q- evÇvq, DËivq Avi ¸jkv‡b | wZbwU †`vKv‡bi wnmve ivLvi Rb¨ G‡·j cÖMÖvgwU bZzb K‡i I‡cb Ki“b| cÖ_‡gB dvBjwU †mf K‡i wbb| 1. File > Save > Mamun > Save> bx‡Pi WvUv¸‡jv wjLyb Comp Name Cards Price Grameen 5 1500 Aktele 6 1800 Banglalink 82 24600 Telitalk 25 7500 Warid 45 13500 2. Sheet1 G Wvej wK¬K>wjLyb Badda> G›Uvi Pvcyb| 3. Sheet2 G Wvej wK¬K>wjLyb Gulshan> G›Uvi Pvcyb| 4. Sheet3 G Wvej wK¬K>wjLyb Uttara> G›Uvi Pvcyb| 5. AviI GKwU kxU `iKvi ZvB >Insert>Worksheet 6. Sheet4 G Wvej wK¬K>wjLyb Total> G›Uvi Pvcyb| 7. Badda kxU †_‡K bx‡Pi WvUv ¸‡jv Kwc Ki“b Ges Zv Gulshan Uttara, Total bvgK kx‡U †có K‡i w`b| 8. Total bvgK kxU †_‡K wbD‡gwiK msL¨v gy‡Q w`b| 9. Total bvgK kx‡U †hLv‡b Cards ‡jLv i‡q‡Q wVK Zvi bx‡Pi †m‡j †mj c‡q›Uvi ¯’vcb Ki“b > Data > Consolidate 10. kx‡Ui bvg Badda ‡Z wK¬K Ki“b > ïay wbD‡gwiK Ask UyKz wm‡j± Ki“b > Add > 11. Gulshan> ïay wbD‡gwiK Ask UyKz wm‡j± Ki“b > Add> 12. Uttara> ïay wbD‡gwiK Ask UyKz wm‡j± Ki“b > Add>ok ‡`Lyb wZbwU †`vKv‡bi me©‡gvU KZwU KvW© i‡q‡Q Zvi †UvUvj Ges ‡mB mv‡_ KZ UvKvi gvjvgvj Avcbvi †`vKv‡b Mw”QZ Av‡Q Zvi GKwU †gvU wnmve P‡j G‡m‡Q| Pivot table and Pivot chart Report
Microsoft Excel Page 11 of 13
1. Data ‡gbyi R‡b¨ ˆZix Kiv dvBjwU I‡cb Ki“b 2. Data Gi Dci Kvm©i ivLyb 3. Data> Pivot table and Pivot chart Report > Next > Next > Finish GKwU bZzb wdPvi Avm‡e| 4. Pivot table Field list ‡_‡K Sex †U‡b a‡i Drop Row Fields Hear Gi Dci †Q‡o w`b| 5. Pivot table Field list ‡_‡K Position †U‡b a‡i Drop Columns Fields Hear Gi Dci †Q‡o w`b| 6. Pivot table Field list ‡_‡K Income †U‡b a‡i Drop Data Items Hear Gi Dci †Q‡o w`b| 7. ‡`Lyb bZzb GKwU kxU G‡m‡Q| WvUv my›`i GbvjvBRW n‡q †M‡Q| cyi“l‡`i I gwnjv‡`i wnmve Avjv`v Avjv`v K‡i P‡j G‡m‡Q| †mB mv‡_ wk¶K, BwÄwbqvi I Awdmv‡`i WvUvI mn‡RB Avjv`v Kiv hv‡”Q| 8. c~‡e©i g~j WvUv‡Z wd‡i †h‡Z n‡j wewfbœ kxU †U‡ei Dci wK¬K K‡i K‡i Ly‡R †`Lyb|
Windows
mKj DB‡Ûv GK mv‡_ †`LvtG‡·‡j KvR Kivi mgq wewfbœ iKg WvUv BbcyU Ki‡Z nq | †Kvb †Kvb WvUv Ggb n‡Z cv‡i ‡h Ab¨ dvBjwU †`‡L †`‡L Ki‡Z n‡”Q| ZLb cÖ‡qvRb nq `ywU dvBj †Lvjv ivLvi| †hb GKwU †`‡L Ab¨wUi KvR Kiv hvq| Pjyb Zvn‡j wmm‡UgwU †`‡L †bB| cÖ_‡gB wZbwU dvBj Open Ki“b| windows>Arrange Data Freez 1. Avcbvi cy‡iv‡bv dvBj I‡cb Ki“b| 2. B2 ‡mj wm‡j± K‡i >Window > Freez pens 3. ‡`Lyb A Kjvg I 1g †iv wd«R n‡q wM‡q‡Q| Kx‡ev‡W©i WvDb G‡iv ‡P‡c a‡i ivL‡jB Zv eyS‡Z cvi‡eb †h cÖ_g †iv wd«R n‡q †M‡Q ev bovPov Ki‡Q bv| wVK GKB fv‡e ivBU G‡iv wUc w`‡q ivL‡j †`L‡eb cÖ_g KjvgwUI wd«R n‡q †M‡Q| Split
Technoloy Navigation Ground E-18/3, Middle Badda, Gulshan, Dhaka-1212 Mobile: 01911563761, email:
[email protected] Windows>Split> ‡hLv‡b Kvm©i _vK‡e †mLv‡b PviwU DB‡Ûv n‡q hv‡e| DwV‡q w`‡Z n‡j Windows>Remove Split
Help cÖwZwU md&UIq¨v‡iB Help †gby _v‡K| Help wb‡Z n‡j Help>show the office assistant >Avcwb hv Rvb‡Z Pvb Zv wj‡L G›Uvi w`b| A‡bK †¶‡ÎB Kw¤úDUvi wbR †_‡KB Avcbv‡K mvnvh¨ Ki‡Z Assistant cvVvq Zv hw` Acbv‡K Lye wei³ K‡i Zvn‡j Help>Hide the office assistant
Some Tips
MS Excel G evsjvq Tk ev UvKv †jLv Avb‡Z n‡j 1. Filter ‡gbyi R‡b¨ ˆZix Kiv dvBjwU I‡cb Ki“b 2. Income Gi wbDg¨vwiK Ask wm‡j± Ki“b 3. Format > Cells > Coustom > ¯Œj K‡i me©‡kl Type wm‡j± Ki“b > Type Dc‡ii N‡i N‡i ïaygvÎ $ wPýwU gy‡Q w`b > Tk UvBc Ki“b > Ok A1 †m‡j 1 wjLyb > A2 †m‡j 2 wjLyb >G›Uvi w`b >Gevi 1 Ges 2 wm‡j± Ki“b> gvDm c‡q›Uvi wm‡jKkv‡bi bx‡P Wvb †Kvbvq ai‡j gvDm c‡q›UviwU Fill Handale AvK…wZi n‡q hv‡e >†P‡c a‡i bx‡Pi w`‡K Uvb w`b| January wjLyb>G›Uvi Pcyb> January wm‡j± Ki“b > Fill handale a‡i bx‡Pi w`‡K Uvb w`b| me¸‡jv gvm P‡j Avm‡e| Saturday wjLyb> G›Uvi Pvcyb> Saturday wm‡j± Ki“b > Fill handale a‡i bx‡Pi w`‡K Uvb w`b| mßv‡ni bvg Avm‡e| ai“b Avcbvi Awd‡m Avcbv‡K Kg©Pvwi‡`i †eZbfvZv cÖ`v‡bi KvRwU Ki‡Z nq|†m †¶‡Î Kg©Pvix‡`i bvg cÖvqB †jLvi c‡qvRbxqZv †`Lv w`‡e| G‡·‡j bv‡gi ZvwjKv hy³ Ki‡Z PvB‡j †Kvb GKwU Kjv‡g Mostafa, Mizan, Saiful, Jamil, Khokon, Osman, Belal, Anis GB ‡iRvë kxU ‰Zix Kivt767
Microsoft Excel Page 12 of 13
KqR‡bi bvg wjLb > me¸‡jv bvg wm‡j± Ki“b >Tools>Options>Custom List> Import > Ok Gevi Avcwb GKwU bvg Anis wjLyb> G›Uvi w`b > bvgwU wm‡j± Ki“b > Fill handale a‡i bx‡Pi w`‡K Uvb w`b| ‡hvM, we‡qvM, ¸Y, fvM, A1 †m‡j 220 wjLyb > A2 †m‡j 120 wjLyb >G›Uvi w`b >Gevi A3 ‡m‡j †mj c‡q›Uvi ivLyb > = wPý w`b >gvDm w`‡q 220 Gi Dci wK¬K Ki“b> + wPý w`b>gvDm w`‡q 120 Gi Dci wK¬K Ki“b> G›Uvi w`b| GKB wbq‡g we‡qvM I ¸Y, fvM, Ki“b| (* ¸b wPý, / fvM wPý) G‡·‡j evsjv wjL‡Z n‡j hZUzKz‡Z evsjv ‡jLvi `iKvi g‡b Ki‡Qb ZZUzKz RvqMv wm‡j± Ki“b > Format>cells> Fonts > SuttonnyMJ >ok A1 †m‡j 220 wjLyb > A2 †m‡j 10% wjLyb >G›Uvi w`b >Gevi A3 ‡m‡j †mj c‡q›Uvi ivLyb > = wPý w`b >gvDm w`‡q 220 Gi Dci wK¬K Ki“b> * wPý w`b>gvDm w`‡q 10% Gi Dci wK¬K Ki“b> G›Uvi w`b| Gfv‡e kZKiv cwigvY †ei Kiv hvq| G‡·‡j ‡h †Kvb msL¨vi cÖ_‡g 0 wj‡L w`‡jI _v‡K bv| †hgb †gvevBj bv¤^vi¸‡jv 01719865322 Avcwb hw` †Kvb N‡i 0 w`‡q bv¤^viwU wjL‡Z Pvb Zvn‡j bx‡Pi KvR¸‡jv Ki‡Z n‡e| ‡h †Kvb GKwU Lvwj N‡i †mjc‡q›Uvi ivLyb > Format>cell>number>Text>Ok w`b Gevi ‡gvevBj bv¤^vi wjL‡Z _vKzb mgm¨v n‡e bv| The End
kZ© mgynthw` 750 ev Gi AwaK cvq ZLb Star, A+ kZ© mg~n co„b I bx‡Pi WvUv¸‡jv wjLyb| 600 ev Gi AwaK cvq ZLb 1st, A 450 ev Gi AwaK cvq ZLb 2nd, A330 ev Gi AwaK cvq ZLb 3rd, B 330 ev Gi Kg cvq ZLb Fail, F
Technoloy Navigation Ground E-18/3, Middle Badda, Gulshan, Dhaka-1212 Mobile: 01911563761, email:
[email protected]
Microsoft Excel Page 13 of 13
D2 †m‡j bx‡Pi m~Î wjLyb =IF(C2>=750,"STAR",IF(C2>=600,"1ST",IF(C2>=450,"2ND",IF(C2>=330,"3RD","FAIL")))) myÎ wjLv †kl n‡j Kx‡evW© n‡Z G›Uvi Pvcyb| Avcbvi m~Î hw` mwVK fv‡e wjLv n‡q _v‡K Z‡e †iRvë Avm‡e ÒStarÓ Gevi D2 †m‡ji Dci †mjc‡q›Uvi ivLyb > Fill Handle a‡i m~Î bx‡Pi w`‡K Kwc K‡i w`b| dvBbvj cix¶vi †iRvë kxU t- kZ© mg~n co„b I bx‡Pi WvUv¸wj wjLyb Ges G2 †m‡j bx‡Pi m~Î wjLyb kZ© mgynthw` ‡gvU bv¤^vi 180 ev Gi AwaK cvq ZLb 1st 135 †_‡K 180 ev Gi g‡a¨ bv¤^vi ‡c‡j 2nd 99 †_‡K 135 ev Gi g‡a¨ bv¤^vi ‡c‡j 3rd =IF(OR(C2<33,D2<33,E2<33),"FAIL",IF(AND(F2>0, (F2<99),"FAIL",IF(AND(F2>=99,F2<135),"3RD",IF(AND(F2>=135,F2<180),"2ND","1ST")))) ‡mjvix kxU ‰Ziv Kit-
kZ© mg~n co„b I kZ© bx‡Pi WvUv¸wj wjLyb| mgynt1. evox fvov eve` Basic Gi 50% 2. wPwKrmv eve` Basic Gi 10% 3. cÖwf‡W›U dvÛ eve` Basic Gi 10% 4. BbKvg †U· Basic 2000 UvKvi bx‡P n‡j 0 BbKvg †U· Basic 2000 UvKv †_‡K 5000 UvKv n‡j 5% BbKvg †U· Basic 5000 UvKvi D‡a© n‡j 10% D2 ‡m‡j m~Î wjLyb =C2*50% Ges E2 ‡m‡j m~Î wjLyb =C2*10% Ges F2 ‡m‡j m~Î wjLyb =C2*10% G2 ‡m‡j m~Î wjLyb =IF(C2<2000,0,IF(AND(C2>=2000,C2<=5000),C2*5%,IF(C2>5000,C2*10%))) G2 ‡m‡j m~Î wjLyb =C2+D2+E2-F2-G2 gRyix kxU ˆZix Kivt- kZ© mg~n co„b I bx‡Pi WvUv¸wj wjLyb| kZ© mgyntcÖwZw`b 8 N›Uv ev Zvi Kg mg‡qi R‡b¨ 1N›Uv = 15 UvKv AwZwi³ mg‡qi Rb¨ 1 N›Uv = 20 UvKv
D2 ‡m‡j m~Î wjLyb =If(C2>8,C2-8,0) Ges E2 ‡m‡j m~Î wjLyb =IF(D2>0,D2*20+815,C2*15)