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

Подписаться 54 тыс.

Просмотров 159 тыс.

50% 1

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...

Опубликовано:

9 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 87

@esoterictime 3 года назад

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

@thanhhung6201 2 года назад

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

@shoaib83professional 2 года назад

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.

@TylerStanczak 3 года назад

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

@Nutsandboltsspeedtraining 3 года назад

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

@TylerStanczak 3 года назад

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 :)

@yanarazhankova4282 3 года назад

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 2 года назад

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

@eastsidephoto 3 года назад

great video man - well done!!

@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 3 года назад

Excellent sir, i learn exactly what i want👍👍

@dayanaguillen348 3 года назад

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

@ketanskolhapure5529 2 года назад

Thanks a ton Dear for wonderful session

@RossMaynardProcessExcellence 2 года назад

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?

@Semiam1 2 года назад

Thanks!

@dataclashers 2 года назад

Chart templates was an awesome trick. Thanks a lot.

@Nutsandboltsspeedtraining 2 года назад

That is one of the best kept PowerPoint secrets :)

@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?

@fixy3657 Год назад

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

@jamestownsend8746 2 года назад

Excellent Presentation

@Nutsandboltsspeedtraining Год назад

Thanks James! Glad you enjoyed the video.

@khristopher5161 2 года назад

Brilliant video!

@Nutsandboltsspeedtraining 2 года назад

Thanks, glad you liked it!

@kumard6451 2 года назад

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

@shockjay 3 года назад

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 3 года назад

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!

@gregbernard7861 Год назад

Really good video, I just liked and subscribed.

@Nutsandboltsspeedtraining Год назад

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

@AbdulKareemAbdulRahman 4 месяца назад

12:00 does this syncing occur for pivottables?

@jackmcdonough7064 3 года назад

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 3 года назад

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.

@moniquelabbe7318 3 года назад

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 3 года назад

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/

@pasolero 2 года назад

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

@Nutsandboltsspeedtraining 2 года назад

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 2 года назад

@@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!

@diydoc 10 месяцев назад

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.

@beck5469 2 года назад

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.

@tevol7448 2 года назад

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 2 года назад

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/

@raziajeena9861 3 года назад

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

@Nutsandboltsspeedtraining 3 года назад

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/

@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!

@taryntarantino387 2 месяца назад

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 taylor@nutsandboltsspeedtraining.com 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.

@williamaviles4962 3 года назад

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?

@maherahmed1977 3 года назад

I like your videos

@Nutsandboltsspeedtraining 3 года назад

Thanks! I appreciate the support.

@PFAJ1 3 года назад

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?

@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 4 месяца назад

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).

@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.

@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

@user-jk1eh2md5i 4 месяца назад

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

@mijemadalin 2 года назад

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 2 года назад

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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-hkshwBJT9No.html

@iqrazonecommerce6126 2 месяца назад

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

@Nutsandboltsspeedtraining 27 дней назад

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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-XZ8pehMyXDY.html

@Nutsandboltsspeedtraining Месяц назад

If you need help fixing your broken link charts, I just made a video covering how to do that: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xGdca2wiGCY.html

@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.

@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.

@lazy3aboood910 2 года назад

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

@jaichander87 3 года назад

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 3 года назад

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

@jaichander87 3 года назад

@@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 :)

@FreeSoloPCgamer Год назад

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.

@FreeSoloPCgamer Год назад

@@Nutsandboltsspeedtraining Haha I got it thanks

@alex85hst 3 месяца назад

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 :)

@billsanders4 2 года назад

Wtf did the chart come from ?????

@Nutsandboltsspeedtraining 2 года назад

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.

@vardhanyadav11 4 месяца назад

6ghh

@Nutsandboltsspeedtraining 4 месяца назад

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

@alexmckenzie8491 3 года назад

Thanks but talks way too fast!

@saikatdas9237 2 года назад

You confused me more than ever. Not good enough

@robertozankan7707 3 года назад

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 3 года назад

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