Microsoft Excel Ppt
- Microsoft Excel 2016 Ppt
- How To Use Microsoft Excel Ppt
- Microsoft Excel Ppt
- Microsoft Excel Introduction Ppt
- Excel For Beginners Ppt
- Tutorial Microsoft Excel Ppt
Microsoft Excel Worksheet is frequently used to collect, analyze and manipulate data. We mainly use Microsoft PowerPoint to make a professional presentation in front of our colleagues to present these analysis reports such as business plans, sales data, and financial reports created from Excel. So it is very important to know How to Convert Excel Worksheet to PowerPoint Slide. In this article you will learn how to convert Excel worksheet to PowerPoint slide with 6 ways.
Microsoft Excel Worksheet is frequently used to collect, analyze and manipulate data. We mainly use Microsoft PowerPoint to make a professional presentation in front of our colleagues to present these analysis reports such as business plans, sales data, and financial reports created from Excel. Customize PowerPoint for greater productivity by customizing the Microsoft Office Ribbon Master the most common uses of Word. How to controlling page appearance including using columns, indents, footers, borders and watermarks. Learn to create many types of documents. Microsoft PowerPoint presentation templates allow you to easily create professional presentations and pitch decks. Choose from hundreds of free presentation templates based on the subject matter of your presentation or stylistic preferences. These beautiful presentation templates help you communicate ideas, pitch proposals, or outline plans. Learn how to use Microsoft Excel, PowerPoint, and Word, online and for free by using an Office.com web apps acccount. You'll learn how to gain access to onli. Excel converts these dates to a numerical representation (1/22/2013 41301) Thus dates may be used in formulas: =A1–B1. Will result in the value. Note: To do arithmetic calculations with dates if you type = 1/27/2013-1/22/2013. Directly in a cell it does not interpret it a date – cell references must be used.
Outlines:
1. Copy and Paste Excel Data into PowerPoint
You can copy the data from Excel worksheet and paste them into the PowerPoint slide. But the data in the PowerPoint by copying and pasting will not be updated automatically if the data on the original Excel spreadsheet is changed.
Step 1. Open the Excel file, select the data that you want to copy by dragging the data area, go to Home and then click Copy.
Step 2. Open Microsoft PowerPoint and go to the slide that you want to paste the data, right click on the slide and then select the Paste Options from the drop-down menu.
Tips: There are five Paste options that you can choose: Use Destination Styles, Keep Source Formatting, Embed, Picture, Keep Text Only. You can move your mouse to each Paste option to see a preview effect of the template.
Step 3. Click Save to save changes after you complete.
Microsoft Excel 2016 Ppt
2. Link an Excel Worksheet to PowerPoint
To link an Excel spreadsheet to PowerPoint means that you insert the whole contents of the Excel file as an object to the PowerPoint. You can convert excel to PPT slide by following these steps.
Step 1. Open Microsoft PowerPoint and go to Insert tab, click Object button under the Text section.
Step 2. After Insert Object pops up on the screen, select Create from file.
How To Use Microsoft Excel Ppt
Step 3. Click the Browse button to locate to your Excel data that you want to insert to PowerPoint, tick the Link button and then click OK.
Tips: You can resize and rearrange the spreadsheet snapshot by grabbing the edges to make it bigger or smaller, or clicking and dragging to move it in the slide. If you double click on the spreadsheet, the file in Microsoft Excel will be opened.
3. Link a Section of Excel Data to PowerPoint
Microsoft Excel Ppt
Sometimes you don't want to link the whole content Excel data to the PowerPoint slide, you can link a section of data in Excel to PowerPoint by the following steps.
Step 1. Select and copy the data on the Excel file, open the target slide and go to Home and then click the inverted triangle under the Paste, select Paste Special (Ctrl + Alt + V).
Microsoft Excel Introduction Ppt
Step 2. In the dialogue box of Paste Special, select Paste Link, and choose Microsoft Excel Worksheet Object, and then click OK.
Tips: If the source Excel file is renamed by you or you move the source file to another location, the linked file would be unavailable. So the changes on the source Excel file will not be reflected and updated directly on the PowerPoint slides.
4. Embed an Excel Worksheet into PowerPoint
To embed an Excel worksheet in PowerPoint slide, there is no connection between each other. So updating the original Excel worksheet doesn't automatically update the data in the slide.
Step 1. Select and copy the data on Excel file, open the target slide, go to Home> Paste> Paste Special.
Step 2. In the dialogue box of Paste Special, select Paste, and choose Microsoft Excel Worksheet Object, and then click OK.
5. Export Excel Data into PowerPoint as an Image
If you don't want to change or update the data in the slide from the Excel file anymore, you can choose to convert Excel to PPT slide as a picture. Any change on the original Excel file will not be reflected on the PowerPoint slide.
Step 1. Select and copy the needed Excel data, locate to Home> Paste> Paste Special on the target PowerPoint slide.
Step 2. In the dialogue of Paste Special, select Paste, choose Picture (Enhanced Metafile), and then click OK.
6. Reproduce Excel Worksheet in PowerPoint
You can insert Excel data into PowerPoint by reproducing Excel data in PowerPoint.
Step 1. Open Microsoft PowerPoint and go to the target slide.
Excel For Beginners Ppt
Step 2. Go to the Insert tab and click the inverted triangle under the Table tab to define the table size.
Step 3. Select and copy the data on the Excel file, and then go back to PowerPoint slide and paste these data to the new table on it.