MS-Excel - 2007

1> TO OPEN MS EXCEL:

Start ---> All Programs ---> Microsoft Office ---> Microsoft Office Excel 2007.

or

Start ---> Run ---> Type (Excel) ---> OK

2> TO CHANGE CELL COLOR:

Select the cell ---> Home ---> Fill Color ---> Select a Color.

3> TO ADD BORDER TO CELL:

Select the Cell ---> Home ---> Border ---> Select (All Border).

4> WRAP TEXT:

Adjust the Cell ---> Home ---> Wrap Text.

5> ORIENTATION OF TEXT:

Select the Cell ---> Home ---> Orientation ---> Select a Orientation.

6> MERGE CELL:
Select the Cell ---> Home ---> Merge and Center.

7> ARITHMETIC FUNCTION:

A>SUM:             = Cell+Cell+Cell+Enter.
                            = Sum(Cell,Cell,Cell)+Enter.
                            = Sum(Cell:Cell)+Enter

B>MULTIPLY:     = Cell*Cell+Enter.

C>DIVIDE:          = Cell/Cell+Enter.

D>SUBTRACT:    = Cell-Cell+Enter.

8> TO INSERT NEW ROW OR COLUMN:

Right click on the row or column which previous you want to insert new one ---> Home ---> Insert.

9>TO DELETE ROW OR COLUMN:

Select the row or column which you want to delete---Home---Delete.

10>CREATE A CHART:

Select the database---Insert---Select a chart type---Select a design.

11>TO CHANGE CHART DESIGN:

Select the chart---Design---More---Select a design.

12>ARITHMETIC FUNCTION:

     Maximum number :

     =Max(Cell,Cell ....)Enter

     =Max(Cell:Cell)Enter

   Minimum number :

    =Min(Cell,Cell ....)Enter

    =Min(Cell:Cell)Enter

13>VALIDATION LIST:

Select the cell ---> Data ---> Data validation ---> Settings ---> Allow (List) ---> Type your list (Using Comma) ---> Ok.

14> CUSTOM LIST:

Customize quick access toolbar ---> More ---> Commands ---> Popular ---> Edit custom list ---> Type your list (Using Comma) ---> Add ---> OK ---> OK.

15> FILL SERIES:

Enter a value---Select that cell---Home---Fill---Series(Series in)Row or Column---Select(Liner)---Enter step value---Enter stop value---Ok.

16> FILTER:

Select the database---Home---Sort and filter---Filter.

17> TO INSERT COMMENT TO ANY CELL:

Select the cell ---> Review ---> New comment ---> Type your comment.

18> TRACE PRECEDENT:

Select the cell that contains formula ---> Formulas ---> Trace precedent.

19> TEXT FUNCTION:

concatenote:

    =Concatenote(Cell,Cell) Enter

    =Concatenote(Cell,"Space",Cell,"Space",Cell) Enter.