As a computer techie, I figure I'm allowed to now speak.
Advice:
1. Don't have the computer techie eat you alive. As a rule of thumb, it often costs more to fix a computer than to buy a new one and move over your hard drive.
2. Before anything else, check to see if your monitor gets a signal when the PC is turned on; i.e, the "no signal found" message goes away. If not, that's a bad sign.
3. If the computer makes beeping noises, record them. PCs use a morse-like set of error message codes.
4. If nothing happens other than a single beep, try switching out the power supply. PSUs can be had for $10 online, or just use a spare if you have one. (I usually have three on hand.)
5. If a new PSU does nothing, odds are your motherboard is croaked. Today, motherboards usually have built-in video, audio, and IDE controllers; much like an integrated amplifier, if the pre-amp goes on one channel, the whole thing is useless. I can sell you a new motherboard and CPU at a very reasonable price, or if you'd rather not deal with the mess, you can move your old hard drive to a new computer - odds are, it will be able to read it, and even if you are using a filesystem that does not allow you to do so, there are assorted free tools that will let you get around it .
Contact me at my E-mail if you'd like - I have oodles of parts I need to sell or trade away, and seeing as how I've broken my leg, I'm not going anywhere fast.