Excel for iPad – a tour


Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

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

subs profile e1563205311409 - Excel for iPad - a tour
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address