Microsoft Office for iPad is finally here. And while anyone who has used Office on a PC before should not have any problems figuring out how to work with Word, Excel and PowerPoint on the iPad, some basic tips and introductions should help make the transition a bit easier.
Here are some basic tips for working in Excel on the iPad and getting started using the application.
There are three easy ways that you can begin typing in Excel.
One way is to tap the cell you want to enter data into, and then tap the formula bar. The keyboard will appear and you will be able to input your data.
When you are done, tap the green check mark to save your work.
The second way is to simply double tap the cell, which will give you the keyboard immediately without having to tap on the formula bar. Then you can type and tap the check mark when you are done.
The third way is probably the fastest. Double tap the cell, type, and then press the enter key on the keyboard to save your work. Pressing the enter key will take you to the next cell down automatically, and keep the keyboard up so that you can continue to type.
If you want to delete what you have typed, or you just want to get the keyboard off the screen, simply tap on the red X next to the green check mark.
While the regular keyboard works just fine, you have another option when working in Excel on your iPad. You can also use a different keyboard that is made specifically for Excel use called the function keyboard. To bring that keyboard up, tap on the green “123” atop the keyboard.
As you can see, the function keyboard is designed to be much more convenient when working with numerical data on your iPad.
You can navigate the cells by using either the Tab key to move to the next cell on the right, or the four arrow keys to move in the direction of your choice.
For this example, let’s use the Sum function, which is one of the easiest and most basic functions in Excel.
Once you have entered data, tap on the total key.
Excel is very intuitive and it will try and guess which cells you want to include in the function, based on the information present and the way in which you have inputted your data.
If Excel guesses wrong, then you can select the cells that you want to include in the function yourself in two ways.
One way is to simply drag the handles in order to get the range of cells you want.
Another way is to select them one by one.
Simply tap on the cell you want to include, then enter a comma, and then tap on the next cell you want to include. Keep doing that until you have the range you want.
Once you have the range you want, simply press enter.
If you want to use functions other than Sum, tap on the function key up top by on the formula bar to see a list of the many functions that are offered to you.
Click on the one that you want to use.
To select the cells that you want to include in the function, you need to tap on the number place holder in the formula bar first and then on the cell that you want to include.
If you need more than three cells included, hold your finger at the end of the formula in order to get the magnifying glass to appear and then position the cursor at the end of the last cell, inside the closing parenthesis.
Now you can continue to add cells by tapping the comma first and then the cell you want to add.