I found lot of very useful videos on How To Series. Putting them all together here:
How To Video on SharePoint 2007
1. Install Configure Microsoft Office SharePoint Server? (Part 1):
Video Link
2. Install Configure Microsoft Office SharePoint Server? (Part 2):
Video Link
3. Configure Search Indexing:
Video Link
4. Publish a Dynamic Excel Workbook File to Excel Services:
Video Link
5. Configure Records Center:
Video Link
6. Configure Keywords and Best Bets:
Vidoe Link
7. Use the Business Data Catalog:
Vidoe Link
8. Configure Single Sign On (SSO):
Video Link
9. Install and Configure the Faceted Search Add-in:
Video Link
10. Configure the Active Directory Profile Import Service:
Video Link
11. Using Search Scopes:
Video Link
12. Create and Configure a Business Data Catalog:
Video Link
13. Create a KPI List and KPI Dashboard:
Video Link
14. Use the SPDiag Tool to Analyze my SharePoint Farm:
Video Link
15. Use the Permission Reporting Tool:
Video Link
16. Install and Configure Microsoft Search Server 2008 Express:
Video Link
17. Configure Federated Search in SharePoint Server 2007:
Video Link
18. Configure My Sites On My SharePoint Server 2007 Farm:
Video Link
19. Enhance User Profiles with BDC Data:
Video Link
20. Install Service Pack 2:
Video Link
How To Video on WSS:
1. Creating a Windows SharePoint Services Web Application and Site Collection:
Video Link
2. Making Use of Managed Paths To Control Site Collection URLs:
Video Link
3. How to Install a Standalone Instance of Windows SharePoint Services on a Windows Server Installation:
Video Link
4. Configure and Manage the Recycle Bin:
Video Link
5. Sharepoint Online Setup:
Video Link
6. Installing And Activating Features:
Video Link
7. Enable Forms-Based Authentication for a Windows SharePoint Services Site Collection (Using IIS 7):
Video Link
8. Configure Anti Virus In Windows SharePoint Services (Using Forefront Security for SharePoint):
Video Link
9. Enable Forms-Based Authentication for a Windows SharePoint Services Site Collection (Pre-IIS 7):
Video Link
10. Create a New Site Column:
Video Link
11. Create Reusable Site Templates:
Video Link
12. Work With Wikis in Windows SharePoint Services:
Video Link
13. Configuring Alternate Access Mappings:
Video Link
14. Creating a New Content Database:
Video Link
15. Configure Outgoing E-mail:
Video Link
16. Using Content Types:
Video Link
17. E-mail-Enabling a SharePoint List:
Video Link
18. Manage Web Parts:
Video Link
19. How Do I: Use Content Types:
Video Link
20. How Do I: Configure Quota Management:
Video Link
21. Configure Forefront Server Security for Sharepoint to Block Uploading and Downloading of Specific File Types:
Video Link
22. Add Forms-Based to an existing Windows Authentication Site:
Video Link
23. Administer SharePoint Farm Using Windows PowerShell:
Video Link
24. Work With Solutions Packages:
Video Link
25. Use Master Pages to Customize the Look and Feel of My Site:
Video Link
26. Migrate a Content Database:
Video Link
27. Install Windows SharePoint Services on Windows Vista:
Video Link
28. Migrate the Configuration Database:
Video Link
29. Integrate My SharePoint Lists with the Microsoft Office Outlook Client:
Video Link
30. Work with Document Templates:
Video Link
31. Use the SPDiag Tool to Analyze my SharePoint Farm:
Video Link
32. Use the Permission Reporting Tool:
Video Link