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
    • analysis for office excel add in

    653 results for analysis for office excel add in

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

    How to make fundamental analysis of stocks with a K-line chart in WPS Office Excel

    Welcome to WPS Official Academy to check the contents of how to make fundamental analysis of stocks in excel. The most effective way to make fundamental analysis of stocks is to create a K-line chart, also called the candlestick chart. Take this AMZN Stock as an example. Here is the stock data within a month, and we need to create a K-line chart with this data. · Step 1: Create a K-line chart to make the fundamental analysis of stocks1. Select the cell range A2:E24, which contains the ....

    Spreadsheet 368 views
    How to merge multiple worksheets into a worksheet

    How to merge multiple worksheets into a worksheet

    01:28

    How to merge multiple worksheets into a worksheet

    By the end of the year, the Indonesian branch needs to make statistical analysis on the sales performance of the whole year. Now, we need to merge all the sales records from January to December into a worksheet, making the PivotTable function possible to use. What can we do? Go to the Data tab, click the Merge Sheet drop-down button, and click the merge multiple worksheets into a worksheet option. Click the Add File button in the pop-up dialog box, select the files from January to Dece....

    Spreadsheet 22 views

    Compare two excel files for differences in WPS Office Excel

    Welcome to WPS Official Academy to check the contents of compare two excel files for differences in WPS Office Excel. We often need to compare the data from two different excel files, but it would be troublesome to compare each item one by one with naked eyes. So how can we compare two excel files for differences in a quick and easy way? Let’s have a try step by step. Here we take two tables of employees performance appraisal for example. We can find the two tables are inconsistent wit....

    Spreadsheet 592 views

    Compare two sheets for differences in WPS Office Excel

    Are you ready to master how to find differences between two sheets in WPS Office Excel? After learning this WPS free tutorial, you will be advanced from a beginner in WPS Spreadsheet. Sometimes we need to compare two worksheets and find out the differences between them but you’ll feel dizzy to compare each item one by one. At this point, the View Side by Side and Manage Duplicates function can help a lot. Let’s have a try step by step.Here we take two performance appraisal sheets (Jan....

    Spreadsheet 417 views

    Compare two sheets for duplicate rows in WPS Office Excel

    Welcome to WPS Official Academy to check the contents of how to compare two excel spreadsheets for duplicate rows. It would be a waste of time to search for duplicate rows by comparing each two rows manually. WPS Office provides a function of Highlight Duplicates to help you compare two sheets for duplicate rows quickly. Let’s have a try step by step. Here we take two lists of participants as examples. We want to find out the participants who have participated in both conferences by hi....

    Spreadsheet 533 views

    Quickly add hyperlink to PDF in WPS Office

    Unsure how to add a hyperlink to PDF? WPS Academy is designed to help you out! In today's tutorial, we will introduce you to the most convenient method to add a hyperlink to a PDF file in WPS Office. Continue to check this free course!For the purpose of adding follow-up information, we often need to add a hyperlink to help the readers view more. WPS Office successfully simplifies the procedure of adding a hyperlink.lQuickly add a hyperlink to PDF in WPS Office1. Open the PDF file i....

    PDF 221 views

    How to convert word/excel/ppt to pdf for free in WPS Office

    Welcome to WPS Official Academy! Are you looking for free pdf converter with powerful functions? That's it! WPS Office is a perfect choice for you to convert word/excel/ppt to pdf files for free. After reading this quick tutorial, you are able to quickly perform conversions between word/excel/ppt and pdf. lSimple steps to convert word/excel/ppt to pdf for free in WPS Office1. Open the word/excel/ppt documents you want to convert in WPS Office.2. Go to the Tools tab, and click Expor....

    PDF 322 views

    How to add signature to PDF in WPS Office

    Wondering how to add a signature to PDF? This free tutorial offered by WPS Official Academy will take you through the simple steps to insert a signature in a PDF file in WPS Office. No hesitation to read and master within 3 minutes!There are various reasons why you need to add a signature to PDF in WPS Office. And WPS Office is sure to provide you with the fastest method.lSteps to add signature to PDF in WPS Office1. Open the PDF document in WPS Office.2. In the Insert tab, click the S....

    PDF 221 views
    Prev 123456...8182 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