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
      • payment collection format in excel

      82 results for payment collection format in excel

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

      82 results for payment collection format in excel

      A collection helps you learn all basic excel formulas in WPS Office

      Welcome to WPS Official Academy to check the contents of how to learn basic excel formulas in WPS Office. You are sure to master all basic excel formulas after reading this tutorial! · The basic excel formula about the SUM functionThe SUM function is commonly used when we process data with WPS Spreadsheet. Do you know how to sum the values with an basic excel formula in certain cells? To learn how to input the basic excel formula, click to watch the video tutorial: Use SUM function to ....

      Spreadsheet 357 views
      TEXT formula in WPS Spreadsheet

      TEXT formula in WPS Spreadsheet

      03:09

      TEXT formula in WPS Spreadsheet

      The TEXT formula in Excel is commonly used for the conversion of number-to-text in a certain format, and it could be also used in Microsoft Office Excel and Openoffice. Normally, the TEXT formula is used to customize format cells in terms of actual needs. To realize it, we need to adjust the second parameter of the formula, which stands for format texts to be set. In this example, the number 2.012584, which equips with six decimal places, entered cell A2. How can we convert it into a v....

      Spreadsheet 1,560 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
      Use Date function to convert date format

      Use Date function to convert date format

      01:50

      Use Date function to convert date format

      We may sometimes need to convert the format of the date in the table when using WPS Spreadsheet like Microsoft Excel. At this point, by using the Date function, we can quickly generate a specific date symbol. Take this table as an example. This table contains the information on the date of birth of some students in class. We can see that the information of year, month, and day are separated in this table. So how can we convert the format quickly to know the birthdays of the students? 1....

      Spreadsheet 3,086 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
      Unique features in Student Tools

      Unique features in Student Tools

      01:42

      Unique features in Student Tools

      Student Tools is a collection of functions in WPS Presentation specially optimized for student user groups, which is not available in any other office software on the market. Student Tools, on the far right of the toolbar, collects the features that students use most frequently to save their time to toggle back and forth between the tabs. There are three common views and two common masters collected from the View tab, which can meet the needs of most reading, reviewing and presentatio....

      Presentation 65 views
      Unique features in Student Tools

      Unique features in Student Tools

      02:23

      Unique features in Student Tools

      No matter you are a student, teacher, or business professionals, you can create and edit documents efficiently by WPS Writer as text editors. Student Tools is a collection of functions launched by WPS for students users. Some frequently-used functions are selected. This built-in function cannot be found in other office software at present. In the interface of this function, WPS Office selects Reading View mode from the View tab, frequently used features such as Highlight and Text Color....

      Writer 104 views
      Batch export multiple pictures

      Batch export multiple pictures

      00:54

      Batch export multiple pictures

      If you want to save multiple pictures in a table, a common practice is to save them one by one. It will be very troublesome when there are a large number of pictures. Today, we will learn a quick tip to export pictures in batches. Taking this table as an example, we can see that there are many pictures in the table. First, change the suffix name of this table file in accordance with the suffix of the zip file. Here, we change the .xlsx format to .rar format and then decompress the file....

      Spreadsheet 6 views
      Prev 123...1011 Next
      WPS Academy