How to convert Excel to PowerPoint

On this tutorial, we are going to present you the way to convert an Excel spreadsheet to a PowerPoint slide. The Excel spreadsheet is commonly used together with PowerPoint displays to produce price range studies, enterprise plans, stock particulars, monetary studies, venture standing studies, and so on. Microsoft Excel spreadsheet is arguably probably the greatest instruments used for accounting and planning enterprise. We steadily use Excel sheets to analyze knowledge, plan occasions, plan audits, produce charts, calculate the price range, plan expenditures, and so on. To current these evaluation studies created from Excel, we primarily use Microsoft PowerPoint to make an expert presentation.

Each the Excel sheets and PowerPoint slides are used facet by facet and, we frequently copy the tables and charts from Excel, and paste them into PowerPoint slides to make a slideshow presentation. However, we often preserve updating the Excel tables with new knowledge commonly, and in circumstances like these, it’s inconvenient to change all of the tables in PowerPoint slides. This hindrance to updating the adjustments made within the Excel sheet to the PowerPoint slide may be averted by linking Excel knowledge with PowerPoint.

How to convert Excel to PowerPoint

Fortuitously, Microsoft permits you to use object linking and embedding methods also referred to as OLE to hyperlink the information from Excel spreadsheet to PowerPoint slides which might robotically replace Powerpoint displays everytime you make adjustments to Excel worksheet. On this case, the Excel sheet is a supply file, and the data from the Excel object is linked to the PowerPoint.That being mentioned, any adjustments to the supply file are mirrored immediately to the linked objects in PowerPoint. On this article, we clarify how to copy the information from an Excel worksheet and put it right into a PowerPoint presentation with built-in controls.

Copy and paste Excel knowledge in PowerPoint

You possibly can copy the information tables from the Excel spreadsheet and paste them into your PowerPoint presentation. Nonetheless, the information in PowerPoint just isn’t up to date robotically when the spreadsheet knowledge is modified or up to date.

Open Excel file you need to copy and choose all the information within the file that you really want to copy by dragging over the world of the information that you really want.

Go to House tab and click on Copy.

Now open Microsoft PowerPoint and open the slide presentation the place you need to paste the spreadsheet knowledge.

Proper-click on the slide and choose the Paste choice from the drop-down menu.

You possibly can change the presentation choices by clicking on the clipboard icon.

As soon as finished, click on Save to apply adjustments.

Hyperlink an Excel worksheet to PowerPoint

Linking an Excel spreadsheet to the PowerPoint will insert all of the contents of the file as an object into your PowerPoint presentation.

Open Microsoft PowerPoint and go to Insert tab

Click on Object underneath the Textual content part.

The Insert Object dialogue field pops up. Click on on the radio button with choice Create from file.

Click on the Browse button and choose the Excel spreadsheet whose knowledge you need to hyperlink to the Powerpoint.

Choose the Hyperlink field and click on Okay.

Resize the spreadsheet snapshot within the slide and double click on on the spreadsheet to open the file in Microsoft Excel.

Link a section of data in Excel to PowerPoint

Launch Microsoft Excel and open the spreadsheet that you want to link to PowerPoint.

Select the data you want to insert into the PowerPoint slide by dragging over the area of the data.

Go to the Home tab and click Copy.

Launch PowerPoint and open the PowerPoint slide where you want to insert the data.

Go to the Home tab and click on the arrow beside the Paste option.

Select Paste Special.

In the Paste Special dialogue box, click on the radio button with the option Paste Link and under Paste Link As, select Microsoft Excel Worksheet Object and click Ok.

It’s price mentioning that the above OLE method won’t work if the Excel supply file is renamed or for those who transfer the supply file from the unique location, because the hyperlink received’t find a way to search the file.

How to convert knowledge to graph in PowerPoint?

You can easily convert data to graph in PowerPoint. To do so, open PowerPoint and go to “Insert > Chart.” After that, a chart will be inserted into the selected slide and Microsoft Excel will be opened automatically containing the default data. You have to replace this default data with the actual data by using the copy-paste method.

Can you export Excel to image?

Yes, you can export Excel data to image. There are multiple ways to do that. Select the data in Excel that you want to export into an image, then click on the drop-down arrow next to the Copy option under the Home tab. Now, select the Copy as Picture option. The selected data in Excel will be copied to your clipboard as an image. Now, you can paste it into any image editing software like Microsoft Paint to save it as an image on your PC. Another method to do this is to use third-party tools to convert Excel into images.

That’s all.

Learn subsequent: How to add Movies and Bullet Factors to PowerPoint.