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

How can we set header and footer

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

Format Cells Locked and Hidden

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

How to insert equations in WPS Spreadsheet

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

Use CONCAT function to merge data

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

How to insert Page Break in WPS Spreadsheet

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

How to set a worksheet in WPS Spreadsheet

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

COUNTIFS function: count data of multiple criteria

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

How to convert numbers into percentages

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

Learn PivotTable from scratch

04:21
Spreadsheet 18.2K views
Learn PivotTable from scratch

Instructions of page setup in worksheet

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

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

How to enter a number starting with 0 in the Spreadsheet

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

Quickly fill cells with multiple methods

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

Look up data quickly with LOOKUP function

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

How to set the print scaling

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

Refresh pivotTable and change data source

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

About WPS Academy

WPS academy supplies free office software training tutorials 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