EXCEL BASIC COURSE

Course Contents:
v  MICROSOFT OFFICE 2007 & 2003 VERSION FILE RECONISISED
v   MICROSOFT OFFICE 2007 & 2003 FILE AUTO SAVE
v   MICROSOFT OFFICE 2007 & 2003 COLOUMNS & ROW DETAILS
v  SHORTCUT KEY:-
1.    BOLD
2.    ITALY
3.    UNDERLINE
4.    SAVE
5.    SAVE AS
6.    OPEN
7.    CUT
8.    COPY
9.    PASTE
v  CELL COLOUR
v  TEXT COLOUR
v  BORDER (TEXT & CELL)
v  SENTENCE :-
1.    CAPITAL LETTER
2.    SMALL LETTER
3.    FIRST LETTER CAPITAL
v  LETTER SIZE
v  LETTER FORMAT
v  BULLET
v  WRAP TEXT
v  MERGE
v  ALIGNMENT
v  DATE & TIME FORMATE
v  DATA SORT & FILTER
v  DATA SORT BY NUMBER
v  DATA SORT BY A TO Z
v  DATA SORT BY COLOR
v  WORDART
v  INSERT & DELET (COLUMN & ROW)
v  INSERT PICTURE
v  CHART (PIE , CLOUMN , BAR , LINE , AREA)
v  FORMULA:-
1.    SUM
2.    SUBTOTAL
3.    AVERAGE
4.    MINIMUM VALUE
5.    MAXIMUM VALUE
6.    PERCENTAGE CALCULATION
7.    VLOOKUP
8.    NUMBER COUNT
9.    NUMBER & LETTER COUNT
v  PIVOT TABLE :-
1.      SUM
2.      COUNT
3.      AVERAGE
4.      VERTICAL VALUE
5.      HORIZONTAL VALUE