How to Create Automated Charts and Tables in PowerPoint from Excel
Vložit
- čas přidán 24. 07. 2024
- Did you know that whatever you create in Excel could be AUTOMATICALLY reflected in PowerPoint?
In this video you will learn how to create automated charts and tables in PowerPoint from Excel. I'll show a table and a graphic samples and will teach how to incorporate them into your presentation in a way that whenever you update your Excel, your Presentation will get automatically updated together! This trick will avoid you to waste tons of time in always copy/paste same table and same graphic to same deck over and over.
-----------------------------------------------------------------------------------------
Content Breakdown
Business Case & Intro: 0:00 - 1:17
Linking PowerPoint to Excel: 1:18 - 5:01
#4 Bonuses: 5:02 - 09:36
Thank You!: 09:37 - 09:58
-----------------------------------------------------------------------------------------
Features Explored in this Video
- PowerPoint and Excel Chart and Table Sync
- Checking which are all external links
- Fixing broken links - The annoying warning message
-----------------------------------------------------------------------------------------
Trick Stats
- Complexity: 1 out of 5
Doing Ctrl+C and Ctrl+V is really easy :)
- Performance: 5 out of 5
Because you are not going to concern [much] anymore with updating your decks every day over and over, your performance will enhance a lot!
- Organization/Control: 5 out of 5
You are AUTOMATICALLY get all your graphics and tables in sync with the Excel source, gaining a tremendous control in ensuring that no updates will be left behind
- Deliverable: 5 out of 5
For this video, this one goes hand-to-hand with organization. By having all graphics and tables updated, you are ensuring your presentation is the best in class! With real time contents to impress your audience all the time, along side with the expedited time you will have to get decks ready, you have now a awesome deliverable.
-----------------------------------------------------------------------------------------
A little background about myself
I'm a Program Manager working for a prestige world-wide IT and Telecom corporation, present in more than 100 countries and having more than 35 thousand employees. I'm 8 years working for this company and within this period I managed to grow from a technician to a Director and be relocated several times. All of these before 40's. I was only 35 years old when I was relocated to USA and only 36 years old when I was promoted to Direction level. My ultimate goal is to teach you my path, how I managed to do it, my right choices and the bad ones as well, to short the several years long corporate journey from expert to Director into just few years. Among several skills you have, dominating MS Office was one of the success keys to call attention to my efficiency, organization and outstanding results delivered.
-----------------------------------------------------------------------------------------
Let's get in touch
e-Mail: diogo@officetothepoint.com
Web: officetothepoint.com (Under Construction)
LinkedIn: / diogoroldao
CZcams: / @diogoroldao-officetot...
Instagram: / diogo_rpc
Facebook: / diogo.rpc
Twitter: / diogoroldao
-----------------------------------------------------------------------------------------
REFERENCES
Icons made by Freepik www.flaticon.com/authors/freepik
#PowerPoint #Excel #HowToCreateAutomatedChartsAndTables - Věda a technologie
Awesome contents and all of your videos are prepared very professionally. Kudos to your efforts. Looking forward to more such videos.
Thank you Anshuman! Such honor to hear from you! Subscribe to stay tuned! 😁
Glad to know
Glad to know
Awesome! Just what I need.
Excellent video, thanks!!
My pleasure, Darling! :)
It works! Thanks!
Glad to know!
Looking how to do this for ages thanks pal
Glad to know!
Really helpful! Can I though save the file without the links in order to keep an archive? I also want to send this ppt. but I want the ppt that I send to stay the same and not change every time I update the file. Is there a solution to this issue?
Looking for this info as well
Obrigado!
Really helpful. Many thanks. Trying to connect with you over LinkedIn but URL is not responding.
Your feedback is highly appreciated, @Yogesh! I'll check what is wrong with the URL, in meanwhile, here you have it: www.linkedin.com/in/diogoroldao/ ... or search for "Diogo Roldão Amdocs" on LinkedIn, you will find me there. Thank you!
Very nice, thank you! I have monthly tables I update to PowerPoint, but my main concern is that I never know how many rows they will be - sometimes it's half a slide, other times it takes two. Is there to ensure that PPT will take such factors into account and auto adjust?
Sorry man. Not as far as I know. When you integrate from Excel, it's a snapshot of that little range that you pre-selected. :( you saw my sample working right? If you add/remove rows in Excel, PowerPoint will not get it. What if you convert the data into Pivot Table and then try to sync the Pivot? Does it work better?
@@diogoroldao-officetothepoi610 thanks for replying! It sort of does, but unfortunately in most cases I need the full tables, sort of like a fancier report (akin to a pitchbook, yet still presented in-person instead of handout) instead of simply sending excel file along with the presentation. Basically I need the tables so we can deep dive and discuss certain details during these meetings, so it's not the most typical presentation format.
Hi, I'm linking the Pivot chart to my powerpoint and it work for me, however when i'm on presentation slide mode i try to filter my Pivot chart on my second screen it does not change. Do you have a solution for this? Would be great if you can solve my problem.
Yes. I have given similar answer to someone else here. The automated link with real time sync only works on the very first time you crate the link, onxs you close the files and open again the sync becomes manual (although MS says it's automated). The trick is to use 2 screens, on one of them you have your presentation ON and it's where you are sharing screen, on other screen you have the Excel and PowerPoint on the slide where the chart is linked. Once you update the Pivot and SAVE THE FILE in Excel, go to your PowerPoint, right click on he chart and chose (update link), once PowerPoint updates, your presentation also then gets updated. It's manual process however you can get it done without leaving the presentation mode.
👍👍👍👍
OK :P
👍🏻
Thx dear!