PowerPoint Excel Automation - Live Link Tables and Graphs
Вставка
- Опубліковано 29 сер 2024
- Newest subscriber ⭐ Teeah Nguyen ⭐
Subscriber goal ➡️ ||||||||||||||| 94% ||||||||||||||. 94.9K/100K ⬅️
🌟 Learn More PPT With Me: www.udemy.com/...
📖 Tutorial description: In this tutorial I will show you how to live link data between PowerPoint and Excel. Everytime you open your Excel file and update the data they will be reflected within PowerPoint. There will be a link between those files and any change (upon restarting Powerpoint) can be reflected both on tables and graphs from Excel.
📝 My Best PPT Courses:
● PowerPoint Masterclass: www.udemy.com/...
● Animated Explainer Videos: www.udemy.com/...
● Social Media Graphic Design: www.udemy.com/...
● Kinetic Typography: www.udemy.com/...
📌 Click to subscribe: www.youtube.com...
🎓 My mission:
I wish to enhance the design quality of presentations, animations and videos on the entire world, video by video. I love creating tutorials, video content and courses on that topic!
🔥 ENROLL TODAY 🔥 in my Course: rebrand.ly/PowerPointComplete
😉 THANKS for watching my tuts 👍
Nice reminder that PowerPoint should be interactive and can update data. I have not used this in a long time. Thank you.
Glad it was helpful! It's not perfect but at least its possible :D
Nice Presentation
Glad you liked it
THANKYOU YOU SAVE MY TIME AND WORK :D
Thank you very much Rafi Addarajad! Appreciate you watching and commenting, that helps! :)
Excelente video, vengo de Udemy saludos por tu curso!!
Hello Antonio, I don't understand spanish but thank you both for participating in the course and checking out my videos here, you are always welcome ;)
Is there any way when we need to change the name of excel file. The links need to be updated one by one. Is there any solution where all the links in ppt can be changed simultaneously.?
Perfect Andrew
This is what I'm looking for. Now I can link my data.
If you don't mind me asking, which software do you use to produce your UA-cam videos?
Awesome to hear. I use Camtasia2020 to edit and produce my vids. I should probably make a course specifically on that.
@@andrewpach Thanks for the quick response. I'd so welcome a video on Camtasia.
What version on PP is this? I cant seem to do this atm. but this would be a life saver!!
This is 2019 from 365 subscription, the Windows version!
Is there a way to link the data but not force the formatting? Often I don't want my PPT dashboard presentations to look like an Excel table
Maybe link just a part of the table (just the date) and format everything else around it and create some sort of table above those imported numbers so the "design" will be within powerpoint and data from excel
Great Work
THANK YOU DUDE
No problem Omar :)
What kind of computer are you working on? I'm on a macbook, but I am having challenges with linking the tables (no issues for charts/graphs).
Hello Jack, Windows, so the version is a bit different, that must be it :/ Sadly the MAC version has a couple of things that aren't implemented :/
Is there a way that I can unlink the data Powerpoint, then link the data to a new Powerpoint file? For context, I'm tracking data in an excel file - I make a presentation on the weekly basis and save a copy to create the next month structure of the presentation. Is there a way that I can edit the data in the new file, but the data in the old file stays the same.. (In Powerpoint Online)
It should work, but you would basically create a new table / chart so it's not really linking / unlinking I would say it's adding a new one and deleting the old one.
Is there a way where we can connect the PPT to excel where if I change number on ppt it updates here.
So I have a game to play and I want the scores to be added on the ppt itself instead of using excel
you would still need to refresh the powerpoint so I'm not entire sure if it's suitable for that purpose. I don't think it will update the way you want it to ;/
@@andrewpach sooo what I did was I made the excel sheet shared it to my personal drive on microsoft. Opened the game on zoom with the ppt sharing and updated the scores on the excel sheet from my phone
Hi Andrew,
Would it be possible to make an Isometric cube in Powerpoint as a picture layout?
There will be an image on each of the 3 sides.
I have sen 3D cube tutorials, but I m looking for an isometric view.
You kinda could skew and adjust pictures so they would appear as if in an isometric view but would be really difficult and unpractical. I don't think there is a smooth and useful way of doing this without getting angry haha
@@andrewpach
Well,that's disappointing to know.
I thought you would have a fix for it since u r so good at this.Love your content btw.
Thanks for the reply and keep up the good work.
@@andrewpach
One more query if u don't mind.
Can I convert a png file of Isometric cube(with transparent background) and convert that into a picture layout?
I tried doing it using 3 cartoon images(with transparent background) and its almost what i want but not perfect.
Hi Andrew May i know why some of my links work and some doesn't work?
This is difficult to answer via a comment not looking in a presentation and all the files directly, I think such technical issues should be discussed on the microsoft forum, you could head here --> answers.microsoft.com/