Sharks445 :
I just got the i7 4770 and right now I'm using integrated and even though the graphics are impressive for integrated, I still need a good GPU.
So right now what software can I use that will take advantage of the 4770?
When I got my 3930k, I had the same question. From reading more than I should have, anything computationally demanding will benefit. That covers a lot of stuff. You can run a huge calculation over the max amount of cells in Excel, using a really complicated formula that iterates across a huge matrix. But it doesn't have to be that nerdy. When you get a good graphics card, you can run games that keep track of a lot of data (e.g. Crysis 3, RPGs with many characters, FPS with many players, etc). Media production and manipulation also benefits. You'll be able to export photo edits and video clips that you make yourself, and you'll also be able to handle programs without GPU acceleration. Adobe Lightroom is all CPU-driven, and some of the editing on RAW photo files will really bog down CPUs that aren't up to snuff, especially when you apply many local edits on specific parts of a photo rather than to the entire photo.
In order to take advantage of heavy CPU usage, you'll need a lot of RAM. I just maxed mine out to 32GB because I would run out of RAM when I had 16GB. If you are into panoramic photography, you'll really see a difference with that 4770 using a lot of RAM. Again, though, that's just an example of something that does computations on a large piece of information. Panoramas are easily more than 1 or 2 GB on a drive, and manipulating them requires many times more RAM. Effectively managing all that information will rely on your CPU.