5. Tutorial of Microsoft Excel:

(1) What is Microsoft Excel and its installation.
(2) How to create & save a file Microsoft Excel.
(3) How to make a password protected Microsoft Excel file.
(4) How to select Cells/ Text.
(5) How to font change.
(6) How to Font size change.
(7) How to Font color change.
(8) How to make a text bold (B), Italic (I), Underline (U).
(9) How to Merge cells.
(10) How to cut, copy & paste cells/ text.
(11) How to align content with Left, Right, Center align, Top, Middle or Bottom align.
(12) How to Draw Cell border.
(13) How to change cells background color.
(14) How to cells background color, font, border change with condition (Conditional Formatting).
(15) How to use Data Validation to input fixed text in cells.
(16) How to hide or unhide rows and columns.
(17) How to apply filter.
(18) How to Page setup.
(19) How to print page.
(20) How to mimic a watermark or place background image.
Formulas and Functions
(1) Use of Sum & AutoSum.
(2) Use of Average function.
(3) How to Divided two value.
(4) How to Multiply two value.
(5) How to use Count formula.
(6) How to use COUNTIFS formula.
(7) How to use MAX formula.
(8) How to use MIN formula.
(9) How to use RANK formula.
(10) How to use IF formula.
(11) How to use SUMIFS formula.
(12) How to use LOOKUP formula.
Graph
(1) How to make a Column Graph.
(2) How to make a Line Graph.
(3) How to make a Line Graph with two or more series.
(4) How to make a Pie Graph.
(5) How to make a Combo Graph with secondary axis.
(2) How to create & save a file in Microsoft Excel.

How to create & save a file in MS Excel:

Step-1: Click Mouse left button in Star icon, click to All Programs.
Step-2: Now click to Microsoft Office & click to Microsoft Excel . Your Microsoft Excel file will open now.

For first time save:


Step-3: Now to save the file click to FILE (Top left) button, then click Save As (for first time save or save to change name or location) and double click to computer or press Ctrl+S from keyboard.

Step-4: Select your location to save the file. Write the name of the file in File name section. Then click to save.

Now your file is save to your selected location with your written name.



After first time save:



Step-5: Click to FILE and then click to Save or press Ctrl+S from keyboard.





See description with screenshot & Video


Description with screenshot:

How to create & save a file in MS Excel:

Step-1: Click Mouse left click in Star button, click to All Programs.





Step-2: Now click to Microsoft Office & click to Microsoft Excel . Your Microsoft Excel file will open now.



Step-3: Now to save the file click to FILE (Top left) button, then click Save As (for first time save or save to change name or location) and double click to computer or press Ctrl+S (after first time save) from keyboard.





Step-4: Select your location to save the file. Write the name of the file in File name section. Then click to save.





Now your file is save to your selected location with your written name.











Video:

How to create & save a file in MS Excel: