  |
| |
|
|
|
|
| |
 |
|
Excel tips for the
person just starting with Excel: basic subtotaling, sorting, pasting as
values. |
|
| |
|
|
|
|
| |
 |
|
Vlookups, Hlookups,
SumIf, Defined Names, and other convenient formulas. |
|
| |
|
|
|
|
| |
 |
|
Customized menu, cell validation, if/then formulas, concatenate,
conditional formatting, audit menu, copying visible cells only, etc. |
|
| |
|
|
|
|
| |
 |
|
Creating macro menus, advanced formulas, drop down menus,
spin buttons, purposeful circular references, hyperlinks, etc. |
|
| |
|
|
|
|
| |
 |
|
Various Excel formulas. |
|