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

How to convert Excel to PDF

02:50
Spreadsheet 30.3K views
How to convert Excel to PDF

Set password to protect privacy in WPS spreadsheet

02:03
Spreadsheet 27.8K views
Set password to protect privacy in WPS spreadsheet

Set the page printing area in WPS Office Spreadsheet

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

Use COUNT function to count the number of cells with parameters

01:20
Spreadsheet 27.4K views
Use COUNT function to count the number of cells with parameters

How to use the Smart Split Columns feature

02:34
Spreadsheet 27.3K views
How to use the Smart Split Columns feature

Insert a symbol in the table

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

How to apply accounting number format in WPS Spreadsheet

00:56
Spreadsheet 24.6K views
How to apply accounting number format in WPS Spreadsheet

How to set the paper size of the table

01:06
Spreadsheet 23.9K views
How to set the paper size of the table

SUBTOTAL function: Calculate the data with the hidden value

02:33
Spreadsheet 23.9K views
SUBTOTAL function: Calculate the data with the hidden value

How to fill cells with pure colors, gradient colors, and patterns

01:57
Spreadsheet 23.5K views
How to fill cells with pure colors, gradient colors, and patterns

TEXT formula in WPS Spreadsheet

03:09
Spreadsheet 23.4K views
TEXT formula in WPS Spreadsheet

Ctrl+E smart filling

02:50
Spreadsheet 22.9K views
Ctrl+E smart filling

Quickly adjust the row height and column width

01:36
Spreadsheet 22.2K views
Quickly adjust the row height and column width

Use SUMIFS function with multiple criteria

02:27
Spreadsheet 21.6K views
Use SUMIFS function with multiple criteria

Use the ROUND function to round decimals quickly 

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

Format cells

04:42
Spreadsheet 20.5K views
Format cells

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 LibreOffice perfectly. It's the best alternative to LibreOffice. Efficient your work and quick download WPS Office now.
Free Download WPS Office