Parallels / VMWare both work very well. Free alternatives may also work – but I’ve never really used in anger. I’m currently running on a Mac using Parallels to run a Win7 and a WinXP virtual machine and it’s working a treat. You will need a version of windows to install.
I believe that VMWare/Parallels have better integration with the Mac OS than the free options as well as better performance- but as I said, I have not used them so can’t really offer much advice.
Office for Mac is pretty good really. If you have it anyway, I’d see how you get on with it. We use a fair few plugins for Excel which don’t work for the Mac version – but if you’re not doing anything too exotic they should work fine.
Edit –
Just thought I’d clarify you’ll need windows to install – and then Office for Windows as well.
And to answer one of your questions – setting the thing up is very easy – put the windows disk in the drive, start parallels (or whatever) and tell it to install windows. Pretty much looks after itself then.