LEARN MICROSOFT EXCEL STEP BY STEP( BASIC FUNCTIONS)

 INTRODUCTION :-

• AS A MBA STUDENT TECHNICAL SKILLS PLAYS CRUCIAL ROLE IN THE JOB OR BUSINESS .
• EXCEL IS BASIC AS WELL AS DYANAMIC TOOLS FOR THE COLLECTING ,ORAGINISING ,REPORTING .
• MIROSOFT EXCEL IS POWERFUL SPREADSHEET SOFTWARE.
• USES FOR THE DATA ANALYSIS AND DATA ANALYTICS ALSO WE CAN USE FOR IMPORT AND EXPORT OF THE DATA .

EXCEL SPREADSHHET HELPFUL IN MAKEING CHARTS AND THE GRAPH FROM THE SPREDSHEET .

• 
  
• USE OF HOME TAB IN THE DETAILS :-
• AS WE KNOW , EXCEL MOST BASIC FUNCTION IS HOME TAB  . IF YOU UNDERSTAND HOME TAB THEN YOU UNDERSTAND 50 % OF EXCEL BECAUSE IT IS BASE OF EXCEL SPREADSHEET .
• 
  
• IN HOME TAB THEIR ARE MAINLY  8 SUB REGIONS AS FOLLOWS .

1. CLIPBOARD
2. FOND
3. ALLIGHNMENT 
4. NUMBER 
5. STYLE
6. CELLS
7. EDITOING 
8. ADD ONCE

    25 QUESTIONS MUST DO  :-

1. as a mba student you must learn the basic layout of excel spreadsheet like rows , column ?
2. how to save exel file ?
3. how to open new spredshhet ?
4. how to delete spredsheet?
5. how to share with others?
6. how to copy & paste the data ?
7. adjustment of rows and columns ?
8. how to select entire data ? 
9. how to change fonds ?
10. borders ?
11. conditional formatting ?
12. cell styles ?
13. table format ?
14. adding and deleteing the row or column?
15. autosum function ?
16. hide and unhide ?
17. allighnment ?
18. sorting features ?
19. replacing the data ?
20. rename the sheet ?
21. adjusting column and the row ?
22. adjusting monetory terms ?
23. icon sets ?
24. fonds ?
25. inserting 

QUESTION 1)  HOW TO SAVE EXCEL FILE ?

FOLLOW THE STEPS 

1) GO TO FILE 

2) CLICK THE SAVE AS 

3) SELECT THE LOCATION 

4) THEN CLICK SAVE 

QUESTION 2) HOW TO OPEN NEW SPREADSHEET ?

FOLLOW THSE STEPS

1)GO TO FILE 

2) SELECT THE NEW 

QUESTION 3) HOW TO DELETE SPREADSHEET ?

FOLLOW THESE STEPS 

1)GO TO HOME TAB IN RIBBON 

2)CLICK ON CELLS TAB 

3)CLICK ON DELETE

4) SELECT ANY FROM 4 OPTIONS 

a) DELETE CELLS

b) DELETE ROW 

c) DELETE COLUMN

d) DELETE SHEET

QUESTION 4) HOW TO COPY PASTE THE DATA ?

FOLLOW THESE STEPS :

1) CLICK AND DRAG TO HIGHLIGHT THE CELLS 

2) YOU CAN SELECT ENTIRE ROW OR COLUMN 

3) USING KEYBOARD PRESS CTRL +C OR YOU CAN USE MOUSE 

4) CHOOSE THE DESTINATION 

5)PRESS CTRL +V AND CLICK THE ENTER .

QUESTION 5) HOW TO SELECT ENTIRE DATA ?

FOLLOW THE FOLLOWING STEPS ?

1) CTRL +A

2) ENTER 

QUESTION 6) HOW TO CREATE BORDER ?

FOLLOW THE FOLLOWING DATA 

1) GO TO HOME 

2) CLICK TO FOND

3) BORDER 

QUESTION 7) FORMAT OF THE TABLE ?

FOLLOW THE FOLLOWING DATA ?

1) GO TO HOME 

2) THEN STYLE

3)SELECT FORMAT AS TABLE 

4) SELECT LIGHT / MEDIUM /DARK STYLE 

QUESTION 8) FONTS  GROUP ? 

FOLLOW THE FOLLOWING DATA 

1) YOU CAN CHANGE FONT STYLE

2) FONT SIZE CHANGE 

3) , BOLD ( MAKES THICKER AND MORE PROMINENT )

(CTRL +B )

4)UNDERLINE (ADD LINES UNDER THE TEXT ) CTRL+U

5) ITALIC CTRL+U

6) CHANGING FONT COLOUR