 | Use named cells, ranges and formulas |
| Calculate using advanced functions such as NOW,
DATE, VLOOKUP, IF, PMT and FV |
| Use advanced and custom number formats |
| Apply outlines |
| Find and replace data |
| Control recalculation |
| Format zero and negative values |
| Use advanced printing options |
| Use comments |
| Utilize worksheet and range protection, hide and
display data, and use password protection |
| Work with multiple workbooks |
| Manipulate the screen display by freezing panes
and splitting windows |
| Import and export data |
| Link workbooks |
| Create and use templates |
| Record, run, and edit macros |
| Create custom lists |
