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
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches
      • Home
      • Popular
      • how to write long numbers in excel

      307 results for how to write long numbers in excel

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

      307 results for how to write long numbers in excel

      How to set the line numbers in WPS Writer

      How to set the line numbers in WPS Writer

      01:56

      How to set the line numbers in WPS Writer

      The usage of Line Numbers in long documents can help readers quickly find specific lines. So, how can we add line numbers? Next, I will show you the effects of setting different line number types: 1. Click the Page Layout tab and the Line Numbers drop-down button. We can see that there are different settings in the list. We can choose the Continuous Reading option to add line numbers to the entire document. 2. Choose Restart Each Page to start with number 1 on each page. 3. Choose Res....

      Writer 782 views
      How to use the MID function in WPS Spreadsheet

      How to use the MID function in WPS Spreadsheet

      01:54

      How to use the MID function in WPS Spreadsheet

      When using WPS Spreadsheets to process data, sometimes we need to catch part of the data from a series of numbers. We can use the MID formula to realize it, to catch up a certain length of characters from a series of numbers. In this example, there is a list of phone numbers. The MID function can extract the long series of numbers, keeping the last seven numbers when removing the first three characters. Select cell D2 and click the Insert Function to pop up the Search for a function d....

      Spreadsheet 514 views
      Use the text function to extract characters in cells

      Use the text function to extract characters in cells

      02:45

      Use the text function to extract characters in cells

      In this video, we'll introduce three practical functions in excel, which are the RIGHT, LEFT, and MID functions.In this example, if we want to extract the first three numbers on the right, how can we realize it? The RIGHT function could help. It can extract characters within a cell, from the right to the left. Here is the complete formula of the RIGHT function. RIGHT(text,num_chars) The first parameter text refers to the specific text to be extracted. The second parameter num_chars....

      Spreadsheet 106 views

      How to write meter square in powerpoint

      There are many reasons why you may be interested in WPS Presentation and its powerful functions. Today's free course will tell you how to write meter square in WPS Presentation with easy steps. And the trick could be compatible with Microsoft Office PPT. · What’s meter square in WPS PresentationThe square metre (international spelling as used by the International Bureau of Weights and Measures) or square meter (American spelling) is the SI derived unit of area with symbol m2. Simil....

      Presentation 273 views

      How to insert page numbers quickly in Word

      No matter you are a student, teacher, or business professionals, you can create and edit documents efficiently by WPS Writer as text editors. Today we will learn how to insert page numbers in a document, which will make your article easier to read.1. Open your document in WPS Writer.2. Double-click the footer of your articles, the footer will become editable.3. Double-click the Insert page number box, then choose its format and position. You can also decide where to apply them at Apply....

      Writer 445 views

      How to add line numbers in WPS Writer

      1. Use WPS Office to open the document, and select the content that needs to be added line numbers.2. Click the Page Layout tab → the Line Numbers drop-down button.3. Select a line number type you want in the drop-down option. The types of line numbers can be divided into Continuous Reading, Restart Each Page, Restart Each Section, Compress current paragraph, or Do not Show Line Number for Blank Line. To be office word advanced, you could learn how to use WPS Office Writer online in WP....

      Writer 1,172 views
      How can we use the data validation feature

      How can we use the data validation feature

      02:46

      How can we use the data validation feature

      We can greatly improve the accuracy of data entry in our work if we use the data validation feature of WPS Spreadsheet. Take this table as an example. This is the information collection form for US citizens joining tour groups for international travel. We need to fill in the information of all the participants. How can we ensure that the passport numbers and phone numbers we entered will not be wrong? 1. First, select the cell area where data needs to be filled.2. Click the Data tab.3.....

      Spreadsheet 1,890 views
      How to insert a table in WPS Presentation

      How to insert a table in WPS Presentation

      01:47

      How to insert a table in WPS Presentation

      When creating a presentation in WPS Office, sometimes we need to insert a table for data demonstration. How can we realize it? Take this PowerPoint as an example. Get into the Insert tab and click the Table dropdown menu. Then drag the cursor to decide the table size. This method allows us to create a table with 10 columns and 10 rows at maximum. If we want to insert a bigger table, choose Insert Table. In the Insert Table dialog, we can decide the numbers of columns and rows. Enter t....

      Presentation 302 views
      Prev 123...3839 Next
      WPS Academy