MICROSOFT EXCEL 1

Introduction To Microsoft Excel

 ;g ,d application Software gSA tks microsoft office dk ,d part gSA Excel dks Spreadsheet
Hkh dgk tkrk gSA blesa Mathematic & logical lacfa /kr dk;Z fd;k tkrk gSA blesa formulas or
Functions dk mi;ksx fd;k tkrk gSA
 Excel esa fuEu Functions dk mi;ksx– Hotel management Function, Text Function, Date &
Time Function, Maths Function, Database Function, AutoSum Function, Logical
Function, Vlookup Function, $ use Function, Statistical Function etc.
 Microsoft excel dk mi;ksx& lkaf[;dh [Link] djus ds fy,] Marksheet, Data Entry, Sorting]
Charts] Hyperlink] Date validation, filter, Goal seek or Subtotal vkfn ds fy, fd;k tkrk gSA
 Excel dks start djrs gS rks By default show gksus okyh file dk uke Book1 gksrk gSA Excel esa ,d
Workbook gksrh gS ftlesa by default 3 Worksheet (Sheet1, Sheet2, Sheet3) gksrh gSA
 ,d workbook esa minimum – 1 or Maximum 255 worksheet gksrh gSA izR;sd worksheet esa
Rows, columns or cell gksrh gSA izR;sd cell dk cell address vyx&vyy gksrk gSA By default
cell address – A1 gksrk gSA Formula apply djus ls igys (=) dk mi;ksx fd;k tkrk gSA
 Excel esa data cell esa fy[kk tkrk gSA Row vkSj Column ds Intersection (pkSjkgk) ls cell curk gSA
Columns – A, B, C ... XFD or Rows – 1, 2, 3 ... 1048576
 Excel 2010 esa Columns – 16384 (A to XFD) vkSj Rows – 1048576 gksrk gSA
 Microsoft Excel dk extension - MS Excel 2003 ;k ml igys dk .xls gSA MS Excel 2007 ;k
mlds ckn dk .xlsx gksrk gSA
Microsoft Excel open :-
 Start  Run  Excel  ok
Or
 Start  All programs  Microsoft office  Microsoft Excel
Or
 Right click on desktop  New  Microsoft excel worksheet.
Microsoft Excel open -
1. Title bar
2. Menu bar/ Tab
3. Ribbon
4. Quick access tool bar
5. Formula bar
6. Scroll bar (Horizontal or Vertical)
7. Worksheet
8. Status bar
- 9828072703
 MICROSOFT EXCEL 2
Title bar lcls Åijh ckj dks Title bar dgrs gSA ftl ij [File name or program name]
[Minimize , Maximize, restore down, Close] By default file name – Book 1.
Menu bar / Tab - MS Excel es dqy 8 Tabs gksrs gS & File, Home, Insert, Page Layout,
Formulas, Data, Review, View.
Ribbon :- bllsa menu bar ds fdlh Hkh menu/Tab ij click djus ij mlds lacaf/kr Groups Show gksrs
gS mlesa Tools fn[kkbZ nsrh gSA ftldk mi;ksx dk;Z djrs gq, dj ldrs gSA

Quick access tool bar :- blesa show gksus okys tools dk mi;ksx lkekU; dk;Z djus ds fy, fd;k tkrk
gSA tSls save, undo, redo, open etc.)
Name box :- ;g formula bar ds Left side show gksrk gSA blesa select fd xbZ cell dk cell address
fn[kkbZ nsrk gSA tSls A1.
Formula bar :- blesa Select fd xbZ cell esa fy[kh value, Text vkSj formula fn[kkbZ nsrk gSA mlesa
changes Hkh dj ldrs gSA Select cell address esa change djus ds fy, shortcut key – F2
Horizontal scroll bar /vertical scroll bar :- Excel sheet esa type fd;k x;k Data, Formula,
Matter, Image, Object vkfn Left, Right, Top or Bottom esa fn[kkbZ ugh nsrk gS rks mls Scroll dj ds
ns[k ldrs gSA
Worksheets Tab:- Horizontal scroll bar ds left side esa worksheets Tab fn[kkbZ nsrh gS ftlesa
sheet1, sheet2, sheet3 fn[kkbZ nsrk gSA Shift + F11 ls Next sheet insert dj ldrs gSA vkSj Ctrl +
Page Up or Page Down ls Next or Previous sheet ij tk ldrs gSA
Status bar :- bllsa Workbook view or Zoom vkfn ds ckjs esa Information ns[k ldrs gSA Excel esa
minimum 10% vkSj Maximum 400% zoom djds ns[k ldrs gSA
Worksheet :- Worksheet eq[; :i ls cell dk ,d laxzg gS tgka vki MsVk j[krs gS vkSj ml MsVk dks lso
djds j[k ldrs gSA
Book 1 – Microsoft Excel

File Menu Menu bar/Tab Ribbon Groups

Title bar
Cell Address Vertical Scroll bar
Column
Row Horizontal Scroll bar
Zoom Controls

Worksheet Tab Workbook Views

- 9828072703
 MICROSOFT EXCEL 3
- File Menu -
 Save (Ctrl + S):- Excel sheet esa rS;kj file dks fdlh Hkh name
ls save dj ldrs gSA ;fn vkius QkbZy dks save ugha fd;k gS rks bl
fodYi dk mi;ksx djus save dialog box open gksrk gS ftlesa file
dk uke rFkk file format o location vkfn dh tkudkjh nsus ds ckn
“Save” cVu ij click djsA
 Save As (F12) – bldk mi;ksx orZeku esa open dh xbZ file dh
Duplicate file cuk ldrs gSA
 Open (Ctrl + O):- Save dh xbZ file dks open dj ldrs gSA
 Close (Ctrl + W) :- blls current open file dks Close dj
ldrs gSA
 Info:- Protect Workbook  Encrypt with password :- bl
option dh lgk;rk ls current file dk password yxk dj lqjf{kr
dj ldrs gSA password yxkus ds ckn file dk lso djuk t:jh gSA
bl file dks open djksxs rks password enter djuk gksxkA
 Recent :- blesa orZeku esa save vkSj open dh xbZ file dh list
show gksrh gS ftlesa fdlh Hkh file dks open Hkh dj ldrs gSA
 New (Ctrl + N) :- blesa Blank workbook vkSj Templates File open dj ldrs gSA
 Print (Ctrl + P) :- blls print dialog box open gksrk gS ftlesa user ds vko” ;drkuqlkj setting
change dj ds current open file dk print fudky ldrs gSA
 Print preview (Ctrl + F2) :- blls open file dk print fudkyus ls igys print preview ns[k ldrs gSA
vkSj print Hkh ns ldrs gSA
 Save & Send :- Create PDF – blls current file dks PDF format esa save ldrs gSA
 Help (Ctrl + F1) Help Dialog box show gksrk gSA
 Options :- bl ij click djus ij dialog box show gksrk gS ftlesa Microsoft excel dh setting show
gksrh gSA
 Exit :- Current window dks close dj ldrs gSA Microsoft Excel cUn gks tkrk gSA

- HOME -

 Clipboard :-
 Font :-
 Alignment :-
Text Alignment :- Selected cell ds matter dks align dj ldrs gSaA tSls%& Left, Right, Center,
Top, Bottom vkfnA
Orientation:- bllsa select cell esa type word/ value dks angle esa rotate dj ldrs gSA
Wrap text:- Wrap Text :- Selected cell esa Type fd;s x;s Sentence dks mlh Cell esa Set dj ldrs
gSa blls Cell fd height cM+h gks tkrh gSaA

- 9828072703
 MICROSOFT EXCEL 4
Merge cell:- bllsa ,d ls vf/kd cell dks select dj ds ,d dj ldrs gSA
blesa fuEu option show gksrs gSA tSls :- merge & center, merge across, merge cell ,unmerge
cell etc.

 Number
Number:- Selected cell fd Category change dj ldrs gSa tSls fdlh cell fd Category Text djus
ij mlesa Type fd;k x;k Formula Text Matter fd rjg gh Show gksrk gSaA General ls Cell fd
Category normal dj ldrs gSaA

 Styles
Conditional formatting:- blls selected cell ij conditional set dj ds formatting apply dj
ldrs gSA apply fd x;h condition ds vuqlkj number ij color, highlight, icons set dj ldrs gSA
Format as tables:- blls selected table ij format set dj ldrs gSA
Table tools:- bllsa table ij apply dh x;h format design dks change dj ldrs gSA
Cell styles:- bllsa select cell ij style apply dj ldrs gSA

 Cells
 Insert:- bllsa sheet esa column, row, cell or sheet insert dj ldrs gSA
 Delete:- bllsa cell, columns, row or sheet dks delete dj ldrs gSA
 Format:-
Cell size :- blls column rFkk row dh size change dj ldrs gSA default weight ls lHkh
column dh size ,d lkFk de T;knk dj ldrs gSA
Visibility :- bllsa column, row or sheet dks hide/show dj ldrs gSA
Organize sheet :-
Rename sheet , move or copy sheet, rFkk tab color dj ldrs gSA
Protect sheet :- bllsa password yxk dj sheet dks lqjf{kr dj ldrs gSA
 Editing
AutoSum:- blesa formula show gksrk gS ftldk mi;ksx Sum, Average, Count, Max, Min etc. ds
:i esa dj ldrs gSA
Clear:- blls select cell esa type value rFkk formatting rFkk comment dks clear dj ldrs gSA
Filter:- bllsa cuk;h x;h table esa heading dks select dj dss record dks filter dj ds ns[k ldrs gSA

Find & select :-

 Find :- bllsa sheet esa type word dks <qa< ldrs gSA
 Replace :- blls sheet easa type word dks change dj ldrs gSA
 Go to :- blls fdlh Hkh cell address ij direct tk ldrs gSA
 Go to special :- bllsa fdlh formula, comment , last cell, object etc.
 Conditional formatting :- bllsa vxj sheet esa conditional apply dh x;h gS rksa ml ij direct tk
ldrs gSA

- 9828072703
 MICROSOFT EXCEL 5
- INSERT -

 Tables
Pivot table & pivot chart :- bllsa selected data dk pivot table or pivot chart cuk ldrs gSA
Process :- Select data  Insert  Pivot table/pivot chart  New workbook  ok 
Pivot Table field list esa vius vko';drkuqlkj field choose djs tks field choose fd;k x;k gS os table
or chart esa show gksrs gSA
Pivot table tools
Design, format, layout, analyze fuEu tools dk use djrs gq, Pivot Table rFkk Pivot Chart esa
changes dj ldrs gSA
Table :- bllsa select data table ds record dks sort or filter dj ds ns[k ldrs gSA

 illustrations
Picture :- blls sheet esa picture insert dj ldrs gSA
Clip art :- compute esas store clip part dh list dks ns[k ldrs gSA rFkk fdlh dks Hkh sheet ess yk ldrs gSA
Format tools :- bllsa selected shapes dk format change dj ldrs gSA tSls :- shape styles ,
shadow effects, 3D effects, arrange, size etc.
Smart art :- blesa vyx&vyx rjg ds smartart gksrs gsSa fdlh dk Hkh mi;ksx dj ldrs gSA smart art esa cukus
ds ckn design or format menu show gksrh gSA ftldk mi;ksx select smart art ij dj ldrs gSA
Screenshort :-
 Chart
Chart :- blesa fuEu izdkj ds charts gksrs gSA ftldk mi;ksx sheet data record dks chart esa fn[kk ldrs
gSA
Type of chart :- column, line, pie, area, bar, stock bubble ,radar, surface etc.
cuk;s x;s chart dks select djus ij three chart tool show gksrh gSA
Design, layout, format etc. bu Tools dk mi;ksx djrs gq, chart dh Design, Layout or Format
change dj ldrs gSaA
 Links
Hyperlink :- bllsa cell dks select dj ds fdlh Hkh file, image dk link set dj ldrs gSA link word ij
mouse click djus ij hyperlink ls set fd x;h file ;k image dks ns[k ldrs gSaA
Process :- Select cell type word  Insert  Hyperlink  Select file  Open  Mouse
click  ok
Remove hyperlink :- Use of hyperlink word right click  Remove hyperlink.
 Text
Text box:- blls text box cuk ldrs gSSA ftldk use dj ds matter type dj ldrs gSaA
Header & footer :- page ds top or bottom area esa date and time, page number, any matter
type dj ldrs gSA Header & footer dk use djus ij design tools show gksrh gSA

- 9828072703
 MICROSOFT EXCEL 6
ftllsa ge page number, date & time, picture, clip art, rFkk header & footer position change
dj ldrs gSA
header & footer area esa set fd x;h date & time , page number lHkh page ij show gksrk gSA
Header & footer dk view page layout esa ns[k ldrs gSA
Wordart – blesa word art gallery essa ls fdlh Hkh word art dks ys ldrs gSA rFkk format menu dk use
djrs gq, formatting change dj ldrs gSA
 Symbol
Equation :- vyx&vyx rjg ds Formula insert djds mlesa Changes dj ldrs gSaA
Symbol :- blesa lHkh izdkj ds symbol gksrs gSA ftldks ge direct keyboard ls ugh yk ldrs gSA rFkk igys
ls cuh shortcut key dks ns[k ldrs gSA
fuEu shortcut key :-
Alt +0188 ¼ Alt +0189 ½ Alt +0190 ¾
Alt +0165 ¥ Alt +0163 £

- PAGE LAYOUT -

 Themes
Themes :- Cell style ls formatting apply dh xbZ gS rks themes dk use dj ldrs gSA vU;Fkk
themes dk use ugh dj ldrs gSaAblesa themes, color, font etc. change dj ldrs gSA
 Page Setup
Margins :- bllas page dk margins (left, right, top, bottom) dks set dj ldrs gSA rFkk custom
margins dj by default margins dks change Hkh dj ldrs gSA
Orientation :- bllsa page dks portrait rFkk landscape esa set dj ldrs gSA
Size :- bllsa page dh size change dj ldrs gSa] tSlsa :- Letter, Legal, A4, A5 etc.
Set print area :- bllsa columns and row dks select dj ds print ds fy, area set dj ldrs gSA set
fd;k x;k area print esa show gksxkA
Clear print area :- set fd;k x;k print area dks clear dj ldrs gSA
 Breaks :-
Insert page break :- bllsa page break dj ldrs gSA
Remove page break :- bllsa insert page break ls fd;s x;s break dks remove dj ldrs gSA
Resent all page break :- bllsa sheet esa insert page break ls fd;s x;s all page break dks clear
dj ldrs gsSaA
Background :- bllsa sheet ds background esa dksbZ Hkh image yk ldrs gSA
Remove background :- bllsa sheet ds background esa image dks remove dj ldrs gSA
Print title :- bllsa viuh vko';drkuqlkj print fdl option dks show djokuk ;k ugh djokuk gSA ml
option dks hide/ show dj ldrs gSA Exp. :- gridline, black and white or row and column
headings etc.
 Scale and Fit
Scale and fit :- blls width, height or scale etc. changes dj ldrs gSA

- 9828072703
 MICROSOFT EXCEL 7
 Sheet options
Gridlines :- view :- bllsa gridlines dks hide/show dj ldrs gSA rFkk print esa Hkh show djok ldrs gSA
Headings :- bllsa heading dk view dks hide/show rFkk heading dks print esa show djok ldrs gSA
- VIEW -

 Workbook Views
Normal:- bllsa page dks normal view esa ns[k ldrs gSA ;g by default view gSA
Page layout :- bllsa sheet esa header & footer use fd;k x;k gSa rks mls ns[k ldrs gSA Ruler bar dks
Hide/Show dj ldrs gSA
Page Break Preview :- Sheet ij Type fd;s x;s Matter dks ist ij ns[k ldrs gSaAa rFkk Matter dks ist
ij Adjust Hkh dj ldrs gSaA
Custom Views :- Sheet ds fdlh Hkh Area dks Custom views esa Add dj ldrs gSa ftls Show }kjk
Direct ns[k ldrs gSaA
Process:- Select cells  View  Custom views  Add  Type name  ok.
Full screen :- bllsa select sheet dks full screen dj ds ns[k ldrs gSA
 Show :-
Ruler, Formula bar, Gridlines, heading dks hide/show dj ldrs gSA
 Zoom
bllsa worksheet dks zoom dj ds ns[k ldrs gSA Mimimum zoom 10% vkSj Maximum zoom
400% dj ldrs gSA
 Window
Freeze pane:- bllsa columns or rows dks freeze dj ldrs gSA reocrd fill djrs le; freeze fd;k
x;k columns or rows ges'kk fn[kkbZ nsrk gSA
 Macros

- REVIEW -

 Proofing
 Language
 Comments
 Changes

- 9828072703
 MICROSOFT EXCEL 8
Protect Sheet :- bllsa current sheet dks password yxkdj lqjf{kr dj ldrs gSA
Process:- Review  Protect sheet  Enter password (SBC@5601)  Reenter
password  (SBC@1483)  ok
- FORMULAS -

 Function Library : blesa formula show gksrk gSA ftls function group ds fglkc ls define fd;k x;k gSaA
 Defined Names :
Define name :- Cell address ds LFkku ij dksbZ Hkh uke Add dj ldrs gSa add fd;k x;k uke Cell dks
Select djus ij Formula bar esa show gksrk gSaA
Process:- Select cell  Formulas  Define name  Define name  Name [SCI] 
Add  ok.
Use in formula :- Define name ls ftl cell dk uke define fd;k x;k gS mldks mi;ksx formula esa dj
ldrs gSA
Name Manager :- blesa cell address dk name define fd;k x;k gS ml lHkh dks name manager esa
ns[k ldrs gS vkSj mlesa change or delete dj ldrs gSA
 Formula Auditing
 Track Precedents :- Selected Cell esa Value ftl Cell ls vk jgh gSa mls Arrow }kjk ns[k ldrs gSaA
 Track Dependents :- Selected cell fd Value ij tks Cell fuHkZj gSa mls Arrow }kjk ns[k ldrs gSaA
 Remove Arrows :- Sheet ij Apply fd;s x;s lHkh Track Arrow gVk ldrs gSaA
 Show formulas :- Sheet ij Apply lHkh Formula ,d lkFk ns[k ldrs gSaA
 Evaluate Formula: - Selected cell ij Apply fd;k x;k Formula ns[k ldrs gSaA
 Show Watch Window :- blds }kjk vyx ls Watch Window open dj ldrs gSa ftles fdlh Hkh
cell dks Add watch ls Add djds mldh information ns[k ldrs gSaA
 Calculation :
- DATA –

 Get External Data

From access :- bllsa ms access / Mail Merge ls cuk;h x;h file dks excel ds sheet esa yk ldrs gSA
From text :- bllsa Notepad dh file ds matter yk ldrs gSA
 Connections
 Sort & Filter
- 9828072703
 MICROSOFT EXCEL 9
Filter :- Selected field ij Filter button apply dj ldrs gSa ftlds }kjk muds Records dks Sort djds
;k Filter djds ns[k ldrs gSaA
Advanced Filter : - Record dks Criteria ds vuqlkj Filter djds Sheet esa dgh ij Hkh copy dj ldrs
gSaA
HINDI
>65
CRITERIA

Process:- Select blank cell  Data  Advanced  (o) Copy To Another Location 
List Range (Type mark Sheet Cell address)  Criteria Range (Type Criteria Cell
Address)  Copy To (Type Selected cell Address)  ok
 Data Tools
Text to column :- Selected cell ds matter ds izR;sd word dks vyx&vyx Column fd Cell esa Set
dj ldrs gSaA
Process:- Select cell  Text to Column  Next  Next  Finish.
Remove Duplicates :- blls duplicates record dks gVk ldrs gSA
Validation: -
Settings :- Selected cells ij Validation Criteria set dj ldrs gS ftlls Cell esa Criteria ds vuqlkj
gh number type dj ldrs gSaA
Process:- Select marks only  Data  Validation  Settings  Allow  Whole number
 Data  Less Than or Equal To  Maximum  100  ok
Input massage: - Select cells ij dksbZ Hkh massage set dj ldrs gSa tks Cell dks Select djus ij
Show gksrk gSa
Process :- Select cells  Data  Validation  Input massage (Enter number less
then 100)  ok
Error alert :- blesa Type fd;k x;k massage rc Show gksrk gSa tc ge cell esa Validation criteria ls
vf/kd value type djrs gSaA
Process:- Select marks  Data  Validation  Error Alert  (Enter number less then
100 other wise wrong value)  ok.
Consolidate:- Data base function fd rjg bldk use dj ldrs gSaA
Process:- Select Blank cell  Data  Consolidate  Function (Sum)  Reference
(Type data base cell address)  Add  Left Column  ok.
Circel invalid data:- apply validation ds vuqlkj circel apply gks tkrk gSA
Clear validation circel :- blls apply fd;k x;k circel dks gVk ldrs gSA

- 9828072703
 MICROSOFT EXCEL 10
Goal Seek: - Formula okyh Cell fd Value esa Changes dj ldrs gSAa
Process:- Select Cell  data  what-If Analysis  Goal Seek  Set Cell (G2) To
Value (460) By Changing Cell (c2)  ok  ok

Data Table :- Selected cell esa Table (igkM+s) set dj ldrs gSaA

=a1*a2

Process:- Select cell  Data  what-If Analysis  Table  Row input cell (A1) 
Column input cell (A2)  ok.
 Outline
Group:- blls column & row dks select dj ds group dj ldrs gSA
Ungroup:- Group fd;s x;s Column o Row dks ungroup dj ldrs gSaA
Subtotals: - Selected Data esa Record fd Total vyx&vyx Field ds vuqlkj fudky ldrs gSaA
ID ITEM RATE QTY TOTAL
101 FREEZE 8000 10 80000
101 DVD WRITER 1000 25 25000
101 MOUSE 150 50 7500
102 LED SCREEN 6500 6 39000
102 TV 5000 9 45000
102 AC 27000 4 108000
103 MOTHER BOARD 2500 12 30000
103 HARD DISK 4000 8 32000
103 MOBILE 4500 13 58500
Select Data  Data  Subtotals  (on) Qty. (on) Total  ok.

- 9828072703
 MICROSOFT EXCEL 11
MS- EXCEL SHORTCUTS KEY

[Link]. Shortcut key Description

1. Alt or F10 To activate menubar

2. Alt+’ To open format style dialog box

3. Alt+= Sum Function

4. Alt+BackSpace To undo the last action

5. Alt+Down arrow To display Auto complete list

6. Alt+Enter To Start the new line in same cell

7. Alt+F1 To insert chart

8. Alt+F11 To open VBE

9. Alt+F4 To close VBA

10. Alt+F6 To switch between last 2 windows

11. Alt+F8 Macro dialog box

12. Alt+Shift+F2 To save the file

13. Alt+Shift+Right Arrow To Group Rows or Columns

14. Alt+Shift+Right Arrow Ungroup Rows or Columns

15. Alt+Spacebar Go to system menu

16. Alt+Tab Move to cycle applications

17. BackSpace To delete previous entry

18. Ctrl + Shift + 1 To format number in comma format.

- 9828072703
 MICROSOFT EXCEL 12
19. Ctrl + Shift + 2 To format number in time format.

20. Ctrl + Shift + 3 To format number in date format.

21. Ctrl + Shift + 4 To format number in currency format.

22. Ctrl + Shift + 5 To format number in percentage format.

23. Ctrl + Shift + 6 To format number in scientific format.

24. Ctrl W To close the file

25. Ctrl+' To copy formula from cell above

26. Ctrl+- To delete the row

27. Ctrl+" To fill down

28. Ctrl+: To insert current time

29. Ctrl+; To insert current date

30. Ctrl+` To display formula

31. Ctrl+’ Fill the above formula in down

32. Ctrl++ To insert the row

33. Ctrl+0 To hide columns

34. Ctrl+1 Format cells dialog box

35. Ctrl+2 To make font Bold

36. Ctrl+3 To make font Italic

37. Ctrl+4 To underline the Font

38. Ctrl+5 To apply/remove strike through formatting

- 9828072703
 MICROSOFT EXCEL 13
39. Ctrl+6 To show/hide objects the View

40. Ctrl+8 To toggle outline symbols

41. Ctrl+9 To hide rows

42. Ctrl+A To select all data without blanks

43. Ctrl+Alt+F9 To calculate the worksheet in all open workbook

44. Ctrl+Alt+Shift+F9 To rechecks dependent formula

45. Ctrl+Alt+V To displays the "Paste Special" dialog box

46. Ctrl+B To make font Bold

47. Ctrl+BackSpace Go to delete to start of word

48. Ctrl+C To copy the selected values

49. Ctrl+D To fill down

50. Ctrl+Delete To delete to end of word

51. Ctrl+Down Arrow Go to down till the blank cell

52. Ctrl+E To Export module

53. Ctrl+End End Of Module

54. Ctrl+Enter To fill the selected cell range with the current entry

55. Ctrl+F Find the value

56. Ctrl+F1 To display or hide the ribbons

57. Ctrl+F10 To activate menubar

58. Ctrl+F12 To open the file

- 9828072703
 MICROSOFT EXCEL 14
59. Ctrl+F2 To print the file

60. Ctrl+F3 To define the name

61. Ctrl+F4 To close the window

62. Ctrl+F5 XL, Restore window size

63. Ctrl+F6 Next workbook window

64. Ctrl+F7 To move window

65. Ctrl+F9 To minimize workbook

66. Ctrl+G Display 'Go to Dialog" box

67. Ctrl+H Replace the value

68. Ctrl+Home Top Of Module

69. Ctrl+I To make the font Italic

70. Ctrl+Insert To copy the selected values

71. Ctrl+J List Properties/Methods

72. Ctrl+K To add the hyperlink

73. Ctrl+L Show Call Stack

74. Ctrl+Left Arrow Move one word to left

75. Ctrl+N To create new workook

76. Ctrl+O To open workbook

77. Ctrl+P To print the file

78. Ctrl+Page Down Go to top of current procedure in another sheet

- 9828072703
 MICROSOFT EXCEL 15
79. Ctrl+Page Up Go to top of current procedure in another sheet

80. Ctrl+R To fill the right

81. Ctrl+Right Arrow Move one word to right

82. Ctrl+S To save the file

83. Ctrl+Shift+! To comma format

84. Ctrl+Shift+# To convert into date format

85. Ctrl+Shift+$ To convert into currency format

86. Ctrl+Shift+% To convert into percent format

87. Ctrl+Shift+& To place the outline border around selected cell

88. Ctrl+Shift+( To unhide rows

89. Ctrl+Shift+) To unhide columns

90. Ctrl+Shift+* To insert current time

91. Ctrl+shift+: To insert current time

92. Ctrl+Shift+^ To convert into expontential format

93. Ctrl+Shift+_ To remove the outline border around selected cell

94. Ctrl+Shift+~ To convert into general format

95. Ctrl+Shift+A To insert the argument names into formula

96. Ctrl+Shift+Arrow key To select the data from first active cell to last active cell

97. Ctrl+Shift+Enter To Enter the Formula as an Array formula

98. Ctrl+Shift+F To display the Format cells dialog box

- 9828072703
 MICROSOFT EXCEL 16
99. Ctrl+Shift+F12 To give the print

100. Ctrl+Shift+F2 To go to last position

101. Ctrl+Shift+F3 To create the names in row and column

102. Ctrl+Shift+F6 For Previous Window

103. Ctrl+Shift+F8 To step out

104. Ctrl+Shift+F9 To clear all breakpoints

105. Ctrl+Shift+I To Edit Parameter Info

106. Ctrl+Shift+J To Edit List Constants

107. Ctrl+Shift+L To Add/Remove the filter

108. Ctrl+Shift+U Toggle Expand or Collapse formula bar

109. Ctrl+Spacebar Select the complete row

110. Ctrl+T To display the Create Table dialog box

111. Ctrl+Tab Go to cycle windows

112. Ctrl+U To underline the font

113. Ctrl+Up Arrow Go to up till the blank cell

114. Ctrl+V To paste the data

115. Ctrl+X To cut the value

116. Ctrl+Y To redo the last action

117. Ctrl+Z To undo the last action

118. Delete To delete the selected values

- 9828072703
 MICROSOFT EXCEL 17
119. Down Arrow Go to down

120. End Move to end of line

121. Enter Go to new line

122. Esc Cancel the Command and close dialog box

123. F1 To open Excel help

124. F10 To activate menubar

125. F11 To create the Chart

126. F12 To Save as the file

127. F2 To edit active cell

128. F3 To paste name into formula

129. F4 To repeat the last action

130. F5 To open 'Go To' dialog box

131. F6 To move next pane

132. F7 To open spell checker dialog box

133. F8 To extend selection mode

134. F9 To evaluate the part of formula

135. Home Move to beginning of line

136. Insert Toggle insert mode

137. Left Arrow Go to left

138. Page Down Go to page down

- 9828072703
 MICROSOFT EXCEL 18
139. Page Up Go to page up

140. Right Arrow Go to right

141. Shift Hold down shift for additional functions

142. Shift+Ctrl+F To open the Font tab in Format cells dialog box

143. Shift+Ctrl+F+F To open the Font tab in Format cells dialog box

144. Shift+Ctrl+F6 Previous workbook window

145. Shift+Ctrl+P To open the Font tab in Format cells dialog box

146. Shift+Ctrl+Tab To activate previous workbook

147. Shift+Delete To cut the selection

148. Shift+Down Arrow Extend selection down side

149. Shift+End Select till end of line

150. Shift+Enter Enter to Move up

151. Shift+F10 To Show right click menu

152. Shift+F11 To insert new worksheet

153. Shift+F12 To save the file

154. Shift+F2 To edit cell comment

155. Shift+F3 To paste function into formula

156. Shift+F4 To find next

157. Shift+F5 Find the value

158. Shift+F6 To move previous pane

- 9828072703
 MICROSOFT EXCEL 19
159. Shift+F7 To view object

160. Shift+F8 To add selection

161. Shift+F9 Quick watch

162. Shift+Home Select from start of line

163. Shift+Insert To paste the data

164. Shift+Left Arrow Extend selection left side

165. Shift+Page Down Select to end of module

166. Shift+Page Up Select to top of module

167. Shift+Right Arrow Extend selection right side

168. Shift+Spacebar To select the entire row

169. Shift+Tab Outdent

170. Shift+Up Arrow Extend selection up side

171. Tab Indent

172. Up Arrow Go to up

- 9828072703
MICROSOFT EXCEL 20

- 9828072703