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

How to lock and unlock cells in WPS Spreadsheet

01:35
Spreadsheet 27.2K views
How to lock and unlock cells in WPS Spreadsheet

Quickly fill cells with multiple methods

04:07
Spreadsheet 17.3K views
Quickly fill cells with multiple methods

How to use the Selection Pane in WPS Spreadsheet

01:49
Spreadsheet 11.0K views
How to use the Selection Pane in WPS Spreadsheet

A quick way to calculate sum, average, count, max, and min

01:34
Spreadsheet 52.8K views
A quick way to calculate sum, average, count, max, and min

Different methods of using format painter

02:12
Spreadsheet 39.8K views
Different methods of using format painter

Use conditional formatting to make data more intuitive

04:46
Spreadsheet 36.8K views
Use conditional formatting to make data more intuitive

How to customize the ribbon in WPS Spreadsheet

02:26
Spreadsheet 23.0K views
How to customize the ribbon in WPS Spreadsheet

How to change the table format

00:51
Spreadsheet 22.6K views
How to change the table format

How can we freeze the pane in WPS Spreadsheet

02:28
Spreadsheet 22.3K views
How can we freeze the pane in WPS Spreadsheet

How to create a table with one click

01:35
Spreadsheet 21.3K views
How to create a table with one click

How to make a simple lottery through the RANDBETWEEN Function?

02:02
Spreadsheet 11.6K views
How to make a simple lottery through the RANDBETWEEN Function?

How to group objects in WPS Spreadsheet

01:20
Spreadsheet 9.3K views
How to group objects in WPS Spreadsheet

Use subtotal feature to do statistic

04:35
Spreadsheet 9.3K views
Use subtotal feature to do statistic

02:20
Spreadsheet 6.3K views
How to insert and delete hyperlink

01:43
Spreadsheet 5.1K views
Facilitate your work with table Clear tools

Use SUM function to quickly calculate the sum

01:31
Spreadsheet 81.8K views
Use SUM function to quickly calculate the sum

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