power point presentation to excel

Convert PowerPoint to Excel

Converting powerpoint to excel - top tools and techniques.

Now Convert your PowerPoint to Excel for free.

In this article, I am going to show you how to convert PowerPoint to Excel by exporting data from presentations to spreadsheets in a fast and efficient way. Moreover, I will also review several important tools and approaches popular among professionals.

Before jumping right to the point, let's review the advantages of the aforementioned office applications and some popular reasons behind converting PowerPoint slides into Excel tables.

PowerPoint is a popular office software designed to create electronic presentations consisting of a series of separate pages or slides. Excel is an essential application that features calculation or computation capabilities, graphing tools, pivot tables, and more. PowerPoint document is used for making presentations, whereas Excel is the most helpful for capturing, tracking, and analyzing data with the help of graphical charts.

In most cases, graphical information needs to be transferred from slides into Excel sheet for displaying and processing data, as well as producing insights. For instance, you have a few tables full of important business data in your PowerPoint file, your desire is to transfer those tables directly into spreadsheets and preserve all formats in order to further analyze the data. In other cases, you may need to collect multiple tables from PPT slides and design a chart to present such data effectively.

How to Convert PowerPoint to Excel

Converting PowerPoint to Excel is not a struggle, there are a great number of methods and tools available to assist you.

Technique 1: inserting PowerPoint Presentation into Excel spreadsheet

First, a PowerPoint presentation can be embedded right into Microsoft Excel. All it takes is to insert the PowerPoint file as an object that should link your data to the spreadsheet. Follow these steps to convert PPT to XLSX.

Open your Excel file that you are dealing with, and click on the "Insert" > "Object".

Select and insert your PowerPoint file: in the window that pops-up, click on the "Create from file" tab and then click on "Browse" to select your PPT file. Pick your PowerPoint presentation and then click "Insert". Hit OK to complete the process of embedding the PowerPoint file into an Excel spreadsheet.

Review your PowerPoint file in Excel. The presentation will appear on a spreadsheet as an image. Just double-click on the image to start playing your PowerPoint presentation. Click on the "Escape" button to return to your Excel spreadsheet.

Unfortunately, this approach will not allow you to modify and process data from your slides in Excel. Thus, consider using some alternative solutions below, if your goal is data manipulation.

Technique 2: copying data from PPT presentation to Excel

In some cases, you can simply select the data from your table on a slide, copy it, and paste it into Microsoft Excel for further processing. The spreadsheet application should recognize numeric data automatically, otherwise, you can set the correct format manually. This method is not the easiest one, and it takes time, however, it does the job well.

How to Convert PowerPoint to Excel Online (technique 3)

Important data from a plethora of PowerPoint presentations can be exported to Excel spreadsheets online for free, thanks to a variety of web applications. You can find and try some of these services on the Internet with Google.

To convert PowerPoint to Excel online:

Pick a suitable web service, such as Aspose.app, and open it in your browser;
Upload your PPT files from your device and set preferences, such as formats and data recognition mode;
Wait until the conversion process is finished and download your file formats in Excel. That is it!

The downside is a lot of people complain that such a technique lacks accuracy, some data is not identified properly, and formats may be adjusted as well.

But here is the kicker: some web converters support OCR or optical character recognition that allows recognizing numeric and text data in images that can't be selected and copied with a standard office suite. Hence, make sure to pick PowerPoint to Excel online converter that provides OCR functionality, this will increase the accuracy of data transferring between these formats.

What's the bottom line?

There is still a gap between PowerPoint and Excel, which hinder the process of data exchanging and processing. Luckily, now you know several proven approaches to convert PowerPoint to Excel offline and online, feel free to test all of them along with free online converters to pick the one that serves your needs well.

All trademarks, logos, and brand names are the property of their respective owners.

Terms and Conditions

Privacy Notice

Cookie Settings

Attributions.

Arrow icons created by Creative Stall Premium - Flaticon
Document icons created by DinosoftLabs - Flaticon
Artificial intelligence icons created by Freepik - Flaticon
Checklist icons created by Freepik - Flaticon
Empty icons created by Freepik - Flaticon
Failure icons created by Freepik - Flaticon
Foursquare check in icons created by hqrloveq - Flaticon
Nothing icons created by LAFS - Flaticon
Excel icons created by Pixel perfect - Flaticon
Word icons created by Pixel perfect - Flaticon
Jpg icons created by Smashicons - Flaticon
Pdf icons created by Smashicons - Flaticon
Png icons created by Smashicons - Flaticon
Microsoft Excel 2019 icon by Icons8

We use cookies to enhance your browsing experience, personalize content and ads, and analyze our traffic. You can choose which types of cookies you want to allow on our website by using the options below. You can change your settings at any time by clicking on the cookie icon at the bottom of the page. For more information, please read our privacy policy .

Necessary: These cookies are essential for the website to function properly and cannot be switched off. They are usually only set in response to your actions, such as logging in, filling in forms, or making payments. You can set your browser to block or alert you about these cookies, but some parts of the site may not work then.
Preferences: These cookies enable the website to remember your preferences, such as your language, region, or layout. They are set by us or by third-party providers whose services we have added to our pages. If you do not allow these cookies, some or all of these services may not function properly.
Analytics: These cookies help us understand how visitors interact with our website by collecting and reporting anonymous information, such as the number of visitors, the pages they visit, and the duration of their stay. They are used to measure and improve the performance of our website and provide insights for optimization.
Marketing: These cookies are used by us or our partners to deliver relevant and personalized ads to you across different websites and devices. They are also used to limit the number of times you see an ad and to measure the effectiveness of advertising campaigns. They track your online activity and store information about your interests and preferences. If you do not allow these cookies, you will experience less targeted advertising.

PDFelement for Windows
PDFelement for Mac
PDFelement on Mac App Store
PDF Reader for Windows
PDFelement for iPhone/iPad
Get from App Store
PDFelement for Android
Get from App Google Play
PDF Scanner for iPhone

Cloud & SDK

Document Cloud
PDFelement Pro DC
PDFelement SDK

Online PDF Tools

PDF to Word
Compress PDF
Word to PDF

Educational Users

Annotate PDF
Combine PDF

Personal Users

Convert PDF
Organize PDF

Professional Users

eSign PDFs Legally
Extract Data from PDF
Password Protect PDF

PDF Solutions for

Chat with PDF
AI PDF Summarizer
AI PDF Translator
AI Content Detector
AI Rewrite PDF
Proofread PDF
Add Bookmarks to PDF
Explain PDF
Mac Software
OCR PDF Tips
Online PDF Tips
Edit PDF like Word
PDF Converter Tips
PDF Compressor Tips

Why PDFelement

Customer Stories
PDF Software Comparison
Contact Support
PDFelement for iOS
InstaScan for iPhone

Explore More

Reviews See what our users say.
Free PDF Templates Edit, print, and customize free templates.
PDF Knowledge PDF-related information you need.
Download Center Download the most powerful and simple PDF tools.
Download Download Pricing Pricing

Four Methods to Convert PowerPoint to Excel

Elise Williams

2024-05-22 13:36:15 • Filed to: PowerPoint Tips • Proven solutions

Learning how to convert PowerPoint to Excel proves to be very hard for a lot of people, and sometimes we may need to convert the graphical information into excel in order to display and manage data. In this article you will learn how to convert PowerPoint to excel in a fast and efficient way, ensuring you become an expert in converting PowerPoint to excel by just following these steps.

How to Convert PowerPoint to Excel with PDFelement

The first method you should try is a file converter. Wondershare PDFelement - PDF Editor can not only convert files to PDF, but also PowerPoint to Excel, Excel to PowerPoint, Word to Excel, Excel to Word, etc.

Step 1. Open the Powerpoint File Using PDFelement

Open PDFlelement and then click on the “Create a PDF” box to select the PowerPoint files you want to convert.

Step 2. Convert PowerPoint to Excel

Before converting, you need to go to the “File”> “Save as” button to save your PowerPoint file into a pdf. Then you can click on the "Convert"> "To Excel" option to achieve the conversion.

Step 3. Save the File

After cilcking "To Excel", a window pops up, and you can choose an output folder you want to save your file into, and then select the "Save" button.

An All-in-One PPT to Excel Converter

When it comes to PDF convertors, Wondershare PDFelement - PDF Editor is currently the best in the market. It comes packed with a set of useful features, making users can do a variety of different tasks, such as PDF creation, annotation, conversion, editing, protection and signature, and so on.

You can create a pdf by converting files from different formats into pdf, and edit scanned pdf files without going back to the source files. In addition, PDFelement allows you to restrict printing or copying of files by employing the feature of protection and signature so that it ensures recipients are able to validate document authenticity and integrity by adding certified digital signatures. More features found on PDFelement include reviewing documents, forms, OCR and so on.

How to Convert PowerPoint to Excel by Inserting Files

Converting PowerPoint to Excel is not hard, and Microsoft has put in place features that will allow you to easily convert your ppt to excel. A user has to convert the PowerPoint to an object in order to link the ppt file to excel. The following are the steps that you can follow and use to convert PowerPoint documents into excel with images.

Step 1. Open the Excel File

Open the Excel file that you are working on, and click on the “Insert”> “Object” option.

Step 2. Select the PowerPoint File

After clicking on the “Object” menu, a window will pop up, and then you need to click on the “Create from file” tab since you are importing a PowerPoint file that already exists. Next, you can click on “Browse” to select your file.

Step 3. Insert the PowerPoint File

Now a window pops up, and you can select the PowerPoint file you want to import and then click “Insert”. After finishing choosing, you can click "OK".

Step 4. View the PowerPoint File

At this time, the PowerPoint document will appear as an image in the excel document. You can double click on the image which will then start playing your PowerPoint presentation, and you can click on the “Escape” button so that it will then return to your excel spreadsheet.

How to Convert PowerPoint to Excel by Copying

Converting a PowerPoint presentation (PPT) into an Excel spreadsheet can be easily done by copying and pasting your PowerPoint content directly into Excel. You can convert tables, diagrams, and other design elements from PowerPoint to Excel using this method. However, be aware that the original formatting of these elements might not transfer perfectly, so you may need to adjust the formatting manually.

Step 1. Copy from a PowerPoint Slide

Open your PowerPoint file and select the data you want to transfer to Excel. Right-click on the selected content and choose "Copy."

Step 2. Paste PowerPoint Content into Excel Spreadsheet

Switch to your Excel spreadsheet. Right-click on a cell where you want to paste the content and select "Paste Special" or "Keep Formatting" to maintain the original look. Repeat this process for all the content you wish to transfer. Finally, remember to click the "Save" button to save your PowerPoint content as an Excel file.

How to Convert PowerPoint to Excel Online

If you need to convert a PowerPoint file into Excel format, you can easily do so using online PPT to Excel converters. These tools are user-friendly and require no software installation. However, be aware that the conversion process may alter your formatting.

Step 1. Upload A File to Online PPT to Excel Converter

Navigate to an online converter like Online2PDF PowerPoint to Excel. Click on "Select Files" and upload your PowerPoint file.

Step 2. Convert PPT to Excel Online

You can choose either XLSX or XLS format and click "Convert."

Step 3. Download the Converted Excel File

Once the conversion is complete, the converter will generate the Excel file. Simply click "Download" to save the converted file to your device.

Free Download or Buy PDFelement right now!

Buy PDFelement right now!

chief Editor

Speak Your Mind

How to convert PPT to XLS

Learn how to easily convert PowerPoint presentations (PPT) to Excel spreadsheets (XLS) in this comprehensive guide.

In today's digital age, there is a growing need for converting PowerPoint presentations (PPT) to Excel spreadsheets (XLS). Whether you're a business professional, a student, or a data enthusiast, understanding how to convert PPT to XLS can prove to be a valuable skill. In this article, we will explore the advantages of PPT to XLS conversion, common scenarios where it is required, and different methods to achieve this task.

Understanding the need for converting PPT to XLS

Before diving into the conversion methods, let's take a moment to understand why converting PPT to XLS can be beneficial. While slideshows are widely used to visually present information, spreadsheets offer a structured way to organize and analyze data. By converting a PPT file to an XLS format, you can harness the power of Excel's formulas, functions, and data manipulation capabilities. This conversion allows you to extract data from your presentations and perform complex calculations, create charts, track trends, and much more.

But why stop there? Let's explore in more detail the advantages of converting PPT to XLS.

The advantages of converting PPT to XLS

Converting PPT to XLS opens up a world of possibilities. Here are some advantages:

Data Analysis: Excel's robust features enable you to analyze data in ways that PowerPoint cannot. With formulas, filters, and pivot tables at your disposal, you can gain valuable insights from your presentation data.
Data Manipulation: In XLS format, you can easily manipulate and rearrange the data from your presentation to suit your specific needs. Whether you need to sort, filter, or calculate new values, Excel empowers you with the tools to do so efficiently.
Improved Collaboration: With Excel, you can collaborate with others seamlessly. By converting your PPT to XLS, you can share the data in a format that allows for easier collaboration, making it simpler for others to view and edit the information, add comments, or make suggestions.

Now that we've explored the advantages, let's delve into some common scenarios where PPT to XLS conversion is required.

Common scenarios where PPT to XLS conversion is required

PPT to XLS conversion can come in handy in various scenarios. Let's explore some common situations:

Data Extraction: Imagine you have a PPT presentation containing multiple slides with sales figures, customer feedback, or survey responses. Converting this PPT to XLS enables you to extract the underlying data, making it easier to analyze and work with the information.
Financial Analysis: For financial professionals, converting PPT to XLS allows for in-depth financial analysis. You can consolidate financial data from multiple presentations into one spreadsheet, perform calculations, create visualizations, and generate accurate reports.
Research and Surveys: Researchers and surveyors often collect data through PPT presentations. By converting the PPT to XLS, they can efficiently manage data, perform statistical analysis, and identify patterns and trends.

As you can see, the conversion from PPT to XLS offers numerous advantages and can be applied in various real-life scenarios. So, whether you're a business professional, researcher, or financial analyst, understanding the need for converting PPT to XLS can greatly enhance your data management and analysis capabilities.

Exploring different methods for converting PPT to XLS

Now that we understand the significance of PPT to XLS conversion, let's explore different methods to achieve this task. These methods vary in terms of tools used, complexity, and the available features.

Method 1: Using Microsoft PowerPoint

If you have Microsoft PowerPoint installed on your computer, you can utilize its built-in functionality to convert a PPT file to XLS. Follow these steps:

Step 1: Open the PowerPoint presentation that you want to convert.
Step 2: Go to the "File" menu and select "Save As".
Step 3: Choose the desired location to save the file and specify the file name.
Step 4: In the "Save as type" dropdown menu, select "Excel Workbook (*.xlsx)".
Step 5: Click on the "Save" button to convert and save the PPT file as an XLS file.
Step 6: Customize the conversion settings, such as selecting the sheet format and specifying whether to include speaker notes or slide thumbnails.

By following these steps, you can convert your PPT presentation to an XLS format using the power of Microsoft PowerPoint.

Microsoft PowerPoint is a widely used presentation software that offers a range of features for creating visually appealing slideshows. With its built-in conversion functionality, users can easily transform their PPT files into XLS files, allowing for seamless integration with spreadsheet applications like Microsoft Excel.

Method 2: Using online conversion tools

Online conversion tools offer a convenient way to convert PPT to XLS without the need to install any software. Here's how you can do it:

Step 1: Choose a reliable online conversion tool such as "Convertio" or "Zamzar".
Step 2: Upload the PPT file to the selected online tool.
Step 3: Select "Excel" or "XLS" as the output format.
Step 4: Click on the "Convert" button and wait for the conversion process to complete.
Step 5: Download the converted XLS file to your computer.

Using online conversion tools provides flexibility and convenience for users who prefer not to use installed software for their conversion needs. These tools often support a wide range of file formats and offer additional features such as batch conversion, file compression, and even cloud storage integration.

Convertio and Zamzar are just two examples of the many online conversion tools available. These platforms are designed to simplify the conversion process and ensure that users can quickly and easily convert their PPT files to XLS format without any hassle.

Method 3: Using third-party software

For advanced users and those requiring specialized features, third-party software offers additional capabilities for PPT to XLS conversion. There are several software options available, such as "Adobe Acrobat" and "Wondershare PDFelement". These tools often provide more control over the conversion process and may include features like batch conversion, custom layout settings, or OCR (Optical Character Recognition) support.

Adobe Acrobat is a comprehensive software suite that offers a wide range of features for working with PDF files. In addition to its PDF editing capabilities, Adobe Acrobat also allows users to convert PPT files to XLS format, providing a seamless workflow for professionals who frequently deal with both presentation and spreadsheet files.

Wondershare PDFelement is another powerful software tool that enables users to convert PPT files to XLS format. With its intuitive interface and advanced features, PDFelement offers a user-friendly experience for individuals looking to convert their presentations to spreadsheets. Its OCR support allows for accurate conversion of scanned documents, ensuring that all text and data is preserved during the conversion process.

These third-party software options provide advanced functionality and customization options for users who require more control over their PPT to XLS conversion. Whether you need to convert multiple files at once or fine-tune the layout of your converted spreadsheet, these tools can cater to your specific needs.

Step-by-step guide for converting PPT to XLS using Microsoft PowerPoint

If you prefer using Microsoft PowerPoint for your PPT to XLS conversion, here's a step-by-step guide to help you:

Step 1: Opening the PowerPoint presentation

Launch Microsoft PowerPoint and open the PPT file that you want to convert. Ensure that the presentation is saved on your computer or accessible through the cloud.

Step 2: Exporting the presentation as XLS

Click on the "File" menu and select "Save As". Choose the location where you want to save the converted XLS file and specify a name for it.

Step 3: Customizing the conversion settings

In the "Save as type" dropdown menu, select "Excel Workbook (*.xlsx)". You can also customize the conversion settings, such as selecting the sheet format and specifying whether to include speaker notes or slide thumbnails. Once you've made your selections, click on the "Save" button to begin the conversion process.

Converting PPT to XLS with online conversion tools

If you prefer the convenience of online conversion tools, follow these steps:

Choosing a reliable online conversion tool

Explore various online conversion tools and choose one that suits your requirements. Ensure that the tool supports PPT to XLS conversion and offers a secure and user-friendly interface.

Step-by-step process of using an online conversion tool

Upload the PPT file to the selected online tool and select "Excel" or "XLS" as the output format. Proceed with the conversion process, and once completed, download the resulting XLS file to your computer.

Tips for ensuring accurate conversion results

Here are some tips to ensure accurate and reliable conversion results:

Content Format: Ensure that your PPT slides follow a consistent format, especially when dealing with complex content such as tables, charts, or images. A consistent format helps maintain the integrity of the converted XLS file.
Data Structure: Pay attention to the structure of your PPT presentation. Use consistent naming conventions for slide titles, sections, and data labels to make it easier to interpret and organize the data in the Excel spreadsheet.
Data Validation: After converting PPT to XLS, review the data in the Excel spreadsheet for accuracy and integrity. Double-check formulas, verify calculations, and validate data entries to ensure the converted data is reliable.

With these methods and tips at your disposal, you now have the tools and knowledge to convert PowerPoint presentations into Excel spreadsheets. Open up a world of possibilities by leveraging the power of Excel's data analysis capabilities. Start converting your PPT files to XLS today and unlock the true potential of your data!

Add WordArt to a slide Video
Add hyperlinks to slides Video
Import a Word outline Video
Check spelling Video
Add a table Video
Insert Excel data Video
Split a table Video

Insert Excel data

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

In PowerPoint, you can embed tables and worksheets from Excel in your presentation slides.

In Excel, click and drag to highlight the cells you want to copy.

Right-click the copied cells and select Copy .

In your PowerPoint presentation, right-click and select the Paste Options you want:

Use Destination Styles – Choose to edit your copied cells like a PowerPoint table, but with PowerPoint's color scheme and fonts.

Keep Source Formatting – Choose to keep your table editable in PowerPoint while maintaining the same source formatting from Excel.

Embed – Choose to keep a copy of your table in PowerPoint in case you want to edit the data, which will open in Excel.

Note: If you're working with a large Excel file, it'll inflate your PowerPoint presentation to a big size. You may also unintentionally be giving more access to your Excel file than you intend to.

Picture – Choose to paste your table as a picture to get the same benefits as embedding except you can format your cells like a picture and add effects to it. You won’t be able to edit data once it’s been pasted though.

Keep Text Only – Choose to paste your table as straight text and to do all formatting in PowerPoint.

If you pasted as a picture, on the Picture Tools Format tab, select the quick picture style you want to use. Adjust the table to your liking.

Insert Excel data in PowerPoint

Copy an Excel chart to another Office program

Need more help?

Want more options.

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Ask the Microsoft Community

Microsoft Tech Community

Windows Insiders

Microsoft 365 Insiders

Was this information helpful?

Thank you for your feedback.

How-To Geek

How to link or embed an excel worksheet in a powerpoint presentation.

Your changes have been saved

Email Is sent

Please verify your email address.

You’ve reached your account maximum for followed topics.

Moto Tag Is an AirTag Clone for Android Users

Today's nyt connections hints and answer for june 26 (#381), 7 tips to use your massive android phone one-handed, quick links, what's the difference between linking and embedding, how to link or embed an excel worksheet in microsoft powerpoint.

Sometimes, you want to include the data on an Excel spreadsheet in a Microsoft PowerPoint presentation. There are a couple of ways to do this, depending on whether or not you want to maintain a connection with the source Excel sheet. Let's take a look.

You actually have three options for including a spreadsheet in a PowerPoint presentation. The first is by simply copying that data from the spreadsheet, and then pasting it into the target document. This works okay, but all it really does is convert the data to a simple table in PowerPoint. You can use PowerPoint's basic table formatting tools on it, but you can't use any of Excel's features after the conversion.

While that can be useful sometimes, your other two options---linking and embedding---are much more powerful, and are what we're going to show you how to do in this article. Both are pretty similar, in that you end up inserting an actual Excel spreadsheet in your target presentation. It will look like an Excel sheet, and you can use Excel's tools to manipulate it. The difference comes in how these two options treat their connection to that original Excel spreadsheet:

If you link an Excel worksheet in a presentation, the target presentation and the original Excel sheet maintain a connection. If you update the Excel file, those updates get automatically reflected in the target presentation.
If you embed an Excel worksheet in a presentation, that connection is broken. Updating the original Excel sheet does not automatically update the data in the target presentation.

There are advantages to both methods, of course. One advantage of linking a document (other than maintaining the connection) is that it keeps your PowerPoint presentation's file size down, because the data is mostly still stored in the Excel sheet and only displayed in PowerPoint. One disadvantage is that the original spreadsheet file needs to stay in the same location. If it doesn't, you'll have to link it again. And since it relies on the link to the original spreadsheet, it's not so useful if you need to distribute the presentation to people who don't have access to that location.

Embedding that data, on the other hand, increases the size of presentation, because all that Excel data is actually embedded into the PowerPoint file. There are some distinct advantages to embedding, though. For example, if you're distributing that presentation to people who might not have access to the original Excel sheet, or if the presentation needs to show that Excel sheet at a specific point in time (rather than getting updated), embedding (and breaking the connection to the original sheet) makes more sense.

So, with all that in mind, let's take a look at how to link and embed an Excel Sheet in Microsoft PowerPoint.

Linking or embedding an Excel worksheet into a PowerPoint presentation is actually pretty straightforward, and the process for doing either is almost identical. Start by opening both the Excel worksheet and the PowerPoint presentation you want to edit at the same time.

In Excel, select the cells you want to link or embed. If you would like to link or embed the entire worksheet, click on the box at the juncture of the rows and columns in the top left-hand corner to select the whole sheet.

Copy those cells by pressing CTRL+C in Windows or Command+C in macOS. You can also right-click any selected cell, and then choose the "Copy" option on the context menu.

Now, switch to your PowerPoint presentation and click to place the insertion point where you would like the linked or embedded material to go. On Home tab of the Ribbon, click the down arrow beneath the "Paste" button, and then choose the "Paste Special" command from the dropdown menu.

This opens the Paste Special window. And it's here where you'll find the only functional different in the processes of linking or embedding a file.

If you want to embed your spreadsheet, choose the "Paste" option over on the left. If you want to link your spreadsheet, choose the "Paste Link" option instead. Seriously, that's it. This process is otherwise identical.

Whichever option you choose, you'll next select the "Microsoft Excel Worksheet Object" in the box to the right, and then click the "OK" button.

And you'll see your Excel sheet (or the cells you selected) in your PowerPoint presentation.

If you linked the Excel data, you can't edit it directly in PowerPoint, but you can double-click anywhere on it to open the original spreadsheet file. And any updates you make to that original spreadsheet are then reflected in your PowerPoint presentation.

If you embedded the Excel data, you can edit it directly in PowerPoint. Double-click anywhere in the spreadsheet and you'll stay in the same PowerPoint window, but the PowerPoint Ribbon gets replaced by the Excel Ribbon and you can access all the Excel functionality. It's kind of cool.

And when you want to stop editing the spreadsheet and go back to your PowerPoint controls, just click anywhere outside the spreadsheet.

Microsoft Office
Microsoft Excel

How to Convert PowerPoint to Excel

Converting PowerPoint presentations to Excel spreadsheets can be useful for extracting and analyzing data from slides. There are a few methods to convert PPT files to Excel.

Why Convert PowerPoint to Excel

Methods to convert powerpoint to excel, insert powerpoint as object in excel, copy-paste slides as images.

You can copy slides as images and paste them into an Excel worksheet:

Cons : Loses slide formatting, can’t update from source

Export PowerPoint Table Data

Cons : Only works for tables, not charts/images

Convert via PDF (Add-ins Required)

Pros : Retains formatting, editable Excel output

Automate with Macros or Scripts

Scripts in Python, C#, or other languages can also automate conversion.

Pros : Saves time for batch processing

Linking Excel and PowerPoint

Rather than doing a one-time conversion, you can link Excel data to PowerPoint for automatic updates:

Recommendations

About the author, vegaslide staff, related posts, how to share a powerpoint presentation: a step-by-step guide, how to create an animated gif from powerpoint slides – ppt to gif, how to flip image vertically or horizontally in powerpoint, how to create a hyperlink in powerpoint 2010.

Microsoft 365 Basic now includes ransomware protection for your files and photos at no extra cost.

Use Word, Excel, PowerPoint and more for free on the web

Office is now Microsoft 365

Get the free Microsoft 365 mobile app*

Start using Microsoft 365 today

Anywhere access

Whether you’re at work or on the go, create your best work on your favorite browser.

Familiar experience

The familiar Microsoft 365 experience you know and trust, so there’s nothing new to learn.

Work with anyone

Share your documents with anyone and work together in real-time.

A laptop screen displaying a Word document with multiple authors editing in Word on the web

Word for the web

Craft great-looking resumes, newsletters, and documents while inviting others to review and coauthor in real time. Plus, access free Word templates, formatting tools for APA, MLA, and Chicago style, and add functionality with free add-ins.

Excel for the web

Organize your data in familiar spreadsheets and workbooks, with all changes saved automatically. Create modern visuals that turn numbers into valuable insights. Work together in real time knowing that everyone is on the same page.

A laptop displaying colorful charts and graphs in Excel on the web

PowerPoint for the web

Turn your ideas into compelling presentations using professional-looking templates. Use animations, transitions, photos, and videos to tell one-of-a-kind stories. Co-author team presentations at the same time, from anywhere.

Start now at Microsoft365.com

No installation required. It's free.

* Availability of mobile apps varies by country/region.

Follow Microsoft 365

Chat with sales
Contact sales

Available M-F 9 AM to 6 PM.

GroupDocs.Total Product Family
GroupDocs.Viewer Product Solution
GroupDocs.Annotation Product Solution
GroupDocs.Conversion Product Solution
GroupDocs.Comparison Product Solution
GroupDocs.Signature Product Solution
GroupDocs.Assembly Product Solution
GroupDocs.Metadata Product Solution
GroupDocs.Search Product Solution
GroupDocs.Parser Product Solution
GroupDocs.Watermark Product Solution
GroupDocs.Editor Product Solution
GroupDocs.Merger Product Solution
GroupDocs.Redaction Product Solution
GroupDocs.Classification Product Solution
GroupDocs.Splitter Product Solution
GroupDocs.Translation Product Solution
GroupDocs.Rewriter Product Solution
GroupDocs.Unlock Product Solution
Source Code
Free Support
Free Download
Free Consulting
aspose.cloud
groupdocs.com
groupdocs.cloud
groupdocs.app
conholdate.com
conholdate.cloud
conholdate.app
Acquisition
Select language
GroupDocs Products
Conversion App
Convert PPT to XLSX

PPT to XLSX converter

Convert ppt to xlsx online from any device with a free converter..

By uploading your files or using our service you agree with our Terms of Service and Privacy Policy .

Your file has been converted successfully

Conversion that you requested produced empty result, send the download link to, about conversion app.

Convert your PPT files online. You can convert your PPT documents from any platform (Windows, Linux, macOS). No registration needed. Just drag and drop your PPT file on upload form, choose the desired output format and click convert button. Once conversion completed you can download your XLSX file.

You even can perform more advanced conversions. For example you can convert password protected documents. Just expand LoadOptions and enter the password of your file. Or you can add a watermark to the converted XLSX file. Expand the ConvertOptions and fill the fields for watermarking.

You can convert your PPT documents from anywhere, from any machine or even from a mobile device. The PPT converter is always available online and is completely free.

Convert WORD to PDF, EXCEL to PDF, PDF to WORD, POWERPOINT to IMAGE, VSDX to PDF, HTML to DOCX,EPUB to PDF, RTF to DOCX, XPS to PDF, ODT to DOCX, ODP to PPTX and many more document formats
Simple way to instant convert PPT to XLSX
Convert PPT from anywhere - it works on all platforms including Windows, MacOS, Android and iOS

How to convert PPT to XLSX

Questions & answers.

How can I convert PPT? First, you need to add a file for conversion: drag & drop your PPT file or click inside the white area to choose a file. Then click the "Convert" button. When PPT to XLSX conversion is completed, you can download your XLSX file.
How long does it take to convert PPT? This converter works fast. You can change PPT in a few seconds.
Is it safe to convert PPT to XLSX using our free converter? Of course! The download link of XLSX files will be available instantly after conversion. We delete uploaded files after 24 hours and the download links will stop working after this time period. No one has access to your files. File conversion (including PPT) is absolutely safe.
Can I convert PPT to XLSX on Linux, Mac OS or Android? Yes, you can use our free PPT to XLSX converter on any operating system that has a web browser. Our PPT to XLSX converter works online and does not require any software installation.
What browser should I use to convert PPT? You can use any modern browser to convert PPT, for example, Google Chrome, Firefox, Opera, Safari.
How can I get the source code for PPT to XLSX conversion? Detailed examples are available at GitHub in the form of executable projects. If you are only interested in PPT to XLSX conversion then check .NET & Java examples.

PowerPoint Presentation

A file with PPT extension represents PowerPoint file that consists of a collection of slides for displaying as SlideShow. It specifies the Binary File Format used by Microsoft PowerPoint 97-2003. A PPT file can contain several different types of information such as text, bulleted points, images, multimedia and other embedded OLE objects. Microsoft came up with newer file format for PowerPoint, known as PPTX, from 2007 onwards that is based on Office OpenXML and is different from this binary file format.

Microsoft Excel Open XML Spreadsheet

XLSX is well-known format for Microsoft Excel documents that was introduced by Microsoft with the release of Microsoft Office 2007. Based on structure organized according to the Open Packaging Conventions as outlined in Part 2 of the OOXML standard ECMA-376, the new format is a zip package that contains a number of XML files. The underlying structure and files can be examined by simply unzipping the .xlsx file.

Other Supported Conversions

You can also convert PPT into many other file formats. Please see the complete list below.

PPT TO XLS Converter Microsoft Excel Binary File Format
PPT TO XLSM Converter Microsoft Excel Macro-Enabled Spreadsheet
PPT TO XLSB Converter Microsoft Excel Binary Spreadsheet File
PPT TO ODS Converter Open Document Spreadsheet
PPT TO XLTX Converter Microsoft Excel Open XML Template
PPT TO XLT Converter Microsoft Excel Template
PPT TO XLTM Converter Microsoft Excel Macro-Enabled Template
PPT TO TSV Converter Tab Separated Values File
PPT TO XLAM Converter Microsoft Excel Macro-Enabled Add-In
PPT TO CSV Converter Comma Separated Values File
PPT TO FODS Converter OpenDocument Flat XML Spreadsheet
PPT TO SXC Converter StarOffice Calc Spreadsheet
PPT TO PS Converter PostScript (PS)
PPT TO PCL Converter Printer Command Language Document
PPT TO HTM Converter Hypertext Markup Language File
PPT TO HTML Converter Hyper Text Markup Language
PPT TO MHTML Converter MIME Encapsulation of Aggregate HTML
PPT TO MHT Converter MIME Encapsulation of Aggregate HTML
PPT TO PDF Converter Portable Document
PPT TO EPUB Converter Digital E-Book File Format
PPT TO MOBI Converter Mobipocket eBook
PPT TO AZW3 Converter Kindle eBook format
PPT TO EPS Converter Encapsulated PostScript File
Convert PPT TO XPS Open XML Paper Specification
Convert PPT TO TEX LaTeX Source Document
Convert PPT TO DOC Microsoft Word Document
Convert PPT TO DOCM Microsoft Word Macro-Enabled Document
Convert PPT TO DOCX Microsoft Word Open XML Document
Convert PPT TO DOT Microsoft Word Document Template
Convert PPT TO DOTM Microsoft Word Macro-Enabled Template
Convert PPT TO DOTX Word Open XML Document Template
Convert PPT TO RTF Rich Text File Format
Convert PPT TO ODT Open Document Text
Convert PPT TO OTT Open Document Template
Convert PPT TO TXT Plain Text File Format
Convert PPT TO MD Markdown
Convert PPT TO PPT PowerPoint Presentation
Convert PPT TO PPS Microsoft PowerPoint Slide Show
Convert PPT TO PPTX PowerPoint Open XML Presentation
Convert PPT TO PPSX PowerPoint Open XML Slide Show
Convert PPT TO ODP OpenDocument Presentation File Format
Convert PPT TO OTP Origin Graph Template
Convert PPT TO POTX Microsoft PowerPoint Open XML Template
Convert PPT TO POT PowerPoint Template
Convert PPT TO POTM Microsoft PowerPoint Template
Convert PPT TO PPTM Microsoft PowerPoint Presentation
PPT TO PPSM Conversion Microsoft PowerPoint Slide Show
PPT TO FODP Conversion OpenDocument Flat XML Presentation
PPT TO SVG Conversion Scalable Vector Graphics File
PPT TO TIFF Conversion Tagged Image File Format
PPT TO TIF Conversion Tagged Image File Format
PPT TO JPG Conversion Joint Photographic Expert Group Image File
PPT TO JPEG Conversion JPEG Image
PPT TO PNG Conversion Portable Network Graphic
PPT TO GIF Conversion Graphical Interchange Format File
PPT TO BMP Conversion Bitmap File Format
PPT TO ICO Conversion Microsoft Icon File
PPT TO PSD Conversion Adobe Photoshop Document
PPT TO WMF Conversion Windows Metafile
PPT TO EMF Conversion Enhanced Metafile Format
PPT TO DCM Conversion DICOM Image
PPT TO DICOM Conversion Digital Imaging and Communications in Medicine
PPT TO WEBP Conversion Raster Web Image File Format
PPT TO JP2 Conversion JPEG 2000 Core Image File
PPT TO EMZ Conversion Enhanced Windows Metafile Compressed
PPT TO WMZ Conversion Windows Metafile Compressed
PPT TO SVGZ Conversion Compressed Scalable Vector Graphics File
PPT TO TGA Conversion Targa Graphic
PPT TO PSB Conversion Adobe Photoshop Image File

APIs available

Convert popular document and image file formats in your app. The GroupDocs.Conversion APIs are available for .NET, Java, and many other platforms and languages.

GroupDocs online applications

Classification
Translation

Select a language

አማርኛ
العربية
Български
Català
Čeština
Ελληνικά
Español
فارسی
Français
עברית
हिन्दी
Հայերեն
日本語
Ქართული
Қазақ Тілі
한국어
Lietuvių
Latviešu
Português
Română
Русский
Slovenčina
Slovenščina
ไทย
Türkçe
Українська
اردو
Tiếng Việt
中文(简体)
中文(繁體)

How to Embed an Excel File in PowerPoint (5 Easy Ways)

Here’s an overview of how data will be presented from Excel into PowerPoint.

How to Embed an Excel File in PowerPoint: 5 Suitable Examples

Let’s assume we have a “ Sales Data for Fruits ” dataset, which includes the Product ID , Fruits , States , and Sales amount under columns B , C , D , and E respectively.

Method 1 – Embedding an Entire Excel File in PowerPoint

Select the Insert tab on the Ribbon in PowerPoint.
Click on the Object command on the Text group of commands.

clicking on Object feature in Insert tab

In the Insert Object dialog box, click on the radio button of Create from file option.
Choose the Browse… button.

In the Browse window, select your desired file and click OK .

selecting excel file to be embedded in powerpoint

You can see your file path and name in the highlighted box. Click OK .

Inserting exel file as object in powerpoint

Note: Don’t check the box before the Link option to embed the Excel file .

Make sure to attach your intended data on the first page of the Excel file.

Read More: How to Perform Excel to PowerPoint Automation

Method 2 – Embedding a Section of Excel Data in PowerPoint File

Open the Excel file and select the range of data (e.g. C4:E14 ) you want to embed.
Press CTRL + C on your keyboard to copy this range.

copy portion of data with keyboard shortcut in excel file

Open your PowerPoint slide and navigate to the Home tab.
Click on the Paste drop-down option and then click on Paste Special .

Select Paste and click on Microsoft Excel Worksheet Object . Press OK .

The selected range is copied to the presentation file.

section of Excel data embedded in powerpoint file

Method 3 – Utilizing Embed Command to Add Unlinked Excel File

Select the dataset (e.g. B4:E14 ) and right-click.
Click on the Copy command from the context menu.

copying selected range using copy command on context menu

Use the Paste drop-down option in PowerPoint.
Choose Embed (E) from Paste Options .

using Embed as paste options to embed excel file in powerpoint

The output in PowerPoint is as follows.

Method 4 – Applying Camera Gadget Tool to Embed Data as Image

Click on the triangular-shaped Customize Quick Access Toolbar icon and select More Commands .

selecting more commands from customize quick access toolbar menu

This will bring a dialog box as follows. Click on the drop-down icon beside the Popular Command bar to get more options. Then pick Commands Not in the Ribbon from the available options.

To bring the Camera tool to the right side, select Camera and click the Add button in the middle.

This will allow you to have a Camera icon in the Toolbar . Now you’re ready to take snaps of the selected area by using the Camera tool.

Select the region you want to copy and press the Camera icon.

Left click anywhere to get an image.

image taken by camera tool in Excel file

Copy the image by selecting it and pressing Ctrl + C command.
Paste the output in the presentation slide as follows:

use keep source formatting and embed option to paste image

Remember that the embedded portion is an image.

Read More: How to Link Excel Data to PowerPoint Chart

Method 5 – Embedding an Excel Chart in PowerPoint File

Charts are perhaps the most commonly-used Excel format in PowerPoint.

Copy the Excel chart with Ctrl+ C command.
Paste the chart into the PowerPoint slide by using Keep Source Formatting & Embed Workbook , one of the Paste Options .

using a paste option to paste chart in powerpoint file

Finally, the output in the presentation slide is as follows:

column chart of exel file embed in powerpoint

Embed Vs. Link an Excel File in PowerPoint

When you want to add an Excel file to a PowerPoint presentation, you have two options: embedding or linking the file. Here’s a brief overview of the differences between the two:

Embedding an Excel file in PowerPoint means that a copy of the file is saved within the PowerPoint presentation itself. This can make your presentation larger in file size, but it also means that you don’t need the original Excel file to view or present the data. Any changes made to the original Excel file won’t be reflected in the embedded copy within PowerPoint.
Linking an Excel file to PowerPoint means that the presentation will display data from the original Excel file. This keeps the file size of the presentation smaller and ensures that any changes made to the Excel file are reflected in the PowerPoint presentation. However, if the Excel file is moved or deleted, the links will be broken and the data won’t display correctly in the presentation.

Read More: How to Link Excel Sheets to PowerPoint

How to Insert Excel File into PowerPoint as Icon

Open a presentation file and select the intended slide to place the icon.
Go to the Insert tab and click on the Object tool in the Text group.

Select the Create from file option.
Click on the Browse button to attach the Excel file that you want to place as an icon on the slide.
Make sure to check the boxes beside Link and Display as icon options.

Use the hooks on the icon’s corners to resize it and drag it into place on the slide.
Double-click the icon to access the workbook’s contents and edit them.

Read More: How to Insert an Excel File into PowerPoint as an Icon

How to Link Excel File in PowerPoint That Updates Data Dynamically

To link an Excel file in PowerPoint, do the same things as you did in Example 1 .
You have to mark the box before the Link option.
Press the OK button.

checking the box of Link in the Insert Object dialog box

Now, if you make any changes in the Excel file, you’ll get the updated data in PowerPoint.

Note: If you delete the file or change the location of the file, PowerPoint will start throwing errors when trying to display data.

Read More: How to Link Powerpoint to Excel for Dynamic Data Updates

Benefits and Drawbacks of Embedding an Excel File in PowerPoint

When creating presentations, it’s useful to embed the Excel file directly into the PowerPoint file. But, it’s important to consider the benefits and drawbacks of this approach.

Easy Access to Data: Embedding an Excel file in PowerPoint allows you to easily access and manipulate data without having to switch between programs.
Increased Interactivity: Embedding an Excel file in PowerPoint allows you to create more interactive presentations with live data that can be manipulated and updated in real time.
Saves Time: It can save time by eliminating the need to create separate charts and graphs from scratch.
Better Organization: Embedding an Excel file in PowerPoint allows you to keep all your data in one place, making it easier to organize and manage your presentation.
Consistent Formatting: Embedding ensures that your data will be presented with consistent formatting and style.
File Size: Embedding an Excel file in PowerPoint can increase the file size of your presentation, making it more difficult to share and collaborate with others.
Compatibility Issues: Embedding an Excel file in PowerPoint can lead to compatibility issues between different versions of PowerPoint and Excel.
Security Risks: Embedding an Excel file in PowerPoint can pose security risks if the Excel file contains sensitive information.
Limited Editing Capabilities: Embedding an Excel file in PowerPoint limits your editing capabilities, as you may not be able to make changes to the data directly within the PowerPoint slide.
Refreshing Data: If the data in the embedded Excel file changes, you will need to manually refresh the data in the PowerPoint slide to ensure accuracy.

Things to Remember

Keep file size in mind when you embed an Excel file in PowerPoint.
Ensure compatibility with different versions of PowerPoint and Excel.
Test your presentation to ensure that the embedded Excel file displays correctly.
Update the presentation file with an embedded Excel file if the data changes or needs to be refreshed.
Consider security and privacy concerns when embedding Excel files containing sensitive information.

Frequently Asked Questions

1. Will embedding an Excel file in PowerPoint increase the file size of my presentation?

Yes, it can increase, especially if the Excel file contains a lot of data. This can make it more difficult to share and collaborate on the presentation.

2. How do I ensure compatibility between different versions of PowerPoint and Excel when embedding a file?

To ensure compatibility, it’s important to save the Excel file in a format that is compatible with the version of PowerPoint you are using.

3. What security risks should I be aware of when embedding an Excel file in PowerPoint?

It’s important to ensure that any sensitive information within the embedded Excel file is appropriately protected and access is limited to authorized individuals.

Practice Section

We have provided a practice section on the right side of each sheet so you can practice yourself. Please make sure to do it yourself.

Download Practice Files

Download the following practice workbook and presentation file. It will help you to realize the topic more clearly and will help you practice yourself.

[Fixed!] Problems with Embedded Excel Files in PowerPoint
[Solved] Embedded Excel in PowerPoint Not Showing All Data
How to Open Existing PowerPoint File from Excel VBA

<< Go Back to Excel to PowerPoint | Export Data from Excel | Learn Excel

What is ExcelDemy?

Tags: Excel to PowerPoint

Mohammad Shah Miran has a professional background spanning over a year at Softeko. Initially starting as an Excel and VBA writer, he authored more than 50 articles for the ExcelDemy project. Currently, Miran is engaged in the LinuxSimply project as a Linux content developer, completed over 40 articles. His analytical approach extends across various domains, including Excel, VBA, Bash scripting, Linux, data analysis, and Python programming. In his leisure time, Miran enjoys watching movies and series or listening... Read Full Bio

Stack Exchange Network

Stack Exchange network consists of 183 Q&A communities including Stack Overflow , the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

How can I hyperlink from PowerPoint to Excel, linking to a specific tab and named range or cell?

How can I hyperlink from PowerPoint to Excel, linking to a specific tab and named range or cell and make it stick?

I am successful in creating the Hyperlinking and obtaining the desired results, however after I save the PowerPoint file, it deletes the tab and named range that were included in the Hyperlink.

As an example:

C:\<file name.xlsx>#<tab name>!<named range or cell>

. This works great as entered and links properly until I save the PowerPoint file.

After a save, it truncates the hyperlink after file name. It opens the Excel file to the last saved location.

microsoft-excel-2010
microsoft-powerpoint-2010

Here is how i did it:

Copy your cell/range in excel
Go to powerpoint and click on Paste > Paste special
Select paste link on the left
Select attach hyperlink

Save the file and you are good to go.

Go ahead and click accept then ;) Glad that I could help. – Mariyan Commented Feb 17, 2013 at 13:51
Office for Mac v15 doesn't support this. – ctc chen Commented Feb 18, 2018 at 7:20

You must log in to answer this question.

Not the answer you're looking for browse other questions tagged microsoft-excel-2010 microsoft-powerpoint-2010 ..

Featured on Meta
Upcoming sign-up experiments related to tags

Hot Network Questions

Powering on a laser diode that exceeds PSU max current
Is there a tool for generating nanotube from an arbitrary 2D structure?
Will shading an AC condenser reduce cost or improve effectiveness?
Historically are there any documented attempts at finding algorithms that are asymptotically faster than the FFT for the Discrete Fourier Transform?
RAW, do transparent obstacles generally grant Total Cover?
Redraw a Recurrent Neural Network
Did James Madison say or write that the 10 Commandments are critical to the US nation?
Can I replace a GFCI outlet in a bathroom with an outlet having USB ports?
Why inductor don't discharge completely even when the duty cycle is 50%?
Co-authors with little contribution
Is the new series for 𝜋 a Big (or even Medium) Deal?
Should mail addresses for logins be stored hashed to minimize impact of data loss?
Short story about a boy living on a fake tropical island / paradise planet, who was actually an adult CEO but didn't remember it
how do i permanently disable my microphone?
What does it mean for observations to be uncorrelated and have constant variance?
Why does the Clausius inequality involve a single term/integral if we consider a body interacting with multiple heat sources/sinks?
What is a quarter in 19th-century England converted to contemporary pints?
Is there an explicit construction of a Lebesgue-measurable set which is not a Borel set?
How to correctly calculate document's type area?
Detect the social network of a given URL
if people are bred like dogs, what can be achieved?
Proof/Reference to a claim about AC and definable real numbers
Is it possible to animate a curve along it's own path?
How to make sure to only get full frame lenses for the Canon EF (non-mirrorless) mount?

DynamicPowerPoint.com
SignageTube.com
SplitFlapTV.com

Create PowerPoint Slides from Excel Data

Oct 5, 2019 | Articles

Undoubtedly Microsoft Excel is amongst the best tools for increased productivity in our workplace today. Microsoft Excel helps workers perform their assigned tasks easily. The use of Microsoft Excel has greatly improved productivity in organizations. It offers a quicker way to complete your task effortlessly. Many organizations now sort after Men and Women with good skill in Microsoft Excel.

PowerPoint is another outstanding program that enhances business excellence. PowerPoint offers a clear understanding and interpretation of data. It has a unique display setting that makes the audience appreciate the program, but it is static.

Some persons believe PowerPoint to be superior to Excel and vice versa. But recently, people create PowerPoint from Excel data. Excel is used for computations because it has a lot of data needed for the report. PowerPoint will help enhance the appearance of these reports. So, simply present your result in PowerPoint after all calculations from your Excel.

classic slide

Submit a Comment

Your email address will not be published. Required fields are marked *

Pin It on Pinterest

StumbleUpon
Print Friendly

Products Aspose.Total Product Solution Aspose.Words Product Solution Aspose.PDF Product Solution Aspose.Cells Product Solution Aspose.Email Product Solution Aspose.Slides Product Solution Aspose.Imaging Product Solution Aspose.BarCode Product Solution Aspose.Diagram Product Solution Aspose.Tasks Product Solution Aspose.OCR Product Solution Aspose.Note Product Solution Aspose.CAD Product Solution Aspose.3D Product Solution Aspose.HTML Product Solution Aspose.GIS Product Solution Aspose.ZIP Product Solution Aspose.Page Product Solution Aspose.PSD Product Solution Aspose.OMR Product Solution Aspose.SVG Product Solution Aspose.Finance Product Solution Aspose.Font Product Solution Aspose.TeX Product Solution Aspose.PUB Product Solution Aspose.Drawing Product Solution Aspose.Audio Product Solution Aspose.Video Product Solution Aspose.eBook Product Solution
Pricing Information
Paid Consulting
Source Code
Free Support
Free Consulting
New Releases
Websites aspose.com aspose.cloud aspose.app aspose.org aspose.dev aspose.ai groupdocs.com groupdocs.cloud groupdocs.app conholdate.com conholdate.app conholdate.cloud
Acquisition

Online EXCEL to POWERPOINT Converter

Easily convert excel files to powerpoint, easily download high quality powerpoint files to any platform..

Press Ctrl + D to store it in your bookmarks in order not to search it again

Aspose.Cells Conversion

Convert XLSX , XLS , XLSB , XLSM , XLTX, XLT , XLTM, ODS
Save to desired format: PDF , XLS , XLSX , DOCX , PPTX , XLSM , XLSB , XLT , XLTX, XLTM, ODS , OTS , CSV , TSV , HTML , XHTML , JPG , BMP , PNG , WEBP , SVG , TIFF , XPS , MHTML , MD , JSON , XML , ZIP , SQL , TXT , ET, TABDELIMITED, FODS, SXC, EPUB
Quick way to convert multiple Excel spreadsheet files
Easily save document as pdf, images or html
Convert OpenDocument Spreadsheet
Upload maximum 10 files and convert them simultaneously

How to convert EXCEL to POWERPOINT

Upload your EXCEL files to convert.
Press the "CONVERT" button.
Download the converted EXCEL files instantly or send a download link to email.

Note that file will be deleted from our servers after 24 hours and download links will stop working after this time period.

Fast and Easy Conversion

Upload your EXCEL files, choose the save format type and click on "Convert" button. You will get the download link as soon as the file is converted.

Convert from Anywhere

It works from all platforms including Windows, Mac, Android and iOS. All files are processed on our servers. No plugin or software installation required for you.

Conversion Quality

Powered by Aspose.Cells . All files are processed using Aspose APIs, which are being used by many Fortune 100 companies across 114 countries.

Work with your Excel spreadsheets in other free apps

Bookmark this app, send the download link to, send us your feedback, oops an error has occurred., invalid file, please ensure that uploading correct file.

Would you like to report this error to the forum, so that we can look into it and resolve the issue? You will get the notification email when error is fixed.

Make this forum private, so that it will only be accessible to you and our developers

Error has been reported successfully.

You have successfully reported the error, You will get the notification email when error is fixed. Click this link to visit the forums.

Immediately delete the uploaded & processed files.

Are you sure to delete the files?

This is a feature for subscribers

To use this feature,

please upgrade your Aspose app account

This is a feature for registered users

please login to your aspose app account

Accessories
Entertainment
PCs & Components
Wi-Fi & Networks
Newsletters
Digital Magazine – Subscribe
Digital Magazine – Info
Smart Answers
Amazon Prime Day
Best laptops
Best antivirus
Best monitors
Laptop deals
Desktop PC deals

When you purchase through links in our articles, we may earn a small commission. This doesn't affect our editorial independence .

Become a PowerPoint pro: 7 must-know tips and tricks

Microsoft’s PowerPoint is extremely popular in schools, universities, and the corporate world, but it has never been as popular with home users. Not surprising since it’s all about creating presentations, something a private person doesn’t have to do very often.

So, if you suddenly find yourself needing to make a PowerPoint presentation and have no idea how to make it good, rest assured that you aren’t alone and there’s hope for you.

Microsoft Office 365 Home

These days, PowerPoint is more than just a basic slideshow—it can be used to create video presentations with voice-over narration, and it even has an AI-based helper called Designer that gives suggestions on how to make your presentation better.

Here are several smart tips and tricks you can use to improve your PowerPoint presentations and come off as a pro.

1. Customize Quick Access

Have you noticed that PowerPoint—and the other apps in Microsoft 365 for that matter—have a small, narrow toolbar at the very top of the application window? By default, you’ll find shortcut buttons for toggling Auto Save and basic actions like Save, Undo, Repeat, etc.

This nifty toolbar also comes with some app-specific actions that you may or may not use frequently. In PowerPoint, for example, there’s a shortcut to start slideshows from the beginning.

This toolbar is called Quick Access and you can actually customize what actions show up here. You can add frequently used actions while removing the ones you never use.

This can make it easier to find important functions that you would otherwise have to rummage around the ribbon to find.

To customize Quick Ass, select File > Options and then Quick Access Toolbar . The box on the right shows the actions currently on it and their order. The box on the left has all the available actions you can add.

Select an action you want in Quick Access and click on Add . To change the order, highlight the action you want to move and use the the arrow buttons on the right side of the window.

2. Use custom themes and templates

PowerPoint comes with a bunch of ready-made templates for presentations, which have also been themed.

A theme is a collection of settings for typography, colors, and effects that make it easy to maintain a consistent style across presentations. A template is a theme plus ready-made content that makes it easier to make a particular type of presentation again in the future.

For example, a company may have a theme that defines the colors and fonts employees should use in presentations, plus a number of templates for product presentations and quarterly reports.

A template may have a number of ready-made slides with images, charts, and everything else already laid out. When you create a new presentation from a template, you will find these individual page templates in New slide in either Start or Insert .

Creating your own custom theme

New themes can be added at any time as long as you have a presentation open—even if it’s a blank presentation.

Select the Design tab and click on the small down arrow with a dash over it on the right side of the Variants section. This shows the four categories of settings you can designate for a theme.

Select Colors > Customize Colors… and the Create new theme colors dialog box will open. A complete set of theme colors includes two pairs of text and background colors (dark/light, to be used either for dark text on a light background or vice versa), six spot colors used for graphic elements, and two colors for hyperlinks. Enter a name at the bottom and click Save when you are done.

If you also want to change the font, select Fonts > Customize Fonts… and you’ll be able to designate a Heading font and a Body font . I recommend a neutral, easy-to-read font for both.

Under Effects , you can choose the style of effects but there’s no way to customize or create a completely new effect. Under Background Styles , you can select Format Background… to tweak backgrounds.

When you’re done, go to the Themes section of the Design tab and click the down arrow with a line above it, then select Save Current Theme… to save your new theme. Give it a name and save and your new theme will appear among the available themes in the Design tab of all presentations.

Create your own custom templates

To create a new PowerPoint template, you can start from either a blank presentation or an existing template. Don’t add any content of your own yet. Instead, go to the View tab and click on Slide Master .

Start by changing the theme of your new template, under the Themes button. If you created your own theme as described above, it will normally be at the top of the list of available themes.

PowerPoint uses the term layouts for slide templates. Click on the Insert Layout button to create a new slide template.

New layouts are automatically given a header and a footer, but you can remove them if you wish (either by selecting and deleting the elements manually or via checkboxes in the Slide Background tab).

To delete an existing layout, right-click on it in the list and select Delete Layout or select it in the list and press Backspace.

To add new design elements to a layout, click the Insert Placeholder button in the ribbon and select the element type you want. You can then position and resize it, and change the placeholder text for it.

If you want to make per-layout changes, make sure to select that layout in the list before tweaking. For example, you can change a layout’s color theme or switch between the four background formats.

When you’re happy, save the template by selecting File > Save As and changing the format to Powerpoint Template (*.potx) . Templates can be stored either locally on your computer or in OneDrive—and since the theme is included, you can freely share the template with others.

3. Link to Excel data

If you’re making a presentation with figures in tables or charts, you can make your life easier by linking PowerPoint to Excel.

To do this, start by copying a chart in Excel, then switching over to PowerPoint and navigating to the Home tab in the ribbon. Select Paste > Paste Special… , then choose the Paste Link option, select Microsoft Excel Chart Object and finish by clicking OK .

A linked chart, table, or other Excel object can be instantly updated with up-to-date information as the data in the Excel document changes, all without having to copy and paste all over again.

To update the Excel object, right-click on it in PowerPoint and select Update Link . PowerPoint will retrieve the latest data to be reflected in the Excel object. This makes it easy to build a data-heavy report in PowerPoint that can be kept up-to-date with zero hassle.

4. Edit and apply effects to images

Basic slide editing in PowerPoint isn’t difficult, but there are a few tricks you can learn to make your slides both behave the way you want them to and do new things you may not have realized were possible.

For example, did you know that PowerPoint has built-in editing features that can change brightness, contrast, and sharpness of images?

Select an image in a slide and the Picture Format tab will open. Here you’ll find several adjustments you can make:

Corrections alters brightness, contrast, and sharpness
Color applies color filters
Artistic Effects stylizes the image (but apart from the useful Blur effect, most of these feel pretty old-fashioned)
Transparency makes the image more or less transparent
Picture Styles can format the image in various ways (e.g., frame, shadow, rounded corners, perspective, etc.)

One thing you’ll notice when you add an image is that PowerPoint automatically generates alternative text—that is, descriptive text that gets read aloud for users with visual impairments. You can set this text to whatever you want, and it’s nice that Microsoft has thought about accessibility in this way.

5. Fill a shape with an image

PowerPoint makes it easy to fill a vector graphic shape with an image instead of just a solid color or gradient.

Create the shape as you want it, then make sure it’s selected before navigating to either the Home or Figure Format tabs in the ribbon. Select Shape Fill > Picture… , then select From a File to pick an image that’s saved on your computer.

If you aren’t satisfied with the positioning of the image in the shape, you can open the Picture Format tab and select Crop > Crop to resize and move the image in relation to the shape, allowing you to center it at a different point and even zoom in or out.

6. Incorporate audio and video

These days, PowerPoint isn’t just for presentations on screen or with a projector—it’s increasingly common to export finished presentations as videos to be sent to recipients, uploaded to the web, embedded in mobile apps, and more.

To make such presentations more vivid and interesting, you can record voice-over audio and/or video from a connected webcam to be placed on top of slides. You can find these features in the Record tab, where PowerPoint has also placed the Export to Video function.

The export function allows you to set the video resolution as well as how long each slide will display in the video.

More on this: How to turn a PowerPoint presentation into a video

7. Get AI help with Designer

Designer is the new name for Design Ideas, a feature that has been around since PowerPoint 2016 and uses machine learning to analyze the content of presentations and suggest improvements.

You can find it as a button in the Home and Design tabs, with Designer itself appearing in a column on the right.

This feature continuously analyzes your presentation and displays a list of suggested changes for the current slide. If you don’t like any of the suggestions, you can click on See More Design Ideas at the bottom and it will generate additional suggestions.

How attractive and useful are the suggestions? Well, it varies. When I tested it myself, they’ve rarely been results that I could use straight away—but the suggestions were helpful in that they gave me several great ideas that I hadn’t thought of myself.

For example, in the image above, you can see a suggestion for a color filter on a photo that looks like it could work really well with bright text and maybe a little blur.

Further reading: PowerPoint keyboard shortcuts worth knowing

This article originally appeared on our sister publication PC för Alla and was translated and localized from Swedish.

Author: Anders Lundberg , Contributor

Anders writes news, reviews and buying guides that touch most categories of consumer tech.

Excel and PowerPoint: Creating High-Impact Financial Presentations

Share This: Share Excel and PowerPoint: Creating High-Impact Financial Presentations on Facebook Share Excel and PowerPoint: Creating High-Impact Financial Presentations on LinkedIn Share Excel and PowerPoint: Creating High-Impact Financial Presentations on X

Instructor: Danielle Stein Fairhurst

Find out how you can create high-impact, data-rich financial presentations using Excel and PowerPoint. In this course, Microsoft MVP and Financial Modelling Specialist Danielle Stein Fairhurst guides you through creating financial presentations that are compelling, easy to understand, and—best of all—easy to update. Get started with an example spreadsheet featuring typical finance data. Learn how to use conditional formatting to highlight important information, PivotTables to summarize data, and sparklines and charts to create illustrations. Explore several different methods—including copying and pasting, linking, and embedding—to import your work into PowerPoint. Plus, learn how to use PowerPoint animation features to animate Excel charts and tables and focus the viewer’s attention.

Conholdate.Annotation App Document Annotator Solution
Conholdate.Assembly App Forms Builder Solution
Conholdate.Barcode App Barcode Solution
Conholdate.QRCode App QR Code Solution
Conholdate.Conversion App Document Converter Solution
Conholdate.Editor App Document Editor Solution
Conholdate.Image App Image Editing Solution
Conholdate.Locker App Document Locker Solution
Conholdate.Metadata App Document Metadata Solution
Conholdate.Merger App Document Merger Solution
Conholdate.Parser App Document Parser Solution
Conholdate.Search App Document Search Solution
Conholdate.Signature App Document eSign Solution
Conholdate.Splitter App Document Splitter Solution
Conholdate.Translation App Document Translator Solution
Conholdate.Viewer App Document Viewer Solution
Conholdate.Unlocker App Document Unlocker Solution
Free Support
aspose.cloud
groupdocs.com
groupdocs.cloud
groupdocs.app
conholdate.com
conholdate.cloud
conholdate.app
containerize.com
codeporting.com
fileformat.com
Acquisition
conversion App

PowerPoint to Excel conversion

Online powerpoint to excel conversion, convert powerpoint to excel online.

Click or drop your files here

By clicking on upload button or uploading document you are agreeing with our Privacy Policy and Terms of Service

Conholdate PowerPoint to Excel Conversion is cross platform and cross browser conversion app that allow you to convert PowerPoint to Excel in any modern browser (Chrome, Safari, Firefox, Opera, Tor, etc) and on any OS (Windows, Unix and MacOS) despite your PC specifications. Converted PowerPoint to Excel will maintain original document structure, content and styles. PowerPoint to Excel Convertor app is built on top of high quality document conversion engine which provides outstanding conversion results and performance, our goal is to offer secure and best conversion experience to our users. Conholdate.Conversion app offers an OCR feature that allows you to parse image files and export data into Excel documents, for example convert PNG to Excel.

Click inside drop area or drag & drop your file.
Wait until PowerPoint to Excel file is uploaded.
Select output format from dropdown menu.
Click on Convert button to start PowerPoint to Excel conversion.
Download or share resulted file.

How to convert PowerPoint to Excel file?

Upload you file by drag and drop it to the upload zone with label "Click or drop your files here" or click on it to select file using file explorer. After that select destination format in which you want to convert your file and click Convert button.

Can I extract tables from images (PNG) and export them to Excel files?

Yes you can. Conholdate Image to Excel conversion will parse image files using OCR feature and extract text and tables data. Extracted data can be saved into various formats, such as Excel, OpenOffice and more.

How many files can be converted at a time?

You can convert 1 file at a time.

What is the maximum allowed file size?

Maximum allowed file size to upload and convert is 20 Mb.

What are the ways to get my conversion results?

At the end of the conversion process, you will get a download link. You can download the results immediately or send the link to your email.

How multi page document is converted to image?

Each page of such a document will be saved as a separate image. After conversion process is finished you will get a package of such images.

translation

#ez_toc_widget_sticky--1 .ez-toc-widget-sticky-container ul.ez-toc-widget-sticky-list li.active{ background-color: #ededed; } Steps To Follow

Get Trainings

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

The Ultimate Guide to Copy Slide Backgrounds in PowerPoint | MyExcelOnline

Slide backgrounds are the unsung heroes that bring your PowerPoint presentations to life. They help set the tone, engage the audience, and make your content pop. Consider them your canvas; with the right choice, they can elevate your presentation to new heights, drawing the audience’s focus to key points while also providing an aesthetic appeal that reflects professionalism.

Download our 141 Free Excel Templates and Spreadsheets !

Key Takeaways

To copy slide backgrounds in PowerPoint , you can right-click on the desired slide with the background you want to copy in the slides pane, select “Duplicate Slide”, and then use the copy as a new slide with the same background.
Another method is to right-click on the background of a slide and select “Format Background”, and then choose to use a picture or texture fill, where you can insert an image from your computer or other sources as a background for a new slide.
For a more precise duplication, you can use the “Format Painter” tool: select the slide with the desired background, click on the “Home” tab, choose “Format Painter”, and then click on the slide(s) where you want to apply the same background style.

The Challenge of Consistent Design Across Presentations

Achieving consistency across presentations can feel like a juggling act. You might wonder how to keep the design uniform when jumping between multiple templates, especially when each one comes with its own default background. It’s about striking a balance between recognizable branding and the uniqueness of each presentation’s content. When consistency in design falls short, it can lead to confusion, a less impactful message, and a diminished professional image.

Table of Contents

Preparing to Copy Slide Backgrounds

Understanding the slide master view.

The Slide Master view is your control center for designing a truly coherent PowerPoint presentation. Here, you’re stepping behind the scenes to manipulate the core aspects that dictate how your slides look and feel. By entering this mode, you gain the power to customize fonts, color schemes, and placeholder positions across all slides, ensuring consistency and saving you from the tedium of making changes to individual slides.

Identifying the Background Elements to Copy

When you’re ready to harmonize your presentation’s aesthetic, identifying the elements of your slide background to copy is crucial. Take a close look at your source slide . What makes it stand out? Is it a unique color gradient, a company logo, a watermark, or perhaps a specific texture or image? Pinpoint these components so you can replicate them accurately in your target presentation. This attention to detail will ensure the backgrounds you copy not only look good but also serve their purpose of complementing your presentation’s content.

Step-by-Step Process for Copying Backgrounds

Transferring backgrounds to target presentation.

Advanced Techniques and Tips

Utilizing high-quality images for backgrounds.

For a professionally polished look, you can’t beat high-quality images for your slide backgrounds. Always choose images that are high resolution to avoid any blurriness when projected onto a big screen. You’re aiming for crisp, visually appealing pictures that add depth to your presentation without overwhelming the content. Remember, the image should support your message, not distract from it.

Using Templates for a Uniform Look and Feel

Templates are the friends you can rely on for a uniform look and feel across your presentations. They come preset with background designs, fonts, and layouts, so all you need to do is plug in your content, and you’re assured of a consistent style that resonates with your brand or message. Investing in well-designed templates can save you tons of time and give all your work that signature look that audiences will start to recognize and trust.

Maintaining the Originality of Your Slides

Adding personal touches to copied backgrounds.

While copying backgrounds can streamline your design process, adding personal touches ensures your presentation doesn’t feel cookie-cutter. You might adjust the transparency of an image for subtlety, layer shapes for depth, or sprinkle in icons that align with your topic. Experiment with fonts and colors for text emphasis, or insert a relevant quote to humanize the slide. These nuanced additions help your presentation stand apart while still maintaining design consistency.

When to Opt for Customization Over Duplication

Duplication is efficient, but customization is key when your message demands distinctiveness. It’s a fine line to walk—you want to preserve your overall branding while also giving each presentation its unique flair. Choose customization when addressing different audiences, when you want to emphasize a specific point, or when the subject matter is unique. Custom slides can give a fresh and tailored perspective that keeps your audience engaged and conveys that you’ve crafted your message just for them.

FAQ Section

How can i copy a background from one slide to another without using the slide master.

How do I extract the background of a PowerPoint presentation?

What should I do if the copied background does not display correctly on the new slide?

If the background isn’t displaying correctly, check the format and size of the background image to ensure it matches your slide dimensions. Adjust the image using ‘Format Background’ settings, aligning it properly. Alternatively, confirm compatibility issues between different PowerPoint versions and resolve them for proper display.

John Michaloudis

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship Academy Online Course .

How to Create a Signature in Outlook – Step-by-Step Email Guide

How to Use Find and Replace in Microsoft Word

How to Share Calendars in Outlook – Step by Step Guide

Get Video Training

Dramatically Reduce Repetition, Stress, and Overtime! Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job! Learn in as little as 5 minutes a day or on your schedule.

BIWS Platinum, Venture Capital, and Project Finance Course Prices Increasing on July 1st, 2024

View Details

Video Tutorials
Knowledge Base
Group Licenses
Why Choose Us?
Certificates

PowerPoint Tutorials

Macros in PowerPoint: Full Tutorial and How to Write VBA Code for a “Swap Multiple Shapes” Macro

In this tutorial, you’ll learn how to set up macros in PowerPoint, and you’ll get practice writing VBA code for your first macro.

Tutorial Summary
Files & Resources
Premium Course

Macros in PowerPoint are useful for tasks such as performing tricky alignments, fitting shapes within tables, and using Drawing Guides, rather than physical lines, to distribute shapes.

Before you start using macros or writing your own VBA code, you must understand the fundamentals of PowerPoint: features like the Quick Access Toolbar , the Slide Master , Tables , and how to duplicate a shape .

It’s counterproductive to “automate” slides and presentations unless you first understand the key PowerPoint commands and shortcuts.

In this tutorial, we’ll walk you through how to create your first PowerPoint macro , which you can use to swap the positions of multiple shapes.

This code is simple, but it is also very useful because it typically takes several keyboard shortcuts and mouse drags to swap shapes manually, so an automated solution is a clear win.

And amazingly, there is no built-in way to do this in the standard version of PowerPoint.

PowerPoint Pro

Master PowerPoint by creating a sell-side M&A / valuation pitch book for Jazz Pharmaceuticals - plus company/deal profiles and more.

Video Table of Contents:

0:58: Why Macros Are Useful in PowerPoint

2:44: PowerPoint Macro Demo

6:27: Lesson Overview

6:40: VBA in Excel vs. PowerPoint

10:09: Simple “Shape Swap” Macro

18:29: Macro to Swap Multiple Shapes

25:29: Recap and Summary

Files & Resources:

Slide Presentation – Macros in PowerPoint and VBA Tutorial (PDF)

Reference Slides for Macro Exercise (PPT)

“Finished” Version of Macro and Reference Slides (PPTM)

PowerPoint Macros and VBA in Excel vs. PowerPoint

Before jumping into the code, it’s worth asking two key questions:

What are the advantages and disadvantages of VBA and macros in Excel vs. PowerPoint?
What are good vs. bad use cases for macros in PowerPoint? In other words, what is the most effective way to spend your time automating your presentations?

On the first question, VBA in Excel is simpler to set up and use for quick macros .

Excel has a macro recorder, so you can record your actions in a spreadsheet, review them in the VBA Editor, and modify the code to do what you want.

Also, assigning keyboard shortcuts to your macros is easy because you always select a keyboard shortcut when you record actions in the macro recorder.

By contrast, PowerPoint macros are more difficult to set up but are arguably more powerful .

Most Excel macros function based on a selected range of cells in a single spreadsheet and automate processes like color-coding the cells or changing the decimal places.

That’s nice, but PowerPoint macros often change the entire presentation , including on normal slides and templates in the Slide Master .

Also, PowerPoint macros do not break the “Undo” command , so you can press Ctrl + Z (or ⌘ + Z on Mac) repeatedly, and it will work correctly with all macros.

But in Excel, macros break the Undo and Redo commands unless you build a workaround into your code, which can get very complicated.

Here’s a summary of VBA in Excel vs. PowerPoint:

Returning to the second question above – good vs. bad use cases for macros in PowerPoint – focus on macros that are simple to code and that automate actions you repeat a lot .

For example, swapping shapes is quite simple to code (5-10 minutes), and it saves you time because it’s cumbersome to swap shape positions manually. Plus, it’s a common task when editing presentations.

On the other hand, it’s silly to write a macro that “centers” a shape vertically and horizontally on a slide because the “Align Center” and “Align Middle” commands already do this, and it’s not especially common to center single shapes on a slide in corporate presentations.

Something like the Table of Contents macro in our full macro package, which is based on the Slide Master and custom layouts, is in the “maybe” category.

It saves you time, but it’s also complicated to code and test, and it doesn’t work 100% perfectly in all cases.

Plus, you might only add the Table of Contents when you’re finished with a presentation, so this macro may be less useful than simpler shape manipulation commands.

Your First PowerPoint Macro: “Swap Shapes”

To start writing your first macro, go to the “Trust Center” in PowerPoint (Alt, T, O in the PC version or ⌘ + , on Mac) and make sure the program will let you run macros:

Use one of the settings above (the screens will look slightly different on the Mac) and make sure the “Developer Toolbar” in the ribbon menu is visible by going to “Customize Ribbon” within the Options menu:

PowerPoint Ribbon Menu and Developer Tab

Once you’ve done this, open the VBA Editor with Alt, L, V on the PC (there is no Mac shortcut, so navigate there manually) and insert a “module” and a “subroutine” to write a new macro:

Macros in PowerPoint - Adding a Module and Subroutine

You can call the new module “SwapShapes” and add a new subroutine with the same name on the right side of the screen:

After you type “Sub SwapShapes()” VBA will automatically insert the “End Sub” at the end to indicate that your macro ends there.

With simple macros, you usually want to work with the shapes, slides, or text the user has selected .

That’s how this “Swap Shapes” macro will work: it will assume that the user has selected the shapes they want to swap, and then it will change their positions.

First, you need to make sure the user has selected shapes , and if so, that they’ve selected 2 shapes rather than 1, 10, or 50 shapes:

PowerPoint VBA - Checking the User's Shape Selection

“IF” statements are the building blocks of all programming languages, including VBA.

They let you check conditions, such as the selection consisting of 2 shapes, and they take actions based on whether these conditions are true or false.

The ActiveWindow.Selection object in VBA contains whatever the user has selected (shapes, slides, text, or nothing at all), and it has “properties” for things like the selection type and the number of objects selected .

You can use the “IF” statements with ActiveWindow.Selection to check for these conditions.

If you’re unsure of an object’s properties, you can start typing its name followed by a “.” so that VBA displays a list of options.

The “=” operator is used for both assignments and equality checks in VBA, which is a bit confusing. But if it’s part of an “IF” statement, as it is here, it’s an equality check.

The MsgBox command is useful for testing the code as you move along and ensuring the “IF” statements work.

Next, you need to save the first shape’s Top and Left positions and put them in “variables” that you can refer to later.

Here’s the code:

PowerPoint VBA - Saving the Shape Positions in Variables

The “=” signs in the main part of the code are assignment operators because they’re not within “IF” statements.

So, they SET one shape’s Left and Top coordinates to the other shape’s Left and Top coordinates.

Again, it is confusing how “=” can check for equality in VBA and set the value of a variable; there is no easy answer other than “continued practice and exposure.”

The ActiveWindow.ShapeRange(1) part means: “Take the first shape the user has selected on the current slide.”

You can use ActiveWindow.ShapeRange(2) to refer to the second shape, which takes us into the next part: setting the first shape’s Top and Left positions to those of the second shape.

PowerPoint VBA - Changing the First Shape's Top and Left Positions

If you stopped here, you’d have a problem because you’ve now lost the first shape’s original Top and Left positions.

This is why you saved them in the tempLeft and tempTop variables: by saving these original positions in variables, you can now use them to change the second shape’s position.

Macros in PowerPoint: Swapping the Original Positions of the First Shape with the Second Shape

This code properly swaps the positions of two shapes.

However, you can make it more efficient by using a “With” statement, which also exists in Excel VBA, to remove the need to type ActiveWindow.Selection:

When you type the “With ActiveWindow.Selection” line, anything that starts with a “.” between that and the “End With” is assumed to be part of ActiveWindow.Selection.

So, VBA “translates” a line like this:

tempLeft = .ShapeRange(1).Left

tempLeft = ActiveWindow.Selection.ShapeRange(1).Left

You can now go into PowerPoint and test this macro with different shapes on the reference slides.

To do this, use the Alt, L, PM shortcut in the PC version (no Mac equivalent, so navigate to Developer in the ribbon menu and click on Macros), select “SwapShapes” and click “Run”:

"Shape Swap" Macro Execution on a Normal PowerPoint Slide

As a final step, you can save this file as a macro-enabled presentation in the .pptm format:

Saving Macros in a Macro-Enabled PowerPoint File

By doing this, you’ll ensure that whoever opens the file next can still use this macro.

The Limitations of Macros in PowerPoint

This simple exercise, while useful, also reveals a few issues with macros in PowerPoint:

1) Keyboard Shortcuts – There is no easy way to assign keyboard shortcuts to macros; you must activate them through the “Macros” menu in the Developer Toolbar.

2) Macro-Enabled Files – While you can save macros with the above method, it is not ideal for sharing them or making them usable across different presentations.

3) Code Constraints – It’s simple to write code that handles only 2 shapes , but it’s not immediately obvious how to extend it to manage multiple shapes.

We could fix these issues now or explore other enhancements, but the first two points above are surprisingly complicated to solve.

So, we’ll focus on point #3 and extend this macro to make it swap multiple shapes:

An Extension to Macros in PowerPoint: “Swap Multiple Shapes”

You can extend this macro to swap multiple shapes with a few simple changes.

Start by changing the variable declarations and error checks at the top.

When the user selects multiple shapes, you need to save the first shape’s positions , and you need to create a “counter variable” that tracks the shape # you’re currently on.

For example, if the user has selected 10 shapes, you need to know if you’re currently on shape #1, #2, #3, or #4-10 as you move through the selection and change each shape’s positions.

Also, you need to make sure the user has selected more than 1 shape – not necessarily just 2 shapes:

PowerPoint VBA - Checking to Ensure That More Than 1 Shape is Selected

Next, you need to “loop” through all the shapes the user has selected with a “For” statement.

So, if the user has selected 10 shapes, you need to move from shape #1 through shape #10 and change the position of each shape.

You can start by typing the syntax for this “For” loop:

PowerPoint VBA - For/Next Loop for Selected Shapes

For an example of how this works, continue assuming that the user has selected 10 shapes.

In this case, you should loop through shapes #1 – #9 and set each shape’s Left and Top positions to the next shape’s Left and Top positions.

So, Shape #1 Top should become Shape #2 Top, and Shape #2 Top should become Shape #3 Top.

When you reach shape #10, you should set its Top and Left positions to those of the first shape .

This means you need to save shape #1’s Top and Left positions before starting this loop.

You can start by handling the case for shapes #1 – 9, or “everything before the final shape”:

PowerPoint VBA - Modifying the "For" Loop for Everything Before the Final Shape

As the next step, you can add a special case to save the first shape’s position before the “For” loop and set the last shape’s position equal to the first shape’s:

Macros in PowerPoint: Saving the First Shape's Positions and Swapping Them in for the Last Shape

You can now test these changes on the reference slides and verify that this macro “rotates” multiple shapes:

Macros in PowerPoint: Testing the Shape Swap Macro with Multiple Shapes on the Reference Slides

Activate the macro enough times, and the shapes will return to their original positions.

Macros in PowerPoint: Beyond the Surface-Level Detail

If you’ve followed the steps above, you should have a “Multi-Shape Swap” macro you can use to rearrange your slides.

But this tutorial just scratches the surface; it represents ~30 minutes out of the 12-13 hours of VBA training in our full PowerPoint Pro course .

You can do far more with macros and VBA than simple shape manipulation – as shown in the video above, you can manipulate tables, combined table/shape designs, and even the Language properties of entire presentations.

And you can automate the alignment, distribution, and formatting processes in many ways, including the clever use of Drawing Guides.

You can see the full set of macros in the course below:

Macros in PowerPoint: Full BIWS Macro Package, Part 1

You’ll gain access to the full package and all the detailed tutorials as soon as you sign up for the PowerPoint Pro course:

About Brian DeChesare

Brian DeChesare is the Founder of Mergers & Inquisitions and Breaking Into Wall Street . In his spare time, he enjoys lifting weights, running, traveling, obsessively watching TV shows, and defeating Sauron.

Files And Resources

Premium Courses

Other biws courses include:.

Perfect Your PowerPoint Skills

The BIWS PowerPoint Pro course gives you everything you need to complete pitch books and presentations in half the time and move straight to the front of the "top tier bonus" line.

Man stands and uses mobile phone in an office

Jun 20, 2024

New Recent Files widgets for Word, Excel, and PowerPoint for iOS

Add our blog to your RSS feed reader" href="/rss/blog.xml" data-bi-name="RSS Subscription" data-bi-id="rss_feed" data-bi-bhvr="120" data-bi-socchn="RSSSubscription" title="Microsoft 365 Insider Blog RSS" target="blank" class="d-inline-block">

Hi, Microsoft 365 Insiders! I’m Jessica Hu, a Product Manager on the Apple Ecosystems team. I’m excited to share that you are now able to quickly access your recently used files straight from your home screen with Recent Files widgets for Word, Excel, and PowerPoint for iOS.

You can add Recent Files widgets for Word, Excel, and PowerPoint directly to your iPhone or iPad home screen. The widgets allow you to both view and open your most recently accessed files in that app from the home screen on your device.

How it works

1. On the device home screen, press and hold an empty space and notice the + icon that appears at the top left corner of the screen.

IOS screenshot showing plus sign used to add Recent Files widgets.

2. Tap the + icon, scroll through or search the list of widgets, and tap to select the app widget you want.

3. A Recents screen will appear. Scroll through the icons and pick the size of the widget you want, then tap Add Widget .

4. Tap the widget to open it and then select the file card that you want; the file will open in the app.

Tips and tricks

The Recent Files widget offers sizes to choose from on the iPad, ranging from small to extra-large. There are three sizes to choose from on the iPhone: small, medium, and large.
If you would like to open the app’s home page instead of a recent file, tap anywhere on the widget outside of the file cards.

Availability

This feature is rolling out to Microsoft 365 Insiders running iOS Version 2.85 (Build 24042818) or later. Don’t have it yet? It’s probably us, not you.

Features are released over some time to ensure things are working smoothly. We highlight features that you may not have because they’re slowly releasing to larger numbers of Insiders. Sometimes we remove elements to further improve them based on your feedback. Though this is rare, we also reserve the option to pull a feature entirely out of the product, even if you, as an Insider, have had the opportunity to try it.

If you have any feedback or suggestions, tap your profile photo, tap Help & Feedback , and then tap Tell Us What You Like or Tell Us What Can Be Better . Be sure to include “Widget” in the title of your feedback. You can also let us know about any other widgets you’d like to see for your Microsoft 365 apps!

Sorry, JavaScript must be enabled to use this app.

IMAGES

Excel Charts PowerPoint Infographic (678156)
Excel Charts PowerPoint Infographic (678156)
Add an Excel Chart to Your PowerPoint Presentation
Automated presentations: linking of Excel data to PowerPoint
How to Insert an Excel File into a PowerPoint Presentation
Create PowerPoint Slides from Excel Data • PresentationPoint

VIDEO

PowerPoint Presentation #ppt #excel #shorts
PowerPoint Part I
Power Point(Presentation)#excel #basic #course #computer #education #students #englishtyping #learn
КАК СВЯЗАТЬ EXCEL И POWERPOINT
Introduction to power point presentation in Microsoft excel PP
✿ TUTORIAL ✿ : Making MS PowerPoint Presentation

COMMENTS

Online PPT to XLS converter
PowerPoint Presentation . A file with PPT extension represents PowerPoint file that consists of a collection of slides for displaying as SlideShow. It specifies the Binary File Format used by Microsoft PowerPoint 97-2003. ... File saved by Excel are known as Workbook where each workbook can have one or more worksheets. Data is stored and ...
Convert PPTX to EXCEL
How to convert PowerPoint to Excel. Open free PowerPoint website and choose Convert application. Click inside the file drop area to upload or drag & drop files. You can upload maximum 10 files for the operation. Click on Convert button.
Convert PowerPoint to Excel
Follow these steps to convert PPT to XLSX. Open your Excel file that you are dealing with, and click on the "Insert" > "Object". Select and insert your PowerPoint file: in the window that pops-up, click on the "Create from file" tab and then click on "Browse" to select your PPT file. Pick your PowerPoint presentation and then click "Insert".
Insert and update Excel data in PowerPoint
In PowerPoint, on the Insert tab, click or tap Object. In the Insert Object dialog box, select Create from file. Click or tap Browse, and in the Browse box, find the Excel workbook with the data you want to insert and link to. Before you close the Insert Object box, select Link, and click OK. Important: The linked object in your presentation ...
How to Convert PowerPoint to Excel
Step 1. Open the Powerpoint File Using PDFelement. Open PDFlelement and then click on the "Create a PDF" box to select the PowerPoint files you want to convert. Try It Free. Step 2. Convert PowerPoint to Excel. Before converting, you need to go to the "File"> "Save as" button to save your PowerPoint file into a pdf.
How to Link Powerpoint to Excel for Dynamic Data Updates
Method 1 - Use Automatic Update Option in Powerpoint. Steps: Hold the left mouse key and drag it to highlight your Table in Excel. Right-click the mouse key and select Copy. Open your MS PowerPoint. On the left top corner, click the down arrow under the Paste icon. Select a special type of paste option.
Free Online PPT to XLS Converter
How to. Click inside drop area or drag & drop your file. Wait until PPT to XLS file is uploaded. Select output format from dropdown menu. Click on Convert button to start PPT to XLS conversion. Download or share resulted file.
How to Convert PPT to XLS: HIVO How-to Guides
Step 2: Upload the PPT file to the selected online tool. Step 3: Select "Excel" or "XLS" as the output format. Step 4: Click on the "Convert" button and wait for the conversion process to complete. Step 5: Download the converted XLS file to your computer.
Insert Excel data in PowerPoint
In Excel, click and drag to highlight the cells you want to copy. Right-click the copied cells and select Copy. In your PowerPoint presentation, right-click and select the Paste Options you want: Use Destination Styles - Choose to edit your copied cells like a PowerPoint table, but with PowerPoint's color scheme and fonts.
Create XLSX from PPT
How to convert PPT to XLSX. Upload PPT files to convert them online for free. Specify the parameters and press the "CONVERT" button to convert PPT. Download the converted XLSX to view instantly or send a link to email. * You can do it either by clicking inside the drop area or by dragging with a mouse. Multiple files can be uploaded at once.
convert power point to excel
You may follow the following steps to convert a PowerPoint presentation into Excel Spreadsheet: Open a new Excel Spreadsheet. In Insert tab, click Object from the Text section. Choose the option Select from File, browse to locate the PowerPoint file and then add it. Click Insert to add the file and the object will be listed in the File Name ...
Free Microsoft 365 Online
PowerPoint for the web. Turn your ideas into compelling presentations using professional-looking templates. Use animations, transitions, photos, and videos to tell one-of-a-kind stories. Co-author team presentations at the same time, from anywhere. Start using PowerPoint for free Learn more about PowerPoint.
How to Link or Embed an Excel Worksheet in a PowerPoint Presentation
Start by opening both the Excel worksheet and the PowerPoint presentation you want to edit at the same time. In Excel, select the cells you want to link or embed. If you would like to link or embed the entire worksheet, click on the box at the juncture of the rows and columns in the top left-hand corner to select the whole sheet.
How to Convert PowerPoint to Excel
You can copy slides as images and paste them into an Excel worksheet: Open the PowerPoint and Excel files. Select the slides and copy them (Ctrl/Cmd+C) Switch to Excel, select a cell, and paste (Ctrl/Cmd+V) The slides will appear as images that can be resized. Pros: Easy to do, editable in Excel. Cons: Loses slide formatting, can't update ...
Automatic Updating of Excel Tables in PowerPoint Slides
Step 2: Copy the table in Excel. Using your mouse or arrow keys, highlight the table of data in Excel. On the Home ribbon, click the Copy button or press Ctrl+C to copy the data table to the Windows Clipboard. Step 3: Prepare the slide in PowerPoint. Create a new slide in PowerPoint.
Free Microsoft 365 Online
Turn your ideas into compelling presentations using professional-looking templates. Use animations, transitions, photos, and videos to tell one-of-a-kind stories. Co-author team presentations at the same time, from anywhere.
Automatically Create PowerPoint Slides from Excel (3 Easy Ways)
Method 2 - Use Paste Special to Generate Slides from Excel. STEPS: Open Excel's saved worksheet to insert data. Select the dataset you want to copy. Click on Copy or press Ctrl + C. Open PowerPoint and click on the slide where you wish to connect the Excel data. Click Paste or right-click and select Paste Special. A new dialog box appears.
Online PPT to XLSX converter
Convert WORD to PDF, EXCEL to PDF, PDF to WORD, POWERPOINT to IMAGE, VSDX to PDF, HTML to DOCX,EPUB to PDF, RTF to DOCX, XPS to PDF, ODT to DOCX, ODP to PPTX and many more document formats ... PowerPoint Presentation . A file with PPT extension represents PowerPoint file that consists of a collection of slides for displaying as SlideShow. It ...
How to Embed an Excel File in PowerPoint (5 Easy Ways)
Method 1 - Embedding an Entire Excel File in PowerPoint. Select the Insert tab on the Ribbon in PowerPoint. Click on the Object command on the Text group of commands. In the Insert Object dialog box, click on the radio button of Create from file option. Choose the Browse… button.
How can I hyperlink from PowerPoint to Excel, linking to a specific tab
I am successful in creating the Hyperlinking and obtaining the desired results, however after I save the PowerPoint file, it deletes the tab and named range that were included in the Hyperlink. As an example: C:\<file name.xlsx>#<tab name>!<named range or cell>. This works great as entered and links properly until I save the PowerPoint file.
Create PowerPoint Slides from Excel Data • PresentationPoint
First, copy the column names to the first rows of the table from your options. The Start filling Data automatically will set to 2. Then click OK to close. The data file automatically copies to the table. Then select all cells that have numeric data, and click on DataPoint and Table again.
Convert EXCEL to POWERPOINT Online for Free
How to convert EXCEL to POWERPOINT. Upload your EXCEL files to convert. Press the "CONVERT" button. Download the converted EXCEL files instantly or send a download link to email. Note that file will be deleted from our servers after 24 hours and download links will stop working after this time period. Fast and Easy Conversion.
Become a PowerPoint pro: 7 must-know tips and tricks
To update the Excel object, right-click on it in PowerPoint and select Update Link. PowerPoint will retrieve the latest data to be reflected in the Excel object. PowerPoint will retrieve the ...
Excel and PowerPoint: Creating High-Impact Financial Presentations
Find out how you can create high-impact, data-rich financial presentations using Excel and PowerPoint. In this course, Microsoft MVP and Financial Modelling Specialist Danielle Stein Fairhurst guides you through creating financial presentations that are compelling, easy to understand, and—best of all—easy to update.
Free Online PowerPoint to Excel Converter
Click inside drop area or drag & drop your file. Wait until PowerPoint to Excel file is uploaded. Select output format from dropdown menu. Click on Convert button to start PowerPoint to Excel conversion. Download or share resulted file.
The Ultimate Guide to Copy Slide Backgrounds in PowerPoint
Slide backgrounds are the unsung heroes that bring your PowerPoint presentations to life. They help set the tone, engage the audience, and make your content pop. Consider them your canvas; with the right choice, they can elevate your presentation to new heights, drawing the audience's focus to key points while also providing an aesthetic appeal that reflects professionalism.
Macros in PowerPoint: Full Tutorial
Video Table of Contents: 0:58: Why Macros Are Useful in PowerPoint 2:44: PowerPoint Macro Demo 6:27: Lesson Overview 6:40: VBA in Excel vs. PowerPoint 10:09: Simple "Shape Swap" Macro 18:29: Macro to Swap Multiple Shapes 25:29: Recap and Summary Files & Resources: Slide Presentation - Macros in PowerPoint and VBA Tutorial (PDF)
Microsoft Office Training : Master Excel, PowerPoint & Word
Unlock the full potential of Microsoft Office with this comprehensive training course covering Excel, PowerPoint, and Word. Whether you're a student, professional, or entrepreneur, proficiency in these essential Office applications is key to success in today's digital world.
New Recent Files widgets for Word, Excel, and PowerPoint for iOS
New Recent Files widgets for Word, Excel, and PowerPoint for iOS. You can add Recent Files widgets for Word, Excel, and PowerPoint directly to your iPhone or iPad home screen. The widgets allow you to both view and open your most recently accessed files in that app from the home screen on your device. How it works. 1.