Excel for iPad – a tour

The features in Excel for iPad.

Here’s a look at the major features in Excel for iPad, looking over the five main tabs. The buttons will be familiar in most cases, though the underlying menus/galleries are different and limited compared to Excel for Windows or Mac.

Shameless plug:
Office for iPad: The Complete Guide is now available.  Every tab, ribbon and menu in the detail that Microsoft’s own documentation/help misses out.  Only $4.95 for Office-Watch.com readers and available to read today.  Click here.

Below each image is a list of the buttons / menus from left to right.


Home

http://img.office-watch.com/ow/Excel%20for%20iPad%20-%20ribbon%20tour%201.png image from Excel for iPad - a tour at Office-Watch.com

Font

Font Size

Bold, Italic, Underline (one only)

Cell Borders: No, All, Outside, Thick Box, Bottom, Top, Left, Right

Cell Background Color

Font Color

Justify: Left, Center, Right, Top, Middle, Bottom

Merge and Center cells

Cell Formatting: General, Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Text, Special

Cell Styles

Insert & Delete Cells: Shift Cells down, Shift Cells Right, Insert Sheet Rows, Insert Sheet Columns

Delete Cells: Shift Cells down, Shift Cells Right, Delete Sheet Rows, Delete Sheet Columns

Sort and Filter: Ascending, Descending, Filter


Insert

http://img.office-watch.com/ow/Excel%20for%20iPad%20-%20ribbon%20tour%202.png image from Excel for iPad - a tour at Office-Watch.com

Table

Recommended

Charts

Pictures

Shapes

Text Box


Formulas

http://img.office-watch.com/ow/Excel%20for%20iPad%20-%20ribbon%20tour%203.png image from Excel for iPad - a tour at Office-Watch.com

Many Excel functions are available, listed under the buttons on the Formulas tab. You can also click on the Formula Bar, press the = (Equals) key and start typing a formula, just like in Excel. As you type, function names will appear to autocomplete your typing.

See also the Formulas Keyboard – a special Excel keyboard to make entering/editing formulas easier.

AutoSum: Sum, Average, Count, Max, Min

Recent: recently used functions

Financial

Logical

Text

Date & Time

Lookup & Reference

Math & Trig

More Functions: Statistical, Engineering, Info, Database

Recalc: force a recalculation of the worksheet


Review

http://img.office-watch.com/ow/Excel%20for%20iPad%20-%20ribbon%20tour%204.png image from Excel for iPad - a tour at Office-Watch.com

Previous comment

Next comment

Show comment

Show all

Delete


View

http://img.office-watch.com/ow/Excel%20for%20iPad%20-%20ribbon%20tour%205.png image from Excel for iPad - a tour at Office-Watch.com

Formula Bar

Sheet Tabs

Headings

Gridlines

Freeze Panes: Panes, Top row, First column

Want More?

Office Watch has the latest news and tips about Microsoft Office.  Delivered once a week.