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

How to make a simple lottery through the RANDBETWEEN Function?

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

How to use the VLOOKUP function

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

Use pivot chart to create a dynamic chart

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

How to insert equations in WPS Spreadsheet

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

The Advanced XLOOKUP Function

08:33
Spreadsheet 468 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 462 views
How to view two sheets side by side

How to use the Selection Pane in WPS Spreadsheet

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

How to group objects in WPS Spreadsheet

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

How to view workbooks side by side

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

Set formulas as the validation condition

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

Use Validation to restrict date entries

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

How to customize the ribbon in WPS Spreadsheet

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

How to add watermarks to a table

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

Track changes

01:30
Spreadsheet 288 views
Track changes

Customize the formats to show data changes

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

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