Scribd
Upload
7 views7 pages

Excel Tips for Data Management

This document provides a guide for using Excel, highlighting features such as commenting, touch functionality, sorting, and filtering data. It includes step-by-step instructions for various tasks like adding comments, using formulas, and organizing data. Additionally, it mentions options for sharing spreadsheets and accessing further resources from the Excel team blog.

Uploaded by

faizanruwais9
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
7 views7 pages

Excel Tips for Data Management

This document provides a guide for using Excel, highlighting features such as commenting, touch functionality, sorting, and filtering data. It includes step-by-step instructions for various tasks like adding comments, using formulas, and organizing data. Additionally, it mentions options for sharing spreadsheets and accessing further resources from the Excel team blog.

Uploaded by

faizanruwais9
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

6/4/2025

Navigate using the tabs below

hjnkn jjjjjn
jjjjnn

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

[Link]@[Link] Andrew Cencini


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

[Link]@[Link] Robert Zare

[Link]@[Link] Laura Giussani

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.
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 A. Datum Corporation Tech $ 195,449.00
most, 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 City Power & Light Utilities $ 299,293.00
from 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