I use it as an expression of joy when something good happens. Example: "Woot! I just make level 39!"

In speech or just in writing? I've only ever seen it on the net (where it's usually spelled "w00t"). In speech I'd tend to use "Wahey!"

Peter