 |
Importing
& Exporting Data |
 |
| |
|
|
multiple worksheets |
|
linking worksheets in msexcel |
|
copying data from msword |
|
copying data from msaccess |
|
linking data between programs |
|
embedding a msword document |
|
importing delimited data |
|
exporting an msaccess table |
 |
|
 |
|
Other
Features |
|
|
|
|
|
formatting recap |
|
format painter |
|
create & use styles |
|
conditional formatting |
|
apply multiple conditions |
|
repeat headings page to page |
|
create & use templates |
|
pivot tables |
|
freezing & hiding panes |
| |
|
Managing
Data |
|
|
|
|
|
data forms |
|
adding new records / fields |
|
performing searches |
|
wildcards |
|
sorting / filtering lists |
|
removing filters |
|
subtotalling |
|
pivot tables |
| |
|
Formulas
Recap |
|
|
|
|
|
BODMAS |
|
absolute vs relative |
|
formula fills |
| |
|
|
|
Printing |
|
| |
|
|
|
setting default printer |
|
setting/clearing print area |
|
print a selection |
|
print preview |
|
landscape / portrait |
|
printing gridlines |
|
printing row & column headings |
|
printing formulas |
|
scaling to fit page |
|
|
|
|
Commonly
used Advanced Functions |
|
|
|
|
|
PMT |
|
IF |
|
AND |
|
OR |
|
VLOOKUP |
|
COUNT |
|
COUNTA / COUNTIF |
|
NOW |
|
NPER |
| |
|
Data
Protection & Security |
|
|
|
|
|
data validation |
|
validation breach alerts |
|
remove data restriction & msgs |
|
copy restrictions from cell to cell |
|
lock/unlock a cells |
|
protecting data |
|
protecting a worksheet |
|
protecting a workbook |
| |
|
Macros |
|
|
|
|
|
what is a macro? |
|
record a new macro |
|
assign macro to toolbar |
|
apply macro to shortcut key |
|
edit macros |
|
edit macro button icons |
|
reset the msexcel toolbar |
|
delete macros |
| |
|
Word
PowerPoint
Excel
Access
Outlook
