Charts
|
| Question |
Version |
| How do I create a conventional chart from a pivot table? |
2003 |
| |
|
| |
|
Collaboration
|
| Question |
Version |
| How do I retrieve data housed in an external data source (e.g. MS Access®)? |
2003 |
| |
|
| |
|
Data
|
| Question |
Version |
| How do I create a validation list dependent on the selection from another? |
2003 |
| How do I create dynamic ranges for formulae, charts and pivot tables? |
2003, 2007 |
| |
|
| |
|
Environment
|
| Question |
Version |
| How do I change my default workbook and worksheet? |
2003, 2007 |
| |
|
| |
|
Formatting
|
| Question |
Version |
| How do I set-up a preferred list of formats (styles)? |
2003 |
| |
|
| |
|
Formulae and Functions
|
| Question |
Version |
| How do I write a lookup based on multiple lookup criterion? |
2003, 2007 |
| How do I do a SUMIF with multiple criterion? |
2003, 2007 |
| How do I sum every nth cell in a row or column? |
2003, 2007 |
| |
|
| |
|
Pivot Tables
|
| Question |
Version |
| How do I clear old items from my pivot table? |
2003, 2007 |
| |
|
| |
|
Visual Basics for Applications
|
| Question |
Version |
| How do I automatically delete rows based on criterion? |
2003, 2007 |
| |
|
| |
|