 |
Navigating
the MSExcel screen |
 |
 |
|
 |
adding toolbars |
|
customising toolbars |
|
viewing layouts |
| |
|
Excel
Features |
|
| |
|
|
|
what is highlighting / selecting |
|
how to select a cell or cell range |
|
bold / italic / underline |
|
font size |
|
font styles |
|
apply/change bullets & numbers |
|
apply/change borders |
|
apply/change shading & textures |
|
undo / redo |
|
formatting numbers |
|
|
|
|
New
Documents |
|
|
|
|
|
saving files |
|
'save' vs 'save as' |
|
finding your saved files |
|
opening existing documents |
| |
|
Row
& Column Management |
|
| |
|
|
|
selecting rows/columns/cells |
|
navigating rows/columns/cells |
|
insert rows/columns/cells |
|
delete rows/columns/cells |
|
insert/edit/delete text |
|
shade rows/columns/cells |
|
merge rows/columns/cells |
|
split rows/columns/cells |
|
increase/decrease row heights |
|
increase/decrease column widths |
|
|
|
|
Charts |
|
| |
|
|
|
types of charts |
|
the chart wizard |
|
step 1: types |
|
step 2: source data |
|
step 3: chart options |
|
step 4: chart location |
|
move a chart |
|
delete a chart |
|
change a charts data |
|
print a chart |
|
|
|
|
|
|
Page
Setup / Page Formatting |
|
|
|
|
|
indenting |
|
page setup dialog window |
|
align page horizontally/vertically |
|
margins |
|
portrait / landscape |
|
page size |
|
customising header / footer |
|
rows to repeat at top of page |
|
altering print area |
|
managing cells |
| |
|
Printing |
|
| |
|
|
|
how to print |
|
selecting your printer |
|
setting default printer |
|
specifying amount of copies |
|
print preview |
|
landscape / portrait |
|
printing gridlines |
|
printing row & column headings |
|
|
|
|
Spelling
& Grammar Checker |
|
|
|
|
|
how to customise the language |
|
customising the alerts |
|
configuring autocorrect |
| |
|
MSExcel
Help |
|
|
|
|
|
maximising your search ability |
|
online help |
|
indexed help |
|
tutorial help |
|
office assistant |
| |
|
Working
with Formulas |
|
| |
|
|
|
addition |
|
subtraction |
|
multiplication |
|
division |
|
autosum |
|
bodmas |
|
average / min / max / sum |
|
|
|
|
Filtering
Data |
|
|
|
|
|
set filtering criteria |
|
reset filter |
|
remove filter |
|
sort data |
| |
|
Word
PowerPoint
Excel
Access
Outlook
