Scribd
Upload
11 views8 pages

Excel Tips for Simplifying Work

This document provides 3 tips for using Excel on touch devices: 1. Add comments to cells to provide feedback that stays with the spreadsheet. 2. Use formulas, sorting, and filtering to analyze data in tables. For example, use the SUM formula to total sales by quarter. 3. Charts and sharing features allow visualizing data trends and collaborating on spreadsheets. Tap buttons in the ribbon to add charts or share the file.

Uploaded by

pankaj kumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
11 views8 pages

Excel Tips for Simplifying Work

This document provides 3 tips for using Excel on touch devices: 1. Add comments to cells to provide feedback that stays with the spreadsheet. 2. Use formulas, sorting, and filtering to analyze data in tables. For example, use the SUM formula to total sales by quarter. 3. Charts and sharing features allow visualizing data trends and collaborating on spreadsheets. Tap buttons in the ribbon to add charts or share the file.

Uploaded by

pankaj kumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Welcome to Excel

3 tips for a simpler way to work.

Navigate using the tabs below


Comments
Target your feedback in comments that stay with
the spreadsheet.
Try it using the table at right:
Email
1 Tap G5. [Link]@[Link]

[Link]@[Link]
2 Tap the pencil button, then tap Review [Link]@[Link]
> Comment, and type something.
[Link]@[Link]

[Link]@[Link]

[Link]@[Link]

3 Close the comment pane to see more


of the spreadsheet.

4 Tap the comment bubble to open the


pane, and tap it again to close the
pane.
Tip: Cells with comments are marked by a
small red triangle.
Customer Name
Nancy Freehafer

Andrew Cencini

Jan Kotas

Steven Thorpe

Robert Zare

Laura Giussani
Built for touch
Excel works on any touch device. It’s easy to make
changes with just a tap.
Try it using the table at right:
Quarter Sales
1 Tap cell G9 and tap the Formulas Quarter 1 $ 37,297.00
button.
Quarter 2 $ 472,928.00

Quarter 3 $ 210,456.00

Quarter 4 $ 78,123.00

Total

2 Tap SUM. The formula bar changes to


=SUM(number1, number2, ...)

3 Tap G5, then drag the selection handle


to include cells G6, G7 and G8.

4 Tap the checkmark to see the result.


Sort and filter data
Make sense of your information by putting it in
order or narrowing your focus.
Try it using the table at right:
Company Industry Q1 Sales
1 To see which company sold the most, A. Datum Corporation Tech $ 195,449.00
tap the arrow next to Q1 Sales.
Adventure Works Travel $ 123,721.00

Blue Yonder Airlines Travel $ 934,763.00


2 Tap Largest to Smallest to sort from City Power & Light Utilities $ 299,293.00
highest to lowest.
Coho Vineyard Beverage $ 228,783.00

Consolidated Messenger Tech $ 579,825.00

Contoso Pharmaceuticals Medical $ 371,570.00

Contoso, Ltd Misc $ 239,219.00


3 How did the Tech and Financial Fabrikam, Inc. Utilities $ 639,630.00
industries do? Tap the arrow next to
Industry then tap Filter Items. Fourth Coffee Beverage $ 876,740.00

Graphic Design Institute Education $ 788,390.00

Humongous Insurance Financial $ 682,545.00

Litware, Inc. Tech $ 902,264.00

Lucerne Publishing Misc $ 905,906.00


4 Tap Financial and Tech to select Margie's Travel Travel $ 289,570.00
these industries and tap Done to view
the results.
More questions about Excel?

Keep going.
There are more ways to simplify your work.

New Charts
Charts tell your data’s story at a
glance. Tap the pencil button in the
ribbon.

Share
Share your spreadsheet by sending a
link or by inviting people to view or edit
it. The Share button is near the top of
the app.

Visit the Excel team blog

You might also like