http://www.youtube.com/watch?v=s12Jb5Z2xaE
This is a video that Common Craft created specifically for Microsoft SharePoint. It does a fantastic job of explaining SharePoint conceptually to new and existing users.