MS Excel Tutorial PDF

## Introduction of MS Excel - This application is very helpful in Excel Calculations. - This Application provides us facility of calculations of thousands of data. - When we open the file, there are 3 worksheets by default. - We can rename these by opening them as we need. ### **Workbook** -...

## Introduction of MS Excel - This application is very helpful in Excel Calculations. - This Application provides us facility of calculations of thousands of data. - When we open the file, there are 3 worksheets by default. - We can rename these by opening them as we need. ### **Workbook** - This is a collection of worksheets and by default, there are 3 worksheets displayed. - A workbook can contain 225 worksheets maximum. ### **Worksheet** - This is a collection of rows and columns. It is created for the task of calculation of financial projects, for example, to play different financial projects. ### **Row** - This is a collection of cells and it is formed vertically. - It covers the complete width of the workbook. - A workbook contains 65536 rows maximum. ### **Column** - It is an arrangement of cells and it is formed horizontally. - It covers the complete height of the workbook. ### **Cell** - This is the intersection of a row and column. - We must activate the cell before filling it with any data. - We can activate a cell by clicking it with a mouse. ### **Function** - This is a predefined term, which is used for calculation of complicated data in a straightforward way. ### **Formula** - Every Formula starts with an equal sign (=) in Excel. - We can use formula to perform calculations on a data set of a thousand. ### **Application Window of MS Excel** | **Parts** | **Description** | |---|---| | Title Bar | Microsoft Excel | | Menu Bar | Home View | | Minimize | Minimize | | Maximize | Maximize | | Close | Close | | | | | Format Bar | | | Ruler Bar | 1-2-3-4 | | Scroll Bar | | | | | | Working Area | | | Task Bar | 9:40 | ### **Title Bar** - This displays the name of the newly opened program in MS Excel. ### **Menu Bar** - This is located just below the title bar and contains menus like Home, View, etc.. ### **Format Bar** - This contains command icons. ### **Ruler Bar** - This shows numbers 1-2-3-4 as scales. - This shows the number scale used for the area where we are working. ### **Working Area** - This is the area where we work. ### **File Menu** | **Option** | **Description** | |---|---| | New (Ctrl+N) | This option is used to create a new page. | | Open (Ctrl+O) | This option is used to open existing save files in MS Excel. | | Save (Ctrl+S) | This option is used to save the current slide made of text in MS Excel. | | Save As | This option is used to save the existing file with a different name after making some changes. | | Print (Ctrl+P) | This option is used to print the matter created in MS Excel. | | Print Preview | This option is used to preview the matter created in MS Excel on the monitor screen to evaluate the way it will be printed. | | Page Setup | This option is used in MS Excel to set up a new page according to your needs, for example, page size, orientation, etc. | | Send In Email | This option is used to send the matter created in MS Excel over the internet to any other location. | | Close | This option is used to close the file currently opened in M.S Excel. | | Exit | This option is used to close the program currently open in MS Excel. | ### **Home Tab** | **Option** | **Description** | |---|---| | Cut(Ctrl+X) | This option is used to copy the matter created in MS Excel to the clipboard by deleting it. | | Copy (Ctrl+C) | This option is used to copy the matter created in MS Excel to the clipboard without deleting it. | | Paste (Ctrl+V) | This option is used to paste the text from the Clipboard to the cursor location in MS Excel. | | Paste Special | This option is used in M.S Excel to paste the Cut or copied text as a special type of text. | | Paste Hyperlink | This option is used to set the cut or copied text as a Hyperlink in MS Excel. | | Bold (Ctrl+B)| This option is used in MS Excel to bold the selected text. | | Italic (Ctrl+I) |This option is used in MS Excel to italicize the selected text. | | Strikethrough | This option is used in MS Excel to strikethrough the selected text. | | Subscript | This option is used in MS Excel to make the selected text small at the bottom of the line | | Superscript | This option is used in MS Excel to make the selected text small at the top of the line | | Increase Font | This option is used in MS Excel to increase the font size of the selected text. | | Decrease Font | This option is used in MS Excel to decrease the font size of the selected text. | | Bottom Border | This option is used in M.S Excel to draw the line at the bottom of the selected text. | | Fill Colour | This option is used in M.S Excel to fill the selected text object with the chosen color | | Font Colour | This option is used in M.S Excel to change the font color of the selected text. |