MS Excel.

                MICROSOFT EXCEL.

Microsoft Excel for windows is a powerful spreadsheet application that can be used for managing, analyzing and presenting data in a graphical manner.

Excel has three components that perform three different tasks: -

1. The spreadsheet component.
2. The database component.
3. The chart component.

1.The Spreadsheet component: - it displays and analyses text and numbers in rows and columns.

2.The Database component: - It manipulates lists of information.

3.The Chart component: - It produces charts, which help to present the data in a graphical manner.

EXCEL Feature: -

According to Microsoft, excel is the most powerful and comprehensive spreadsheet application available in the market. It is not just a tool for calculating, manipulation and analyzing data, but also a versatile organizational tool and an excellent one for presenting information.

Spreadsheet: -

A Spreadsheet is a grid of rows and columns also called as a worksheet. Earlier a spreadsheet was created manually with pencil and paper.

What is on the screen: -

Formula Bar

It is below the formatting toolbar and made up of 3 parts; the reference area at the left end shows the address of the active cell. The middle and the right areas are used to display or the edit data present in the cells.

Status Bar

It appears at the bottom of the window. The left part displays various messages prompts. For example the status message “Ready” indicates that Excel is in the edit mode. These are various other status messages the user can observe which Excel displays from time to time. The right part displays keyboard status indicators. For e.g. CAPS, NUMS etc.

Sheet Tabs

The tabs at the bottom of the document window. These are used to select different worksheets within the current workbook.

The workbook

A workbook is an Excel file where the user stores his data. Each workbook consists of several worksheets i.e. a workbook can be thought of as a file folder, and a worksheet as every page in the file folder. Hence, a workbook is said to be a set of worksheets grouped together.

The advantages of organizing several worksheets into one workbook are: -

1. Sheets that belong to a particular application can be stored in the same workbook i.e. the data does not have to be stored separately.
2. As soon as a workbook is opened, all its worksheets become automatically available.

When Excel is started, the first thing typically seen is a workbook named “Book1”. Book1 is a new unsaved workbook, which Excel displays by default.

The worksheet

Excel organizes data in a single worksheet by location the worksheet is displayed as a grid of 65,536 rows and 256 columns. Across the top of the worksheet are column headers are labeled as A, B, C, and so on till Z. After Z, the columns are labeled as

AA, AB, AC and so on.

The intersection of a row and a column is called as a cell. There are approximately over 4 million cells in a single worksheet and each can hold or up to 1024 characters in a formula. Light gray lines known as gridlines surround each cell.

Each cell is identified by a cell address, which is made up of a row and a column number. The address of the first cell in a worksheet is A (1) and that of the last cell is IV (256). The cell address of fourths row and second column is B4.

The Active cell is the cell in which one starts typing data. Only one cell can be active at a time and is shown by a heavy border.

File: -

Set Print Area: - It is used to define the selected range as the print area, which is the only portion of the worksheet that will be printed.

Clear Print Area:- It is used to delete the print area.

Edit: -

Fill Series: - It is used to fill the selected range of cells with one or more series of numbers. The contents of the first cell or cells in each row or column of the selection are used as the starting values for the series.

Delete Sheet: - It is used to delete the selected sheets from the workbook. You cannot undo this command.

Move or Copy Sheet: - It is used to Moves or copies the selected sheets to another workbook or to a different location within the same workbook.

VIEW

CUSTOM Views: - It is used to Creates different views of a worksheet. A view provides an easy way to see your data with different display options.

INSERT

Cell: - It is used to Inserts cells starting at the intersection point. You can choose to shift other cells in the table to the right or down. You can also insert an entire row or column.

Rows: - It is used to insert the extra row whenever you want.

Columns: - It is used to insert the extra column whenever you want.

Worksheet: - Insert a new worksheet to the left of the selected sheet.

Chart: - It is used to Starts the Chart Wizard, which guides you through the steps for creating an embedded chart on a worksheet or modifying an existing chart.

Function: - It is used to display a list of functions and their formats and allows you to set values for arguments.

Name

Define: - It is used to create a name of the cell, range, or constant or computed value that you can to refer to the cell, range, or value.

FORMAT

Cell: - It is used to Cells Applies formats to the selected cells. This command might not be available is the sheet is protected.

ROWS: - It is used to change the height of the selected rows. You need to select only one cell in a row to change the height for the entire row. In Microsoft Excel, this command is not available if the worksheet is protected.

COLUMNS: - It is used to change the width of the selected column.

Sheet: - It is used to rename the active sheet.

Auto Format: - It is used to apply a built-in combination of formats, called an auto format. This command is not available is the sheet is protected.

Conditional formatting: - It is used to apply  formats to selected cells that meet specific criteria based on values or formulae you specify.

Style: - It is used to define or apply to the selection of a collection of formats, called a style.

Tools

Protected Sheet: - Prevents changes to cells on worksheets.

Goal seek: - Adjusts the value in a specified cell until a formula that is dependent on that cell reaches a target value.

Scenarios: - Creates and saves scenarios, which are sets of data you can use to view the results of what-if analysis.

FORMULA AUDITING: -

Trace precedents: - Draws tracer arrows from the cells that supply values directly to the formula in the active cell. To trace cells that supply values indirectly to the formula in the active cell, click the trace precedents button again.

Trace dependents: - Draws a tracer arrow to the active cell from the formulae that depend on the value in the active cell. To add additional levels of indirect dependents, click the dependents button again.

Trace Error: -If the active cell contains the error value such as #VALUE or #DIV/0, draws tracer arrows to the active cell from the cells that cause the error value.

Remove all arrows: - Removes all the tracer arrows from the worksheet.

FILTER

A. Auto filter: -

The quickest way to select only those item you wants to display in a list.

B. Advanced Filter: -

Filters data in a list so that only the rows that meet a condition you specify by using a criteria range are displayed.

Form

Displays a data form in a dialog box. You can use the data form to see, change, add, delete, and find records in a list or database.

Sub Totals

Calculates subtotal and grand total values for the labeled columns you select. Microsoft Excel automatically inserts and labels the total rows and outlines the list.

Validation

Defines what data is valid for individual cells or cell ranges; restricts the data entry to a particular type, such as whole numbers, decimal numbers, or text; and sets limits on the valid entries.

Table

Creates a data table based on input values and formulas you define. Data tables can be used to show the results of changing values in your formulas.

Convert Text to Table

Converts the selected text to table.

Consolidate

Summarizes the data from one or more source areas and displays it in a table.

Group and outline

Defines the selected rows and columns of detail data as a group in am outline, so you can summarize the data. If you have not created an outline, this command creates one for you.

Pivot Table

In a pivot table, this command groups items in a field to create a single item from multiple items; for example, you can group days, weeks, months, or other dates into quarters.

Import data

Import data from a selected data source.