Here are some links to SolidWorks tutorials and tips that I think might be useful to someone who doesn't quite know all there is to know about the software. If you find any websites that really help you out, let me know and I'll add them to the list.
solidsmack.com - This is a quirky site all about SolidWorks that has some good tips and articles. This is a link to the tips page, but the rest of the site is full of information. Most of the tips are in video format.
SolidWorks Web Help - This site is well organized and seems to have a lot of useful information paired with well illustrated pictures.
SolidWorks Community - This is the official SolidWorks forum. A good place to look for answers if you get stuck.