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

Format Cells Locked and Hidden

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

How to insert equations in WPS Spreadsheet

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

Ctrl+E smart filling

02:50
Spreadsheet 28.3K views
Ctrl+E smart filling

How can we set header and footer

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

How to insert Page Break in WPS Spreadsheet

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

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

Learn PivotTable from scratch

04:21
Spreadsheet 26.6K views
Learn PivotTable from scratch

Use CONCAT function to merge data

Spreadsheet 26.3K views
Use CONCAT function to merge data

How to set a worksheet in WPS Spreadsheet

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

COUNTIFS function: count data of multiple criteria

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

How to enter a number starting with 0 in the Spreadsheet

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

How to convert numbers into percentages

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

How to set the print scaling

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

Refresh pivotTable and change data source

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

Look up data quickly with LOOKUP function

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

Quickly fill cells with multiple methods

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

About WPS Academy

WPS academy supplies free office software training courses with quality videos and useful tips online, which could help office beginners to specialists. WPS office could compatible with FreeOffice perfectly. It's the best alternative to FreeOffice. Efficient your work and quick download WPS Office now.
Free Download WPS Office