ms-excel in hindi

42 Pages·2012·4.55 MB·English

1

MS Exel
MS Excel tutorials in Hindi
Excel): (spreadsheets)
datas)

workbook)
worksheets)
' ' (columns) ' ' (rows) (grid)

(cell)
,
'E' '5' 'E5' ,
mathematical formulas)
Microsoft Excel - Screen Elements)

Adding and Renaming
Worksheets)
2

| Insert|Worksheet)
rigit click)
Rename) Enter)
Toolbar)

New) - | File|New)
N (CTRL+N) ' ' (New)

Open) -
| File|Open) O (CTRL+))
' ' (Open)
Save) - |
File|Save) S (CTRL+S)
' ' (Save)
Prnt) - | File|Print)
P (CTRL+P) ' ' (Save)

Save) -
| File|Print Preview) '
' (Print Preview)
Save) -
' ' (Spell Check)
, Cut, Copy, Paste) -
Modifying A Worksheet) section)
3

, Undo, Redo) - Undo)
Redo)

Undo and Redo) -
Insert Hyperlink) - cell)
Insert Hyperlink) -
OK

, Autosum, Function Wizard, and Sorting) -
(Functions) section)
Zoom) -
' ' (zoom)

Customizing MS Exel
MS Excel tutorials in Hindi

1. | | View|Toolbars|Customize)
2. Options)
4

3. Menus show recently used commands first

Toolbars)

| View|Toolbars)
Customize Toolbars)
, ,
,
5

1. | | View|Toolbars|Customize)
Commands)

2. Categories)
Commands)
3. , (Commands)

4.

5. , ,

Recording A Macro)

, margins)
,
6

1. | | Tools|Macro|Record New Macro)

2. Macro name)
space)

3.
Shortcut key)
small) CTRL+number shortcut
CTRL+SHIFT+number
4. Store macro in)

5. Description)

6. OK
7.
| File|Page
Setup) OK

8. Stop)
saved)
Running A Macro)
1. | |
(Tools|Macro|Macros)
7

2. Macros) Macro name)
Run)

3. BREAK) (
PAUSE , (CTRL+PAUSE)

Modifying MS Exel
MS Excel tutorials in Hindi
Moving Through Cells)
data)
keyboard)

Movement) Key stroke)
Up Arrow
Down Arrow Enter
:Left Arrow)
Right Arrow)
A1) CTRL+HOME
CTRL+END

CTRL+right arrow key
CTRL+down arrow key
8

File|Go To menu bar command
, , Adding Worksheets, Rows, and
Columns)
Worksheets) - |
Insert|Worksheet)
Worksheets) - |
(Insert|Rows)
right click) Insert),

Worksheets) - |
Insert|Columns)
right click)
(Insert),
Resizing Rows and Columns)

1. Resize a row)
Resize a column)
- -
2. | |
(Format|Row|Height) | | Format|Column|Width)

Selecting Cells)

whole sheet)
9

SHIFT)
Cluster of

cells)
To activate)
double click) F2
Moving and Copying Cells
Moving Cells)

| (Edit|Cut) Cut)
Copying Cells)
| Edit|Copy)
Copy)
Pasting Cut and Copied Cells)

|
(Edit|Paste) Paste)
Drag and Drop)

Freeze Panes)

1.
,
2. | Window|Freeze Panes)
3. | Window|Freeze Panes)
.
10

1
1

Formating MS Exel
MS Excel tutorials in Hindi
Formatting Toolbar)

| |
View|Toolbars|Formatting)

Format Cells Dialog Box)

right click) Format Cells)
| Format|Cells)