.

Welcome to Excel

Three tips for a simpler way to work.

Navigate using the tabs below

NAME : NANDINI SHARMA

QUALIFICATION: PERSUING GRADUATE FROM DU

SKILLS: GOOD COMMUNICATION IN HINDI

Comments

Target your feedback in comments that stay with the

spreadsheet.

Try it using the table on the right:

Email address Customer Name

1. Tap G5. *****.*********@************.*** Nancy Freehafer

******.*******@****************.*** Andrew Cencini

2. Tap the pencil button, then tap Review ***.*****@**********.*** Jan Kotas

> Comment and type something.

******.******@****************.*** Steven Thorpe

******.****@****************.*** Robert Zare

*****.********@*********-*****.*** 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 with 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 on the 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 tick 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 on the 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 industries Fabrikam, Inc. Utilities £639,630.00

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 these Margie's Travel Travel £289,570.00

industries and tap Done to view the

results.

Have 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

Contact this candidate