Excel 2007: downloadable Topic Guides
Below is a list of Topic Guides on Excel 2007. Some of the guides refer to specific exercises. To request these, contact the helpdesk.NB Topic Guides have restricted access and are only available to members of the University.
| Description | Topic Guide in Word format |
|---|---|
| Charting techniques |
download  (682kb) |
| Creating a new workbook |
download (1,109kb) |
| Creating charts |
download (1,178kb) |
| Editing in a workbook |
download (501kb) |
| Filtering data |
download (334kb) |
| Formula techniques |
download (522kb)
|
| Formulae and functions |
download (749kb) |
| Getting to know Excel |
download (1,935kb) |
| Grouping and outlining |
download (337kb) |
| Headers and footers |
download (801kb) |
| Importing and exporting |
download (689kb)
|
| Lookup functions |
download (556kb) |
| Macros - recorded |
download (702kb) |
| Number formatting |
download (473kb) |
| Number formatting techniques |
download (229kb) |
| Pivot Charts |
download (496kb) |
| Pivot table techniques |
download (1,006kb) |
| Selecting ranges |
download (985kb) |
| Sorting data |
download (1,028kb) |
| Worksheet techniques |
download (518kb) |