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

How to make a simple lottery through the RANDBETWEEN Function?

02:02
Spreadsheet 377 views
How to make a simple lottery through the RANDBETWEEN Function?

How to use the VLOOKUP function

04:29
Spreadsheet 513 views
How to use the VLOOKUP function

Use pivot chart to create a dynamic chart

04:49
Spreadsheet 373 views
Use pivot chart to create a dynamic chart

How to insert equations in WPS Spreadsheet

01:53
Spreadsheet 348 views
How to insert equations in WPS Spreadsheet

The Advanced XLOOKUP Function

08:33
Spreadsheet 461 views
The Advanced XLOOKUP Function

How to use the FILTER Function

03:14
Spreadsheet 1.9K views
How to use the FILTER Function

How to view two sheets side by side

01:09
Spreadsheet 450 views
How to view two sheets side by side

How to use the Selection Pane in WPS Spreadsheet

01:49
Spreadsheet 296 views
How to use the Selection Pane in WPS Spreadsheet

How to group objects in WPS Spreadsheet

01:20
Spreadsheet 289 views
How to group objects in WPS Spreadsheet

How to view workbooks side by side

01:21
Spreadsheet 206 views
How to view workbooks side by side

Set formulas as the validation condition

00:59
Spreadsheet 209 views
Set formulas as the validation condition

Use Validation to restrict date entries

01:10
Spreadsheet 210 views
Use Validation to restrict date entries

How to customize the ribbon in WPS Spreadsheet

02:26
Spreadsheet 486 views
How to customize the ribbon in WPS Spreadsheet

How to add watermarks to a table

02:19
Spreadsheet 266 views
How to add watermarks to a table

Track changes

01:30
Spreadsheet 281 views
Track changes

Customize the formats to show data changes

01:28
Spreadsheet 251 views
Customize the formats to show data changes

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