MS Excel Tutorial PDF
Document Details
Uploaded by Deleted User
Tags
Summary
This document provides an introduction to Microsoft Excel, covering topics like worksheets, rows, columns, cells, functions, formulas, and the application window. It also includes the different options and functionalities available within the program.
Full Transcript
## 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. |