MICROSOT EXCEL BASIC 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