ฝัง
- เผยแพร่เมื่อ 26 ก.ย. 2024
- In this video, I show you how to use Excel inside OneNote. Whether you're looking to maintain data explanations, enhance data accessibility, or simply improve your organizational process, this video will guide you through multiple methods to attach Excel files, embed entire workbooks, or even convert OneNote tables into new Excel files. Perfect for professionals and students alike who are looking to make the most out of their data and notes. Don't forget to subscribe for more productivity tips and tricks!
⌛Timestamps
00:51 Attached existing spreadsheet
01:44 Insert spreadsheet
03:09 Insert a chart or table
03:54 Create a new spreadsheet
04:20 Create new spreadsheet from existing table
~~~~~
If you are interested in seeing what gear I use to make my TH-cam videos, you can see the list in my Amazon storefront along with video reviews of some of the products:
🛍️ www.amazon.com...
If you purchase any items from my Amazon storefront, I will earn a small commission at no cost to you. Thank you for supporting the channel!
Very clear and concise explanation. Well done and thanks for sharing👍🏾
Excellent explanations. This was very helpful. Thank you for making this video.
This was very helpful. Thank you!
Great productivity video. I have not used both OneNote and Excel together and it looks like a great way for a team to use Teams with OneNote with Excel docs integrated. Time for me to test and practice!
I didnt realize this, thank you!!!
Thanks Andy!! Great tip
bonjour, est il possible de modifier la zonne du fichier excel qui apparait dans la page one note ?
Thanks for this Andy. Unfortunately there's an issue in this respect in terms of cross-device usage for the same excel spreadsheet. From briefly playing with this, as a temp file will be saved on your computer you can't access that same file from as smoothly from the OneNote section on another device (e.g. mobile or tablet).
Is there any way to insert the spreadsheet, and when opening it from OneNote, have it open the master/original document - this would easily resolve the issue when accessing/viewing/editing the spreadsheet from multiple devices.
Hi Andy, thanks for you video. Do you know if there is a way to update and modify the original Excel file instead of the copy of it? thanks
Yes, either option is a copy of the file, that was not noted in the second option shown but you can see that in the file name with is Sales_Orders14. Due this local copy and editing of the file in OneNote, it is not updating the original file, if you open the original file, it will not have the updates you see in OneNote. Makes it almost, if not impossible, to use this workflow across computers and devices.
Hey thanks Andy for this. When embedding the Excel spreadsheet is there an option to make updates from WITHIN One note, or will it always open up the Excel spreadsheet when editing from within One Note? Thanks!
How do you add the spreadsheet in OneNote from your OneDrive so that as you are working on the Spreadsheet it autosave in OneNote?
Hi Andy,
Is there a way to choose what cells are shown in the embedded image of the spreadsheet within OneNote? It automatically shows the 7 or so columns and maybe the first 100 rows. What if I want the embedded image to only show 3 columns and 15 rows? Or 20 columns and 3 rows? When clicking "Select what to display" it only allows you to choose different sheets. Hoping there's a way to choose what is displayed in the embedded image...
Is the only workaround creating a table out of the data and selecting the table as what is displayed? What if you don't want the whole table displayed in the embedded image?
What do you think of DeepNotes?
Functionality doesn't seem to exist in Microsoft @OneNote for Mac? Wonder why.
I insert an existing spreadsheet but only the first page inserts. What do I need to do to insert the entire spreadsheet?
Where is the spreadsheet saved when you convert table in OneNote to Excel spreadsheet?
What version of OneNote are you using? My version doesn't have this functionality.
I'm using the latest OneNote app for Windows which can be downloaded here: www.onenote.com/download
Is it available for MacOs?
Why u stopped using Obsidian!
Hi - I continue to use Obsidian for specific research purposes. However, I don't use it for general note-taking or as a second brain.
@@AndyPark365 thanks for your reply I actually have a question for you regarding one note as when I make a sub group and open it in the mobile application you can't squeeze this subgroups and it's keep all the time open
🛑🛑🛑🛑 WARNING 🛑🛑🛑🛑🛑
First thing you should do is warn them that vba code WILL NOT RUN if the spreadsheet is run from onenote. I have been working for days changing security and macro settings and the code will not run.
🛑🛑🛑🛑