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 in excel 2010

    370 results for analysis in excel 2010

    • 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
    More features in AutoFilter

    More features in AutoFilter

    02:39

    More features in AutoFilter

    When dealing with large amounts of table data, we often need to temporarily hide some of them with AutoFilter to focus on those we need. Here we will compare the AutoFilter function of WPS Spreadsheets and Microsoft Excel. In general, both of them support filtering data according to numbers, text, color and so on.WPS Spreadsheets has three special advantages. Let's go through them one by one.First, Click the Home tab, and click the AutoFilter drop-down button to turn on the AutoFil....

    Spreadsheet 48 views

    LOOKUP Function in Excel

    WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more.· Description:The LOOKUP function can search a value in a column or row and returns a particular value from the same place in another column or row. It has two Syntax. · Syntax1 :LOOKUP(value, array) · Arguments:Value: The value to search for in an array, which must be in ascending order.Array: An array of values.(contains both the values to search for a....

    Spreadsheet 1,142 views

    Goal Seek in Excel

    Goal Seek feature is used to solve an equation. Assuming a certain result of a formula, work out what one of its variables should be. To make it more comprehensible, we take a simple case as an example. Here is a sales table. Commission equals to 5% of total sales (A9=SUM(B2:B6)*0.05). Tips: Goal Seek only works when there is a formula. Based on the sales of Lipstick, Liquid Foundation, Eye Cream and Body Lotion, the Commission now is 671.65. At this point, we want to know that when ....

    Spreadsheet 1,042 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

    MATCH Function in Excel

    WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. · Description:The INDEX function can look up a value regarding its row and column numbers, which can be used in two forms: array form and reference form. · Syntax1(Array form): INDEX (Array, Row_num, [Column_num].) · Arguments:Array: Specified array or range of cells.Row_num: The row number of the specified arrayCol_num: [Optional] The column number of....

    Spreadsheet 803 views

    HLOOKUP Function in Excel

    To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy. · Description:The HLOOKUP function can look up a value in the top row of values and returns a value in the same column from a row that you specify. · Syntax: HLOOKUP(lookup_value, table_array, row_num, range_lookup) · Arguments:Lookup_valueThe value to be found in the first row of the table. (can be a value, a reference, or a text string).Table_arrayThe table of text, numbers, or logic....

    Spreadsheet 637 views
    Prev 123456...4647 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