What is excel?
Excel k‡ãi A_© †kªôZ¡| Bnv GKwU Spreadsheet Analysis RvZxq mdUIq¨vi |mdUIq¨viwU gvB‡µvmdU Gioffice package †cÖvMÖvg | gvB‡µvmdU G‡·j GKwU †¯úWkxU DB‡ÛvR wnmve,MÖvwdK&ª Uzjm,wcfU †Uwej Ges GKwU g¨v‡K&ªv‡cÖvMÖvwgs cÖ‡qvM mgy‡ni Rb¨ wfRy¨qvj †ewmK bvgK fvlv AwZwi³ ˆewkó¨¸wj I i‡q‡Q|
g~jZtG·‡ji mvnv‡h¨ WvUv Gw›Uª Ges A¨vbvjvBwmm Dfq myweav cvIqv hvq|
What is Worksheet?
Iqv©K A_© KvR Ges kxU A_© cvZv| Iqv©K kxU nj Kv‡Ri wbwg‡Ë cvZv| gvB‡K&ªvmd&U Iqv‡W©i dvB‡j _v‡K GK ev GKvwaK †cR| Avi G‡·‡ji Iqv©K eyK G _v‡K GK ev GKvwaK Iqv©KkxU| G‡·‡j ‡h †Kvb KvR Kivi GKgvÎ ¯’vb n‡jv Iqv©KkxU| mvwi (‡iv) I Kjvg m¤^wjZ Kv‡Ri RvqMv‡K e‡j G·‡ji Iqv©KkxU| G·‡ji Iqv©K ey‡Ki GK ev GKvwU Ask ev cvZv†K e‡j Iqv©KkxU.GKwU LvZvq †hgb A‡bK¸wj cvZvq †jLv hvq, Gi·ª‡jI †Zgwb wfbœ webœ IqvK©kxU Ly‡j Zv‡Z KvR Kiv hvq|
What is Workbook?
GK ev GKvwaK Iqv©K kxU m¯^wjZ gvB‡K&ªvmdU G‡·‡ji GK GKwU dvBj‡K e‡j Iqv©K eyK| Iqv©K ey‡K cÖ‡qvRbxq KvR K‡i Zv msiÿ‡Yi Rb¨ †mf KgvÛ cÖ‡qvM Ki‡j Save as WvqvjM e‡·i NameAck‡bi †UK÷ e‡· GKwU bvg Gw›U K‡i †mf evU‡b wK¬K Ki‡j Pjgvb Iqv©KkxU¸wj GKwU Iqv©K ey†K cwibZ nq| GKwU Iqv©K ey‡K GK ev GKvwaK Iqv©KkxU m¤^wjZ n‡Z cv‡i| ‡Kvb IqvK©kxU I‡cb Kivi Rb¨ Av‡M I‡cb Ki‡Z nq mswkø÷ Iqv©K ey‡K| ms‡ÿ‡c avibv G ‡h, gvB‡K&ªvmcd&U Iqv‡W© hv‡K WzKz‡g›U ejv nq gvB‡K&ªvmcd&U G·‡j Zv‡K e‡j Iqv©K eyK|
Spreadsheet : SpreadGi A_© n‡jv Qov‡bv sheet Gi A_© n‡jv cvZv| Spreadsheet Gi A_© `vovq Qov‡bv cvZv| MÖvd KvM‡Ri b¨vq Aÿ Aÿ eivei †Lvc †Lvc N‡ii b¨vq A‡bK Ni m¤^wjZ kxU‡K †¯úªWkxU ejv nq|
Microsoft Excel Run
v cÖ_g t Iqvj m‡K‡Ui myBP Ab Kiæb
v wØZxq t hw` ÷¨vwejvBRvi _v‡K Zvn‡j ÷¨vwejvBRv‡ii myBP Ab Kiæb Ges Gi meyR jvBwU R¡‡j DVv ch©šÍ A‡cÿv Kiæb|
v hw` BDwcGm _v‡K Zvn‡j meyR evwZwU R¡‡j DVvi ci BDwcGm Gi myBP Ab Kiæb|
me‡k‡l wm‡÷‡gi Gi cvIqvi evU‡b cwigvb g‡Zv Pvc w`‡q mv‡_ mv‡_ †Q‡o w`b I cvIqvi evU‡b Pvc w`bGes wKQzÿb A‡cÿv Kiæb| Gici Kw¤úDUvi GKv GKv Pvj~ n‡e Ges GKwU wbw`ó c`©vq G‡m †_‡g hv‡e| GLvb †_‡KB Avcbv‡K KvR ïiæ Ki‡Z n‡e|
Click Start buttonàClick Prorograms /All Prorogramsà Microsoft OfficeàClick Microsoft Excel
wKQzÿ†bi g‡a¨B Microsoft Excel Gi QK KvUv GKwU dvuKv ¯Œxb Avm‡e| GLv‡b †Uwe‡ji gZ wewfbœNi (Column), Kjvg Ges mvwi (Row) ‡Z wewf³ _vK‡e|
Microsoft Excel G hLb Ready Mode _vK‡e ZLb Excel G Kv‡Ri Dc‡hvwM n‡e l
Cloumn: Worksheet Gi Dc‡i Avgiv A.B.C BZ¨vw` †jLv †`L‡Z cvB| GB cªwZwU A.B.C -B nj GK GKwU Excel †cÖvMÖv‡g Cloumn Gi msL¨v n‡jv 2003 f©vm‡b 256wU 2007 f©vm‡b 16,384 wU| Last Column= XFDRow: Gi evg cv‡k¦© 1.2.3 BZ¨vw` †jLv †`L‡Z cvB| GB ¸‡jv cÖwZwU GK GKwU Row wn‡m‡e Mb¨ nq| Excel †cÖvMÖv‡g †gvU Row Gi msL¨v nj 2003 f©vm‡b 65,536 wU 2007 f©vm‡b 10,48,576 wU| Last Row=1048576
Cell: GKwU Kjvg Ges GKwU wg‡j Cell MwVZ 1,67,77,216 wU 2007 f©vm‡b 1717,98,69,184 wU|
UvB‡Uj evi: Microsoft Excel c¨v‡KR †cÖvMÖvgRun Kivi ci Screen Dc‡ii cÖ_g jvBbwU nj UvB‡Ujevi|
Z„ZxqZ: Wvbc¦v‡k©i †QvU †QvU AvBKb My‡jvi Øviv Window †K Miximize,Minimize Close BZ¨vw` KvR Kiv hvq|
TitleBar DB‡Ûvi kxl©‡`k‡K e‡j UvB‡Uj evi| Pjgvb DB‡Ûv‡Z ev‡ii gvSvgvwS Pjgvb †cÖvMÖvg Ges D³ †cªvMÖv‡g Pjgvb IqvK©eyK dvBjwUi bvg Zv cÖ`wk©Z nq UvB‡Uj ev‡i| GB ev‡ii evg cÖv‡šÍ Quick Access toolbar Ges Wvb cÖv‡šÍ Excel Window Controls Gi Ae¯’vb
KvR: UvB‡Uj ev‡ii mvnv‡h¨ Avgiv AeMZ n‡Z cvwi †h, c`©vq †Kvb †cÖvMÖvgwU Pvjy Av‡Q|
w`¦ZxqZ: †Kvb dvBj wb‡q KvR Ki‡j †mB dvB‡ji bvg|
K‡›Uªvj e·t DB‡Ûvi UvB‡Uj ev‡ii me©ev‡g we`¨gvb e·†K K‡›Uªvj e· e‡j|†hgbt- Restor,Move,Size,Miximize,Minimize,Close .
Tab Bart DB‡Ûvi UvB‡Uj ev‡ii bx‡P we`¨gvb Home,Insert, Page Layout,Refarance, Mailing,Review BZ¨vw` †jLv mw¤^wjZ evi‡K e‡j Tab Bar. Tab Bar cÖ‡Z¨KwU AckbB GK GKUv †gbyi gZ KvR K‡i| GB †gby evi ¸‡jvi bx‡P AvÛvijvBb Kiv Aÿi My‡jv w`‡q Kx‡evW© KgvÛ K‡i H †gby GKwUf Kiv hvq | ‡hgb: Alt+F KgvÛ w`‡j dvBj †gby I‡cb n‡e|
Tool Bart Gi bx‡P wewfbœ cÖZxK m¤^wjZ evi‡K Uzjevi e‡j| cÖ‡Z¨KwU cÖZx‡Ki evU©b‡K AvBKb ev Uzj evU©b e‡j| GB Uzjevi e¨envi K‡i Lye `ªæZ KvR Kiv hvq|
Strat/Taskbar: Desktop Avvm‡e Ges GKwU j¤^v wdZvi gZ e¨vÛmn wb‡P evgw`‡K GKwU Strat evUb _vK‡e|G‡K e‡j Taskbar Ges GwU me mgq cÖ`wk©Z n‡Z _v‡K|GB Taskbar†_‡K wKQy AvBKb _vK‡e| GB AvBKb †_‡K I mswkó †cÖvMÖvg Pvjv‡bv hv‡e|
Status Bar :IqvK©eyK DB‡Ûvi me©wb‡¤œ Uv¯‹ev‡ii Dc‡ii evi‡K †÷Uvm evi e‡j| G‡Z Wz‡Kv‡g›U Gi †÷Uvm ev Ae¯’v( Ab/Ad) cÖ`wk©Z nq|GB †÷Uv‡mi ev‡ii evg cv‡kReady †jLv _vK‡j eyS‡Z n‡e Kvm©i †m‡jAv‡Q Ges G Ae¯’vX KvR Kiv hv‡e| †Kvb †jLv Edit Kivi mgq GLv‡b GB GwWU †jLv †`Lv hv‡e Ges †kl n‡j Avevi †iwW gyW wd‡i Avm‡e|
Workspace/Workarea Worksheet Gi A†_‡K U ch©šÍ 21(GKzkwU) Kjvg Ges 1 †_‡K 25 ch©šÍ Row me©mgq c`©vq weivRgvb Z‡e gwbU‡ii AvqZ‡f‡` Gi msL¨v Kg-‡ekx n‡Z cv‡i | GB `©k¨gvb Total Column 
TotalRow m¤^wjZ RvqMv‡K e‡j Workspace .FormulaBar Ges Status BarcÖ`k©‡bi Dci `„k¨gvb Row msL¨v wbf©i K‡i| FormulaBar : Worksheet Gi Cloumn ev‡ii Dc‡i Geq Uyjev‡ii wb‡P eviwU‡K FormulaBar e‡j| dgy©jvev‡ii evg cv‡ki As‡k †hLv‡b Cell Adderss (A1)cÖ`©wkZ nq †m Ask‡K NameBoe‡j|A_©¨v_© †mj c‡q›Uvi †h †m‡j ivLv n‡e NameBox †mB †m‡ji G‡Wªm cÖ`wk©Z n‡e| Gi Wv‡b we`¨gvb evi‡K FormulaBar e‡j|†m‡j †Kvb †U·U ev dg©~jv wjL‡j D³ †mj GKwUf¨¨vjywU GB FormulaBar G cÖ`wk©Z nq|Avevi IqvK©kx‡U †Kvb †mj wm‡j±W Ae¯’vq GB FormulaBar G †U·U ev dgy©jv wjL‡j Zv D³ †m‡j Kvh©Ki nq|
Formula e¨env‡ii †ÿ‡Î Kibxqt †jLvi cÖ_‡g mgvb (=) wPý e¨envi Ki‡Z n‡e|
If , And Gi c‡i (First Bracket) w`‡Z n‡e|
And n‡j `ywU kZ©‡K First Bracket () w`‡q Close Ki‡Z n‡e
Formula Gi g‡a¨ hZ¸‡jv If _vK‡e ZZ¸‡jv Formula Gi †k‡l First Bracket () w`‡q Close Ki‡Z n‡e|
hyw³‡K Kgv (,) w`‡q wef³ Ki‡Z n‡e|
Formula Gi †jLvi †QvU-eo Aÿ‡ii †f`v‡f` bvB|
= 
Funtion Functin Name: Functin wK KvR K‡i Zv wba©viY K‡i|
Arguments: †Kvb †Kvb †mj ev gvb †idv‡iÝ e¨envi K‡i wn‡me Ki‡Z n‡e Zv wba©viY K‡i|
Functin e¨env‡ii Logical Symbol
+ †hvM mgvb wPý
- we‡qvM wPý
/ fvM wPý
* ¸bb wPý
Õ Kgv wPý
Equal to = mgvb wPý
Grater than >†ekx ev D‡a©Ÿ
Less than < Kg ev wb‡¤œ
Grater than or Equal to>= mgvb ev Zvi ‡P‡q †ekx
Less than or Equal to <= mgvb ev Zvi †P‡q Kg
‡¯Œvj evit Pjgvb DB‡Ûv‡Z we`¨vgvb Af¨šÍixb welqvw`i Dc‡i,bx‡P, ev‡g,Wv‡b †`Lvi Rb¨ †¯Œvj evi e¨envi Ki‡Z nq| ‡¯Œvj evi 2wU †hgb-
Virtical scroll Bar t wP‡ý wK¬K Ki‡j WKz‡g›U Gi †cR Dc‡i DV‡Z _v‡K Avi wP‡ý wK¬K Ki‡j WKz‡g›U Gi †cR bx‡P bv‡g| Horizontal scroll Bar t à Gi wb¤œvs‡ki w`‡K ZvKv‡j Ges ß wPý GKevi wK¬K Ki‡j WKz‡g›U Gi †cR evg ‡_‡K Wv‡b cÖ`©kxZ nq|
Cursor Movement
Key Action | Activity |
Press Left Arrow | Move Cell Pointer One Cell Left Side |
Press Right Arrow | Move Cell Pointer One Cell Right Side |
Press Up Arrow | Move Cell Pointer One Cell Up |
PressDown Arrow | Move Cell Pointer One Cell Doewn |
PressPageup | Move Cell Pointer One Page Up or One Screen Up |
PressPagedown | Move Cell Pointer One Page Down or One Screen Down |
Press Ctrl+Home Key | Move Cell Pointer at the Top of the document |
End,Down Arrow | Move Cell Pointer at the End of the Row |
Press Ctrl+End Key | Move Cell Pointer at the Bottom of the document |
Press Home | Move Cell Pointer One Cell Left |
Press Shiftl+Tab Key | Move Cell Pointer One Cell Left |
Tab | Move Cell Pointer One Cell to the Right . |
Kw¤úDUvi eÜ Kivi c×wZ
cÖ_‡g Pjgvb †cÖvMÖvg eÜ Kivi Rb¨ Worksheet ‡_‡K Close Zvici Workbook †_‡K Exit n‡q
†W·Uc G‡m wb‡¤œi KgvÛ w`‡Z n‡e| K‡›Uªvj e· Miximize,Minimize,Close †_‡K X w`‡q †ei
nIqv hvq|
v Kw¤úDUvi Pvjy Kivi ci †h ¯Œx‡b A_v©r †W·Uc G‡m †_‡g hvq, †m ¯Œx‡bi wb‡P GKev‡i ev‡gi ÿ wPü‡jLv hv‡e| Kw¤úDUvi e× Kivmn hveZxq KvR GLvb †_‡K m¤úbœ Kiv hvq|
v gvDm w`‡q ÿ wPü Dci wK¬K Kiæb| wK¬K Ki‡j wb‡Pi wPGwU Avm‡e GLvb n‡Z Wvb cv‡k©¦i Shut down wK¬K|
=
![কাচ্চি বিরিয়ানি | How to Make Kacchi Biryani | Bangladesh [বাংলাদেশ]](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg0mkUPkvgWQ5rIbn_GZHMH5m3Y1FDo2FrU2xpXS97EdjfUlPNq6L8g9s7QossrFVlJbbpYg7hP6805DuwWRVWyja0OHmXfgLMbU5XqsPKvq6lmTlNR-d84EEnVWa4po9xDwjuWuMu_F2A/s640/ela-dum-biriyani-500x500.png "কাচ্চি বিরিয়ানি | How to Make Kacchi Biryani | Bangladesh [বাংলাদেশ]")
