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

        2608 results for if or excel

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

        2608 results for if or excel

        Use IF function to judge data

        Use IF function to judge data

        01:48

        Use IF function to judge data

        The IF function can judge the specified condition and give two results when the condition is established and when it is not.Here is a staff interview form. Now we need to count the people who passed the interview quickly. If the interview score is greater than or equal to 6, the interviewee is passed, but the interviewee is unqualified if the interview score is less than 6. Here, we can use the IF function to judge the result of the interview quickly. The IF function syntax is as follo....

        Spreadsheet 45.0K views
        Show or hide editing marks

        Show or hide editing marks

        02:27

        Show or hide editing marks

        All users may need to show or hide editing marks to preview the editing effects or make the document look neater. Today we are going to learn about how to show or hide editing marks. · Show/Hide paragraph marksTake this document as an example. Every time we press the Enter key, a black Paragraph Mark appears, which is also called Hard Return. In general, it appears at the end of a paragraph, and its code is "^p" in a Word document.It doesn't affect printing but sometimes has a nega....

        Writer 11.5K views
        How to use the OR Function

        How to use the OR Function

        01:40

        How to use the OR Function

        WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. This is a promotion application form submitted by employees. The company sets two conditions for it.1. Length of service should be more than 3 years; 2: Personal KPI should be rated as A.The Applicant has the qualification to register when any one of the requirements is met. If you are the HR of the company, how can you quickly select qualified employee....

        Spreadsheet 9.4K views
        More features in Split or Merge

        More features in Split or Merge

        03:21

        More features in Split or Merge

        WPS Writer is easy to use as Microsoft Word. WPS and Microsoft Word both have the Split and Merge function, but what is the difference between them? We will use the same document to compare. For Microsoft Word, if we want to merge the file, head to the Insert tab, click the drop-down list at Object, select Text from File. Then select the files to be merged, and click OK.This method merges the whole document by default, and the scope of merging cannot be selected. If we want to split do....

        Writer 7.3K views
        More features in Split or Merge

        More features in Split or Merge

        02:26

        More features in Split or Merge

        Sometimes we may need to split or merge documents when creating presentations. So how can we do that? In Microsoft PowerPoint1. To merge the editing PowerPoint with new slides, we can enter the "Home" tab, click ”New Slide," and click "Reuse Slides." Select a desired PowerPoint document on the right to insert it.2. In this way, only one document can be inserted at a time, and multiple documents require repeated operations to be merged.3. Besides, Microsoft PowerPoint doesn't suppor....

        Presentation 7.3K views
        How can we add or remove text shading

        How can we add or remove text shading

        01:20

        How can we add or remove text shading

        When using WPS Writer to edit documents, we can add shading to highlight some parts of the text content. So how can we add and remove text shading? Take this document as an example. If we want to highlight the students mentioned in the notice, we can select this part of the content and click the Character Shading command button in the Home tab. By this, we can quickly add a gray shading to the selected content. Gray is the default color. If we want to delete the shading, just click the....

        Writer 44.2K views
        Insert date and time in the header or footer

        Insert date and time in the header or footer

        00:55

        Insert date and time in the header or footer

        WPS Writer allows users to add various styles of header and footer, including text, pictures, and date and time. So how can we realize inserting date and time? A footer has been added to this document. So here we take the header as an example to show how to insert date and time. Get into the Header/Footer tab and click Date and Time to pop up the dialog. On the left-hand side of the dialog, we can choose from different formats to present the date and time. Check the Update automaticall....

        Writer 18.3K views
        How to set up paging or cross-page printing in WPS Writer

        How to set up paging or cross-page printing in WPS Writer

        01:47

        How to set up paging or cross-page printing in WPS Writer

        The system prints all the pages by default when printing a document. But what if we only want to print part of the pages in the document? Today we're going to share with you two solutions.l Method 1. Select the print range.Take this document as an example. If we only need to print pages 1, 4, 5, and 9, we can click the Print button in the upper left corner or press CTRL+ P to pop up the dialog box. At Page ranges, enter 1, 4, 5, 9, and insert commas to separate them from each other....

        Writer 9.4K views
        Prev 1 2 3 ... 325 326 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