**
Data Menu **
1.
Sort (WvUv mvRv‡bv) t
NB t A‡bK mgqB Avgv‡`i KvR Kivi †¶‡Î †h †Kvb Column (Kjvg) †K †QvU †_‡K eo
A_ev eo †_‡K †QvU AvKv‡i
†`Lvi cÖ‡qvRb nq| Gi mvnv‡h¨ Avgiv Column (Kjvg) wfwËK †h †Kvb wKQy
Ly‡R †ei Ki‡Z cvwi| GB KvRwU Kivi
Rb¨ Avgiv wbæiƒc GKwU QK ‰Zix Kwi|
Dc‡ii Z_¨¸‡jv †jLv †kl n‡q †M‡j Cell Pointer Data Gi
ga¨eZ©x †h †Kvb RvqMvq †i‡L
Data
Click
Sort
Click
Sort
By Button Click Ki‡j ‰ZixK…Z Field (wdì) ¸‡jv ‡`Lv hv‡e ZLb
†h †Kvb GKwU Field (wdì) Click
(wK¬K) K‡i
Ascending
Click Kwi (hw` Select
K…Z Column
wU †QvU †_‡K eo AvKv‡i †`L‡Z PvB)
Desceding
Click Kwi (hw` Select
K…Z Column
wU eo †_‡K †QvU AvKv‡i †`L‡Z PvB)
cieZ©x‡Z
Ok Click Ki‡jB
Avkvbyiƒc djvdj cvIqv hv‡e|
2.
FILTER (‡WUv †LvuRv) t
Cursor
(Kvm©i) †h †Kvb GKwU Field Gi g‡a¨ †i‡L
Data
Click
Filter
Click
Auto
Filter Click Ki‡j cª‡Z¨‡KwU dx‡ìi (Field) bv‡gi cv‡k wdëvi evUb P‡j
Avm‡e ZLb †h †Kvb GKwU
Field Button Click K‡i †h †Kvb †WUv‡Z Click (wK¬K) Ki‡j ïay gvÎ H Column
(Kjvg) Gi Aš—M©Z †mB ai‡bi
me †WUv¸‡jv †`Lv hv‡e| KvR‡k‡l Avevi
me †iKW© wdwi‡q Avb‡Z n‡j
Data
Click
Filter
Click
Show
All Click Ki‡Z n‡e| A_ev H Field Button Click K‡i
All
Click KivgvÎB me¸‡jv †iKW© P‡j Avm‡e|
_ To
Create Custom Filter (Kvóg wdëvi ‰Zwi) t
Custom
Filter Ki‡Z n‡j KZ¸‡jv Relation
Operator Gi `iKvi nq| †hgb t
= Equal
> Greater Than
< Less Than
>= Greater Than or Equal
To
<= Not Equal To
<> Not Equal To BZ¨vw`|
Custom
Filter Gi wewfboe cÖKvi e¨envi Av‡Q| G¸‡jv wk¶‡Ki wbKU
†_‡K fvjK‡i †R‡b wbb| GQvovI wewfboe cÖKvi
Filter m¤ú‡K© hw` wKQy Rvbvi _v‡K Z‡e Aek¨B Zv wk¶‡Ki wbKU †_‡K †R‡b wb‡eb|
_ To
Delete Auto Filter (A‡Uv wdëvi †gvQv) t
_ Custom
Filter Kiv †kl n‡q †M‡j hLb wdëvi evUb †gvQvi cÖ‡qvRb
n‡e ZLb
_ Data
Click
_ Filter
Click
_ Auto
Filter Click K‡i wVK wPý (_) †Zv‡j w`‡Z n‡e| wVK wPý (_) †Zv‡j w`‡j wdëvi evUb _vK‡e bv|
_ To
Create Advanced Filter (G¨vWfvÝ wdëvi ‰Zwi) t
NB t Advanced Filter Gi gva¨‡g Avgiv g‡bi B‡”QgZ wbw`ªó wKQy Cell ‡K Copy K‡i H Worksheet Gi Awab¯’
†h †Kvb wVKvbvq cvVv‡Z cvwi| GRb¨
_ Data
Click
_ Filter
Select Kivi ci
_ Advanced
Filter Click Ki‡j Advanced
Filter Dialog Box Avm‡e ZLb
_ Copy
To Another Location Click K‡i List Range, Criteria Range & Copy To c~ib
Kivi ci
(cÖ‡qvR‡b wk¶‡Ki mvnvh¨ wbb)
_ Ok
Click Ki‡jB wbw`ªó Z_¨¸‡jv wVKvbvgZ †cŠ‡Q hv‡e| cix¶v
K‡i †`L‡Z cv‡ib|
_
3.
FORM........ : ‡WUv Gw›Uªi KvR
(A). To Entry A New Record (bZyb GKwU †iKW© ‡hvM Kiv) t
_ wKQy
Record Entry Kiv
_vKve¯’vq
_ Data
Click
_ Form
Click Ki‡j GKwU Dialog
Box Avm‡e ZLb
_ New
Click K‡i bZzb †WUv UvBc Ki‡Z n‡e| Zvi ci
_ Close
Click Ki‡jB †`Lv hv‡e bZzb K‡i Entry Kiv Data ¸‡jv mshy³ n‡q‡Q|
(B). To Edit The Record (‡iKW© ms‡kvab ev cwie©Zb Kiv) t
_ wKQy
Record Entry Kiv
_vKve¯’vq
_ Data
Click
_ Form
Click Ki‡j GKwU Dialog
Box Avm‡e ZLb
_ Find
Next Click Ki‡Z _vK‡j GK GK K‡i cieZ©x Record ¸‡jv †`Lv‡e Ges Find Prev Click Ki‡j
GK GK K‡i c~e©eZ©x Record ¸‡jv †`Lv‡e| GB Ae¯’vq †h
Record (†iKW©)wU
ms‡kvab ev cwieZ©b Ki‡Z PvB
†mB Record
(†iKW©)wU hLb †`Lv‡e ZLb g‡bi B‡”QgZ cwieZ©b ev
ms‡kvab K‡i
_ Close
Click Ki‡jB g‡bi B‡”QgZ ms‡kvwaZ ev cwiewZ©Z n‡q
hv‡e|
(C). To Delete The Record (‡iKW© †gvQv) t
_ wKQy
Record Entry Kiv
_vKve¯’vq
_ Data
Click
_ Form
Click Ki‡j GKwU Dialog
Box Avm‡e ZLb
_ Find
Next Click Ki‡Z _vK‡j GK GK K‡i cieZ©x Record ¸‡jv †`Lv‡e Ges Find Prev Click Ki‡j
GK GK K‡i c~e©eZ©x Record ¸‡jv †`Lv‡e| GB Ae¯’vq †h
Record (†iKW©)wU
‡gvQ‡Z PvB †mB Record
(†iKW©)wU hLb †`Lv‡e ZLb
_ Delete
Click
_ Ok
Click Ki‡j H Record
(†iKW©)wU †gv‡Q hv‡e cieZ©x‡Z
_ Close
Click Ki‡jB Dialog
Box wU P‡j hv‡e|
4.
TEXT TO COLUMNS
(GKB †m‡ji g‡a¨i †jLv‡K wfboe wfboe Kjv‡g wb‡q hvIqv)
wb‡æ Aw¼Z QKwUi Abyiƒc GKwU QK ˆZix
Ki‡Z n‡e| †m‡ji †jLv¸‡jvi g‡a¨ GKB mgvb Spacebar
w`‡Z n‡e| Zvn‡j
Avmyb wb‡æ Aw¼Z QKwU ˆZix Kwi|
_ Gevi
cÖ‡g †jLv¸‡jv e−K K‡i Zvici
_ Data
Click K‡i, Text
To Columns Click, Delimited Click K‡i, Next Click
_ Space
Click K‡i, Next
Click, Text Click K‡i
_ Finish
Click Ki‡jB cÖg Kjv‡gi †jLv¸‡jv avivevwnKfv‡e wfboe
wfboe Kjv‡g P‡j hv‡e|
No comments:
Post a Comment