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

        2174 results for how to find inverse of log

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

        2174 results for how to find inverse of log

        The Go to and Find & Replace function of data

        The Go to and Find & Replace function of data

        11:15

        The Go to and Find & Replace function of data

        We mainly study two methods of targeted search, Go to and Find, which are the same in objectives to find the desired cells, and different in search mechanism. Specifically speaking, Go to plays its role based on the cell's own attributes, such as constants, formulas, and blanks. While Find is more flexibly used to set some keywords and cell formats.In addition to exact search, we can use the two wildcards, * and ?, to apply the approximate lookup to the text.

        Spreadsheet 16.7K views
        How to find, replace, and locate content

        How to find, replace, and locate content

        02:27

        How to find, replace, and locate content

        When we are using WPS Document to edit documents, there is always a high frequency of using search and replace features. These features not only can help us locate content, and replace it with specified content but also can replace the format of the text. It saves us a lot of time when we are editing the document, and increases the efficiency of work. Take this document as an example, when we are reading, we may want to quickly know where the character named Bennet has appeared in the ....

        Writer 107.6K views
        How to find the specified text content in WPS Presentation

        How to find the specified text content in WPS Presentation

        01:06

        How to find the specified text content in WPS Presentation

        When using WPS Presentation, how can we quickly find the text in the slide? Take this presentation as an example. If we want to find the WPS in this file quickly, we simply click the Home tab and then click Find. Its shortcut key is Ctrl+F. In the pop-up dialog box, enter WPS in the edit box. We can also check the replacement conditions as needed, such as Match case and Find whole words only.Once we set it up, click Find next to quickly find the specified text content in the presentati....

        Presentation 10.1K views
        How to insert and find bookmarks in WPS Writer

        How to insert and find bookmarks in WPS Writer

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

        Writer 14.7K views
        How to delete blank rows of table in batches

        How to delete blank rows of table in batches

        00:51

        How to delete blank rows of table in batches

        When we encounter many blank rows in a table, it can be troublesome to delete them one by one. Then how can we accurately delete all the blank rows in batches at once? We click the Home tab, find the Find and Replace drop-down button under the tab, and choose the Go To option. Or we can use the shortcut key Ctrl+G to open the dialog box.In the Go To dialog box, check the Blanks option, and then click Go To. We can see that all the blank rows are selected. Click the right mouse button, ....

        Spreadsheet 15.9K views
        How to quickly update the table of contents

        How to quickly update the table of contents

        01:10

        How to quickly update the table of contents

        How can we quickly update the table of contents when we need to modify the title content, location, and page number after setting up the table of contents? Take this document as an example. We found that the current page number is incorrect, so we modified the page number. At this time, the page numbers in the table of contents are not updated. And now we click the table of contents, and click the Update TOC button of the References tab. In the pop-up dialog, we choose Update page numb....

        Writer 17.4K views
        How to adjust line spacing of the text

        How to adjust line spacing of the text

        01:18

        How to adjust line spacing of the text

        After we finish editing the text content, we need to adjust the font size and line spacing of the text in order to make it easy to read. So how can we adjust line spacing of the text? Take this document as an example, select all the text content, then click the Line Spacing button of the Home tab. Users can select the amount of line spacing here according to their needs. If there are is no proper options, users can also set line spacing by themselves. 1.Click the Line Spacing button o....

        Writer 23.1K views
        How to set the calculated field of the pivot table

        How to set the calculated field of the pivot table

        01:49

        How to set the calculated field of the pivot table

        We often need to use a pivot table to calculate sales in the work of commodity sales. So how can we quickly count the sales by setting the calculated fields of the pivot table?Take this pivot table as an example. As is shown in this pivot table, if we want to count the total sales, average sales, maximum sales, and minimum sales of each product, we only need to enter the fields in the pivot table to set it up.First, we need to drag the Total sales field to the VALUES list box three tim....

        Spreadsheet 41.2K views
        Prev 1 2 3 ... 271 272 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