I know there's a million different articles, posts and books written on the topic of working more efficiently on your Mac, but this post on lifehacker is really great. I use spotlight for a lot of things and had no idea it could do all of this.

Half the time, when I'm looking for a file, it's because I don't actually know where it is, or its buried so far in the Finder that I don't want to click around the file system to get there. Searching for it in Spotlight will get you the file, but you can also use this keyboard shortcut to view that file's parent directory. Just highlight the file and press Cmd+Enter (or Cmd+Click on the file) to view it in the Finder. It's immensely handy for searches where you need to do more than just open the file.