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

How to set the calculated field of the pivot table

01:49
Spreadsheet 41.6K views
How to set the calculated field of the pivot table

How can we use the data validation feature

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

General format and special format

01:27
Spreadsheet 41.5K views
General format and special format

Change horizontal data to vertical and make data clearer

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

Use Date function to convert date format

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

Rows and columns tools in WPS Spreadsheet

02:34
Spreadsheet 40.3K views
Rows and columns tools in WPS Spreadsheet

Different methods of using format painter

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

How to use the paste special function

02:11
Spreadsheet 39.3K views
How to use the paste special function

How can we create a drop-down list

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

How to use the FILTER Function

03:15
Spreadsheet 38.4K views
How to use the FILTER Function

Quickly filter classified data

01:41
Spreadsheet 38.2K views
Quickly filter classified data

How to crop the picture in a table

01:30
Spreadsheet 37.0K views
How to crop the picture in a table

Use conditional formatting to make data more intuitive

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

Use COUNTIF function for conditional statistics

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

Custom sorting in WPS Spreadsheet

02:14
Spreadsheet 35.2K views
Custom sorting in WPS Spreadsheet

How can we format cell values

01:57
Spreadsheet 34.2K views
How can we format cell values

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