There are 16 free training tips of how to use office suite for WPS

TEXT formula in WPS Spreadsheet

TEXT formula in WPS Spreadsheet

03:09
Spreadsheet 1725 views
TEXT formula in WPS Spreadsheet
The SUMPRODUCT function for quick calculation of total sales

The SUMPRODUCT function for quick calculation of total sales

01:44
Spreadsheet 834 views
The SUMPRODUCT function for quick calculation of total sales
Use the ROW function to mark the row number

Use the ROW function to mark the row number

02:04
Spreadsheet 448 views
Use the ROW function to mark the row number
Use the ROUND function to round decimals quickly 

Use the ROUND function to round decimals quickly 

01:57
Spreadsheet 1541 views
Use the ROUND function to round decimals quickly 
Use Date function to convert date format

Use Date function to convert date format

01:50
Spreadsheet 3322 views
Use Date function to convert date format
Look up data quickly with LOOKUP function

Look up data quickly with LOOKUP function

04:23
Spreadsheet 1236 views
Look up data quickly with LOOKUP function
How can we use RANK function

How can we use RANK function

01:18
Spreadsheet 718 views
How can we use RANK function
Use the Today function to quickly calculate days between dates

Use the Today function to quickly calculate days between dates

01:57
Spreadsheet 2083 views
Use the Today function to quickly calculate days between dates
Layout skill-How can we split columns

Layout skill-How can we split columns

01:39
Writer 1347 views
Layout skill-How can we split columns
How to customize draw borders for tables

How to customize draw borders for tables

01:19
Spreadsheet 4366 views
How to customize draw borders for tables
Insert a symbol in the table

Insert a symbol in the table

02:36
Spreadsheet 1203 views
Insert a symbol in the table
Set the page printing area in WPS Office Spreadsheet

Set the page printing area in WPS Office Spreadsheet

00:47
Spreadsheet 2042 views
Set the page printing area in WPS Office Spreadsheet
Set the date format cells

Set the date format cells

01:40
Spreadsheet 3989 views
Set the date format cells
How can we create a drop-down list

How can we create a drop-down list

01:33
Spreadsheet 1988 views
How can we create a drop-down list
How can we use the data validation feature

How can we use the data validation feature

02:46
Spreadsheet 1966 views
How can we use the data validation feature
Clear and avoid duplicates entries in WPS Spreadsheet

Clear and avoid duplicates entries in WPS Spreadsheet

01:56
Spreadsheet 2795 views
Clear and avoid duplicates entries in WPS Spreadsheet

About WPS Academy

WPS academy supplies free office software training tips with quality videos and useful tips online, which could help office beginners to specialists. WPS office could compatible with Office 365 perfectly. It's the best alternative to Office 365. Efficient your work and quick download WPS Office now. Free Download WPS Office