Loading documents preview...
1
MS Exel MS Excel tutorials in Hindi Excel):
(spreadsheets) datas)
'
' (columns)
'
workbook) worksheets) ' (rows)
(grid) (cell) ,
'E'
'5' 'E5' mathematical formulas)
,
Microsoft Excel - Screen Elements)
Adding and Renaming Worksheets)
2
|
Insert|Worksheet) rigit click) Enter)
Rename)
Toolbar)
New) -
| N (CTRL+N)
|
'
Open) File|Open) ' ' (Open)
Save) File|Save) ' ' (Save)
O (CTRL+))
| S (CTRL+S)
Prnt) -
| P (CTRL+P)
Save) | File|Print Preview) ' (Print Preview) Save) ' (Spell Check)
' ,
File|New) ' (New)
Cut, Copy, Paste) Modifying A Worksheet) section)
File|Print) ' ' (Save)
'
3 ,
Undo, Redo) -
Undo) Redo)
Undo and Redo) Insert Hyperlink) -
cell) Insert Hyperlink) OK
, (Functions)
Autosum, Function Wizard, and Sorting) section)
Zoom) ' ' (zoom)
Customizing MS Exel MS Excel tutorials in Hindi
1. 2.
| Options)
|
View|Toolbars|Customize)
4 3. Menus show recently used commands first
Toolbars)
|
View|Toolbars)
Customize Toolbars) ,
, ,
5 1.
| | Commands)
2.
View|Toolbars|Customize)
Categories) Commands)
3.
,
(Commands)
4. 5.
,
,
Recording A Macro)
, ,
margins)
6 1.
|
2.
|
Tools|Macro|Record New Macro)
Macro name) space)
3. Shortcut key) small) CTRL+SHIFT+number Store macro in)
4. 5.
CTRL+number shortcut
Description)
6. 7.
OK |
File|Page
Setup)
OK
8.
Stop) saved)
Running A Macro) 1.
| (Tools|Macro|Macros)
|
7 2.
Macros)
Macro name) Run)
3.
BREAK) , (CTRL+PAUSE)
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)
|
Selecting Cells)
whole sheet)
|
| | Format|Column|Width)
9
SHIFT)
Cluster of cells)
To activate) F2
double click)
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. 3.
| .
Window|Freeze Panes) | 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)
11
Number tab) data) , Number)
General), Date) Alignment tab) -
Font tab) -
,
,
Border and Pattern tabs) -
,
,
Dates and Times) January 1, 2001" 1-Jan-01" Format Cells) Number) Date") Category) OK
Category) (Type) ("Time")
12
Styles)
Dates and Times) January 1, 2001" 1-Jan-01" Format Cells) Number) Date") Category) OK
Category) (Type) ("Time")
13 Comma) -------comma) 0] (Comma [0]) Currency) $, Rs. 0] (Currency [0]) -
_
Normal) Percent) -
Style Dialog Box)
|
Format|Style...)
Create a New Style)
14 Style)
ENTER)
Format Painter)
Format Painter)
(double click) Esc)
,
active)
AutoFormat) -
|
Format|AutoFormat)
15
Options...) OK
>
Keyboard Shortcuts) MS Excel tutorials in Hindi
(Action)
(Keystroke)
(Document actions) (Open a file)
(Action)
(Keystroke)
(Selecting Cells
CTRL+O
SHIFT+left arrow (All cells left
16
(New file)
CTRL+N
of current cell)
SHIFT+right arrow
F12 (Save As) (Save) (Print) (Find) (Replace)
(All cells right of current cell) CTRL+S
CTRL+Spacebar
CTRL+P
(Entire column)
CTRL+F
(Entire row)
CTRL+H
(Entire worksheet)
SHIFT+Spacebar CTRL+A
F5 (Go to)
(Text Style)
(Cursor Movement) (One cell up) (One cell down) (One cell right) (One cell left)
A1 (Top of worksheet)
CTRL+B
(Bold)
CTRL+I
up arrow
(Italics)
down arrow
(Underline)
Tab
(Strikethrough)
CTRL+U CTRL+5
SHIFT+Tab (Formatting) CTRL+Home
(Edit active cell) (currency)
F2
SHIFT+CTRL+$
( CTRL+End (End of worksheet) (last cell with data) Home
(Format as percent with no decimal places) (Cut)
SHIFT+CTRL+%
CTRL+X
17 (End of row)
(End of column)
(Copy)
CTRL+left arrow
(Paste)
CTRL+ PageDown
(Move to next worksheet)
(Undo) (Redo)
(Formulas)
CTRL+V CTRL+Z CTRL+Y
CTRL+1 (Format cells dialog box)
ALT+=
(Apply AutoSum)
CTRL+C
CTRL+;
(Current date)
CTRL+:
(Current time)
F7
(Spelling)
F1
(Help)
ALT+F8
(Macros)
Graphics) MS Excel tutorials in Hindi Adding Clip Art)
|
|
Insert|Picture|Clip Art)
18
image)
Search for clips)
keywords) -
Insert Clip) -(Preview Clip) right)
x"
19
Add Clip to Favorites) favorites) Insert ClipArt) Find Similar Clips)
Close)
Add An Image from a File)
| | Look in):
Insert|Picture|From File)
Insert)
20
Editing A Graphic)
9 -
-
Picture toolbar, |
|
View|Toolbars|Picture),
,
Insert Picture) selection)
(gray scale),
Image Control) black and white)
image
21 More/Less Contrast) -
More/Less Brightness)
-
Crop) Line Style)
Text Wrapping) Format Picture)
Reset Picture)
AutoShapes) , | | Insert|Pictures|Autoshapes) View|Toobars|Autoshapes)
Lines) -
,
|
,
,
,
|
,
Connectors) -
Basic Shapes) two- and three-dimensional shapes) icons), (braces), brackets)> drag-and-drop)
,
22 handles)
yellow -
-
diamond handles)
Block Arrows) two- and three-dimensional arrows). open box and yellow diamond) . Free Rotate)
Flow Chart elements)
stars),
flow chart
Stars and Banners) banners), Call Outs) -
speech and thought bubbles,
call outs More AutoShapes) -
Enter your search terms Search
Charts) MS Excel tutorials in Hindi
Submit search form
line
23 data)
Chart Wizard)
Chart Wizard dialog box) Chart Type) Chart type) Next)
Chart subtype)
24
Chart Source Data) Next)
25
Chart Options) -
, ' -' (X-)
' ' (Y-) (Next)
26 Chart Location) As new sheet) As object in
Finish)
Resizing the Chart)
Moving the Chart) left)
27
Chart Formatting Toolbar)
Chart Objects List) Chart Objects List) Format) Chart Type) -
Legend Toggle) -
Data Table view) -
table)
data) Display Data by Column or Row) ,
Angle Text) Angle Downward) angle) +/- 45
axis) (value) (Angle Upward) degrees)
28
Copying the Chart to Microsoft Word)
Sorting and Filing) MS Excel tutorials in Hindi General Sorts) ,
(alphabets), (
,) Sort Ascending) (A-Z) Sort Descending) (Z-A)
Complex Sorts) ,
, |
Data|Sort)
Sort) Sort By)
29 ,
headings) My list has)... No header row)
Header row) -
alphabetic or numeric)
special nonOptions)
OK
Autofill) repetitive)
(sequential)
Autofill) sequential) repetitive) handle)
30
Alternating) ,
1
2 3, 1 2 3....
Autofilling Functions)
A
B SUM(A2:B2)"
C
C2
--
Tips and Trips)
MS World tutorials in Hindi Watermark) Excel): |
|
View|Toolbars|WordArt)
WordArt Toolbar) WordArt Button)
Insert
31
OK
| (Format|WordArt) No Fill)
Fill)
32
Line)
OK
Gridlines) |
Tools|Options)
33
Gridlines)
OK
34
Page Properties and Printing) MS Excel tutorials in Hindi Page Breaks)
|
Insert|Page
Break)
Page Setup) margins), |
headers) (footers) File|Page Setup)
Page) Orientation)
Portrait) Scaling)
Landscape)
1 page(s) wide)
li>
(Fit to 1
35 Margins) top),
bottom), header)
Header/Footer) Header/Footer) preset)
Margins) left) footer)
(right)
36
Custom Header)
Format Text) -
(Custom Footer)
font),
size)
style)
Page Number) -
Total Number of Pages) 15" Date) -
Time) File Name) Tab Name) -
Sheet) Gridlines) Rows to repeat at top
page 1 of
37
Print Preview) | Preview)
File|Print Next) -
Previous) Zoom) Page Setup) Close)
Print)
Print) |
(File|Print)
38
Print Range) Print What) Copies) (Collate) OK
Formulas and Functions) MS Excel tutorials in Hindi Formulas)
Enter) ,
,
39
L(inking Worksheets) value) 1 A1+2)
A2 2
2
A2
A3
"=+B1+Sheet1!B1" "=A1+Sheet2!A2"
2
A3
, A3 1 2
2
'="
A2 A2 A3
(Enter) "=+B1+Sheet1!B1" 2
A3
, Referencing)
Relative, Absolute, and Mixed
A1") relative referencing). - "=(A1+B1)"
C1 C2
40 A2+B2)" A1+B1)" (absolute referencing) $" $A$1+$B$1)" "=(A$1+$B2)"
,
Basic Functions)
D1 D10 D1+D2+D3+D4+D5+D6+D7+D8+D9+D10" SUM(D1:D10)"
(Function) =SUM(A1:100)
SUM) AVERAGE)
=AVERAGE(B1:B10)
A1
A100
B1
B10
C1
C100
D1
D100
=MAX(C1:C100)
MAX)
=MIN(D1:D100)
MIN)
SQRT) =SQRT(D10)
TODAY)
D10
=TODAY()
Function Wizard) Function Wizard)
Function Wizard) Paste Function) category)
(Function (Function
41 name)
OK
OK
Autosum) adjacent) Autosum)
C2 Autosum) A2
B2
42 ENTER) green check mark
(