Microsoft Excel 2007 (all but Visual Basic) courseware
Our current courseware in Microsoft Excel 2007 (all but Visual Basic) is as follows (where available you can click on any chapter to download it):
| Chapter title | File size | Page count (1) |
|---|---|---|
| Excel basics | 645 kb | 9 |
| Moving and Selecting in Excel | 522 kb | 8 |
| Entering And Editing Data | 786 kb | 11 |
| Copying and Moving Cells | 534 kb | 8 |
| Formulae and Functions | 555 kb | 8 |
| Formatting Worksheets | 855 kb | 12 |
| Themes and Styles | 697 kb | 10 |
| Number formatting | 390 kb | 6 |
| Dates and Times | 343 kb | 6 |
| Conditional Formatting | 731 kb | 10 |
| Absolute and Relative Referencing | 367 kb | 6 |
| Range Names | 772 kb | 11 |
| Cell Comments | 446 kb | 7 |
| Printing | 1050 kb | 14 |
| Using Multiple Worksheets | 579 kb | 9 |
| Consolidation | 1005 kb | 14 |
| Creating Excel charts | 1001 kb | 14 |
| Tables Basics | 1436 kb | 19 |
| Cell Validation | 633 kb | 9 |
| Protection and Templates | 821 kb | 12 |
| Importing and Linking to Data | 605 kb | 9 |
| Tables | 2216 kb | 29 |
| Structured References | 648 kb | 9 |
| Pivot Tables | 1445 kb | 19 |
| Pivot Charts | 436 kb | 7 |
| Subtotals | 576 kb | 9 |
| Conditional formulae | 517 kb | 8 |
| Lookup Tables | 566 kb | 8 |
| Other Functions | 519 kb | 8 |
| Financial functions | 375 kb | 6 |
| Array Formulae | 382 kb | 6 |
| Outlining | 492 kb | 7 |
| Recording Macros | 725 kb | 10 |
| Running Macros | 626 kb | 9 |
Notes:
- The page count is an estimate only, calculated by a reasonably intelligent algorithm based on the current file size.
You can now view our training courses in Microsoft Excel 2007, or if you can not come on a course or want to train a large number of people find out how to purchase our Microsoft Excel 2007 courseware.
