Excal Notes In Hindi 6i2c5i

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 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

(