Your browser version is outdated.
To browse WPS Academy normally, we recommend you to upgrade to the latest version of Internet Explorer or try other browsers.
chrome
Chrome
firefox
Firefox
WPS Academy

WPS Academy Free office suite tutorials

  • Home
  • Video Tutorials
    WPS Spreadsheet Data Entry and Editing Data Analysis Data Visualization Page Layout Review and Security More Functions and Formulas
    WPS Writer Text Writing Insert and Edit Page Layout Review and Security References More
    WPS Presentation View Insert and Edit Animation and Slide Show More Review and Security
    PDF Multiple Editing Tools Insert More Add Comments Page Management File Format Conversion Print
  • Graphic Tutorials
    WPS Spreadsheet Data Entry and Editing Data Analysis Functions and Formulas Page Layout Review and Security More
    WPS Writer Text Writing Insert and Edit References Page Layout Review and Comments Security More
    WPS Presentation Insert and Edit Animation and Slide Show Premium Benefits More
    PDF Edit View Review and Comments Security Premium Benefits More
    WPS Basics Home Page Settings and Account Premium Benefits More
    Beginner Tutorial Preferences Settings Get Started Common Uses
  • Download
    WPS Office for Windows
    WPS Office for Mac
    WPS Office for Android
    WPS Office for iOS
    WPS Office for Linux
Top Searches
    Login/Sign up
    • Home
    • Popular
    • validity powerpoint

    214 results for validity powerpoint

    • All Tutorials
    • Video Tutorials
    • Quick Tutorials
    • All
    • Spreadsheet
    • Presentation
    • Writer
    • PDF
    Set formulas as the validation condition

    Set formulas as the validation condition

    00:59

    Set formulas as the validation condition

    Sometimes we need some preconditions to improve the validity when inputting data. Today we will learn how to set formulas as the validation condition.For example, we only need to enter the spouse's name if the marital status in column D is "married."First, select the cell area E3: E11, click "Validation" in the "Data" tab to enter the "Data Validation" dialog, where we can select "Custom" at the "Allow" drop-down box.Then, enter the formula =D3="married." It means that people can ....

    Spreadsheet 11 views

    How to attach Excel file to PowerPoint

    1. Click the Insert tab → the File Object button.2. Select the Excel file we want to insert, and click the Open button. Then, we can attach this Excel file to PowerPoint.3. Click the left mouse button to move the attachment icon, then we can change the location of the attachment. And, drag the small white dots around the icon, then we can change the size of the icon.4. Click the Slide Show from Current button to start the slide show. And we can click the attachment icon to pop up the c....

    Presentation 1,122 views

    Typewriter effect in WPS Office PowerPoint

    Welcome to WPS Official Academy to check the contents of Typewriter effect in WPS Office PowerPoint. The Typewriter effect is one of the amazing animations to make a perfect presentation. So how can we make a typewriter effect? Let’s have a try step by step. If you want to make a vintage typewriter look, we recommend going with a Courier New font in black.1. Insert a text box and input the content that you need.2. Set the font size as needed, and then set font style and font color. 3.....

    Presentation 544 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 44 views

    How to rename a hyperlink in WPS Office PowerPoint

    Are you ready to master how to rename a hyperlink in WPS Office PowerPoint? With the help of this free tutorial in WPS Official Academy, you will become advanced from a beginner in PowerPoint designing. Now let's explore how to rename a hyperlink in WPS Office PowerPoint step by step.lHere are the steps to rename a hyperlink in WPS Office PowerPoint1. Open your PPT in WPS Presentation and locate the hyperlink you want to rename.2. Right-click the hyperlink, and select Hyperlink > E....

    Presentation 283 views

    How to make video play automatically in PowerPoint

    1. Click the video and get into the Video Tools tab.2. In the Start area, select Automatically in the box.3. Click the Slide Show from Current, or use the shortcut Shift+F5 to start the slide show from the current slide.4. Then we can make video play automatically in PowerPoint. You will be the amazing reporter with WPS Presentation, which could be an alternative to Microsoft PowerPoint.

    Presentation 732 views

    Add connection points to connectors in PowerPoint

    To make the joint of a connector and a shape more clear, we can add connection points.1. Open your PowerPoint in WPS Office.2. Select the connector, and you can see four icons appear on the right of the shape. 3. Click the Shape Outline icon > Arrow Style. Then we can change its style to those with connection points as needed. We can also customize the connection points. 4. Double click the connector, and an Object Formatting pane pops up. 5. We can choose a desired size and shape for....

    Presentation 745 views

    How to create magnifying glass effect in PowerPoint?

    How to create magnifying glass effect in PowerPoint?Sometimes we need to highlight a specific area in our presentation pictures. Then we can create the magnifying glass effect in our slides.Now let’s explore the techniques step by step.1. Create a duplicate of the original picture with the shortcut key Ctrl+D. Then select the duplicate picture and click the Picture Tools tab. Then click Crop drop-down button and choose an oval shape preferably. 2.Next, narrow the cropped area as you wi....

    Presentation 637 views
    Prev 123456...2627 Next
    WPS Academy
    Products
    WPS Office for Windows
    WPS Office for Mac
    WPS Office for Android
    WPS Office for iOS
    WPS Office for Linux
    Affiliate Program
    Links
    OEM Partners
    Strategic partners
    Enterprise Sales
    Popular Searches
    Partners
    WPS Office for Windows
    WPS Office for Mac
    WPS Office for Android
    WPS Office for iOS
    WPS Office for Linux
    Affiliate Program
    Links
    OEM Partners
    Strategic partners
    Enterprise Sales
    Popular Searches