- All Tutorials
- Video Tutorials
- Quick Tutorials
640 Search results
How to insert and find bookmarks in WPS Writer01:13
How to insert and find bookmarks in WPS Writer
No matter you are students, teachers or business workers, can create and edit documents efficiently by WPS Writer as text editors. Easy to use like Microsoft Word.We cannot finish reading a long document all at once, so we can create bookmarks for the document contents to record the location we saw this time. Click the position where the bookmark needs to be Inserted. Then, select the Insert tab and click the Bookmark button to pop up the dialog box. We can enter the name of the Bookma....
Use VLOOKUP function to create dynamic charts03:44
Use VLOOKUP function to create dynamic charts
In the last video, we introduced the tips for making dynamic charts quickly. And this video will show you how to create dynamic charts with the help of the VLOOKUP function. Some knowledge points such as drop-down lists, VLOOKUP function, and absolute references are involved in making dynamic charts. If you are not familiar with these knowledge points, you're welcome to enter WPS Academy to search for learning. Take this table as an example. We're going to create a dynamic char....
Create simple and intuitive mini charts03:10
Create simple and intuitive mini charts
The mini chart can help us to compare and analyze data of a row or column. It is very useful when presenting data. So in this video, we are going to show you how to create simple and intuitive mini charts.In Sheet1, we can see Monthly sales of clothing. But we can't visually tell the difference between sales each month. Therefore, we should use the mini chart.1. Click the Insert tab.2. Click the Line buttons.3. Now a Create Sparklines dialog box will pop up.4. Select cells B3:J3 as....
Quickly create dynamic charts01:12
Quickly create dynamic charts
We often use dynamic charts in our practical work. Use the mouse to select different preset items in the slicer. Then the chart will change with the selected item. This video will show you how to quickly create simple dynamic charts. Take this table as an example. We select any cell in the table, click Table under the Insert tab to create a super table, or we can use the shortcut Ctrl+L to quickly open Create Table, and click OK. Get into the Table Tools tab, and click Insert Slicer. I....
How to use the read mode of PDF files.02:09
How to use the read mode of PDF files.
With WPS PDF, you can read, take annotation, compress, convert PDF to jpg, highlight, search, process&edit pdf documents on both windows, mac pc and android mobiles.Today, We will learn how to use PDF read mode.Click the Home tab before clicking the read mode, then the page will automatically hide other irrelevant function buttons, enabling users' immersive reading. · BookmarksWhen the e-book is too lengthy to read all at once, we can add a Bookmark and name it.1. Right-click the b....
How to create a table with one click01:35
How to create a table with one click
Did you know that, when you are using WPS Spreadsheet, you can directly create a table in the original datasheet? The generated table comes with functions such as sorting, filtering, and setting styles, which can save us a lot of time for subsequent operations. For all, easy our work with WPS Spreadsheet like Microsoft Excel. Here are the steps to create a table. Take the sales table in this article as an example. 1. Click the Table button in the Insert tab. (Notes: You can also use th....
How to use the Excel MID function01:54
How to use the Excel MID function
When using WPS Spreadsheets to process data, sometimes we need to catch part of the data from a series of numbers. We can use the MID formula to realize it, to catch up a certain length of characters from a series of numbers. In this example, there is a list of phone numbers. The MID function can extract the long series of numbers, keeping the last seven numbers when removing the first three characters. Select cell D2 and click the Insert Function to pop up the Search for a function d....
Use pivot chart to create a dynamic chart04:49
Use pivot chart to create a dynamic chart
A pivot chart is a graphical representation of a pivot table, which can clearly and intuitively visualize the data. Suppose we now want to create a pivot chart of the total sales of each branch in the fourth quarter. How can we do that? Take this table as an example. Select any cell in the data area, click the Insert tab, then the PivotChart button. Now select New Worksheet in the popup dialog box, and click OK. After that, we can create an empty PivotTable and an empty PivotChart.In W....