MICROSOFT EXCEL 2007

Spreadsheet:- Spreadsheets allows to you perform detailed analysis on numerical data. Spreadsheets are also known as worksheets, display data in the form of rows and columns. Data entered in entered in the cell which represents the intersection of row and column.
Microsoft developed this program, so it is known as Microsoft Excel. It is a spreadsheet program where we can insert data, process them, sort them, filter them and create chart from the data etc., in this program we can perform various kinds of Mathematical, financial, statistical, engineering calculations. Using this program we can create bill, voucher, salary sheet, income& expenses statement, mark sheet, purchase book, sales book, balance sheet etc.
The file of Ms-Excel is called workbook and its extension is .XLSX (Microsoft Office 2007).
Worksheet: - The large working area of a workbook is called worksheet. There are 1,048,576 rows and 16,384 columns in a worksheet.
Workbook: - Workbooks are containers that hold one or more worksheets. Keeping all sheets that are related to a project in one file reduces the need to maintain different files.
Rows: - The rows in a worksheet are numbered from top to bottom along the left column of the worksheet.
Column: - The columns are labeled from left to right with letters.
Cell: - The intersection between row and column is called Cell.
Cell Reference: - It is the address of a cell denoted to using the column label followed by the row number. In a spreadsheet terminology a cell‘s column co-ordinate is called the cell reference e.g. A2.
Cell Range: - It is an area or collection of number of defines cells into a worksheet e.g. A1:E15.
Active Cell: - When you select a cell by clicking it with the mouse, or moving to it using the keyboard, it becomes the active cell. The name Box, on the left of the formula bar displays the reference of the active cell.

To Start Microsoft Excel 2007
1. Click on Office Button
2. Click on Programs.
3. Click on Microsoft Office
4. Click on Ms Excel.
OR
1. Click on Start
2. Click on Run
3. Then a dialog box will appears
4. Type Excel
5. Click on OK.

To Create New a Workbook.(Ctrl+N)
1. Click on Office Button
2. Click on New
3. Click on Blank & Recent
4. Click on Blank
5. Click on Create Button.

To Save Workbook.(Ctrl+S)
1. Click on Office Button
2. Click on Save command
3. In the Save in list, select the drive and folder where you want to save the workbook.
4. [If you want to save the workbook in a new folder, click on Create New folder]
5. In the File name box, type a name for the workbook.
6. Click on Save

To Close Workbook.
1. Click on Office Button
2. Click on Close command.

To Open Workbook
1. Click on Office Button
2. Click on Open command.
3. In the Look in list, click the drive, folder or location that contains the workbook you want to open and then locate a double-click the folder that contains the workbook.
4. Select the required workbook name.
5. Click on Open.
OR
1. Double click the workbook you want to open.

To Protect by Using Password
1. First open the workbook.
2. Click on Office Button
3. Click on Save as command.
4. Then a dialog box will appear.
5. Click on Tools of dialog box and click on General option.
6. Type the password in Password to open box.
7. Click on ok bottom.
8. Then a confirm password box will appear.
9. Type the same password Modify again.
10. Click on ok button.
11. Click on save button.

Home Tab
To Select Entire Row
1. Move the mouse pointer over the row number which you want to select.
2. Press the mouse button once.

To Select Entire Column.
1. Move the mouse pointer over the column label which you want to select.
2. Press the mouse button once.

To Select Entire Worksheet.
1. Move the mouse pointer over the top left corner of worksheet.
2. Press the mouse button once.

Using Cut/ Copy/Paste.
1. Select the required cells which you want to copy or move.
2. Click on Home..
3. Click on icon of Copy or Cut command as required
4. Then place the active cell at the required cell
5. Click on Home. .
6. Click on icon of Paste Command
[You can also use the shortcuts to copy, cut and paste as in Ms Word such as Ctrl+C, Ctrl+X, Ctrl+V]

To Fill Series of Numbers and Data.
To Fill Numbers.
1. Put the active cell at the required cell.
2. Type First and Second number in First and Second cell.
3. Then select the both cell.
4. Move the mouse pointer over the button right corner of second cell.
5. Drag the fill handle as required.

To Fill Date
1. Put the active cell at the required cell.
2. Type Sunday or January in First cell.
3. Then move the mouse pointer over the button right corner of first cell.
4. Drag the fill handle.

To Insert Cells
1. Select the required cells where you want to insert new blank cells.
2. Click on Home
3. Click on Insert of Cells Group
4. Then a dialog box will appear.
5. Choose any one option. (Shift cells right, shift cells down & insert entire Rows, Columns).
6. Click on Ok

To Insert Rows
1. Select the required rows where you want to insert new rows.
2. Click on Home
3. Click on Insert of Cells Group.
4. Click on Insert Rows command

To Insert Columns
1. Select the required rows where you want to insert new rows.
2. Click on Home
3. Click on Insert of Cells Group.
4. Click on Insert Columns command.

To Insert Worksheet.
1. Select the sheet name where you want to insert new worksheet.
2. Select the required rows where you want to insert new rows.
3. Click on Home Tab
4. Click on Insert of Cells Group.
5. Click on Insert Worksheet command.
6. [Now a new worksheet will appear in the sheet tabs]

Using Clear Command
1. Select the required cells which you want to clear.
2. Click on Home Tab
3. Click on Clear Icon (command) of Editing Group.
4. Then click on All option to clear everything with formatting, contents etc,
5. Click on formats option to clear only the formats.
6. Click on Contents option to clear only the contents.
7. Click on Comments option to clear the comments only.

To Delete Cells, Rows, Columns
1. Select the required cells or rows or columns which you want to delete.
2. Click on Home Tab
3. Click on Delete Icon (command) of Cell Group.
4. If you have selected cells then a dialog box appears.
5. Choose any option. [Shift cells left, shift cells up etc.]
6. Click on Ok.

To Delete Worksheet.
1. Select the required sheet name which you want to delete.
2. Click on Delete Icon (command) of Cell Group.
3. Click on Delete sheet command.
4. Then a message box will appear.
5. Click on Ok.

To Move or Copy Sheets.
1. Select the required sheet name.
2. Right Click on Sheet
3. Click on Move or Copy sheet command.
4. Then a dialog box will appear
5. Choose any option from before sheet list.
[If you want to create a copy of the selected sheet click create a copy option]
6. Click on OK.

Using Find and Replace Command
Find:
1. Click on Home Tab
2. Click on Find & Replace of Editing Group
3. Then a dialog box will appear.
4. Type a required text or data in find what box.
5. Click on Find next button.

Replace:
1. Click on Home Tab
2. Click on Find & Replace of Editing Group
3. Then a dialog box will appear.
4. Type the required text or data in find what box which you want to replace.
5. Type the replacing text or data in Replace with box.
6. Then click on Find next.
7. Click on Replace or Replace all button as required.

Using Go To Command
1. Click on Home Tab
2. Click on Find & Replace of Editing
3. Click on Go To command.
4. Then a dialog box will appear.
5. Type the cell name in reference box.
6. Click on OK.

To Format Numbers.
1. Select the required cells.
2. Click on Arrow of Font Group of Home Tab.
3. Then a dialog box will appear.
4. Click on Number tab.
5. Choose Number category.
6. Choose the required decimal places.
7. If needed choose the Use thousand separators option. Click on Ok.

To Change the Number in Currency Format.
1. Select the required cells.
2. Click on Arrow of Font Group of Home Tab.
3. Then a dialog box will appear.
4. Click on Number tab.
5. Choose Currency tab.
6. Choose the required decimal places.
7. Choose any currency symbol.
8. Click on OK.

To Change the Number in Percentage Format.
1. Select the required cells.
2. Select the required cells.
3. Click on Arrow of Font Group of Home Tab.
4. Then a dialog box will appear.
5. Click on Number tab.
6. Click on Percentage tab.
7. Choose the required decimal places.
8. Click on OK.

To Merge and Center Data
1. First type the long text in a single cell.
2. Select the required cell range.
3. Select the required cells.
4. Click on Arrow of Font Group of Home Tab.
5. Then a dialog box will appear.
6. Click on Alignment tab.
7. Choose center from Horizontal and Vertical alignment.
8. Click the three option of text control criteria. (Wrap text, shrink to fit, merge cells)
9. Click on Ok.
10. [Put the Cursor at the required text and op pressing spacebar unit the text comes to the next line.]

To Change the Data Orientation.
1. Select the required cells.
2. Click on Arrow of Font Group of Home Tab..
3. Then click on Alignment tab.
4. Choose the required degrees.
5. Click on Ok.

To Format Font.
1. Select the required cells.
2. Click on Arrow of Font Group of Home Tab..
3. Then click on Font command.
4. Choose the required font, font style size, font color, underline style, effects.
5. Click on Ok.

Using Conditional formatting command
1. Select the required cells.
2. Click on Home Tab
3. Click on Conditional formatting command of Style Group.
4. Then a List will appear.
5. Choose any condition.
6. Cell value is less than, greater than, equals to etc.)
7. Type the value.
8. Choose any Formatting.
9. Click on Ok.
10. If you want to add other conditions also click on add button and set the other condition.
11. Click on Ok.

To Apply Borders & Patterns.
1. Select the required cells.
2. Click on Arrow of Font Group of Home Tab..
3. Then click on Borders tab.
4. Choose any boarder style and Color.
5. Click on Outline and inside option.
6. Then click on Patterns tab.
7. Choose any color.
8. Click on OK

To Format Row
1. Select the required row or column
2. Click on Format of Cell Group of Home Tab
3. Then choose the required options, (Height, Auto fit, hide, unhide)

To Rename Sheet.
1. Select the required sheet name which you want to rename.
2. Click on Format of Cell Group of Home Tab
3. Click on rename command.
4. Type the name for sheet.
5. Press Enter key.

To Hide/Unhide Sheet.
1. Select the required sheet name.
2. Click on Format of Cell Group of Home Tab.
3. Click on Hide/Unhide.
4. Choose the required option

Using Page Setup Command.
This command is used to set margins, paper source, paper size, page orientation, and other layout options for the active file.
1. First open the workbook of which you want to set page.
2. Click on Page Layout Tab
3. Click on Page Setup command.
4. Then a dialog box will appear.
5. Click on page tab.
6. Choose the required orientation. (Portrait or landscape)
7. Choose any paper size.
8. Click on margin tab.
9. Set the required margin for Top, Bottom, and Left, Right, Header& footer.
10. Choose other required options.
11. Click on OK button.

To See the Print Preview of Worksheet.
1. Click on Office Button
2. Click on Print Command
3. Click on Print Preview command.
4. Now you can see the preview of your worksheet.
5. Click on close button to close the preview.

To Set Print Area.
1. Select the required part of sheet which you want to set as print area.
2. Click on Page Setup Section of Page Layout Group.
3. Click on Print area command.
4. Choose Set print area.
5. [To clear print area click on Click on Page Setup Section of Page Layout Group.
Choose print area and click on clear print area.]

To Print a Worksheet.
1. Open the worksheet which you want to print.
2. Click on Office Button
3. Click on Print command
4. Then a dialog box will appear.
5. Choose the print name from Name box.
6. Choose any option from Print range criteria. [All, Page].
7. Choose any option from Print what criteria. [Selection, entire workbook etc.]
8. Choose the required number of copies to print.
9. Click on other required options and Click on OK button.

To Show or Hide Formula Bar.
1. Click on View Tab
2. Click on Formula bar Command to show or hide of Show & Hide Group

To Add Header and Footer.
1. Click on Insert Tab
2. Click on Header & Footer command of Text Group
3. Type the header Name.
4. Click on Ok.
5. Then click on Custom Footer button.
6. Type the footer Name in the required section.
7. [You can also insert page number, date, time, filename etc as header & footer]
8. Click on OK.

To View the Worksheet in Full Screen
1. Click on View Tab
2. Click on Full screen command of Workbook Views.
3. Now your worksheet will appear in full screen.
4. To close full screen, click on Close full screen tool.

To Change the View of Worksheet.
1. Click on View Tab
2. Click on Zoom command of Zoom
3. Choose any one option. (200%, 100%, 50%, 75% ect.)
4. Click

To Insert Chart
1. First type the data for chart.
2. Select the data range.
3. Click on Insert Tab
4. Click on Arrow of Chart Group
5. Choose Chart Type & Click
6. Click on Chart..
7. Then Layout, Design & Format of Chart will display.
8. Choose the required option from series in [Rows or Columns]
9. Type the chart title in Chart title box From Labels Group.
10. Click on Axes and choose the required options.
11. Click on Gridlines tab and choose the required options.
12. Click on Legend and choose any option.
13. Click on Data labels and Data table tab and choose the required options.
14. [If you want to change the chart type, chart options, chart location etc then select the chart, click on Chart menu and choose the required options.]

Using Formula
1. Put the active cell at the required cell where you want to use formula.
2. Type (=) equal sign, [Formula always begins with (=) sign]
3. Enter the formula with cell references and operators
4. Press Enter Key

Functions Operators:-
+ Addition
- Subtraction
* Multiplication.
/ Division
% Percentage.
= Equal comparison.
<> Greater than.
<= Less than or equal to >= Greater than or equal to
<> Is not equal to
And/ Or/ Not/If [Logical Operator]

Using Function Wizard
1. Place the cursor in cell where you want to insert Function.
2. Click on Home Tab
3. Click on Function Icon (∑) of Editing Group.
4. Then a list of function will appear.
5. Select the required Function category.
6. Choose any Function name. (Sum, average, min, max etc.) Or More function Command
7. Click
8. Then a dialog box will appear.
9. Type the cell references in Number box & Click on Ok button.

To Insert Comment.
1. Select the required cells where you want to insert comment.
2. Click on Insert Tab
3. Click on New Comment command (icon) of Comments Group.
4. Then a comment box appears.
5. Type the required comments.

To show or Hide comments.
1. Select the required cells that contains comment.
2. Press opposite mouse button.
3. Choose show comment/Hide comment.

To Edit or Delete comment.
1. Select the required cells that contain comments.
2. Press opposite mouse button.
3. Choose Edit comments or Delete comments. Of Comments Group of Insert Tab.

To insert Clipart.
1. Click on Insert tab
2. Click on Clipart command(ICON) of Illustrations Group
3. Then a Clipart box will appear.
4. Click any category.
5. Choose any picture and press the mouse button.
6. Choose Insert clip
7. Then close the clipart box.

To Insert Auto Shapes.
1. Click on Insert tab
2. Click on Shapes command(ICON) of Illustrations Group
3. Then an auto shapes toolbar will appear.
4. Choose any shape from toolbar.
5. Press the mouse button and drag it to draw auto shapes.

To Insert Word Art.
1. Click on Insert tab
2. Click Word art command(ICON) of Text Group
3. Click on Word art.
4. Then a word art style box will appear.
5. Choose any style.
6. Then a format dialog box will display
7. Format the text size & other thing .

To Insert Object (Paint brush picture)
1. Click on Insert Tab
2. Click on Object command (icon) of Text Group.
3. Then a dialog box will appear.
4. Choose Paint brush picture.
5. Click on Ok.
6. Now draw any picture you like.

To Insert Hyperlink.
1. Select the required cells or object where you want to insert hyperlink.
2. Click on Insert Tab
3. Click on hyperlink command (icon) Link Command.
4. Then a dialog box will appear.
5. Click on File of Browser for option.
6. Choose the required file.
7. Click on Ok.
8. Again click on Ok.

To Change the Background of Sheet.
1. Click on Page Layout
2. Then click on Background.
3. Now a dialog box will appear.
4. Choose any background file.
5. Click on Insert button

To Delete Background.
1. Click on Format menu.
2. Click on Sheet command.
3. Click on Delete background.

To Protect Worksheet.
1. Click the worksheet name which you want to protect.
2. Click on tools menu.
3. Click on protection Command.
4. Click on Protect sheet.
5. Then a dialog box will appear.
6. Choose the required options, (Contents, Objects etc)
7. Type a password.
8. Click on Ok.
9. Again type the same password.
10. Click on Ok.

To Protect Workbook.
1. Click on Review
2. Click on Protect workbook of Changes Group
3. Then a dialog box will appear.
4. Choose the required options(Structure, Window)
5. Type a password.
6. Click n Ok.
7. Again type the same password.
8. Click on Ok.

Using Goal Seek command.
1. On the Data Tab, Data Tools Group, What if analysis & click Goal seek.
2. In the Set cell box, enter the reference for the cell that contains. The formula you want to resolve.
3. In the To value box, type the result you want.
4. In the By changing cell box, enter the reference for the cell that contains the value you want to adjust. This cell must be referenced by the formula in the cell you specified in the Set Cell box.
5. Click on Ok button.

To Show/Hide gridlines, row & columns header, scrollbar, sheet tabs etc.
1. Click on View Tab
2. Click on Show & Hide
3. Then a list will appear.
4. Choose the required options to from windows options.
5. [Gridlines, row & column headers, Horizontal scrollbar, sheet tabs et c.]

To Sort Data.
1. Select the required cells.
2. Click on Data Tab
3. Click on Sort & Filter Group.
4. Choose the required column name for sort by option.
5. Choose Ascending or Descending order. [If you want to sort multiple columns click on Then by option and choose the required column name.
6. Choose Header row or No header row from My list has option.
7. Click on Ok.

To Auto Filter data.
1. Select the required columns.
2. Click on Data Tab
3. Click on Filter command sort & filter Group
4. Now Click on drop down arrow list of column and choose the required options. (All, Top 10, custom etc)

To Remove Auto Filter.
1. Click on Data
2. Click on Filter command sort & filter Group