Microsoft Excel

© Excel wK t

Excel n‡jv Microsoft Corporation KZ©„K ‰ZwiK…Z Windows wfwËK GKwU eûj cwiwPZ Spread Sheet Data Analysis Software| GwU wek¦weL¨vZ Microsoft Corporation Gi RbwcÖq †cÖvMÖvg| Gi mvnv‡h¨ RwUj MvwbwZK mgm¨vi mgvavb, Z_¨ e¨e¯’vcbv Ges wbLyuZ fv‡e MÖvd ˆZix Kiv  hvq| Excel Gi mywekvj c„ôvwU Kjvg I mvwiwfwËK †m‡j wef³ nIqvi G‡Z wewfbœ Z_¨ mwbœ‡ekZ K‡i Z_¨ we‡k­lY Kiv hvq e‡j G‡K Spread Sheet Data Analysis Program ejv nq|

© Excel Gi mvnv‡h¨ Avgiv wK wK KvR Ki‡Z cvwi

© Gi mvnv‡h¨ Avgiv wbgœwjwLZ KvR¸‡jv Ki‡Z cvwi|

© ‰`bw›`b wnmve wbKvk msi¶b I we‡k­lY|

© e¨vswK e¨e¯’vcbvi hveZxq KvR¸‡jv my›`i fv‡e Ki‡Z cvwi|

© RwUj ˆeÁvwbK K¨vjKz‡jkb|

© ‡eZb wnmve ˆZix|

© cix¶vi djvdj ˆZix|

© evwl©K cÖwZ‡e`b I ev‡RU cÖYqb|

© cwimsL¨v‡bi KvR m¤úv`b|

© me ai‡bi Avw_©K e¨e¯’vcbv|

© ‰e`y¨wZK wnmve wbKv‡ki KvR m¤úv`b|

© WvUv msi¶b I e¨e¯’vcbvi hveZxq KvR m¤úv`b|

© wewfbœ Z_¨‡K AvKl©Yxq K‡i Dc¯’vc‡bi Rb¨ PvU© ev MÖvd ˆZix BZ¨vw` Kv‡R Microsoft   

    Excel e¨envwiZ nq|

© ‡mj (Cell) wK

Excel Gi IqvK©kxUwU ÒKjvgÓ I Ò†ivÓ wfwËK| Kjvg I mvwii ci¯úi †Q‡` ˆZixK…Z †QvU †QvU AvqZKvi Ni‡K Cell e‡j| A‡bK ¸‡jv †mj wg‡j GKwU Sheet nq| Excel Gi GKwU mx‡U 256 wU ÒKjvgÓ Ges 65,536 wU Ò†ivÓ Av‡Q| eZ©gv‡b GKwU †mj Gi me©‡gvU 3200 (ewÎk nvRvi) A¶i †jLv hvq|

© wKfv‡e GK mv‡_ 3 wU Sheet †jLv hvq

Shift+Mouse †P‡c cÖ_g, wØZxq, Z…Zxq Cell ¸‡jv Sheet Ki‡Z n‡e| Gevi UvBc Ki‡jB GK mv‡_ GKvwaK kxU A_ev Dc‡iv³ wbe©vwPZ wZbwU kx‡U †jLv n‡e| D‡j­L¨ GKB †jLv mKjkxU G †jLv n‡e| Z‡e gyQ‡Z †n‡jI hw` wbe©vPb Kiv _v‡K Z‡e GKevi gyQ‡jB mKj †jLv gy‡Q hv‡e|

© GKwU †`vKv‡bi A‡bK ¸‡jv cb¨ GK mv‡_ wewµ Kiv  n‡j ev †Kvb cb¨ †`vKv‡bi wfZ‡i Avbv n‡j Gi `vg I cwigvb ZvwjKv K‡i Zv ‡ei Kie|

	A		B	C	D	E
1	No		Description.	Quantity.	Amount.	Total Amount.
2	01		Motherboard
3	02		Processor
4	03		H.D.D
5	04		Ram
6	05		DVD Writer / DVD Rom
7	06		Monitor LCD/LED/CRT
8	07		Mouse
9	08		Keyboard
10	09		Cashing
11	10		Speaker
12		Total =

© hw` Avcwb GKwU k‡Z© Av‡jv‡K  wb‡P †WUv ¸‡jv cÖ`k©b Ki†Z Pvb Zvn‡j wb‡gœv³ KgvÛ ¸‡jv KvR Ki“b t-  

	A	B	C	D	E	F
1	Serial No-	Name	Age	Sex	Position	Income
2	01	Ziaur Rahman	20	Male	M.D.	25000
3	02	Rezaul Karim	21	Male	Officer	25000
4	03	Amena Rahman	18	Female	Officer	18000
5	04	Miss Badal	17	Female	Officer	18500
6	05	Lima	18	Female	Eng.	20000
	e

² cÖ_‡g Auto Filter Select Ki‡Z n‡e|

² Position wd‡ìi evU‡b wK¬K K‡i Officer Ki“b|

² Income wd‡ìi evU‡b Click Ki“b|

² Custom G  Click Ki“b|

² Custom A‡Uv wdìvi WvqjM e‡·i  Income Wªc WvDb wj÷ †_‡K is less than  

     G Click Ki“b|

²Wvb cv‡k¦© †_‡K 9000 wbe©vPb Ki“b Ges Ok Ki“b|

Work Sheet G wb‡Pi gZ WvUv †`Lv hv‡e| A_©vr hv‡`i †eZb 9000 UvKvi Kg Ges Officer Zv‡`i Z_¨ †`Lv hv‡e|

© GKwU cÖwZôv‡b GKRb Kg©Pvix ‰`wbK 8 N›Uv cwikªg K‡i cvq 280 UvKv Ges †Kvb †Kvb Kg©Pvix ˆ`wbK 8 N›Uv KvR bv K‡i 8 N›Uvi Kg ev †ewk K‡i| ZvB †Kvb Kg©Pvix ‰`wbK KZ UvKv cvwikªwgK cv‡e Zvnvi GKwU ZvwjKv ˆZixi Ki‡Z ejv nj t-

	A	B	C	D	E	F
1	Seri. No.	Name	Day	Daily Fee	Hours	Total Fee
2	01	Labonno	Sat. Day	280	8	280
3	02	Uzzal Mia	Sun Day	280	5
4	03	Sabina Akter	Mon Day	280	12
5	04	Afruza Khatun	Tues Day	280	7
6	05	Shohel Rana	Wedn.Day	280	9
7	06	Jamil Hossen	Thu. Day	280	3

Total Fee ‡ei Kivi Rb¨ wbgœ m~ÎwU e¨envi Ki‡Z n‡e t- F2 ‡m‡j UvBc Ki“b =(D2/8)ÍE2 Cell G Pointer wb‡q gvDm Øviv Drag K‡i|

© g‡b Kwi Avcbvi KviLvbvq wbhy³ kªwgK‡`i cÖwZ 8 N›Uv KvR Kiv eva¨ZvgyjK Ges gRyix (30Í8) = 240 UvKv| B”Qv Ki‡j †Kn Ifvi UvBg Ki‡Z cv‡i, GRb¨ cÖwZ 1 N›Uvq gRyix 45 UvKv| GLb gRyixi ZvwjKv ˆZix Kwi|

	A	B	C	D	E
1	Seri. No.	Name	Working Hour	Over Time	Total Taka
2	01	Sohel	12
3	02	Kakuly	15
4	03	Nipu	8
5	04	Sathi	6
6	05	Momin	9
7	06	Samim	10

g~j †eZb ‡ei Kivi wbqg t KZ N›Uv  Over Time K‡i‡Q Zv †eiKivi Rb¨ D2 Cell

G Type Ki‡Z n‡e = C2-8 Zvi ci Enter w`‡Z n‡e| E2 †m‡j UvBc Ki‡Z n‡e

= D2Í45+240 Zvi ci Enter w`‡Z n‡e|

© wKfv‡e Avgiv Avgv‡`i †eZb †_‡K miKvi‡K Income Tex w`e Zv wbgœ iƒc t-

	A	B	C	D	E
1	Seri. No.	Name	Selary	Income Tex	Total Taka
2	01	Siddik	5000
3	02	Robel	12000
4	03	Sa-ad	18000
5	04	Alim	20000
6	05	Rashel	3000
7	06	Mizan	8000

‡h‡nZz GKwU cÖwZôv‡b A‡bK †jvK PvKzix K‡i wKš‘ mevBZ Avi GKB cy‡ó PvKzix K‡ibv ZvB G‡KK R‡bi †eZb †¯‹j nq G‡KK iKg ZvB mK‡ji Dci mgvb fv‡e Income Tex avh© nq bv| Avq Gi Dci Income Tex avh© Kiv nq| Avgiv g‡b Kwi Income Tex †iU wbgœiƒc t-

1.    Selary 5000 UvKvi Kg n‡j Income Tex 3%

2.    Selary 10,000 UvKvi mgvb ev g‡a¨ n‡j Income Tex 5%

3.    Selary 15,000 UvKvi mgvb ev g‡a¨ n‡j Income Tex 7%

4.    Selary 15,000 UvKvi Dc‡i n‡j Income Tex 10%

m~Ît- =IF(C2<5000,C2Í3%,IF(C2<=10000,C2Í5%,IF(C2<=15000,C2Í7%,

IF(C2>15000,C2Í10%)))) Gevi Enter w`b|

© wKfv‡e Avgiv Avgv‡`i GKwU †mvi“g/K¤úvbxi cY¨ wewµi Dci Commissin cv‡ev Zv wbgœ iƒc t- 

1| weµq 10,000 UvKvi Kg n‡j Kwgkb 5%

2| weµq 10,000 UvKvi †_‡K 30,000 n‡j Kwgkb 7%

3| weµq 30,000 UvKvi †_‡K 50,000 n‡j Kwgkb 9%

4| weµq 50,000 UvKvi Dc‡i n‡j Kwgkb 10%

	A	B	C	D	E
1	Seri. No.	Name	Sale	Commisson	Total Taka
2	01	Sharmin Jahan	8000
3	02	Mokhles	30000
4	03	Joty	15000
5	04	Sahidul	18000
6	05	Atik	20000
7	06	Monzurul	50000

gvDm c‡q›Uvi D2 †m‡j ‡i‡L wbgœ m~ÎwU wjLyb t-

=IF(C2<10000,C2Í5%,IF(AND(C2>=10000,C2<=30000),C2Í7%,IF(AND(C2<30000,C2<=50000),C2Í9%,C2Í10%))) Gevi Enter w`b|

PERFECT COMPUTER

© Avgiv wKfv‡e we`y¨r wej ˆZix Ki‡ev Zv Zy‡j aiv nj t-

	A	B	C	D	E	F	G	H
1	Serial. No.	Name	Unit	Unit Taka	Taka	Vet.	Meter Cost	Total Taka
2	01	Saheen
3	02	Mokhles
4	03	Joty
5	04	Sahidul
6	05	Atik
7	06	Monzurul

Avgiv †h we`y¨r e¨envi Kwi Zv mKj †¶‡Î mgvb bq| g‡b Kwi we`y¨r Gi BDwbU g~j¨ wbgœ i“c t

1| 1 †_‡K 100 BDwbU 3.50 UvKv,

2| 100 †_‡K 150 BDwbU 4 UvKv,

3| 150 †_‡K 200 BDwbU 5 UvKv,

4| 200 †_‡K 400 BDwbU 6.5 UvKv I

5| 400 †_‡K 500 BDwbU 8.5 UvKv|

©  wKfv‡e Avgiv Salary Sheet ‰Zix Kie t-

‡Kvb cªwZôv‡bi Kg©KZ©v I Kg©Pvix‡`i Rb¨ GKwU Salary Sheet ‰Zix Ki‡Z n‡e, wb‡gœ Zv ˆZix Kwi t-

·       House Rent, Basic  Gi 50%

·       Medical Allowance, Basic  Gi 10%

·       Provident Funt , Basic  Gi 10%

·       Income Tex, Basic  5000 Gi bx‡P n‡j 0%, Basic  5000 †_‡K 10000 ch©š— n‡j 3%, Ges 10000 Gi Dc‡i n‡j 5%, ai‡Z n‡e| Income Tex Gi

m~Ît- =IF(C2<5000,C2Í3%,IF(C2<=10000,C2Í5%,IF(C2<=15000,C2Í7%,

IF(C2>15000,C2Í10%)))) Gevi Enter w`b|

	A	B	C	D	E	F	G	H	I	J
1	S/N	Name	Basic	House Rente	Medical	Pro- F	Inc- Tex	Total	Advance	G - Total
2	01	Saheen	5000
3	02	Mokhles	7000
4	03	Joty	8500
5	04	Sahidul	12000
6	05	Atik	10000
7	06	Monzurul	12500

Result Sheet

	A		B	C		D		E			F		G	H					J		K			L		M		N		O		Q
1	Serial	Name			Eng-1		Eng-2	Sub To	GPA	Bang-1		Bang-2			Sub To		GPA	Math		GPA		G.Science	GPA		S.Science		Islam		Total		Result		G.P.A		POINT
2	1	Ismail			45		65			47		35						66				75			45		78
3	2	Mokhles			50		50			68		75						53				46			66		86
4	3	Joty			55		38			37		46						43				80			95		46
5	4	Sahil			35		40			85		64						25				33			78		78
6	5	Nun			37		45			70		35						70				45			84		65

                               

  

   Total ‡ei Kivi Rb¨ Avgiv †h fv‡e UvBc Kie t-

                                                            = SUM(E2+H2+I2+J2+K2+L2) wj‡L Enter w`‡Z n‡e|

   Result ‡ei Kivi Rb¨ Avgiv †h fv‡e UvBc Kie t-

                                                            = IF(Min(E2+H2+I2+J2+K2+L2)>32, “Pass”, “Fail”) wj‡L Enter w`‡Z n‡e|

   G.P.A‡ei Kivi Rb¨ Avgiv †h fv‡e UvBc Kie t-

                                                                 = IF(M2/5>=80, “A+”, IF(M2/5>=70, “A”, IF(M2/5>=60, “A-”, IF(M2/5>=50,   

                                                                   “B”, IF(M2/5>=40, “C”, IF(M2/5>=33, “D”, IF(M2/5>=32, “F”)))))))  wj‡L Enter

                                                                   w`‡Z n‡e|

   POINT ‡ei Kivi Rb¨ Avgiv †h fv‡e UvBc Kie t-

                                                            = IF(M2/5>=80, “5”, IF(M2/5>=70, “4”, IF(M2/5>=60, “3.5”, IF(M2/5>=50,   

                                                                   “3”, IF(M2/5>=40, “2”, IF(M2/5>=33, “1”, IF(M2/5>=32, “0”)))))))  wj‡L Enter w`‡Z n‡e|

 M/S Word                            Home                      M/S Access                            M/S Power Point