🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: th-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
Impossible Kevin!😱 My teacher was telling me about this on Saturday and I asked him if it would Auto-update, but he said he was not sure (no joke, I actually wanted to know a few days back)🤔. And you uploaded a tutorial on it immediately🔥🔥! We all have to admit that Kevin has a 6th sense of reading minds🧠🔥! Thanks a LOAD and please continue making such helpful tutorials and you will soon reach THE BIG GUY (1 Million)🙏 Whoever thinks Kevin will get 1Million subs by September 15th 👇 (I definitely think he will!)
I wanna link my Teeth and Kevin's Cookies. They are so tasty! Well, this is so similar to my reaction to having one of your cookies. It's gonna get in before you can think. "But wait, the magic is about to happen", got so curious...If there's something I want to learn from you it's everything. But then your storytelling is the next level. All excel videos I see are *boring* you make it so interesting. I'm loving this Kevin! More TH-cam videos? Yaaay! Let's do this!!!
These instructions are very clear. There is only one problem. When you follow them, they don''t work. In case it's not clear. 'don't work' means you can follow the instructions exactly but changes to excel do not show up in ppt. The smiles and upbeat attitude are nice but it would be even nicer of the product worked with way MS says it's supposed to. Does anyone, smiley or not, have suggstions on how to make this work?
No way! I always struggle to create tables and this feature is awesome. You are correct. This saves a lot of time. Can we also link an excel table to word, cause that would be awesome.
I felt this tutorial very useful to update the scores of teams after each round by entering into an excel sheet and linking into the powerpoint of the quiz. thanks a lot.
Kevin this is by far the best channel on TH-cam I love all this new stuff! I wouldn't even know to ask for half of it as I didn't know it existed. Thank you and keep the knowledge flowing :-)
Thank you for the work is greatly appreciated! I am trying to start using MS Project with Planner and Share point... Knowing how those all interacted between them, will be amazing! Thanks again and keep up the great energy!
Hi Kevin, From what I noticed, when the PowerPoint slides are closed and everything needs to be "refreshed" by clicking on edit data, any way to ensure that even the PowerPoint slides are re-opened the data still can auto-update? Else I have to keep my data open for both excel and ppt to ensure the synchronization exists.
Nice Kevin. Using this, I wonder if the dashboard you showed in previous videos should be stored in a linked ppt instead of a dedicated sheet of the xls where all the data are, simply for the global look of this dashboard you may set up with all powerpoint assets. You didn't tell us about the xls location: I suppose this file cannot be moved cause you would break the link right? Does it work while in fullscreen presentation mode? This would allow you to bring another kind of animation of your presentation! Also, does this work with Word?
Great video Kevin as usual. You are on you way to 1 million subscribers!!! Go Kevin go!!! You are my #1 virtual PROFESSOR @ TH-cam University regarding expanding my productivity skills with software. Cheers, Mario from Costa Rica.
I followed your instructions for inserting data from Excel into Powerpoint and it works as expected UNTIL I actually present the Powerpoint. Once in presenter mode, changing the Excel data dies nothing in Powerpoint. Help please.
Wow, that's great feature! Thanks for sharing + your thumbnail is too looking awesome. Well, when you are going to post a video on how to make attractive looking thumbnail?
Hi Kevin, thanks for this very useful tutorial! A question I'd like to ask, let's say I have a very long table to load to ppt and it requires 2-3 sheets for this long table, how to put this long table on those ppt sheets and can this table still connected to one another page on ppt? Thanks!
Hey Brother, I need help regarding this. I think you have seen some Top 10 type video where graph moves dynamically like 2010, 2011, 2012 what was the data. Is it possible to do same in Powerpoint?
Hi Kevin Thank you for all you Videos, really helpful. I love Pivot Charts because I could use different filters. Can I place Pivot Charts in PPt and use the filters?
One of these days, I think there will be a real "Kevin's Cookies Company" And all of these MS videos are just a clever ploy to build a brand following in order to be successful with minimal investment risk.
Kevin what if I had created a text box within the graph which shows the sum of values.. these remain still and doesn't change according to the change in excel values. Can you please suggest a fix for that 🥺 Many thanks! You rock!🤘
Thank you bro for the Tips....already subscibe and will support the channel..Hope god will give you the rewards coz of this tutorial realy helps a lots..
I have found that when linking graphs between Excel and PowerPoint in this manner is less than reliable when using cloud based documents. However, inserting graphs as a linked picture has proved much more reliable and sufficient for reporting needs.
Serious comment this time : what you explain is only half the equation, how to save time when building the presentation, which is great and useful. But now I want to share an instance of the presentation that is locked in time, and I also need to archive it as auditable evidence. What’s the best way to do so ? How to avoid slides from previous quarters to be updated automatically when I look at them in the future ?
Hello, Thank you for the video. Its very helpful. I have one question. If I email the powerpoint as an attachment, do I have to include the excel or will powerpoint remember the last time data was updated?
Thanks Kevin. The whole “Excel to PowerPoint” path still feels a bit inelegant to me. What would be really helpful is having a “template link” so I could save and retain monthly iterations of Excel and PowerPoint links and keep them independent of one another. I would simply reuse the template to creat another month. Make sense? This has been a thorn in my side for a long time. Creating decks for upper management from our source workbooks takes way too much time. Any thoughts?
I have the problem that I can only link one table not two, as soon as I want to paste another table the excel crashes. and also if I update the excel data it does not update in powerpoint. only if I double click on the table in powerpoint it opens another excel file that seemes to be embedded and here it does update. please help :)
Hi Kevin, do we have option to link Excel in cloud or web to PowerPoint. So when someone makes any changes to Excel, table/chart in PowerPoint also gets updated
Hi Kevin , Good Video! I created entire presentation in PPT last months and it happened correctly. But , recently I am facing an issue. When I am clicking on Paste link , the data is not coming on PPT slides. Other all options are working under paste special except paste link. Any idea? is there anything about version?
Kevin this is great, i have created this but used 25 data sets with field manager names on slicers so the data changes on the powerpoint from a slicer. Is there a way that i can make muitple people access and make changes to access them self
THis is excellent Kevin, thank you. Issue I am having is that after the first day, the sync between is broken and I have to refresh data from PP each time. However, when I have the Excel file open, PP throws an error and will only allow me to refresh when the Excel file is closed. Is this expected functionality?
🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: th-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
I've learned more on Kevin's TH-cam video's than I ever did in school at no cost. Did I mention that I'm still paying my tuition to SDSU(:
😂
Now I can create one PowerPoint file and use it forever. Thank you for this awesome tutorial.
Impossible Kevin!😱 My teacher was telling me about this on Saturday and I asked him if it would Auto-update, but he said he was not sure (no joke, I actually wanted to know a few days back)🤔. And you uploaded a tutorial on it immediately🔥🔥! We all have to admit that Kevin has a 6th sense of reading minds🧠🔥! Thanks a LOAD and please continue making such helpful tutorials and you will soon reach THE BIG GUY (1 Million)🙏
Whoever thinks Kevin will get 1Million subs by September 15th 👇 (I definitely think he will!)
I wanna link my Teeth and Kevin's Cookies. They are so tasty! Well, this is so similar to my reaction to having one of your cookies. It's gonna get in before you can think. "But wait, the magic is about to happen", got so curious...If there's something I want to learn from you it's everything. But then your storytelling is the next level. All excel videos I see are *boring* you make it so interesting. I'm loving this Kevin! More TH-cam videos? Yaaay! Let's do this!!!
Glad to see that you are being so active on TH-cam
These instructions are very clear. There is only one problem. When you follow them, they don''t work. In case it's not clear. 'don't work' means you can follow the instructions exactly but changes to excel do not show up in ppt. The smiles and upbeat attitude are nice but it would be even nicer of the product worked with way MS says it's supposed to. Does anyone, smiley or not, have suggstions on how to make this work?
this might work on a specific version of excel.
No way! I always struggle to create tables and this feature is awesome. You are correct. This saves a lot of time. Can we also link an excel table to word, cause that would be awesome.
i needed this and ou made it...looks like you were speaking to my heart..
Wait, what?! Such a easy way?? I never thought this would be possible!! Thanks a lot for the video
Hi Kevin, usually I am watching your videos. Today I am very happy because you mentioned my very small Country in this video. Thanks Dear for that.
First comment 🤭........love your videos.....helped me a lot....btw new subscriber 🙂🤗
Thanks Kevin for this super useful video! Love the way you simplify and present the topic, keep up the great work! 😊👍
Thank you for making easier our business lives!
You just made my life a little easier. Thanks Kevin!
Thanks Kevin for this video 👍
I felt this tutorial very useful to update the scores of teams after each round by entering into an excel sheet and linking into the powerpoint of the quiz. thanks a lot.
Kevin this is by far the best channel on TH-cam I love all this new stuff! I wouldn't even know to ask for half of it as I didn't know it existed. Thank you and keep the knowledge flowing :-)
Dude, you saved me so much time!!!!!! thanks a lot!
I love your cookie company! 😅😅 Love from Bangladesh.
This guy is a robot right?
Soon ✨️1Million Subscribes🎗️
Well Done Kevin Startvert 🌝💟
Kevin is a legend 👏
Excellent presentation; very useful information. Please post more such useful videos.
that was time well spent, thanks!
Thanks, Kevin.... These tips are going to help me a lot.
Thank you!! I was struggling trying to figure this out
Amazing! Thanks!
I’d previously done some VBA to copy charts into my weekly reports, but this is so much neater and easy to update!!
You made my work a lot easier... Thanks
Wow! That is a really great feature! 😁👍 Thanks Kevin, If it wasn't for you, I wouldn't even have known! 😁😁
Thank you for the work is greatly appreciated! I am trying to start using MS Project with Planner and Share point... Knowing how those all interacted between them, will be amazing! Thanks again and keep up the great energy!
Great Presentation Mr. Kevin. Tq
Excellent video. Solved my problem. Thank you.
You are coming up with very fresh topics!
Please post on how to transfer data from excel to SPSS!
Tks , Kevin . amazing class .
Hi Kevin,
From what I noticed, when the PowerPoint slides are closed and everything needs to be "refreshed" by clicking on edit data, any way to ensure that even the PowerPoint slides are re-opened the data still can auto-update? Else I have to keep my data open for both excel and ppt to ensure the synchronization exists.
Great presentation with story telling and aha moment .
0:00 - Hi Kevin. 👋
6:07 - 426th thumbs up from me. 👍 Cheers.
Amazing video! thanks so much
Very well explained. Thanks to you pal.
Thank you Sir!!! Nicely Done!!!
Great video Kevin!
Hey Kevin
Have a question. It worked great for files on desktop but did not for files on sharepoint / onedrive. Any pointers? Thanks
Thank you, the video was very helpful and saved a lot of time
Thank you very much Kevin for such these good videos :)
Nice Kevin.
Using this, I wonder if the dashboard you showed in previous videos should be stored in a linked ppt instead of a dedicated sheet of the xls where all the data are, simply for the global look of this dashboard you may set up with all powerpoint assets.
You didn't tell us about the xls location: I suppose this file cannot be moved cause you would break the link right?
Does it work while in fullscreen presentation mode? This would allow you to bring another kind of animation of your presentation!
Also, does this work with Word?
almost at 1 million!!!!!!!
Great video Kevin as usual. You are on you way to 1 million subscribers!!! Go Kevin go!!! You are my #1 virtual PROFESSOR @ TH-cam University regarding expanding my productivity skills with software. Cheers, Mario from Costa Rica.
magnifico
Great help, thanks!
Great hint, thanks a lot !
Worthy info
It was very useful.
Thanks a lot
Great video as always.
Thanks so much brother for sharing 😊❤️
I followed your instructions for inserting data from Excel into Powerpoint and it works as expected UNTIL I actually present the Powerpoint. Once in presenter mode, changing the Excel data dies nothing in Powerpoint. Help please.
I don't know from where you learn this everything but you are Incredible, from Sangamitra. J . Patel
Always informative
Wow, that's great feature! Thanks for sharing + your thumbnail is too looking awesome. Well, when you are going to post a video on how to make attractive looking thumbnail?
🤣🤣🤣🤣🤣
Hi Kevin, thanks for this very useful tutorial!
A question I'd like to ask, let's say I have a very long table to load to ppt and it requires 2-3 sheets for this long table, how to put this long table on those ppt sheets and can this table still connected to one another page on ppt? Thanks!
thank you. it's best video 🙏👍
Thank You So Much
Hey Brother, I need help regarding this. I think you have seen some Top 10 type video where graph moves dynamically like 2010, 2011, 2012 what was the data. Is it possible to do same in Powerpoint?
Hi Kevin
Thank you for all you Videos, really helpful.
I love Pivot Charts because I could use different filters.
Can I place Pivot Charts in PPt and use the filters?
This is awesome!
Thank you!!
Thank you for your sharing... it is very helpful...
Thank you!
You are really genius Kevin. How can we make a stickman in PowerPoint?
One of these days, I think there will be a real "Kevin's Cookies Company" And all of these MS videos are just a clever ploy to build a brand following in order to be successful with minimal investment risk.
Kevin what if I had created a text box within the graph which shows the sum of values.. these remain still and doesn't change according to the change in excel values. Can you please suggest a fix for that 🥺 Many thanks! You rock!🤘
Nice work!
Thank you so much... 💝
The best👍🏻
Your videos rock!
Really amazing, thanks a lot
thanks Kevin
Thank you bro for the Tips....already subscibe and will support the channel..Hope god will give you the rewards coz of this tutorial realy helps a lots..
Thank you
I have found that when linking graphs between Excel and PowerPoint in this manner is less than reliable when using cloud based documents. However, inserting graphs as a linked picture has proved much more reliable and sufficient for reporting needs.
Informative
Awesome video
On Mac there seems to be no option for paste link. The powerpoint does not update when the excel changes. Any ideas?
Bump- same question for mac users
Yes, buy a windows machine.
Loved it
Serious comment this time : what you explain is only half the equation, how to save time when building the presentation, which is great and useful.
But now I want to share an instance of the presentation that is locked in time, and I also need to archive it as auditable evidence.
What’s the best way to do so ? How to avoid slides from previous quarters to be updated automatically when I look at them in the future ?
Is it possible to go to 'edit links' and break the link for the quarterly file that you want to keep static?
Hello, Thank you for the video. Its very helpful. I have one question. If I email the powerpoint as an attachment, do I have to include the excel or will powerpoint remember the last time data was updated?
Amazing, thanks for sharing. Do you know how to link 7 days of weather forest from a certain website?
Thanks Brother
Thanks Kevin. The whole “Excel to PowerPoint” path still feels a bit inelegant to me. What would be really helpful is having a “template link” so I could save and retain monthly iterations of Excel and PowerPoint links and keep them independent of one another. I would simply reuse the template to creat another month. Make sense? This has been a thorn in my side for a long time. Creating decks for upper management from our source workbooks takes way too much time. Any thoughts?
Hey Nick, check out this ppt add-in Called Grunt. It does what you described.
I have the problem that I can only link one table not two, as soon as I want to paste another table the excel crashes. and also if I update the excel data it does not update in powerpoint. only if I double click on the table in powerpoint it opens another excel file that seemes to be embedded and here it does update. please help :)
Amazing!
Hi Kevin, do we have option to link Excel in cloud or web to PowerPoint. So when someone makes any changes to Excel, table/chart in PowerPoint also gets updated
thanks very userfull tips
Hi Kevin , Good Video! I created entire presentation in PPT last months and it happened correctly. But , recently I am facing an issue. When I am clicking on Paste link , the data is not coming on PPT slides. Other all options are working under paste special except paste link. Any idea? is there anything about version?
Genius!
1st comment
Kevin this is great, i have created this but used 25 data sets with field manager names on slicers so the data changes on the powerpoint from a slicer. Is there a way that i can make muitple people access and make changes to access them self
Very helpful your video..can we add more excel sheet in ppt slides
THis is excellent Kevin, thank you.
Issue I am having is that after the first day, the sync between is broken and I have to refresh data from PP each time. However, when I have the Excel file open, PP throws an error and will only allow me to refresh when the Excel file is closed. Is this expected functionality?
thanks