Microsoft Excel

  • June 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Microsoft Excel as PDF for free.

More details

  • Words: 6,395
  • Pages: 13
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‡bvtTools> 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)

Related Documents

Microsoft Excel
December 2019 48
Microsoft Excel
June 2020 11
Microsoft Excel
June 2020 23
Microsoft Excel
June 2020 18
Microsoft Excel
November 2019 44
Microsoft Excel
April 2020 31