Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
One nice improvement you'll find here in OneNote 2013 happens when you embed files into a notebook. For example, Excel spreadsheets, even now Visio drawings. You can embed a Visio file. If you go into Visio to make changes to that drawing, you'll see them updated here in your notebook. Same thing goes for an Excel spreadsheet. So, let's experiment with an Excel spreadsheet here in our current notebook, called No Obstacles 2012, that we created earlier on. If you haven't been following along, just create any old notebook and we're going to create a new page for this as well.
We'll go over here to the right-hand side and click Add Page. It becomes an Untitled Page at the bottom. Our cursor is flashing in the top left corner, let's type in a title for this page. We'll call it, July 2012 Sales. There we go. Now, we'll click down below the date and time and this is where we want to insert our spreadsheet. It could be an entire spreadsheet, it could be parts of that spreadsheet. Let's go to the Insert Tab to find out how. From here, in the File section, you can see we can get that File Printout like we did earlier with our Word document.
We can Attach Files or we can go right to Spreadsheet here, notice the Excel logo, give it a click and this allows us to create a New Excel spreadsheet, which we can edit in Excel or Existing Excel spreadsheet, one that we already have. Let's click there, because in your exercise files, in the OneNote folder you will find, No Obstacles Sport - July 2012 Sales Report. Select it by clicking and click Insert. Now, we have a few options here. We can attach the file, which will simply attach it to the page and we can double-click the attachment to get in.
We can insert the entire Spreadsheet or just a part of it by picking a Chart or a Table. Let's insert the entire spreadsheet by clicking the middle option and it just takes a moment now, and as we scroll through this, momentarily, we'll be able to see that actually more than one table was inserted. The Scroll Bar on the right, you'll see what came from the second tab or second sheet. As we scroll further up that was from our first sheet and we have access to all of that information here in our notebook.
Of course, if we're in Excel working on this and we make changes, they're going to be updated automatically and dynamically here in our OneNote Notebook. We can also edit directly from here. Notice the Edit symbol in the top left corner. If you'd click that, you'll actually be able to go in and edit this in Excel. Notice an Excel window pops up now. We can enable any disabled content and just go down here and start making changes. For example, if this SKU here had to be changed, it's just a little bit too long, you can go in, double-click, let's take out the 9 at the end, it doesn't belong and press Enter.
It's going to update that now in our notebook. So, let's look for 1070845 for our first SKU number when we close this up. Yes, we'll Save our changes and when we arrive back here in OneNote, there it is, updated dynamically right in front of us. So, this is a nice new feature and as I mentioned, it will also work with Visio files now. So, if you do have a Visio drawing and you do make changes to that Visio drawing in Visio, those changes are updated dynamically here in your OneNote notebooks as well.
Let's go back to our very first page, Identity Branding and Style Guide and continue from here.
Get unlimited access to all courses for just $25/month.Become a member
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.