On September 14th, 2017, we published revised versions of our Privacy Policy, Terms of Service and Website Use Policy and published a Cookie Policy. Your continued use of Lynda.com means you agree to these revised documents, so please take a few minutes to read and understand them.

- If you've created a table here in OneNote 2016,…you start adding content and realize,…"I'd like to be able to do some calculations with the data,…"maybe some visualization,"…and you miss the power of Microsoft Excel…because we don't have it here in OneNote 2016…although we have the ability…to convert our tables to Excel spreadsheets…and manipulate them right from within OneNote 2016.…Let's see what I'm talking about…as we continue working with our table here…on the London page of our Travel section…at the Landon Hotel Notebook.…

If you need to get caught up, just open up Landon Hotel0704…and you'll have this table.…Clicking anywhere inside the table…gives us this Layout tab at the top under Table Tools.…The very last button on the ribbon…is a Convert to Excel Spreadsheet button…that allows us to edit the table using the power of Excel…without actually leaving OneNote.…So let's click this button and see what happens.…Well, a little bit of flashing going on…and it looks like we just lost our table.…Not so.…Scroll down using the scroll bar.…

Resume Transcript Auto-Scroll

Author

Released

9/22/2015

Learn how to use the Office 365 version of OneNote 2016 to create, edit, and save notes and keep your information organized. Discover easy ways to create notes, add and format text, stay organized with tables, and share and password-protect your notebooks. Plus, learn how to integrate all sorts of content into notes, such as screen clippings, images, audio and video, and even Excel worksheets.