Hi Matthew.
If you decide you really need the Microsoft Office apps, your best bet is to get an Office 365 subscription. Once you have that you can install and use all the main products on both your Mac and iPad. The small business package allows five computers and five tablets for about $100 a year.
The apps for the iPad can be found in the App Store on the iPad, and are free. They are limited to reading documents until you sign into them with an Office 365 account.
I'm not sure where you get the apps from for the Mac, but I'm sure Microsoft will be happy to point you to them once you're a subscriber.
If you don't actually need Office (for it's compatibility mostly), but just some good productivity apps, the iWorks suite of Pages, Numbers, and Keynote are excellent, and free with your new purchases (if you purchased your devices in the last few months). Just head to the appropriate App Store for your device/computer and check them out.
Just ask about any other solutions you need, and I'm sure someone will have some ideas for you to try out.
