Excel

Microsoft Excel 2007

Microsoft Excel is one of the most popular spreadsheet applications that helps you manage data, create visually persuasive charts, and thought‐provoking graphs. Excel is supported by both Mac and PC platforms. Microsoft Excel can also be used to balance a checkbook, create an expense report, build formulas, and edit them.
To begin Microsoft Excel: Go to Start > All Programs > Applications > Microsoft Office > Microsoft Excel

TYPES OF CELL

There are two types of cell references:relativeandabsolute. Relative and absolute references behave differently when copied and filled to other cells. Relative referenceschangewhen a formula is copied to another cell. Absolute references, on the other hand, remainconstantno matter where they are copied.
Relative references
By default, all cell references arerelative references. When copied across multiple cells, they change based on the relative position of rows and columns. For example, if you copy the formula=A1+B1from row 1 to row 2, the formula will become=A2+B2.Relative references are especially convenient whenever you need torepeatthe same calculation across multiple rows or columns.


Absolute references
There may be times when you do not want a cell reference to change when filling cells. Unlike relative references, absolute referencesdo not change when copied or filled. You can use an absolute reference to keep a row and/or columnconstant.
An absolute reference is designated in a formula by the addition of adollar sign ($). It can precede the column reference, the row reference, or both.

EXELL FUNCTION

Afunctionis apredefined formulathat performs calculations using specific values in a particular order. All spreadsheet programs include common functions that can be used for quickly finding thesum,average,count,maximum value, andminimum valuefor a range of cells. In order to use functions correctly, you'll need to understand the differentparts of a functionand how to createargumentsto calculate values and cell references.

The parts of a function

In order to work correctly, a function must be written a specific way, which is called thesyntax. The basic syntax for a function is anequals sign (=), thefunction name(SUM, for example), and one or morearguments. Arguments contain the information you want to calculate.






A
In theInsert Functiondialog, specify a function category in theOr select a categorybox, and select a function from theSelect a functionlist.



MOST IMPORTANT EXCEL FUNCTION
Vlookup & Hlookup


1-VLOOKUP

2- HLOOKUP

COUNT , COUNTA, COUNTBLANK,COUNTIF

Statistical Function

MAX , MIN , AVERAG , MEDIAN , MODE , VARIANCE , STDEV, RANK

RANK FUNCTION

DATE & TIME FUNCTION

DAY , MONTH , YEAR
DATE , DATEDIF





























Date Formats
















Text Function : CONCATENATE function















 PAGE \* MERGEFORMAT 23