764 results for how to open xml in excel
- All Tutorials
- Video Tutorials
- Quick Tutorials
How to convert Excel to PDF02:50
How to convert Excel to PDF
PDF is a highly compatible format that occupies little space and is easy to transfer. Converting a table into a PDF file is often needed in daily study and work. Here are the steps. Take this table as an example. Click the Tools tab, then click the Export to PDF button. A dialog box Export to PDF will pop up, where you can select the small icon to the right of the file name to rename it. We can choose Active sheet for multi-page tables to set the export range.When we want multiple tabl....
How to use OCR in PDF01:16
How to use OCR in PDF
Optical character recognition, also called OCR, is practical to extract text information from a picture. It can also maintain the content layout in the source picture. The first example will show you how to extract text from a picture.1. Go to the Tool tab and click OCR.2. In the pop-up dialog, click Screen Capture to take a screenshot of a selected area.3. Choose Extract text only.Then, we can get the text from the dialog on the right-hand side.If you've joined WPS Premium, you ca....
How to set a worksheet in WPS Spreadsheet03:53
How to set a worksheet in WPS Spreadsheet
The Worksheet feature of the WPS Spreadsheet can perform several basic operations on the table. So now I'm going to show you the usage of Worksheet feature that it could be also used in Microsoft Office Excel and Openoffice. · Insert SheetClick the Home tab, select Worksheet, then select Insert Sheet. Now we can set the number and position of the insert in the popup dialog box. Or we can also click the plus sign in the bottom column of the table to add directly.· Delete SheetClick....
How to consolidate data in WPS Spreadsheet01:28
How to consolidate data in WPS Spreadsheet
In daily work, we often need to summarize and calculate some related data. By using the Consolidate feature, we can quickly calculate the data in multiple worksheets. This feature can be also used in Microsoft Office Excel and Openoffice. Now let's learn it together! Take the following table as an example. You can see that there are sales data from different staff. Now we want to count the total sales volume of all employees. 1. Create a summary sheet in Spreadsheet.2. Select cell....
How to insert attachments in WPS Writer01:11
How to insert attachments in WPS Writer
When editing a document, we sometimes need to add related attachments to explain more detail. At this time, we can use the Insert Attachment function to open the attachment in the original file directly. It can greatly improve our work efficiency. So how can we do that? Take this document on introduction to Monet's as an example. We can insert his work as an attachment at the end of the document. It can make it easier for people who read this document to understand Monet.1. Click t....
How to insert calculated fields in PivotTable01:06
How to insert calculated fields in PivotTable
Take this sales performance table as an example. We want to generate a new column, "sales commission" based on this PivotTable. (Tips: Sales commission is equal to sales amount multiplied by 0.08.) So, how do we do that? First, we click the Options tab, and the Fields, Items drop-down button, select Calculated Fields, then the Insert Calculated Field dialog will pop up.In the Name edit box, input "Sales commission". In the Fields area, choose Sales amount. In the Formula edit box, inpu....
How to insert pictures in WPS Presentation02:13
How to insert pictures in WPS Presentation
When using WPS Presentation, we can insert pictures to make the slides more beautiful and help others better understand the text content. So how can we insert and set pictures in slides? Take this slide as an example.1. Click the Insert tab, and then click Picture.2. In the popup window, click From File.3. Select the picture we want to insert and click Open. As we can see, the picture is inserted into the slides now. After inserting the picture, we can see that there are eight small do....
How to insert attachments in PDF files01:08
How to insert attachments in PDF files
We use powerful PDF in our daily life nearly every day.To better explain the content, we often need to add multiple attachments in PDF. Purchase our WPS Premium, and then you can use the Insert attachment feature. By using this feature, you can directly open the attached file in the original PDF.Take this PDF as an example.1. Click the Insert tab.2. Then click Attachment.3. At this time, click the place where we want to place the attachment, then find the file we want to insert in the ....