There are 16 free training skills of how to use office suite for Spreadsheet

The SUMPRODUCT function for quick calculation of total sales

01:44
Spreadsheet 13.2K views
The SUMPRODUCT function for quick calculation of total sales

Use the ROW function to mark the row number

02:04
Spreadsheet 12.9K views
Use the ROW function to mark the row number

Use the ROUND function to round decimals quickly 

01:57
Spreadsheet 20.8K views
Use the ROUND function to round decimals quickly 

Use Date function to convert date format

01:50
Spreadsheet 40.8K views
Use Date function to convert date format

Look up data quickly with LOOKUP function

04:23
Spreadsheet 17.3K views
Look up data quickly with LOOKUP function

How can we use RANK function

01:18
Spreadsheet 16.4K views
How can we use RANK function

Use the Today function to quickly calculate days between dates

01:57
Spreadsheet 27.9K views
Use the Today function to quickly calculate days between dates

How to customize draw borders for tables

01:19
Spreadsheet 51.9K views
How to customize draw borders for tables

Insert a symbol in the table

02:36
Spreadsheet 26.6K views
Insert a symbol in the table

Set the page printing area in WPS Office Spreadsheet

00:47
Spreadsheet 27.6K views
Set the page printing area in WPS Office Spreadsheet

Set the date format cells

01:40
Spreadsheet 47.4K views
Set the date format cells

How can we create a drop-down list

01:33
Spreadsheet 38.5K views
How can we create a drop-down list

How can we use the data validation feature

02:46
Spreadsheet 41.6K views
How can we use the data validation feature

Clear and avoid duplicates entries in WPS Spreadsheet

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

How can we change the font in a cell

01:09
Spreadsheet 46.3K views
How can we change the font in a cell

Wrap text in a cell

00:53
Spreadsheet 58.3K views
Wrap text in a cell

About WPS Academy

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