Save local copies
Storing a document in the cloud is fine and dandy, so long as you know you're going to have a data connection of some sort. If you have a big presentation coming up, don't let something like a broken Wi-Fi network ruin it for you. Save the document to your iOS device as a backup.
To do this, while viewing the file you want to save, tap on the document icon with the two arrows making a circle. It's what I consider to look like a refresh icon. From the list of options, select Duplicate, then choose your device from the list of storage options.
Autofill in Excel
Typing a long list of repetitive dates, numbers, months, years — repetitive anything, really — into your Excel spreadsheet is a hassle. Thankfully, the time-saving Autofill feature from the desktop version has made it into Excel on iOS.
Start by filling in the first two cells, setting the pattern for Excel to understand. Then highlight the two cells, bringing up the copy menu where you'll find the Fill option. Tap on it, then drag the proper arrow in the direction you'd like to continue the sequence. When you lift up your finger, the cells are filled automatically.
Even when an app is touch-optimized, repeating tasks can be a bit taxing and tedious, and that definitely includes trying to match formatting between sections of your document.
Start by highlighting a block of text with the format you want to reproduce, and tap Copy in the popup. Next, highlight the text you want to apply the formatting to, and select Paste Formatting from the list of options. Too easy.
Freaking laser beams
OK, so there's actually no lasers to be found in the Office apps. There is, however, a fake laser buried within PowerPoint's presentation mode. While presenting, presumably from your iPad to an Apple TV or projector, you can tap and hold on the device's screen to bring up a fake laser icon that moves around under your finger.
You'll also notice the option to draw on the screen in various colors, for an added dramatic effect.
Sign up for CIO Asia eNewsletters.