Ms excel all topics mentioned in this pptx

Ms excel

1. Dns science academy

2. EXCEL

3. WHAT IS MICROSOFT EXCEL? It is spreadsheet software . It is used to do entry of statistical data, to do calculation on data and to represent the data as chart. This software allows doing entry and analysis of statistical and financial data. First spreadsheet software was VISICALC (Visual Calculator). Other examples of spreadsheet software are MSExcel , Open Office Calc, Google Sheet and Lotus 1-2-3. Microsoft Excel is most popular spreadsheet software because it is very easy to learn and use.

4. REQ. STEPS TO START MS-EXCEL C LICK ON S TART – A LL P ROGRAMS – M ICROSOFT OFFICE – M ICROSOFT E XCEL OR P RESS W INDOW KEY + R T YPE EXCEL P RESS ENTER KEY T O Q UIT F ROM M ICROSOFT E XCEL C LICK O N F ILE + E XIT O R P RESS A LT + F4 K EYS

5. A file created in Microsoft-Excel is called workbook. Each page of workbook is called worksheet. The secondary name of a file created in Microsoft-Excel is .XLSX File + New - Ctrl + N – to create a new workbook File + Save – Ctrl + S / F12 –to save contents of workbook for future File + Close – Ctrl + W – closes currently opened workbook File + Open – Ctrl + O/ Ctrl + F12 – opens existing workbook

6. Name Roll Marks Name Acno Balance Product name Quantity Rate A worksheet is collection of rows and columns. Each worksheet contains 16384 columns and 1048576 rows

7. REQ. STEPS TO CHANGE FONT- select data range click on Home + Font Select desired font type, style, size and colour A Worksheet contains 1048576 rows and 16384 columns Ctrl + B / Ctrl + 2 – applies bold style Ctrli + I/ Ctrl + 3 – applies italic style Ctrl + U / Ctrl + 4 – applies underline style

8. MS-EXCEL PROVIDES FOLLOWING FACILITIES – It allows to create worksheets It allows to do entry/ edit of data in worksheet It allows to do calculation on the data It allows to arrange data in ascending or descending order It allows to draw chart on statistical data It allows to get printout of data as well as chart

9. DIFFERENT COMPONENTS OF MS-EXCEL WINDOW- Title bar Tab group (Home, Insert, Page layout etc.) Formula bar f(x) Column heading (A, B, C, D ) Row heading (1,2,3,…) Worksheet area Sheet tabs

10. REQ. STEPS TO CREATE A NEW WORKBOOK click on File + New + Blank workbook click on Create button OR Press Ctrl + N File + Save / Ctrl + S / F12 – saves the contents of workbook for future File + Close – Ctrl + W – closes currently opened workbook File + Open – Ctrl + O / Ctrl + F12 – opens existing workbook File + Exit – Alt + F4 – closes workbook then quits from excel

11. RAM 388 DCA AMIT 388 DCA RAVI 388 DCA RAHUL 389 OLEVEL RAJESH 389 OLEVEL ABHINAV 389 OLEVEL Ctrl + Home – moves cell pointer to the beginning of worksheet Ctrl + End – moves cell pointer to the last cell of data area

12. REQ. STEPS TO SEARCH ANY VALUE IN WORKSHEET- Press Ctrl + Home keys Click on Home + Find & select + Find or press Ctrl + F Type the value to be searched Click on Find next button THE CELL WHICH CONTAINS CELL POINTER IS CALLED ACTIVE CELL

13. REQ. STEPS TO FIND TEXT AND TO REPLACE WITH NEW TEXT- Press Ctrl + Home keys Click on Home + Find & select + Replace or press Ctrl + H Type the value to be searched Press tab key Type new value Click on Find next button Click on Replace all button

14. REQ. STEPS TO SELECT DATA RANGE- Click at the beginning of the range to be selected Hold shift key down Click at the end of the range to be selected TO SELECT COMPLETE DATA RANGE- Click in data area Press Ctrl + * / Ctrl + A

15. To select a column- click on column title Or press Ctrl + Space bar To select a row – click on row title Or press Shift + Space bar   To select entire worksheet – Press Ctrl + Shift + Space bar

16. TO ERASE DATA – 1. Select data range 2. Press delete key TO GET BACK DELETED DATA – Click on Undo button or press Ctrl + Z

17. PRESS CTRL + ; TO GET DATE PRESS CTRL + SHIFT + ; TO GET TIME PRESS F2 KEY TO EDIT/CHANGE CONTENTS OF CELL REQ. STEPS TO APPLY READY MADE STYLE TO A DATA RANGE SELECT DATA RANGE CLICK ON Home + Style + Format As Table Select desired style Click on OK

18. View + Zoom – To increase or decrease magnification. View + 100% - to see actual size of the contents View + Heading – to show or hide row and column heading

19. REQ. STEPS TO COPY DATA 1 ST METHOD Select data range Click on Home + Copy or press Ctrl + C Click on target Click on Home + Paste or press Ctrl + V 2 ND METHOD Select data range Press right mouse button Click on copy Right click on target Click on paste 3 RD METHOD Select data range Move mouse pointer to the border of selection Hold Ctrl key down and drag selection to new location

20. REQ. STEPS TO MOVE DATA 1 ST METHOD Select data range Click on Home + Cut or press Ctrl + X Click on target Click on Home + Paste or press Ctrl + V 2 ND METHOD Select data range Press right mouse button Click on Cut Right click on target Click on paste 3 RD METHOD Select data range Move mouse pointer to the border of selection Drag selection to new location

21. MICROSOFT EXCEL REQ. STEPS TO ADD NEW ROW- Click in desired row Click on Home + Insert + Insert sheet row (Alt + I + R) REQ. STEPS TO DELETE ROW- Click in the row to be deleted Click on Home + Delete + Delete sheet row or press (Alt + H + D + R) REQ. STEPS TO INSERT NEW COLUMN- Click in the column before a new column is to be added 2. Click on Home + Insert + Insert sheet column command (ALT + I + C)

22. REQ. STEPS TO DELETE A COLUMN- 1. Click in the column to be deleted 2. Click on Home + Delete + delete sheet column or press (ALT + H + D + C) REQ. STEPS TO INSERT NEW WORKSHEET- Click on the sheet tab before new sheet is to be added Click on Home + Insert + Insert sheet or press Shift + F11 keys

23. REQ. STEPS TO DELETE SHEET- 1. Click on the sheet to be deleted 2. Click on Home + Delete + Delete sheet or press Alt + H + D + S Ms -Excel deletes worksheet permanently We can insert column/row/sheet using right click also We can delete column/row/ sheet using right click

24. TO RENAME A WORKSHEET- Double click on the name of worksheet Type new name Press enter key 2 ND METHOD Click on the name of sheet Click on Home + Format + Rename sheet Type new name Press enter key n Name of sheet must be unique

25. REQ. STEPS TO HIDE COLUMN Select desired column Click on Home + Format + Hide / Unhide Click on Hide column command REQ. STEPS TO SHOW HIDDEN COLUMN Select two columns between a column is hidden Click on Home + Format + Hide / Unhide Click on unhide column

26. IF FIRST COLUMN IS HIDDEN Press Ctrl + Shift + Space bar Click on Home + Format + Hide / Unhide Click on unhide column REQ. STEPS TO HIDE A ROW Select desired row Click on Home + Format + Hide / Unhide Click on hide row

27. REQ. STEPS TO SHOW HIDDEN ROW Select two rows between a row is hidden Click on Home + Format + Hide / Unhide Click on unhide row IF FIRST ROW IS HIDDEN Press Ctrl + Shift + Space bar Click on Home + Format + Hide / unhide Click on Unhide row

28. REQ. STEPS TO HIDE A WORKSHEET Click on Desired sheet Click on Home + Format + Hide/Unhide Click on Hide sheet REQ. STEPS TO SHOW HIDDEN SHEET Click on Home + Format + Hide / Unhide Click on Unhide sheet option Click on the name of sheet Click on ok