MS_Excel Tutorial

Microsoft Excel XP

 CURSOR MOVEMENT     (Kvm©i ¯’vbvš—i Kiv) t

mywcÖq  cÖwk¶bv_©xMb,  AvkvKwi  Avcbviv  Key  Board  Gi  Aš—M©Z  Cursor  Key  Gi  mwnZ  fvjfv‡e  cwiwPZ|  GB

Cursor Key ¸‡jvi mnvqZvq Cursor Movement Ki‡Z nq| hw` †KD Cursor Key Gi mwnZ cwiwPZ bv _v‡Kb Z‡e

wk¶‡Ki mvnvh¨ wbb| Ges wb‡Pi Cursor Movement msµvš— m~θ‡jv fvjfv‡e AvqË Ki“b| g‡b ivL‡eb KvR Kivi mgq

hZ ZvovZvox Cursor Movement Ki‡Z cvi‡eb KvR ZZB ZvovZvwo Ges mnR n‡e| Gevi wb‡Pi m~θ‡jv AvqË Kivi

Rb¨ †h †Kvb RvqMvq Cursor †i‡L,

Right Arrow Key Press Ki‡j Cursor wU GK Cell Wv‡b hv‡e| 

Left Arrow Key Press Ki‡j Cursor wU GK Cell ev‡g hv‡e |

Up Arrow Key Press Ki‡j Cursor wU GK Cell Dc‡i hv‡e| 

Down Arrow Key Press Ki‡j Cursor wU GK Cell wb‡P hv‡e| 

Home Key Press Ki‡j Cursor wU H Row Gi cÖ_g Cell Gi g‡a¨ P‡j hv‡e| 

End Key ‡Z GKevi Press K‡i mv‡_ mv‡_ Right Arrow Key Press Ki‡j Cursor wU H Row Gi ‡k‡l hv‡e|

End Key ‡Z GKevi Press K‡i mv‡_ mv‡_ Left Arrow Key Press Ki‡j Cursor wU H Row Gi ïi“‡Z P‡j hv‡e|

End Key ‡Z GKevi Press K‡i mv‡_ mv‡_ Down Arrow Key Press Ki‡j Cursor wU H Column Gi ‡k‡l hv‡e|

End Key ‡Z GKevi Press K‡i mv‡_ mv‡_ Up Arrow Key Press Ki‡j Cursor wU H Column Gi ïi“‡Z P‡j hv‡e|

Page Up Key Press Ki‡j Cursor wU GK ¯Œxb Dc‡ii †m‡j hv‡e| 

Page Down Key Press Ki‡j Cursor wU GK ¯Œxb wb‡Pi †m‡j hv‡e|

Ctrl + Home Key Press Ki‡j Cursor wU dvB‡ji ïi“‡Z hv‡e|

Ctrl + End Key Press Ki‡j Cursor wU dvB‡ji ‡k‡l hv‡e|

[ NB t D‡j−L¨ †h, GLv‡b GK ¯Œxb ej‡Z GKev‡i gwbU‡ii ¯Œx‡b IqvK©kx‡Ui hZUzKz †`Lv hvq Zv‡K eySv‡bv n‡q‡Q| ]

***********

Microsoft Excel XP

 File Click

 New Click

** File Menu **

1. To Create A New Book (GKwU bZzb eB ˆZix Kiv) t

  Ok  Click  Ki‡jB  bZzb  GKwU  eB  ˆZix  n‡e|  Microsoft  Word  Program  Gi  g‡a¨  hv  Avgiv  Document

wnmv‡e wP‡bwQjvg| 

[  NB  t  To  Create  A  New  Book  (GKwU  bZzb  eB  ˆZix  Kiv)  GB  KvRwU  Avgiv  Ab¨fv‡eI  Ki‡Z  cvwi  †hgb

Standard Tool Bar Gi New Icon Gi g‡a¨ Click K‡i A_ev KeyBoard Key Ctrl + N Press Gi gva¨‡g| ]

2. Save to the Book  (msi¶b Kiv) t

cÖ_‡g msi¶b Kivi Rb¨ †Kvb wKQy ˆZix K‡i Zvici †h †Kvb RvqMvq Cursor ‡i‡L

 File Click

 Save Click Ki‡j mv‡_ mv‡_ Save As Dialog Box Avm‡e ZLb Save As Type Box G Microsoft Excel

Workbook Select K‡i File Name Box Gi g‡a¨ †h bv‡g Save Ki‡Z PvB †mB bvgwU wj‡L 

 Save Click Ki‡jB H bv‡g msiw¶Z n‡e| cieZ©x‡Z Open K‡i ‡`L‡Z cvwi| 

[ NB t Save As Dialog Box  wU Avgiv Ab¨fv‡eI Avb‡Z cvwi †hgb Standard Tool Bar Gi Save Icon  Gi

g‡a¨  Click K‡i A_ev  KeyBoard Key  G Ctrl + S Press Gi gva¨‡g| cieZ©x KvR¸‡jv GKB iKg Ki‡Z n‡e|

we¯—vwiZ wk¶‡Ki wbKU †_‡K †R‡b wbb| ]

3. To Close A File Or Book (GKwU dvBj ev eB eÜ Kiv) t

‡Kvb GKwU File ev Book Open _vKve¯’vq 

 File G Click

 Close Click Ki‡jB Open K„Z File ev Book wU Close n‡e| Z‡e Close Click KivgvÎB Yes/No K_vwU mn

WvqvjM e· Avm‡Z cv‡i ZLb hw` H File ev Book wU Save (msi¶b) Ki‡Z PvB Z‡e 

 Yes Click Ki‡jB msi¶b Kivi Rb¨ Save As Dialog Box Avm‡e ZLb msi¶b Kivi c×wZg‡Zv msi¶b Kiv

hv‡e Z‡e hw` msi¶b Ki‡Z bv PvB ZLb

 No Click Ki‡jB File ev Book wU Close n‡e|

[ NB  t Close Avgiv Ab¨fv‡eI Ki‡Z cvwi †hgb Standard Tool Bar  Gi g‡a¨ Close  hw` †jLv _v‡K Z‡e GB Close G

Click K‡i A_ev  KeyBoard Key Alt + F4 Press Gi gva¨‡g| cieZ©x KvR¸‡jv GKB iKg Ki‡Z n‡e| we¯—vwiZ wk¶‡Ki

wbKU †_‡K †R‡b wbb| ]

4. To Open A File (GKwU dvBj †Lvjv ev ¯Œx‡b wb‡q Avmv) t

cÖ_‡g Open Kivi Dc‡hvMx K‡i GKwU Book †K Save K‡i File G cwibZ Kwi Zvici

 File G Click

 Open Click Ki‡j Open Dialog Box Avm‡e ZLb †h bv‡gi File wU Open Ki‡Z PvB †mB File wU Location

g‡Zv Lyu‡R †ei K‡i Select Kivi ci

 Open Click Ki‡jB Save K…Z File wU Open n‡e|

[ NB t  Open Dialog Box wU Avgiv Ab¨fv‡eI Avb‡Z cvwi †hgb Standard Tool Bar Gi Open Icon Gi g‡a¨  Click

K‡i A_ev KeyBoard Key  Ctrl + O Press  Gi gva¨‡g| cieZ©x KvR¸‡jv GKB iKg Ki‡Z n‡e| we¯—vwiZ wk¶‡Ki wbKU

†_‡K †R‡b wbb| ]

Microsoft Excel XP

5. Save A (GKwU dvBj Ab¨ †Kvb bv‡g Kwcc~e©K msi¶b Kiv) t

cÖ_‡g †h dvBjwU Kwcc~e©K msi¶b Ki‡Z PvB †mwU Open Ki‡Z n‡e Zvici 

 File Click

  Save  As  Click  Ki‡j  mv‡_  mv‡_  Save  As  Dialog  Box  Avm‡e  ZLb  Save  As  Type  Box  G  MicroSoft  Excel 

Workbook Select K‡i File Name Box Gi g‡a¨ †h bv‡g Kwcc~e©K msi¶b Ki‡Z PvB †mB bvgwU wj‡L 

 Save Click Ki‡jB H bv‡g Open Kiv File Gi GKwU Copy msiw¶Z n‡e| cieZ©x‡Z Open K‡i ‡`L‡Z cvwi| 

6. Save As Web Page (I‡qe mvB‡W msi¶b Kiv) t

‰ZixK…Z File wU Web Page Gi g‡a¨ msi¶b Ki‡Z n‡j GB Save As Web Page Option wUi mvnvh¨ wb‡Z nq

A_©vr GB  Option wUi mnvqZvq ‰ZixK…Z  File  wU  Web  Page Gi g‡a¨ msi¶b Kiv hvq| hw` Avcbvi Computer

wU‡Z Internet Gi ms‡hvM †`Iqv _v‡K Ges Internet m¤ú‡K© hw` Avcbvi my¯úó avibv _v‡K Z‡e wk¶‡Ki wbKU †_‡K

†R‡b wbb| 

7. Save As Workspace (GKvwaK dvBj GKwÎZ K‡i msi¶b Kiv) t

cÖ_‡g  †h  KqwU  (GKvwaK)  dvBj  GKwÎZ  K‡i  Save  (msi¶b)  Ki‡Z  PvB  †mB  KwU  dvBj‡K  Open  Kwi  Zvici

dvBj¸‡jv Open _vKve¯’vq 

 File Click

 Save As Workspace Click Ki‡j Save Workspace Dialog Box Avm‡e Ges Save As Type Box G Workspace

‡jLv _v‡K GB Ae¯’vq File Name Box Gi g‡a¨ †h bv‡g GKvwaK GKwÎZ K‡i msi¶b Ki‡Z PvB †mB bvgwU wj‡L 

 Save Click Ki‡j Open Kiv dvBj¸wj H bv‡g GKwÎZ n‡q Save (msi¶b) n‡e| 

8. To See Web Page Preview (I‡qe †cBR †`Lv) t

cÖ_‡g I‡qe †cB‡R †`Lvi Rb¨ GKwU dvBj ˆZix Kwi Zvici

 File Click

  Web  Page  Preview  Click  Ki‡j  Internet  Mode  G  Microsoft  Internet  Explorer  Open  n‡e|  mv‡_

mv‡_ ˆZixK…Z File ev  Book wU c`wk©Z n‡e| 

9. Page Setup (c„óvi gvwR©b, mvBR BZ¨vw` †mwUs Kiv) t

cÖ_‡g Page Setup Kivi Rb¨ Page Gi g‡a¨ †Kvb wKQy wj‡L Zvici

 File Click

 Page Setup Click Ki‡j mv‡_ mv‡_ Page Setup Dialog Box Avm‡e ZLb   Page Tab Gi g‡a¨ Click K‡i,

 Potrait Click Ki‡j Page wU Lvovfv‡e Print n‡e Ges Landscape Click Ki‡j Page wU evuKvfv‡e Print n‡e

(Lvov Ges evuKv Ae¯’v `ywU bv eyS‡j wk¶K‡K wRÁvmv Ki“b)

 Paper Size  Box  Gi g‡a¨ Click K‡i Avgiv †h Size  Gi  Paper  Gi g‡a¨ Print  Kie †mB Size Gi  Paper

Select Ki‡Z cvwi| 

  Print  Quality  Box  Gi  g‡a¨  Click  K‡i  Avgiv  KZ  dpi  ‡Z  Print  Kie  Zv  Select  Ki‡Z  cvwi|  cieZ©x‡Z

Margins Tab Gi g‡a¨ Click K‡i,

 Top, Buttom, Left, Right, Header, Footer, BZ¨vw`i Margin Setup Ki‡Z cvwi|

  Center  Of  Page  Box  Gi  g‡a¨  Horizontally  ‡Z  Click  c~e©K  (       )  wPý  w`‡j  †jLv¸‡jv  Horizontally

Center  n‡e  Aciw`‡K  Vertically  ‡Z  Click  c~e©K  ( )  wPý  w`‡j  †jLv¸‡jv  Vertically  Center  n‡e|  Zvici

cÖ‡qvRb‡ev‡a GB Page Setup Box ‡_‡K Avgiv Print Preview ‡`L‡Z cvwi Ges Print Ki‡Z cvwi| cieZ©x‡Z

 Ok Click Ki‡j g‡bi B‡”QgZ ‰Zix Kiv Page Setup Apply n‡e hv Avgiv c‡i ‡h †Kvb mgq Print Preview

‡`L‡Z cvwi|

[ NB t GB Page Setup Box ‡_‡K Avgiv Header & Footer Ki‡Z cvwi| Z‡e Microsoft Excel Gi g‡a¨ View Menu ‡Z

Header & Footer m¤ú‡K© Av‡jvPbv Kiv n‡q‡Q| ZvB G m¤ú‡K© View Menu ‡Z we¯—vwiZ Rvb‡Z cvie| ]

Microsoft Excel XP

10. To Create Print Area (†Kvb c„óvi wbw`ªó wKQy ¯’vb wcÖ‡›Ui Rb¨ ˆZix Kiv) t

‡Kvb  GKwU  Page  Gi  ga¨  †_‡K  hw`  wbw`ªó  wKQy RvqMv  Avjv`vfv‡e  Print  (wcÖ›U)  Ki‡Z  PvB  Zvn‡j  †h  RvqMvUzKy

Avjv`vfv‡e Print (wcÖ›U) Ki‡Z PvB †mB RvqMvUzKz Block c~e©K Select K‡i  

 File Click

 Print Area Click

 Set Print Area Click Ki‡j H RvqMvUzKz Print (wcÖ›U) Kivi Rb¨ ˆZix n‡e| hv Avgiv Print (wcÖ›U) Kivi Av‡MB

Print Preview Click  K‡i ‡`L‡Z cvwi| cieZ©x‡Z hLb wbw`ªó RvqMvUzKz Print (wcÖ›U) Kiv †kl n‡q hv‡e ZLb hw`

Avevi Print Area wU ev` w`‡q m¤ú~b© Page wU Print (wcÖ›U) Kivi cÖ‡qvRb nq Z‡e H RvqMvUzKz Block c~e©K Select

K‡i ev Gi cv‡k Cursor ‡i‡L 

 File Click

 Print Area Click

 Clear Print Area Click Ki‡j H RvqMvUzKz ‡_‡K  Print Area Delete n‡e Ges m¤ú~b© Page wU Avevi  Print

(wcÖ›U) Kivi Rb¨ ˆZix n‡e|

11. Print Preview (wcÖ›U Kivi Av‡M cª`k©b) t

‡h dvBj ev eBwU  Print (wcÖ›U) Ki‡Z PvB †mwU Open  Kwi|  Print (wcÖ›U) Kivi ci GwU wKfv‡e c`wk©Z n‡e Zv

†`Lvi Rb¨ 

 File Click

  Print  Preview  Click  A_ev  Standard  Toolbar  Gi  Print  Preview  Icon  Gi  g‡a¨  Click  Ki‡j  Print

Preview  ‡Z  Page  wU  †QvU  AvKv‡i  c`wk©Z  n‡e|  c`k©b  †k‡l  Print  Preview  Toolbar  ‡_‡K  Close  Button

Click Ki‡j Print Preview eÜ n‡q Worksheet Gi g‡a¨ P‡j Avm‡e| 

12. Print (ˆZixK…Z Kv‡Ri AvDUcyU †`Iqv) t

 Print Kivi we¯—vwiZ c×wZ wk¶‡Ki wbKU †_‡K †R‡b wbb| (Rvbv AZ¨vek¨K)

13. Send To (¯’vbvš—i cÖm½) t

 Open  K…Z File ‡K GK¯’vb †_‡K Ab¨¯’v‡b ¯’vbvš—i Kivi Rb¨ Send To Menu  Gi Awab¯’ wewfbœ Sub Menu  ¸‡jv

e¨envi Kiv n‡q _v‡K| Gi Rb¨ Internet Connection / Network cÖ‡qvRb nq| we¯—vwiZ wk¶‡Ki wbKU †_‡K †R‡b wbb| 

14. Propertie (dvBj m¤ú‡K© we¯—vwiZ Rvbv) t

 Open  K…Z File  m¤ú‡K© we¯—vwiZ Rvbvi Rb¨ D³  Sub Menu wU e¨envi Kiv n‡q _v‡K| we¯—vwiZ e¨envi wk¶‡Ki wbKU

†_‡K †R‡b wbb| 

15. Exit (cÖ¯’vb Kiv) t

KvR‡k‡l Spreadsheet Analysis Software (Microsoft Excel) ‡_‡K cÖ¯’vb Ki‡Z n‡j

 File Click

 Exit Click A_ev KeyBoard Gi ga¨ †_‡K Alt + F4 Press KivgvÎB Yes/No K_vwU mn WvqvjM e· Avm‡Z

cv‡i ZLb hw` H File ev Book wU Save (msi¶b) Ki‡Z PvB Z‡e 

 Yes Click Ki‡jB msi¶b Kivi Rb¨ Save As Dialog Box Avm‡e ZLb msi¶b Kivi c×wZg‡Zv msi¶b Kiv

hv‡e Z‡e hw` msi¶b Ki‡Z bv PvB ZLb

 No Click Ki‡jB File ev Book wU Close n‡e Ges Operating System Gi Screen wU Open n‡e| 

*********************