All

Spreadsheet

Writer

Presentation

PDF

Other

Data Entry and Editing

Data Analysis

Functions and Formulas

Data Visualization

Page Layout

Review and Security

More

Insert Settings

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

Use SUMIFS function with multiple criteria

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

Format cells

04:42
Spreadsheet 23.2K views
Format cells

Use the ROUND function to round decimals quickly 

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

Format Cells Locked and Hidden

01:21
Spreadsheet 22.3K views
Format Cells Locked and Hidden

Instructions of page setup in worksheet

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

How can we set header and footer

02:17
Spreadsheet 21.6K views
How can we set header and footer

Use CONCAT function to merge data

01:16
Spreadsheet 20.9K views
Use CONCAT function to merge data

How to insert Page Break in WPS Spreadsheet

00:48
Spreadsheet 20.8K views
How to insert Page Break in WPS Spreadsheet

Learn PivotTable from scratch

04:21
Spreadsheet 20.8K views
Learn PivotTable from scratch

How to set a worksheet in WPS Spreadsheet

03:53
Spreadsheet 20.5K views
How to set a worksheet in WPS Spreadsheet

How to convert numbers into percentages

01:08
Spreadsheet 20.5K views
How to convert numbers into percentages

COUNTIFS function: count data of multiple criteria

01:57
Spreadsheet 20.5K views
COUNTIFS function: count data of multiple criteria

How to enter a number starting with 0 in the Spreadsheet

01:38
Spreadsheet 19.9K views
How to enter a number starting with 0 in the Spreadsheet

How to set the print scaling

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

Refresh pivotTable and change data source

01:28
Spreadsheet 19.3K views
Refresh pivotTable and change data source

Formatting time in WPS Spreadsheet

01:08
Spreadsheet 18.6K views
Formatting time in WPS Spreadsheet

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