Nov 19, 2012

LEARN MS EXCEL - 2007(PRACTICAL)

                               MS EXCEL- 2007(PRACTICAL)
SPREADSHEET

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.



3 comments:

Post a Comment

Share

Twitter Delicious Facebook Digg Stumbleupon Favorites More