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
    • s curve in project management in excel tutorial

    189 results for s curve in project management in excel tutorial

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

    How to draw price elasticity of demand curve in WPS Office Excel

    In this article, you will know how to draw price elasticity of demand curve in excel with simple steps as following: The demand curve shows the relationship between price and the number of units demanded.· Step 1: Insert a chart in WPS Spreadsheet.1. Select the cell range, head to the Insert tab, and click Chart to pop up a dialog.2. Click Line and then choose a preferred style by clicking Use. WPS Office provides one template for common users, and you can subscribe for Template Premiu....

    Spreadsheet 374 views
    More features in picture inserting

    More features in picture inserting

    01:53

    More features in picture inserting

    WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. WPS Spreadsheet and Microsoft Excel both have the function of inserting pictures. Compared with Microsoft Excel, WPS spreadsheet has an added advantage-Embed to cell. In Microsoft Excel, we usually need to manually adjust the size of the pictures after inserting them. If the position of the table changes, the inserted pictures will not fit in the new ce....

    Spreadsheet 61 views
    How to insert a background image and print it out in WPS Spreadsheet

    How to insert a background image and print it out in WPS Spreadsheet

    01:31

    How to insert a background image and print it out in WPS Spreadsheet

    WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Sometimes, background images are nice-to-have if we are to beautify the table. Today, we will learn how to add a background picture and print it out. First, head to the Page Layout tab, click the Background button and select the desired images. Note: The inserted image, either too big or too small, is inappropriate. Here is a smart way for adjusting tho....

    Spreadsheet 2,489 views
    How to apply accounting number format in WPS Spreadsheet

    How to apply accounting number format in WPS Spreadsheet

    00:56

    How to apply accounting number format in WPS Spreadsheet

    WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Counting the amount in areas of finance and accounting is quite necessary. Take this Budgetary sheet as an example. The table's currency symbols and decimal points are badly aligned, which is not convenient for us to consult and calculate. How can we improve it? Select the cells D7-D15. Click Number Format in the Home tab, and select More Number For....

    Spreadsheet 155 views
    Edit settings in WPS Spreadsheet

    Edit settings in WPS Spreadsheet

    03:47

    Edit settings in WPS Spreadsheet

    WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc. Today, we will learn Editing settings in WPS Spreadsheet. A personalized editing style will make the table easier to edit and read. First, click Menu in the upper left corner of the table, select Options, and click Edit in the pop-up dialog box to get into the Edit Settings interface. Here I will elaborate on how the functions of Edit Settings can be put int....

    Spreadsheet 257 views
    Add comments to explain the content.

    Add comments to explain the content.

    01:52

    Add comments to explain the content.

    WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. In WPS Spreadsheet, we can supplement the contents by adding comments, which can make it easier for others to understand what the contents means. Take the table as an example, select the cell or cell range to which comments need to be added, click the Review tab, and click the Edit Comment button. You can also use the shortcut key Shift+F2 and fill in t....

    Spreadsheet 5 views
    Formatting time in WPS Spreadsheet

    Formatting time in WPS Spreadsheet

    01:08

    Formatting time in WPS Spreadsheet

    WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Today, we will learn how to format the time. Before setting, we need to be aware of the correct way to record time.A complete-time duration consists of hours, minutes and seconds, and each value is separated by colons.For example: 12:25:25. Take this table as an example, select the cells A4-A14. Click the Number Format drop-down button in the Home tab, ....

    Spreadsheet 99 views
    How to consolidate data in WPS Spreadsheet

    How to consolidate data in WPS Spreadsheet

    01:28

    How to consolidate data in WPS Spreadsheet

    In daily work, we often need to summarize and calculate some related data. By using the Consolidate feature, we can quickly calculate the data in multiple worksheets. This feature can be also used in Microsoft Office Excel and Openoffice. Now let's learn it together! Take the following table as an example. You can see that there are sales data from different staff. Now we want to count the total sales volume of all employees. 1. Create a summary sheet in Spreadsheet.2. Select cell....

    Spreadsheet 1,635 views
    Prev 123456...2324 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