Teach Yourself Excel
These are links to short tutorial-style animations that I have created. They are designed to help anyone learn some of Microsoft Excel's features. They cover a range of useful, everyday functions and tips and also some basic statistical tools.
You'll need this xls file in order to follow the tutorial - click here to download.
| Lesson | Function |
|---|---|
| Lesson 1 | Insert Function |
| Lesson 2 | If |
| Lesson 3 | Autosum |
| Lesson 4 | & |
| Lesson 5 | Live Zoom |
| Lesson 6 | Align Vertical |
| Lesson 7 | Sort |
| Lesson 8 | Average |
| Lesson 9 | Freezing Panes |
| Lesson 10 | Unhide |
| Lesson 11 | Sum |
| Lesson 12 | Adding Text |
| Lesson 13 | Alt + Enter |
| Lesson 14 | Fill Down |
| Lesson 15 | Conditional Formatting |