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
    • excel named range manager

    105 results for excel named range manager

    • All Tutorials
    • Video Tutorials
    • Quick Tutorials
    • All
    • Spreadsheet
    • Presentation
    • Writer
    • PDF
    How to use Name Manager

    How to use Name Manager

    01:13

    How to use Name Manager

    We can use the Name Manager to set a fixed name for the cell area, which can be more simple and intuitive in function calculations and it can be also used in Microsoft Office Excel and Openoffice. Take this spreadsheet as an example. We can select the cell range from A2 to A10 and click the Name Manager in the Formulas tab. Its shortcut key is Ctrl+F3.In the pop-up dialog box, click New, enter a custom name, select the scope of use, and finally click OK.In this way, we will give the ce....

    Spreadsheet 538 views
    More features in Splitting Columns

    More features in Splitting Columns

    03:06

    More features in Splitting Columns

    When several pieces of information are filled in one cell, we often need to split it into multiple columns, and both WPS Spreadsheets and Microsoft Excel support splitting columns. Take this table as an example. In Microsoft Excel, we select the cell range of A2:A11, click the Data tab, click Text to Columns, and we can choose Delimited or Text Width to split columns manually. In addition to this original method, WPS Spreadsheets has a new feature, namely, Smart Split Columns. It has t....

    Spreadsheet 89 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
    More features in Reading Layout

    More features in Reading Layout

    00:45

    More features in Reading Layout

    Faced with huge amounts of data, we find it difficult to locate the selected cell or cells range. At this point, Reading the Layout can help a lot. Microsoft Excel doesn't support reading mode without plug-ins, while WPS Spreadsheets has the function of Reading Layout. Take this table as an example. 1. Click the View tab, and click the Reading Layout button to select a preferred color.2. When you click a cell, the row and column it lies in are highlighted. You can easily find the s....

    Spreadsheet 35 views
    Why error message #NAME? occurs and how to solve it

    Why error message #NAME? occurs and how to solve it

    03:29

    Why error message #NAME? occurs and how to solve it

    When processing data in a table, the #NAME error might occur. There are four possible causes: first, the formula name was misspelled. Second, the double quotation marks were omitted for text values. Third, the colon was omitted in a range reference. Fourth, the formula refers to a name that has not been defined. First, the formula name was misspelled Take this table as an example. When we use the formula =SUN(C3:C12) to calculate the total sales of all products, the calculation result ....

    Spreadsheet 12 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
    How to make conference table cards in batches

    How to make conference table cards in batches

    02:58

    How to make conference table cards in batches

    Making conference table cards is a necessary skill for civilian staff. Today we will learn about how to make double-sides conference tables. Step 1. Create a single table.First of all, click the Page layout tab, and set the page layout to Landscape.To make the table more exquisite, we have inserted a two-column, one-row table and a background image into the document in advance.Now, we can choose the desired WordArt effect and add it to the appropriate position in the cells on both side....

    Writer 4 views
    How to find, replace, and locate content

    How to find, replace, and locate content

    02:27

    How to find, replace, and locate content

    When we are using WPS Document to edit documents, there is always a high frequency of using search and replace features. These features not only can help us locate content, and replace it with specified content but also can replace the format of the text. It saves us a lot of time when we are editing the document, and increases the efficiency of work. Take this document as an example, when we are reading, we may want to quickly know where the character named Bennet has appeared in the ....

    Writer 9,726 views
    Prev 123456...1314 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