Office for iPad can do many things, but a lot of important stuff simply can't be done in the iPad version. For now and the foreseeable future, you have to drop back and punt -- on a desktop or laptop.
For example, Word for iPad won't let you edit text inside SmartArt. There are no watermarks. Most section-based settings don't work, along with paragraph indents, line spacing, custom tabs, and on and on.
Excel for iPad won't do conditional formatting or sparklines, no matter how hard you try. You can see them if they've been set up on a desktop or laptop, but you can't do anything with them on the iPad. The same goes for changing components in charts.
PowerPoint lets you create new presentations, but there are only 20 templates, most of which aren't very inspiring. Transitions and animations that work in the desktop version may or may not work in the iPad version, and there's no way to embed a YouTube clip or a video clip embedded on a computer.
None of the Office for iPad apps tolerate odd fonts. If you stick to the Office Compatible Fonts and iOS fonts, you're fine. But if you want to work outside the norm, be prepared for text that jumps all over the place.
There's a point of diminishing returns at work here. If you throw in every Office feature, you'll end up with an app that runs like Photoshop on DOS and a Ribbon that looks like Office 2013 -- and nobody wants that. The folks who design Office for iPad have to carefully choose which features they'll support and which get relegated to the heavy iron.
Get used to it.