| 1. | building small components | |
| 2. | A1 vs. $A$1 vs. $A1 vs. A$1 | |
| 3. | Funcitions | |
| 4. | Index | |
| 5. | String Concatenation | |
| 6. | Cells vs. Strings | |
| 7. | Conditional Formatting | |
| 8. | Functions | |
| 9. | Pivot Tables | |
| 10. | Grouping | |
| 11. | Importing data | |
| 12. | Quick Access Toolbar | |
| 13. | Options | |
| 14. | Printing | |
| 15. | Formulas | |
| 16. | VLookup | |
| 17. | VBA aka Excel Macros | |
| 18. | Range Names | |
| 19. | Testing a spreadsheet | |
| 20. | Working on /Changing someone's spreadsheet | |
| 21. | Document a spreadsheet's algorithm | |
| 22. | Optimize a spreadsheet | |
| 23. | importing data into excel | |
| 24. | Shuffle a list using excel but may not work so will have to use vba | |
| 25. | Creating quoted comma separated lists from actual report for VBA, SQL or other usage (see pptools create list sheet |