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 classes of how to use office suite for Spreadsheet

Format Cells Locked and Hidden

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

How can we set header and footer

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

Instructions of page setup in worksheet

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

How to insert equations in WPS Spreadsheet

01:53
Spreadsheet 20.5K views
How to insert equations in WPS Spreadsheet

Use CONCAT function to merge data

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

How to insert Page Break in WPS Spreadsheet

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

Learn PivotTable from scratch

04:21
Spreadsheet 19.8K views
Learn PivotTable from scratch

COUNTIFS function: count data of multiple criteria

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

How to set a worksheet in WPS Spreadsheet

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

How to convert numbers into percentages

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

02:05
Spreadsheet 19.1K views
How to insert and delete cells, rows and columns

How to enter a number starting with 0 in the Spreadsheet

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

Quickly fill cells with multiple methods

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

How to set the print scaling

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

Refresh pivotTable and change data source

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

Look up data quickly with LOOKUP function

04:23
Spreadsheet 18.3K views
Look up data quickly with LOOKUP function

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