Excel is a widely used data analysis software. People use it to make decisions and insights on a given data set. Similarly, PowerPoint is an excellent presentation software. Sometimes, you might need to export your charts and data from Excel sheets to PowerPoint to present them to your boss or audience.
How to convert Excel to PowerPoint? This tutorial will help you learn to export Excel to PowerPoint in simple and easy steps.
Part 1. Step-by-step: Export Excel to PowerPoint (6 Common Ways)
There are different ways to export Excel data to PowerPoint. Some of these are listed below.
1. Copy and Paste Excel Data into PowerPoint
The simplest way to export data from Excel to PowerPoint is to copy and paste the Excel data into PowerPoint. You can simply copy desired cells or the whole worksheet and paste it onto the PowerPoint slide.
Step 1: Open the Excel sheet and copy your desired data.
Step 2: Open the PowerPoint, select your desired slide, and paste the copied cells.
Step 3: There are different paste options available, e.g., Use Destination Style, Keep Source formatting, Embed, Picture, and Text only. You can select any of them as per your needs.
2. Insert an Excel Object into PowerPoint
You can also insert Excel objects like charts and tables into PowerPoint using these steps.
Step 1: Open the Excel sheet and select and copy the desired object you want to insert into the PowerPoint. In our example, we are copying the graph from the Excel sheet.
Step 2: Open the PowerPoint and select the desired slide you want to insert the object and paste the object by pressing the Ctrl + V keys.
3. Link an Excel worksheet to PowerPoint
Linking an Excel sheet to PowerPoint helps to dynamically update the Excel sheet content in the PowerPoint as it is updated in the original worksheet. If you want to link an Excel sheet to PowerPoint, use the following steps.
Step 1: Open the PowerPoint presentation and select the desired slide you want to insert the object.
Step 2: In the Insert tab, click the Object option.
Step 3: In the Insert Object dialog box, select Create from file, browse for your desired Excel file, and then click OK.
Step 4: After selecting the desired Excel file, check the Link checkbox and click OK.
4. Export Excel Data into PowerPoint as an Image
If you do not want to reflect changes in the imported Excel sheet into PowerPoint, you can insert Excel data as an image. You can not edit or update the Excel data in the imported image in PowerPoint.
Step 1: Open the Excel sheet and select and copy the desired cells you want to export to PowerPoint. You can use Ctrl + C shortcut to copy the data.
Step 2: Open PowerPoint and select the desired slide where you wish to paste the desired cells. Right-click and select paste as a picture option from the different paste options available. You can darg and adjust this picture to fill the screen size.
5. Embed an Excel Worksheet into PowerPoint
You can also embed an Excel sheet into PowerPoint. To embed an Excel sheet, follow these steps.
Step 1: Open the Excel sheet and copy the desired data.
Step 2: Open the PowerPoint and click the Paste Special from Paste drop-down menu.
Step 3: In the Paste Special dialog box, select the Microsoft Excel Worksheet object and click OK.
The copied data will be embedded in the PowerPoint slide. Remember that you can not edit this data.
6. Reproduce Excel Worksheet in PowerPoint
You can also reproduce Excel data into PowePoint. Use the below steps to reproduce the data.
Step 1: Copy the data from the Excel file. Suppose we want to insert the table of COVID cases and masks sold.
Step 2: Open a PowerPoint Slide and go to the Insert option and click the drop-down menu under the Table icon. Select your required number of rows and cols as per the copied data from Excel.
Step 3: Paste the copied data from the Excel sheet in this table.
Part 2. How do I automatically update Excel charts in PowerPoint?
You can insert charts from Excel sheets into PowerPoint easily. These charts will be updated automatically in the PowerPoint as you change data in the Excel sheet. To do this, follow these steps.
Steps 1. Copy the chart from the Excel sheet. We are again using the chart of our previous example of maks sold and COVID Cases.
Step 2: Paste the chart into a PowerPoint slide by right-clicking on the slide and selecting the Use Destination theme and link data from the paste option.
Step 3: Now, change the data in the Excel sheet. Suppose we change the masks sold in December from 4200 to just 420. The change in the chart will be depicted in the PowerPoint chart also.
Part 3. Best Free Office Suite: WPS Office
WPS Office is the widely used Office solution nowadays. Billions of people use it worldwide. It is free to use and has powerful features. It is the best alternative to Microsoft Office also. The WPS Office suite contains the following software.
Writer - to create professional documents
PDF Editor - to open and edit PDF files
Spreadsheet - to create and edit Excel worksheets
Presentation - to create stunning PowerPoint slides
WPS Office has the following features and benefits that make it unique among all Office solutions available in the market.
Free to use
WPS Office is available for free. You can freely download it from its official website. There are no subscription charges. If you want to use the Business version of the WPS Office, there is a nominal cost associated with the Business version. The standard version is totally free to use, with all the basic and advanced features of Microsoft Office.
Cross-platform Availability
WPS Office is available for all major operating systems. You can use WPS Office on Windows, Mac, Linux, Android, and iOS devices.
Compatibility With MS Office
WPS Office is fully compatible with all file formats of MS Office. You can easily open all your MS Office and PDF files using WPS Office.
Frequently Asked Questions
1. How to copy and paste from Excel to PowerPoint without gridlines?
You can turn off the gridlines by going to the View option in PowerPoint and unchecking the Gridline checkbox.
Alt: Show or Hide Gridlines
2. How to paste a chart from Excel into PowerPoint without linking data?
You can copy the chart from the Excel file and paste it as a picture in the PowerPoint slide. The chart will be pasted as a picture only and will not be linked to the Excel sheet.
3. Why is my chart in PowerPoint not showing all data?
Sometimes the required data options are not selected in the Excel sheet, so they will not display in the PowerPoint. To show all data, just click the chart in the PowerPoint and go to the Design tab and click the Select Data option. The chart will be opened in Excel, and you can select the required data in the Excel sheet.
Export Excel To PowerPoint - Wrap Up
You can easily export Excel data to PowerPoint slides. You can export this data as an object or as a picture. You can also link the data back to the Excel sheet in Powerpoint to export Excel to Powerpoint automation. So that when the data is updated in the Excel sheet, the change is also depicted in the PowrPoint slide.
You can use WPS Office to export Excel to PowerPoint. WPS Office is a versatile and powerful Office solution for the modern world. It is an AI-powered Office solution that is free to use. You can download WPS Office for free from its official website.
