** 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
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|
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|
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
_ OK
Click Ki‡j H kZ©wU mshy³ Kiv †kl n‡jv| H GKB c×wZ‡Z
cª‡koe D‡j−wLZ Ab¨vb¨ kZ©¸‡jv GKwU GKwU K‡i
mshy³ Kwi| KvR‡k‡l
_ Close
Click Ki‡j Secnario
Manager Dialog Box wU P‡j hv‡e Ges cieZ©x‡Z
wb‡æ ewb©Z Dcv‡q djvdj
Microsoft Excel XP
Created By: Kamrul Hassan
Bappy Bappy Computer Education Centre
_ To
See The Scenario (m¨vK‡bvwiI cÖ`k©b) t
_ Dc‡i
D‡j−wLZ KvR¸‡jv †kl n‡q †M‡j
_ Tools
Click
_ Secnarios
Click Ki‡j Secnario
Manager Dialog Box Avm‡e ZLb †h Secnarios wU cÖ`k©b Ki‡Z PvB
†mwU Select
K‡i
_ Show
Click Ki‡j Select
K…Z Secnario
wUi djvdj cÖ`wk©Z n‡e| cÖ`k©b †k‡l Close Click Ki‡j
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
_ c~‡e©B
Avgiv wewfboe cÖKvi Function e¨envi K‡i †hvM, we‡qvM, ¸b, fvM BZ¨vw` wnmveKvh© wk‡LwQ| †h †Kvb
wnmve
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
Type Ki‡Z n‡e) cieZ©x‡Z
_ 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|
_ To
See The Macro (g¨v‡_v cÖ`k©b) t
_ Dc‡i
D‡j−wLZ KvR¸‡jv †kl n‡q †M‡j †h Cell
G Macro
(g¨v‡_v) cÖ`k©b Ki‡Z PvB †mB Cell G Cursor ‡i‡L
_ Tools
Click
_ Macro
Select K‡i
_ Macros
Click Ki‡j Macros
Dialog Box Avm‡e ZLb c~‡e© ˆZix Kiv Macro (g¨v‡_v) Gi bvg¸‡jv
cÖ`wk©Z n‡e
GB Ae¯’vq †h Macro (g¨v‡_v) wU cÖ`k©b Ki‡Z
PvB †mB Macro (g¨v‡_v)
Gi bvgwU Select K‡i
_ Run
Click Ki‡jB H bv‡g ˆZix Kiv Macro (g¨v‡_v) wU Cursor ivLv Cell G cÖ`wk©Z n‡e|
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¨
Macro (g¨v‡_v) wU cÖ`k©b Ki‡Z PvB †mB Cell
Gi g‡a¨ Cursor
‡i‡L Keyboard
Gi gva¨‡g H Shorycut
Key Press Ki‡jB
Macro (g¨v‡_v) wU Cursor ivLv Cell G cÖ`wk©Z n‡e|
_ 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
_ Macros
Click Ki‡j Macros
Dialog Box Avm‡e ZLb c~‡e© ˆZix Kiv Macro (g¨v‡_v) Gi bvg¸‡jv
cÖ`wk©Z
n‡e GB Ae¯’vq †h Macro (g¨v‡_v) wU ‡gvQ‡Z PvB
†mB Macro (g¨v‡_v)
Gi bvgwU Select K‡i
_ Delete
Click Ki‡jB H bv‡g ˆZix Kiv Macro (g¨v‡_v) wU ‡gv‡Q hv‡e|
cieZ©x‡Z Avgiv cix¶v K‡i †`L‡Z
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
_ Ok
Click Ki‡j Tools
Menu ‡Z Autosave
bv‡g Sub
Menu wU cÖ`wk©Z n‡e| ZLb
_ Tools
Click
_ Auto
Save Click K‡i
_ Automatic
Save Every Box G wbw`ªó mgq wbe©vPb 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
_ Ok
Click Ki‡j cieZ©x‡Z Tools
Menu ‡Z Autosave
bv‡g Sub
Menu wU cÖ`wk©Z n‡e bv|
No comments:
Post a Comment