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

How to insert shapes in a worksheet

01:20
Spreadsheet 10.9K views
How to insert shapes in a worksheet

Use COUNTIF function for conditional statistics

01:32
Spreadsheet 36.7K views
Use COUNTIF function for conditional statistics

Print page setup in WPS Spreadsheet

01:20
Spreadsheet 14.1K views
Print page setup in WPS Spreadsheet

How to split sheets by content

01:16
Spreadsheet 16.4K views
How to split sheets by content

How to set custom symbols and symbols shortcut key in WPS Spreadsheet

01:51
Spreadsheet 12.9K views
How to set custom symbols and symbols shortcut key in WPS Spreadsheet

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

Instructions of page setup in worksheet

01:54
Spreadsheet 17.8K views
Instructions of page setup in worksheet

How to set the print scaling

01:15
Spreadsheet 17.0K views
How to set the print scaling

How to set the paper size of the table

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

Use slash header to show the title name

01:25
Spreadsheet 6.8K views
Use slash header to show the title name

Quickly locate and view data

03:46
Spreadsheet 8.2K views
Quickly locate and view data

How to delete blank rows of table in batches

00:51
Spreadsheet 15.9K views
How to delete blank rows of table in batches

Change horizontal data to vertical and make data clearer

01:06
Spreadsheet 40.7K views
Change horizontal data to vertical and make data clearer

Text to Columns: Sort data quickly

02:03
Spreadsheet 6.4K views
Text to Columns: Sort data quickly

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

About WPS Academy

WPS academy supplies free office software training classes 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