In this video, learn how to use the new Insert data from picture feature within Excel on a mobile device to transfer data that appears in a table on paper into Excel by taking a picture of it. Plus, learn how to edit the content as you insert it.
- [Instructor] If you've ever had to recreate a table here in Excel on your mobile device, you're going to love this time-saving new feature that allows you to take a picture of a table, could be in a textbook, on a piece of paper, and turn it into a table right here in Excel. Now it is available for most mobile devices. I'll be working with an iPad. So all you need to do is move to the cell where you want to insert the table, and then take a picture of it by going up to the Insert tab at the top, give that one a tap, and you'll notice Data from Picture, a new option. Tap that and now it's just a matter of using your mobile device's camera to get a clear picture of the table that you want to take a picture of. So I'm looking at this price list, and you can see there is a table in there. Once I have it around the center, we'll take a picture, but we're not done there. Obviously, we don't want everything. So now it's a matter of dragging the handles to focus in on the content we want for our table. So I'm going to the bottom left corner, for example, and just going to drag that in. Same thing in the bottom right-hand corner up and inwards a little bit. Next, I'll go up to the top left-hand corner and drag that down, I don't need all of those graphics at the top, I just want the table. And I'll go up to the opposite side and drag that one down and in. Doesn't have to be perfect. But now I have exactly what I want. In the bottom right-hand corner, you'll see Done, give that a tap and it will process. Even now though, as it's processing, we can go in and make adjustments before we actually insert it into Excel. And in fact, what'll happen here, is if there are errors, they'll be highlighted. You can see Mother's Day Arrangement is kind of shaded in a different color. I can go in there, tap that cell, and I can choose to ignore it, I could edit, maybe I want to take out that apostrophe from Mother's Day, so I'm going to tap Edit, gets me inside, and you can see I'm actually editing the table now where I could go over here to Mother's and take out the apostrophe at the S and the space back. That looks good. Now when I click or tap the Done button, you can see it's no longer highlighted, and it's ready to be inserted. Tapping Insert in the bottom left-hand corner inserts it right here into Excel, and you can see it looks pretty good. Now I can do some formatting. For example, I might want those numbers in the Price column over here on the right-hand side to show up as dollar amounts, change it to a currency, for example, any of the formatting available in Excel, I now have access to it to make this table look great in Excel. But I didn't have to recreate it thanks to this new feature that allows me to create data from a picture.
- Using natural language queries in Excel
- Getting writing assistance from Editor
- Using the Resume Assistant in Word
- Turning data into maps in Excel
- Setting access to linked files right within Outlook
- Creating better PowerPoint lists with Designer
- Using the math assistant in OneNote
- Working with Microsoft To-Do and Forms