Ms-Excel

What is Microsoft Excel??

MS Excel, जिसका पूरा नाम ‘Microsoft Excel‘ है तथा इसे ‘Excel‘ के नाम से भी जानते है, एक Spread Sheet Program है, जो आंकडों को Tabular format में Open, Create, Edit, Formatting, Calculate, Share एवं Print आदि करने का कार्य करता है. MS Excel को Microsoft द्वारा विकसित किया गया है.

To start MS EXCEL 

Step 1:-Click on start menu.

Step 2:-Point to all programs.

Step 3:-Point to Microsoft Excel.

Step 4:- Click on Microsoft Excel .

Used to excel including

Data entry

Data management

Accounting

Financial analysis

Programming

Charting and graphing

Task management

Financial modeling

Customer relationship management

Used for Menu

• Home
  • Comprises options like font size, font styles, font colour, background colour, alignment, formatting options and styles, insertion and deletion of cells and editing options
• Insert
  • Comprises options like table format and style, inserting images and figures, adding graphs, charts and sparklines, header and footer option, equation and symbols
• Page Layout
  • Themes, orientation and page setup options are available under the page layout option
• Formulas
  • Since tables with a large amount of data can be created in MS excel, under this feature, you can add formulas to your table and get quicker solutions 
• Data
  • Adding external data (from the web), filtering options and data tools are available under this category
• Review
  • Proofreading can be done for an excel sheet (like spell check) in the review category and a reader can add comments in this part 
• View
• Different views in which we want the spreadsheet to be displayed can be edited here. Options to zoom in and out and pane arrangement are available under this category

Shortcut keys:-

To create a new workbook

Ctrl + N

2. To open an existing workbook

Ctrl + O

3. To save a workbook/spreadsheet

Ctrl + S

4. To close the current workbook

Ctrl + W

5. To close Excel

Ctrl + F4

6. To move to the next sheet

Ctrl + PageDown

7. To move to the previous sheet

Ctrl + PageUp

8. To go to the Data tab

Alt + A

9. To go to the View tab

Alt + W

10. To go the Formula tab

Alt + M

11. To edit a cell

F2

12. To copy and paste cells

Ctrl + C, Ctrl + V

13. To italicize and make the font bold

Ctrl + I, Ctrl + B

14. To center align cell contents

Alt + H + A + C

15. To fill color

Alt + H + H

16. To add a border

Alt + H + B

17. To remove outline border

Ctrl + Shift + _

18. To add an outline to the select cells

Ctrl + Shift + &

19. To move to the next cell

Tab

20. To move to the previous cell

Shift + Tab

21. To select all the cells on the right

Ctrl + Shift + Right arrow

22. To select all the cells on the left

Ctrl + Shift + Left Arrow

23. To select the column from the selected cell to the end of the table

Ctrl + Shift + Down Arrow

24. To select all the cells above the selected cell

Ctrl + Shift + Up Arrow

25. To select all the cells below the selected cell

Ctrl + Shift + Down Arrow

26. To add a comment to a cell

Shift + F2

27. To delete a cell comment

Shift + F10 + D

28. To display find and replace

Ctrl + H

29. To activate the filter

Ctrl + Shift + L

Alt + Down Arrow

30. To insert the current date

Ctrl + ;

31. To insert current time

Ctrl + Shift + :

32. To insert a hyperlink

Ctrl + k

33. To apply the currency format

Ctrl + Shift + $

34. To apply the percent format

Ctrl + Shift + %

35. To go to the “Tell me what you want to do” box

Alt + Q

 

                             .......RAUNAK RKS