Look to your past. Though you don't have your high school counselor to hold your hand this time, you may find a similar figure at the college you attended or the one you plan on attending. If you have formed strong enough ties and left good impressions -- especially if you've excelled in your work -- don't be shy about asking former professors for suggestions about where to look for scholarships. If you had any contact with counselors at the college, give them a call as well. Education professionals, for the most part, love to feel that they are helping others to advance their education and careers.
Look to your future. If you already have been accepted at your next college, get in contact with its financial aid office. Not only will it often have listings of local and national scholarships, it will also most likely provide you with application forms for scholarships only available to students at that school. This greatly narrows your competition and raises your chances of winning money.
Look to your present. If you are a returning college student, chances are you've been in the workplace awhile. If your intended field of study is related to your job, see if your employer, company, or other agencies in your field offer scholarships for what you are going to study. You may be surprised to find out there are grants available, or that they'll cover the tuition (or part of it) without the need to "win" a scholarship; as an employee, you will be advancing your education and bringing your knowledge back into the field.
Look online. Along with these great real-world resources, sign on along with the rest of the scholarship-hunting world and create accounts on sites such as FastWeb.com and Scholarships.com. On these sites, you create a profile detailing what degree you aspire to and what talents, skills and hobbies you have, and scholarships you may be eligible for are displayed for your perusal. Other sites such as studentscholarshipsearch.com and ScholarshipHunter.com do not require accounts, but require you to search through lists of scholarships to find ones that fit you.