Learn ms excel - 2007(practical)

                              
TO OPEN MS EXCEL
    Start---All Programs---Microsoft Office---Microsoft Office Excel 2007.
or: Start---Run---Type(Excel)---Ok.

TO CHANGE CELL COLOR

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


ms excel


TO ADD BORDER TO CELL

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

WRAP TEXT

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

ORIENTATION OF TEXT

    Select the Cell---Home---Orientation---Select an Orientation.

MERGE CELL

    Select the Cell---Home---Merge and Center.

ARITHMETIC FUNCTION


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

   MULTIPLY     = Cell*Cell+Enter.


   DIVIDE          = Cell/Cell+Enter.


   SUBTRACT    = Cell-Cell+Enter.


TO INSERT NEW ROW OR COLUMN

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

TO DELETE ROW OR COLUMN

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

CREATE A CHART

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

TO CHANGE CHART DESIGN

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

ARITHMETIC FUNCTION

     Maximum number 
      =Max(Cell,Cell ....)Enter
      =Max(Cell:Cell)Enter

   Minimum number 

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

VALIDATION LIST

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

CUSTOM LIST

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

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.

FILTER

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

TO INSERT COMMENT TO ANY CELL
      Select the cell---Review---New comment---Type your comment.

TRACE PRECEDENT

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

TEXT FUNCTION

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



No comments for "Learn ms excel - 2007(practical)"