There is other software around to do what you want (I've used Wingate before - be careful upgrading it though as it likes to re-activate all it's servers and re-open the ports
), but why not just use a wireless router?
Most wireless routers will act as an access point for an infrastructure based wireless network providing the clients with access to the net without the need for the PC to be turned on.