 |
Excel
Features |
 |
| |
|
|
vertical / horizontal text aligning |
|
images - |
|
insert
images |
|
resize images |
|
move images |
|
editing text wrap in images |
|
inserting wordart |
|
conditional formatting |
|
locking cells |
|
protecting worksheets |
|
format painter |
 |
|
 |
|
Row
& Column Management |
|
| |
|
|
|
increase/decrease row heights |
|
increase/decrease column widths |
|
|
|
|
Charts |
|
|
|
|
|
charts recap |
|
types of charts |
|
chart source data |
|
chart titles & legend |
|
chart axis & gridlines |
|
chart data labels & tables |
|
chart location |
|
chart resize/ move/ delete/ print |
|
selecting non-contiguous ranges |
|
add / remove data in a chart |
|
format data markers & parts |
| |
|
|
|
Printing |
|
| |
|
|
|
setting/clearing print area |
|
printing formulas |
|
scaling to fit page |
|
|
|
|
MSExcel
Help |
|
|
|
|
|
maximising your search ability |
|
online help |
|
indexed help |
|
tutorial help |
|
office assistant |
| |
|
Formulas
Guidelines |
|
| |
|
|
|
absolute cell reference |
|
relative cell reference |
|
intermediate level functions |
|
|
|
|
Filtering |
|
|
|
|
|
customise filter |
|
conditional filter / sort |
| |
|
Using
Fill for Data Entry |
|
|
|
|
|
edit fill/series |
|
auto fill |
|
formula filling |
| |
|
Word
PowerPoint
Excel
Access
Outlook
