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
  • 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
    WPS 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
    Login/Sign up
    Top Searches

      • Home
      • Video Tutorials
      • Graphic Tutorials
      • Home
      • Popular
      • how do u spell red

      10 results for how do u spell red

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

      10 results for how do u spell red

      Conditional Formatting for data virtualization

      Conditional Formatting for data virtualization

      01:23

      Conditional Formatting for data virtualization

      Do you know how to virtualize data with the Conditional Formatting function? The worksheet presents the data of 'Likes to views ratios'. Today's tutorial will take this sheet as an example for data virtualising. Select the cell range B2:B10. Go to Home and click Conditional Formatting. Next, choose Data Bars and then the red Gradient Fill option. After that, we can see the data virtualized with red bars.Although the data in cell B13 is 66.42%, as we can see, the data bar fi....

      Spreadsheet 32 views
      Customize the formats to show data changes

      Customize the formats to show data changes

      01:28

      Customize the formats to show data changes

      Comparing and analyzing similar data is something we have to do. Today, we will look at how to customize the formats to show data changes.Take this table as an example. Subtract the data of 2018 from that of 2019 to get the difference. Positive numbers show progress, while negative numbers indicate underperformance and entail attention.To better illustrate, we want to display the increase in green and highlight the decrease in red with a * symbol. Right-click the data area and choose F....

      Spreadsheet 2 views
      Skillfully use Conditional Formatting to highlight  performance

      Skillfully use Conditional Formatting to highlight performance

      01:21

      Skillfully use Conditional Formatting to highlight performance

      To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy. Take this table as an example. This is a sales performance table. Now we want to add a red flag to employees whose sales are greater than or equal to $950 while giving warnings to under-performers with sales less than $700. So how can we do that? We can use conditional formatting.1. We can select the D2:D26 cell, then click the Conditional Formatting in the Home tab before choosing the....

      Spreadsheet 43 views
      How to use the spell-check function

      How to use the spell-check function

      02:31

      How to use the spell-check function

      The spell-check function of WPS helps us to quickly check spelling mistakes and provides suggestions for corrections. It saves us a lot of time to align documents. We can see that some of the content of this document has been marked with red underlines because WPS Office judged that the content of the text is wrong. At this time, we need to correct the marked content to eliminate these red underlines.Click the Review tab and click the Spell Check button. A pane will pop up on the right....

      Writer 1,291 views
      How to convert PDF files into pictures

      How to convert PDF files into pictures

      01:59

      How to convert PDF files into pictures

      We use powerful PDF in our daily life nearly every day. WPS pdf converter is easy and free for people to use.When viewing a PDF file, we may want to save the file content as a picture. So how can we do that? Take this file as an example. Click the Tools tab, then click PDF to Picture. Now a dialog box will pop up. Here, we can set the converted picture, such as Watermark, Pages, Quality and so on.We can choose output By Page or output Long picture according to actual needs.As for the u....

      PDF 2,118 views
      Create an area chart to display data trends

      Create an area chart to display data trends

      02:00

      Create an area chart to display data trends

      Do you know how to make an ordinary line chart more special? Today we are going to show you how to make a line chart with fill effects, that is, an area chart.Take this table as an example. This is the dynamic price-earnings ratio data of a certain country over a period of time. It is difficult for us to see the difference between the data. Therefore, we need to use an area chart to show the changes in the dynamic price-earnings ratio index.1. First, we click the Insert tab.2. Click th....

      Spreadsheet 63 views
      Application of Track Changes

      Application of Track Changes

      02:36

      Application of Track Changes

      When we need to highlight the changes of an article, we can apply this feature: Track Changes. · Track ChangesClick the Track Changes drop-down button in the Review tab, and select Track Changes to enter the Track Changes mode. Its shortcut key is Ctrl+Shift+E. Then when we add text to the paragraphs, the text automatically appears in red. When we delete text or change its style, there are corresponding records on the right.In simple terms, WPS Office automatically records and displays....

      Writer 4.2K views
      Use conditional formatting to make data more intuitive

      Use conditional formatting to make data more intuitive

      04:46

      Use conditional formatting to make data more intuitive

      We often need to compare and mark the table setting conditions at work. But how can we see the trend of the data more intuitively? Take this table as an example. Suppose now we want to find out the names of milk tea with a quantity larger than 100 and mark the color.1. Select the quantity area, and click the Conditional Formatting drop-down button in the Home tab.2. Choose the Highlight Cells Rules option in it. Then, you can a popup window, where you can select Greater Than, Less than....

      Spreadsheet 2,308 views
      Prev 12 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