Presenting Tables and Figures in PowerPoint

Annual reports, financial plans, or calculations: Too many tables and figures often seem unnecessarily complex. In a presentation this can quickly seem overwhelming and irritate the audience.

In most cases, however, numbers are useful and unavoidable.

This makes it even more important to be able to convince with a minimalist, clearly structured overall appearance of your presentation. In this article, we will show you how to include tables and figures in your presentation without overwhelming your audience.

6 Tips for Handling Tables and Figures in Microsoft PowerPoint

Presentations rarely work without numbers. User numbers, key figures, and statistics are important and should be mentioned. However, a presentation overflowing with numbers often misses its primary goal: to provide the audience with an engaging, understandable approach to interpreting the various numerical values.

To help you focus on the purpose of your presentation, we will present 6 tips on how to handle complex tables and figures in PowerPoint presentations.

1. Only Mention Relevant Numbers

Always ask yourself if the numbers listed add to the understanding or support your argument. Sometimes it makes more sense not to mention some numbers if they are not relevant for the purpose of your presentation.

2. Use Rounded Numbers

If possible, round numbers up or down to make them easier for the audience to understand. Numbers are usually easier to grasp when they are rounded.

3. Visualize Numbers

If possible, use infographics and images to visually support the numbers you are presenting. For instance, if you are displaying production figures, enhance the display of these figures with symbol images of the product you are talking about.

You can find a variety of professionally designed diagrams in our shop on the PresentationLoad website.

Use Gantt Charts in Your Presentations! ►Shop: https://www.presentationload.com/project-timelines-powerpoint-template.html

Use Waterfall Diagrams for Your Presentations! ►Shop: https://www.presentationload.com/waterfall-diagrams-powerpoint-template.html

4. Always Put Figures and Comparative Values in Context

When you quote a number, its context should always be easy to understand. It is important to rely on both the verbal level in the lecture and the visual level in the presentation. Comparative values should always be mapped in parallel, and the context of a number should be clearly articulated.

5. Use Infographics Instead of Tables

Instead of filling tables with numbers, create infographics that communicate the relevant numbers clearly. Ensure that you don’t show too many numbers on the graphics and use images that are related to the numbers.

You can find a number of professionally designed infographics in our PresentationLoad shop.

Use Icons in Your Presentations! ►Shop: https://www.presentationload.com/business-icon-powerpoint-template.html

Use Infographics in Your Presentations! ►Shop: https://www.presentationload.com/infographic-template-world-powerpoint-template.html

6. Use 2D Instead of 3D Diagrams

Even though 3D charts are visually appealing and a good way to grab the audience’s attention, they have limited use for presentations with high numerical content. Two-dimensional representations run less risk of distorting the conditions and are usually easier to grasp visually.

Especially with a high volume of numbers, it is important to keep the rest of your slides minimalistic.

Inserting Numbers and Cells from Excel into PowerPoint

Entrepreneurial numerical values are commonly collected and archived in tabular form, usually in Excel. To include Excel tables in your PowerPoint presentation, there are several ways. In this section, we will show you how to create and edit a well-structured Excel table in PowerPoint and provide shortcuts for faster results.

Create and Edit Excel Sheets in PowerPoint

In your opened PowerPoint project, you will find the “table” option in the “insert” tab. Once you click on “Spreadsheet,” a drop-down menu opens where you will find an “Excel spreadsheet” button at the bottom.

After you select the Excel button, two things will happen: the PowerPoint view turns into an Excel view inside the open window, and a miniature Excel spreadsheet opens on the selected slide.

This “Excel mode” lets you create a completely new table or insert content from existing tables as Office effectively opens a simplified mini version of Excel within PowerPoint.

Within Excel mode, dark corner points appear along a thick table frame. You can drag the corner points to reveal more columns and rows and enter all the necessary numbers and labels for your presentation. By pressing the Enter key, you can jump to the next cell and continue there.

As long as you have selected one or more cells of the table, you have various options for further processing and reshaping, located at the top of the screen. To finish your Excel table or to exit Excel mode, simply click next to the table on your slide again at the end of your editing.

Shortcut: Copy and Paste Directly from Excel to PowerPoint

The simple Copy + Paste function provides a faster way to create an Excel table in PowerPoint. With the shortcut Ctrl + C, you can copy marked contents, and with Ctrl + V, you can paste them into a new place.

This way, you can copy existing tables completely or partially into PowerPoint.

After selecting Ctrl + V on your PowerPoint slide, press the Ctrl key again, one at a time. Five different ways to insert the content will appear. These options significantly influence both the display and further processing of your table, making it essential to choose the right option. Here are the five different insertion options:

1. Use Target Format Templates

With this option, you can paste all copied data from Excel. PowerPoint will format the data as a table by default. This way, you can still edit the table partly, but you can no longer add or remove new cells.

2. Keep Original Formatting

All graphical attributes are taken from Excel, while PowerPoint formats the data using a standardized table. The graphic elements include font and color design, with graphics inserted as complete image objects in the upper left corner.

3. Embed

Graphic elements are adopted (font and color), and all graphics and image objects remain in place. Double-clicking on the embedded table takes you back to Excel mode for further editing.

4. Graphics

Here, the Excel spreadsheet is converted into a graphic/image and inserted into PowerPoint. Size and shape can be changed, but content cannot.

5. Adopt Text Only

With this option, only the text is transferred. Neither formatting, color scheme, nor fonts are taken from Excel.

To properly use the shortcut for your Excel spreadsheet, first copy the contents from Excel using Ctrl + C, paste them onto your PowerPoint slide using Ctrl + V, and select the “Embed” option after pressing the Ctrl key again.

Tip: Professional Table Templates for PowerPoint

If creating a visually appealing table in PowerPoint takes too much time and effort, consider our store where we offer various PowerPoint templates suitable for different themes:

PowerPoint notices changes in Excel and adjusts its display accordingly. This allows you to have data visualized live quickly. If you have questions about handling numbers and tables in PowerPoint, feel free to contact us via email at info@presentationload.com .