Excel to PowerPoint - What's the best way to do it? (Embedding, Linking or Other)

Lindsay asked what is the best way to move from Excel to PowerPoint? Do I recommend embedding Excel in PowerPoint, linking Excel to PowerPoint or something else? #Excel #PowerPoint
This video is my response, walking through the different options you have and what I recommend when moving from an Excel spreadsheet to a PowerPoint presentation (and why I recommend it).
🚀 UNLOCK the critical PowerPoint shortcuts trusted by industry leaders like KKR, American Express, HSBC, and more inside our free course here ► bit.ly/Learn-Critical-Shortcutss
VIDEO TABLE OF CONTENTS
0:00 Lindsay's PowerPoint question
1:28 Pasting Excel as a Picture
6:09 Embed Excel into PowerPoint
10:38 Link Excel to PowerPoint
14:24 Tricks for building tables in PowerPoint
18:33 Tricks for building charts in PowerPoint
SUBSCRIBE to get our latest PowerPoint tips and tricks bit.ly/PPT-Subscribe-Today
THE BEST PLACES TO FIND POWERPONT TEMPLATES ONLINE
► bit.ly/Slide-Cow-PowerPoint-T...
► bit.ly/Envato-Elements-for-Po...

[@esoterictime]

But how do update the damn data? Am i missing something? U just went off about formatting??

[@shoaib83professional]

I have been searching for this type of video related to excel and powepoint but couldnt find it. This videos is awesome. Great work man. Keep it up and make powerpoint table deep dive please.

[@thanhhung6201]

I especially love the template chart, it saves me ton of time really. Thanks for your helpful video,

[@yanarazhankova4282]

Great tips. That was one of the best organized and well explained videos I have seen for PowerPoint and Excel connection. Great job guys. I am really looking forward seeing the Deep Dive Chart Templates video. :)

[@yiweigu5999]

Great information. really looking forward to the episode for PowerPoint table deep dive!!

[@eastsidephoto]

great video man - well done!!

[@ketanskolhapure5529]

Thanks a ton Dear for wonderful session

[@torrancesorrell2848]

Glad to see I was already doing things most efficiently. Good tip on saving the chart template, wasn’t aware of that. Thanks!

[@Nutsandboltsspeedtraining]

Chart templates are an AWESOME way to save time in Word, PowerPoint, and Excel as they all feed from the same folder on your computer :)

[@roshanbhelke7669]

Excellent sir, i learn exactly what i want👍👍

[@dayanaguillen348]

OH my! I've become from basic ppt user to advance user in 22 minutes , thank you. Subscription to your channel right away!

[@TylerStanczak]

This is extremely helpful! Thank you for sharing this. I am going to use these tips when merging excel to PowerPoint :)

[@Nutsandboltsspeedtraining]

Glad it was helpful and thanks for the comment. Great to see another good PowerPoint channel running, keep up the good work!

[@TylerStanczak]

Nuts & Bolts Speed Training it was very helpful. You guys are very clear and easy to follow in your tutorials so it’s awesome to see. Also thank you for those kind words. Trying my best to provide helpful content. Still learning and growing from awesome creators like you guys :)

[@dataclashers]

Chart templates was an awesome trick. Thanks a lot.

[@Nutsandboltsspeedtraining]

That is one of the best kept PowerPoint secrets :)

[@jamestownsend8746]

Excellent Presentation

[@Nutsandboltsspeedtraining]

Thanks James! Glad you enjoyed the video.

[@ElzbietaZabicki]

Really useful video explaining the various options, I have a presentation with around 100 charts, all of which are built in PowerPoint. These are updated manually each month, could you give me (and others it seems) an idea of the most efficient way of updating them?

[@khristopher5161]

Brilliant video!

[@Nutsandboltsspeedtraining]

Thanks, glad you liked it!

[@gregbernard7861]

Really good video, I just liked and subscribed.

[@Nutsandboltsspeedtraining]

Glad you enjoyed the video, and welcome to our channel!

[@diydoc]

Great video - Building native charts and tables in Excel sounds good for individuals, but it does not work for team input on shared files. For example, if a team of people must inout data to various parts of a shared workbook, the best method I have found is to store both the shared workbook and target presentation in a SharePoint folder. Then, the Excel soyrce can be linked to the presentation via paste-link or a macro button to export to presentation on demand.

[@Semiam1]

Thanks!

[@RossMaynardProcessExcellence]

Excellent video. Question. I have a large table in Excel with a slicer. I want to paste and link the table and slicer into PowerPoint so that I can manipulate the table on the screen in PowerPoint using the slicer. Is that possible?

[@taryntarantino387]

Thank you so much for this! My team and I are very excited about the chart and table templates, but we also need to share with other teams. We could not figure out how to embed the chart templates in a document that is hosted online for multiple users. Can you point me in the right direction? PS even as a Mac user, I was able to make chart and table templates - yay!

[@Nutsandboltsspeedtraining]

Chart templates are saved to your own computer, so you need to share them with everyone. Shoot me a quick email at [e-mail] and let me know you want to share a chart template and I'll make a screenshot of where you need to go to do that.

[@Nutsandboltsspeedtraining]

If you need help fixing your broken link charts, I just made a video covering how to do that: kzbin.info/www/bejne/rnjHlJRorM56ebs

[@shockjay]

I also set up chart templates and find it extremely efficient and quick when using multiple charts in a document. I'm not as big a fan of using the table formatting styles in PowerPoint as I prefer to use paragraph and table styles in Word and copy them over in a similar manner to Excel. Nevertheless, this is a great video and something I may send to my co-workers as proof that copying in tables and charts is a bad idea.

[@Nutsandboltsspeedtraining]

Glad you enjoyed the video! Interesting that you are using the Word table styles and pasting them over, I will look more closely into that. Thanks for the tip!

[@MartinBarnes-hf9db]

Hey there! Can you do option 3, but when the excel file is actually saved as an object within the powerpoint? That would be awesome for sending to clients!

[@beck5469]

This is great! I did the link/embedding option but for some reason the right click to save it as a template does not work. I need to play around more but I like this channel, thank you!!

[@Nutsandboltsspeedtraining]

When right-clicking your chart, make sure you right-click it as an object. If you right-click something within the chart (like a series or an axis), you will not get the save as template option.

[@kevinwilson5539]

Yeah I kind of need to see the spreadsheet on the dialogue on your tires and tubes with your using for your threads for your embedding your links because they're magnetic and your kinetic energy should be matching with your threads and some should not be matching it should not be no kinetic energy in between your boards

[@tevol7448]

really useful thanks. But I was waiting for something about how to transfer data from excel to powerpoint having built the chart in ppt as you describe with templates etc (a tip I didn't know about). I've always found pasting data from excel into a chart created in powerpoint really difficult

[@Nutsandboltsspeedtraining]

Great question. The way I like to do it is to simply copy and paste the Excel data directly into the Excel spreadsheet behind your chart in PowerPoint. When doing this, I recommend using the match destination formatting option (the little paste option that appears in the lower right-hand corner). You might need to adjust the range as well so that the correct data is charted in PowerPoint. To see how to use the paste options button, check out my blog post here: nutsandboltsspeedtraining.com/paste-shortcut/

[@jackmcdonough7064]

When you build & format your tables natively in PowerPoint is the data still connected to an original excel file (similar to how the linking works)?

[@christiankarajanneh8291]

Same thought. I believe so, as once the data in excel is updated, the Pivot Table should be updated once refreshed and so is the chart next to it on excel. So then I believe it's the fastest way to copy and paste as an image and use the saved formatted chart template.

[@maherahmed1977]

I like your videos

[@Nutsandboltsspeedtraining]

Thanks! I appreciate the support.

[@pasolero]

Great tut video. Question: Do you know if we can add a shadow to a row and/or column in a PowerPoint table?

[@Nutsandboltsspeedtraining]

Great question. I am assuming you want to use the shadow to highlight the row. While you cannot add it to a single row or column, you can duplicate your table, delete everything but the row or column you want to highlight, overlay it on your original table (so it looks perfect) and then add the shadow to that single column or row table (which is over the top of your original table). That is a workaround you can use. Otherwise, I would just use formatting to highlight the row or column you want to highlight. I hope that helps!

[@pasolero]

@@Nutsandboltsspeedtraining Thanks for the tip. I'll give it a try. I'm trying to recreate a table I was given in a job assessment test and can't figure out how it's done. If you'd like, I can email you a picture of the table so you can see exactly what I meant. Thanks again for your time and dedication. Cheers!

[@moniquelabbe7318]

For tables - I would like to know how to create a default table in the master slides that doesn't exist in the suggested layouts with our branding colors.

[@Nutsandboltsspeedtraining]

Great question. The only way to do that is is through XLM code. While possible, unless you are very comfortable with coding, I don't recommend going this route as it can crash PowerPoint if you mess it up. To learn more, see the article here. www.brandwares.com/bestpractices/2015/07/xml-hacking-custom-table-styles/

[@williamaviles4962]

Hi great video. I have a question for you. can you link or connect a drop down list to a bar chart in PP or lock a slicer in excel bar chart and link it to PP?

[@PFAJ1]

Great video - I want to import an Excel doc (saved on MSFT Teams and accessible to other team members to make edits). Since it is in Teams and I and others can edit will this impact the data in the slide as you explain in the video?

[@kumard6451]

Does anyone remember there use to be a record macro option in the macro menu & what happened to it.?

[@tutsecret499]

Thank you very much. You fell off from heaven.

[@Nutsandboltsspeedtraining]

Glad to hear that I helped you out! You can always join my mailing list too if you want to learn my weekly PowerPoint tips and tricks.

[@fixy3657]

how to create a link from Excel to PPT but in slide number 2, 3, so on ? thank you

[@lazy3aboood910]

Plzzz we need the tables deep dive and tips & tricks in powerpoint

[@AbdulKareemAbdulRahman]

12:00 does this syncing occur for pivottables?

[@raziajeena9861]

V good. Is there to convert PPT to PDF and retain the animations?? Thanks

[@Nutsandboltsspeedtraining]

Unfortunately not. Converting PPT to PDF will retain your hyperlinks, but not your animations. You can check out my blog post to see what type of content works (and doesn't work) in the PPT to PDF conversion process. nutsandboltsspeedtraining.com/powerpoint-tutorials/ppt-to-pdf/

[@davidfringer4970]

Will the broken link happen if you have the Excel file saved in TEAMS/SharePoint or a shared network folder?

[@Nutsandboltsspeedtraining]

My guess is yes, but I recommend testing it out just in case I'm wrong. To test it out, copy and paste an Excel chart into PowerPoint (that is housed on your Teams/SharePoint server, send the deck to a colleague and ask them if they can edit the data. Let me know what happens as now I'm curious :)

[@gianlucabrilli5744]

there is a way to include xls file into ppt reducing time to upgrade the ppt when i reopen it?

[@Nutsandboltsspeedtraining]

You can embed your XLS document into PPT... just make sure that after you do that, you delete all the Excel tabs you don't want someone to have access to (as your entire spreadsheet will be embedded into PPT).

[@user-jk1eh2md5i]

Good day sir, Please how can I create chat and my figures on it

[@iqrazonecommerce6126]

How to give animation after taking excel file to power point?

[@Nutsandboltsspeedtraining]

Once you are in PowerPoint, using the Animations tab to animate your object. You cna see me add animations to an object in this video here: kzbin.info/www/bejne/jouboZiegt6Lers

[@mijemadalin]

Hi Is possible to: Embed an excel calculator, in Power Point, but to be able to open it and edit fields (cells) directly in Slideshow view of the presentation, instead of double click on the embedded excel in slide? For example, if I want to change some numbers for calculations, to be able to do it directly in SlideShow view In a simple way, I want to know if is possible to set: 3 cells, for example: One editable cell with: X One editable cell with: Y One editable cell with: Z ( being SUM(X,Y)) So once I am in Slideshow view of the presentation, I will be able to edit X and Y and Z to te calculated

[@Nutsandboltsspeedtraining]

Great question. Editing in Slide Show mode is still not possible. The best you can do is create the Slide Show mode view while still in the Normal View. Check out my other video for how to set that up: kzbin.info/www/bejne/npzWmap4f7lshNE

[@vishnupriyavenkataraman376]

Can we link excel file from sharepoint to the ppt in sharepoint?

[@Nutsandboltsspeedtraining]

That is a great question. I'm not very familiar with SharePoint, so I'm not 100% sure. Sorry.

[@creta6705]

I wanna automatically paste text into a presentation. Can somebody help me?

[@Nutsandboltsspeedtraining]

By automatically pasting text, what do you mean? If you want Excel to paste text into PowerPoint based on an action you take (like opening or closing a book), you will need to code up a macro using VBA.

[@jaichander87]

Hi! I need some help..I received a mail from my colleague. He send me the pptx file in which Excel file link. when i click those link it opens the excel file. How those files are open in my pc even if I don't have these files??. There is no file path is showing..plz help

[@NaveedSaeed1]

Thats because your friend embedded the charts/ Sheets in the PPT file :-D

[@jaichander87]

@@NaveedSaeed1 🙏 thanks bro 🙏

[@harshnaroliya9115]

how to remove that space 🤨

[@Nutsandboltsspeedtraining]

I think you mean the spaces that pop up in your tables when you copy from Excel into PowerPoint correct? My favorite way to remove spaces like that in tables is using Microsoft Word (bear with me). 1. Copy and paste your table (with all the extra spaces into Microsoft Word) 2. As you paste into word, make sure to select "keep source formatting" in the Paste Options 3. Select all the cells with extra spaces in them 4. Add bullet points in Word and then immediately take the bullet points away 5. Copy and paste your table back into PowerPoint For whatever reason, when you add bullet points in Word, Microsoft Word removes all the leading spaces. So, all you need to do is add bullet points and then remove them and POOF... all the spaces are gone :)

[@alex85hst]

Why people use PowerPoint's built-in data updating is beyond me. Just get a damn add-in.

[@Nutsandboltsspeedtraining]

Add-ins make this a lot easier for sure :)

[@devinpledger2251]

2:00 windows chipz S? what in the fuck does that mean

[@Nutsandboltsspeedtraining]

At 2:00 I say "Windows + Shift + S" which is the shortcut to take a screenshot on your computer. Sorry that was not clearer in the video.

[@devinpledger2251]

@@Nutsandboltsspeedtraining Haha I got it thanks

[@billsanders4]

Wtf did the chart come from ?????

[@Nutsandboltsspeedtraining]

The chart was just based on data I had in Excel. I didn't go through building the chart as that is a whole other process.

[@alexmckenzie8491]

Thanks but talks way too fast!

[@vardhanyadav11]

6ghh

[@Nutsandboltsspeedtraining]

Is that a shortcut you are quoting? Not sure what you mean by that.

[@saikatdas9237]

You confused me more than ever. Not good enough

[@robertozankan7707]

Great Information and Presentation! Really Useful Tips and Techniques. Love your logic behind doing everything in PowerPoint. Would love to see that Deep Dive on Tables that you mentioned in the video. Thanks!

[@Nutsandboltsspeedtraining]

Glad it was helpful! I will put the Table Deep Dive higher up on my list then. Cheers!