Join David Rivers for an in-depth discussion in this video Converting tables to Excel spreadsheets, part of OneNote 2013 Essential Training.
If you've inserted a table into one of your notebooks here in OneNote and decide you…need the additional power that you would find in a spreadsheet program like Microsoft Excel, no problem.…All you have to do is convert the table to a spreadsheet,…then you'll be able to edit it using all of the functionality built into Excel.…That's what we're going to do with our Agenda here.…And if you have jumped to this lesson, you can go to the No Obstacles Chapter 7d notebook,…in the User Conference 2013 section under Agenda is where we're working on our table.…
Now the Layout tab does appear when you're working in a table.…If you've jumped to this lesson, though, and you've clicked inside the table and don't…see that just go to the Insert tab, click Table, click it again, and you'll see this…tab, click Layout and from here is where you'll find Convert to Excel Spreadsheet.…It's a very last option on the ribbon so your cursor needs to be anywhere inside the table…when you click Convert to Excel Spreadsheet.…And that's just a matter of sitting back and watching it get converted, there it is.…
Author
Released
2/28/2013- What is OneNote?
- Copying and pasting content
- Creating, moving, and deleting sections
- Adding images, audio, and video
- Formatting text
- Searching notebooks
- Sharing and moving books
- Using templates
- Creating tables
- Converting handwriting to type text
Skill Level Beginner
Duration
Views
Related Courses
-
Outlook 2013 Essential Training
with Jess Stratton3h 6m Intermediate -
Word 2013 Essential Training
with David Rivers5h 9m Intermediate
-
Introduction
-
Welcome1m 18s
-
-
1. Getting Started with OneNote 2013
-
What is OneNote?3m 17s
-
Sharing and moving notebooks4m 15s
-
Creating a note on a page3m 13s
-
-
2. Creating and Adding Content
-
Sending content to OneNote3m 18s
-
Copying and pasting content3m 53s
-
Adding pictures4m 12s
-
Adding audio and video files5m 40s
-
Recording audio and video3m 29s
-
Embedding Excel spreadsheets3m 15s
-
Adding files3m 47s
-
-
3. Formatting Notes
-
Using bullets and numbering3m 47s
-
Checking spelling6m 14s
-
4. Viewing and Organizing Information
-
Searching a notebook5m 22s
-
Tagging notes5m 50s
-
5. Working with Templates
-
Using templates6m 22s
-
Saving as a template4m 9s
-
Choosing a default template1m 46s
-
-
6. Formatting Pages
-
Adding a background graphic3m 52s
-
7. Working with Tables in OneNote
-
Creating a table4m 20s
-
Formatting tables and data2m 36s
-
-
8. Using Writing Tools
-
Working in Pen mode4m 12s
-
-
9. Interacting with Outlook
-
Sending page info by email1m 43s
-
Working with Outlook tasks3m 22s
-
10. Sharing a Notebook
-
Saving to other formats3m 6s
-
Saving to SkyDrive1m 52s
-
Creating a shared notebook3m 37s
-
-
11. Collaborating on a Notebook
-
12. Modifying OneNote Options
-
Setting display options5m 6s
-
Changing email options2m 58s
-
Password protection3m 48s
-
Setting backup options2m 39s
-
-
Conclusion
-
Next steps18s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Converting tables to Excel spreadsheets