Excel Teaching Videos

Excel Useful Videos (Excel2007, but concepts valid today)

1. Introduction to Excel
2. Setting to print in Landscape
3. Using Headers and Footers
4. Using Conditional Formatting
5. How to use the Fill Handle
6. Indenting Cells
7. Now function and Format Dialog
8. Wrapping and Rotating Text
9. Naming Cell Ranges
10. Protecting Cells
11. PMT function
12. Absolute/Relative Reference
13. If Function
14. Creating a Table
15. Sorting a Table
16. The Comparison Operators
17. Using Simple Filters
18. Using Advanced Filters
19. The VLOOKUP function
20. The DB functions