Shulou(Shulou.com)11/24 Report--

Hello, everyone! I am Xiaolan who "loves and kills each other" with Excel.

In daily life and office, we often use Office software "family bucket"-Excel, PPT and Word.

But sometimes, we need to convert different documents into other formats, for example, we need to transfer the tables and charts in Excel to PPT and Word, and we need to convert Word to PPT for use in work reports.

In order to help students work efficiently and get off work early, today we will take a look at these "Office format conversion tips" ~

First take a look at the catalogue to learn about 👇👇👇

1. Excel and Word transfer each other

Excel to Word

Word to Excel

II. Mutual conversion between Excel and PPT

Excel to PPT

PPT to Excel

III. Mutual conversion between PPT and Word

Word to PPT

PPT to Word

Excel and Word transform each other

▋ Excel to Word

Excel is the work of data analysis and processing. In general, it does not need to be specially converted to Word format.

But at some point, we also need to transfer the beautiful tables made in Excel to Word. For example: when writing papers and making analytical reports.

So, how to solve this problem?

In fact, it is very simple, and it can be realized with the help of the [selective paste] function.

Procedure:

❶ copy the table area you want to move in Excel, switch to Word, and select paste-selective paste under the start tab.

❷ in the pop-up window, select Microsoft Excel worksheet object, and click OK.

The effect is as follows:

▋ Word to Excel

The conversion from Word to Excel is relatively rare, but in order to satisfy the students' thirst for knowledge, Xiaolan is still here to tell you a little bit.

If you want to extract the data from the Word file, you can refer to this article: how to convert Word to Excel? In this way, the data is clear and intuitive!

If you need to convert the whole Word file into an Excel table, students can refer to the following steps:

❶ saves the Word form [as] web page format (.htm)

❷, open or create a new Excel form, click the "File" tab-"Open", and select the previously saved web page file to open.

❸ [Save as] Excel file (.xlsx).

So it's done.

Excel and PPT transform each other

▋ Excel to PPT

This feature is used in most cases to transfer tables and charts from Excel to PPT.

❶ transfers the table from Excel to PPT.

Method 1:

After copying the region in Excel, paste [Ctrl+V] into PPT, and select "embed".

Method 2:

As in the Excel to Word above, paste the table selectively as a Microsoft Excel worksheet object.

These two methods are actually the same, double-click can open the Excel table, modify the content, but there are some differences in operation, students are free to choose.

❶ transfers the chart from Excel to PPT.

Generally, you only need to paste the table area copied in Excel into PPT, and select [keep source format and linked data].

The advantage of this is that if the content of the Excel is modified, the PPT can automatically synchronize.

▋ PPT to Excel

PPT to Excel this function is generally less used, if you really want to use, select all the contents of PPT, copy and paste to Excel.

If someone wants to save the Excel file built into PPT, you can:

Select the chart or table in PPT, right-click, and select "worksheet object"-"Open"-"Save as" on it.

PS: provided that the chart or table in PPT is selectively pasted as a Microsoft Excel worksheet object.

PPT and Word transform each other

▋ PPT to Word

You can switch with one click with the help of the shortcut tools that come with Office, don't you believe it? Let's take a look.

❶ opens the Files tab-options.

❷ finds the Quick access Toolbar and selects commands that are not in the Ribbon from the drop-down menu of Select Command from.

Then swipe down to [create handouts in Microsoft Word] from the list, then add on the right, and click "OK".

The icon after the addition looks like this:

.

❸ directly clicks the icon, selects the appropriate one from the layout below, and then clicks OK.

Of course, you can also save PPT in PDF format and open it for editing with Word. Click "File"-"Save as PDF":

▋ Word to PPT

This can also be achieved with the tools that come with Office, similar to the conversion from PPT to Word.

❶ follows the steps written above, open the Quick access Toolbar, find [send to Microsoft PowerPoint] in the list, and then "add" on the right.

The icon after being added looks like this:.

❷ switches the display window of Word to outline View and adjusts the typesetting format of the text.

❸ automatically completes the conversion from Word to PPT by clicking on the icon you just added.

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: Zhu Lan, Editor: Xiao Pang

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.