MS-EXCEL

MS-EXCEL

Introduction :-

                    Ms-excel is the most popular spreadsheet software available for computer and one of the major components of ms-office. Ms-excel allows you to create, manage, store, analyze and presenting data in tabular format. It is also used to perform simple arithmatic operations as well as trigonometry, statistical and business calculations with excel you can prepare annual reports, invoices, salary statements, income tax statements, developing business plans inserting graphs, charts etc.

Features :-

1) Ms-excel allows you to enter, modify, delete and stored to data electronically.

2) Using excel, you can prepare wide variety of highly customisable business        charts.

3) Excel spreadsheet can be used to create computerised ledger.

4)Ms-excel is a multiple document interface which needs you can open more  than 1 doc. inside the application.

5) Ms-excel provides mathematical, statistical string functions using these        functions you can preform any calculations if the entries in the sales are          changed then formulas automatically calculated the new results.

6) Ms-excel can import data from a wide variety of sources.

7) Excel provides auto shapes features to create simple and complex diagrams.

8) Excel makes it easy to sort, filter, summarise and manipulate stored in the  worksheet.

9) Excel is used to create budgets, analyze survey results, preform any type of financial analysis.

10) Excel also has the facility of spellcheck, tracking changes, macrows, error    checking.

Shortcuts

Shortcuts Of MS-WORD

     Action                                                                    Keystroke

1] Select all the contents of the pages                             ctrl+A

2] Bold highlighted section                                             ctrl+B

3] Copy selected text                                                     ctrl+C

4] Open font window                                                     ctrl+D

5] Align the lines or selected text to the center 
   of the screen                                                             ctrl+E

6] Opens find box                                                         ctrl+F

7] Italic highlighted section                                            ctrl+I

8] Aligns the selected text or lines to justify screen          ctrl+J

9] Insert link                                                                ctrl+K

10] Aligns the lines or selected text to the left of 
      screen                                                                   ctrl+L 

11] Open the print window                                            ctrl+P

12] Aligns the lines or selected text to the right of 
     screen                                                                    ctrl+R

13] Save the open document                                         ctrl+S

14] Underline the selected text                                      ctrl+U

15] Paste                                                                     ctrl+V

16] Cut selected text                                                    ctrl+X

17] Redo the last action perform                                   ctrl+Y

18] Undo the last action perform                                   ctrl+Z

19] Change the font                                                     ctrl+shift+F

20] Increase selected font +1pt upto 12 pt 
     & then increase font +2 pt                                       ctrl+shift+>

21] Increase selected font +1pt                                   ctrl+]

22] Decrease selected font by 1pt. If 12 pt or lower 
     If above 12 decrease font by 2 pt                           ctrl+shift+<

23] Decrease selected font by 1pt                                ctrl+[

24] Moves 1 word left                                                 ctrl+left arrow

25]Moves 1 word to right                                            ctrl+right arrow

26] Moves to the beginning of the line or paragraph      ctrl+up arrow

27] Moves to the end of the paragraph                        ctrl+down arrow

28] Deletes word the right of the curser                      ctrl+Del

29] Deletes word to the left of curser                         ctrl+Backspace

30] Moves the curser to the end of the document       ctrl+End

31] Moves the curser to the beginning of the 
     document                                                          ctrl+Home

32] Opens new document                                     Alt+Ctrl+F2 OR Ctrl+O

33] Open help                                                         F1

34] Open Find, Replace, go to window                       F5

35] Spellcheck and grammer                                    F7

36] Save as                                                            F12 OR Ctrl+S

37] Change the text from uppercase to 
     lowercase                                                          Shift+F3

38] Save open document                                     Shift+F12 OR Ctrl+S

39] Insert current date                                          Shift+Alt+D

40] Insert current time                                          Shift+Alt+T

41] Single space lines                                            ctrl+1

42] Double space lines                                           ctrl+2

43] 1.5 line spacing                                               ctrl+5