WPS Academy
Free Download
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches

        2513 results for use of wps office

        • All Tutorials
        • Video Tutorials
        • Quick Tutorials
        • All
        • Spreadsheet
        • Presentation
        • Writer
        • PDF

        2513 results for use of wps office

        Smart use of Hyperlink in WPS Writer

        Smart use of Hyperlink in WPS Writer

        01:49

        Smart use of Hyperlink in WPS Writer

        No matter you are a student, teacher, or business professionals, you can create and edit documents efficiently by WPS Writer as text editors. Hyperlinks in the text can jump to the webpage or the specified position in the document. Today, we will learn how to add hyperlinks. · 1. Jump to to a location on the webFirst, place your cursor on where the hyperlink needs to be added, and enter the Insert tab, click Hyperlink to generate a dialogue box. Head to Existing File or Web Page on the....

        Writer 11.1K views
        How to use the formula function of table in WPS Writer

        How to use the formula function of table in WPS Writer

        02:38

        How to use the formula function of table in WPS Writer

        You know what? In WPS Writer, not only can we perform simple calculations on the table data, but apply the formulas of built-in functions. Here are a few commonly used functions for you to explore. Take this table as an example. Assume that we want to count how many Expense there are in the whole table. We can use the COUNT function to count the number of data in the table.Tips: The COUNT function in WPS can only be applied in counting number data, while the empty cells, logical value....

        Writer 9.1K views
        How to use the fast calculation function of table in WPS Writer

        How to use the fast calculation function of table in WPS Writer

        01:21

        How to use the fast calculation function of table in WPS Writer

        Do you know how to perform statistical operations on tabular data inserted in a document? It teaches you to perform quick calculations in a document in one minute.For example, let's say we want to figure out the total sales of small businesses in Q1 for all regions.First of all, insert a total column on the right of the table,select the data cell of row Q1, click the Table Tools tab, click the Fast Calculation drop-down button, and select Sum to calculate the Sum of the data in thi....

        Writer 8.8K views
        Use the DATEDIF function to calculate the intervals of dates

        Use the DATEDIF function to calculate the intervals of dates

        03:12

        Use the DATEDIF function to calculate the intervals of dates

        The DATEDIF function is mainly used to calculate days, months, or years between two dates. Now we are going to use this table to show you the usage of this function. This table records the entry date of the company’s employees. Now we want to calculate the employee’s year of service. We can first click cell C2 and then click Insert Function. Insert DATEDIF in the Search for Function of the dialog box. Click the OK button, and then the Function Arguments dialog box will pop up.Start dat....

        Spreadsheet 24.3K views
        How we can use the settings of borders and shading

        How we can use the settings of borders and shading

        01:43

        How we can use the settings of borders and shading

        When we are using WPS Document to edit text, we sometimes need to put a border around the text, or we may also want to add a special shading color to the text in order to highlight the keywords. So now the problem is, how can we do that? Take this resume as an example. If we want to highlight the border, we should select all the content first, and click the Home tab, and then lick the Outside Borders drop-down button. Here, we can see different styles of border lines. Click Borders and....

        Writer 32.5K views
        How to use Icon Library in WPS Presentation

        How to use Icon Library in WPS Presentation

        01:29

        How to use Icon Library in WPS Presentation

        It usually takes an amount of time to search for suitable icons to beautify the slides. Why not subscribe for WPS Template Premium membership right now to enjoy massive icon resources? How can we beautify the slides effectively? WPS Office provides an Icon Library with rich and diverse icon resources to perfect the slides and highlight the content. 1. Click the Insert tab, click the Icon Library button, and we can see a lot of different categories of Icons to choose from, like Recommen....

        Presentation 13.0K views
        How to use the read mode of PDF files

        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....

        PDF 27.2K views
        Instructions of printing interface in WPS Writer

        Instructions of printing interface in WPS Writer

        04:06

        Instructions of printing interface in WPS Writer

        When we use WPS Office to print documents, we often encounter a variety of printing glitches. So in this video, we are going to briefly explain the effects of each small function in the print panel. Let's take this thesis as an example. First, we need to make sure that the hardware device of the printer is normal and on-state. Meanwhile, we also need to determine whether the computer used can find your printing device in LAN. 1. Click Menu and Print. The Print dialog box also can b....

        Writer 221.2K views
        Prev 1 2 3 ... 314 315 Next
        WPS Academy
        Products
        WPS Office for Windows
        WPS Office for Mac
        WPS Office for Android
        WPS Office for iOS
        WPS Office for Linux
        Partners
        Links
        OEM Partners
        Strategic partners

        Follow us

        WPS Office Official Twitter

        WPS Office Official Facebook

        WPS Office Official YouTube