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

Use formula to set the conditional formatting

01:28
Spreadsheet 14.0K views
Use formula to set the conditional formatting

Use pivot chart to create a dynamic chart

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

Elementary arithmetic functions in WPS Spreadsheet

02:50
Spreadsheet 13.6K views
Elementary arithmetic functions in WPS Spreadsheet

The Advanced XLOOKUP Function

08:33
Spreadsheet 13.5K views
The Advanced XLOOKUP Function

How to change the page orientation

00:48
Spreadsheet 13.3K views
How to change the page orientation

Print the spreadsheet with different orientations and zoom percentages

01:16
Spreadsheet 13.3K views
Print the spreadsheet with different orientations and zoom percentages

How to group data in a spreadsheet

02:01
Spreadsheet 13.2K views
How to group data in a spreadsheet

How to create a Form in spreadsheet

01:26
Spreadsheet 13.2K views
How to create a Form in spreadsheet

The SUMPRODUCT function for quick calculation of total sales

01:44
Spreadsheet 13.1K views
The SUMPRODUCT function for quick calculation of total sales

Use VLOOKUP function to create dynamic charts

03:44
Spreadsheet 13.1K views
Use VLOOKUP function to create dynamic charts

How to add watermarks to a table

02:19
Spreadsheet 13.1K views
How to add watermarks to a table

How to set custom symbols and symbols shortcut key in WPS Spreadsheet

01:51
Spreadsheet 13.0K views
How to set custom symbols and symbols shortcut key in WPS Spreadsheet

Use the ROW function to mark the row number

02:04
Spreadsheet 12.9K views
Use the ROW function to mark the row number

How to view two sheets side by side

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

Use format painter to adjust the styles in batches

01:28
Spreadsheet 12.8K views
Use format painter to adjust the styles in batches

Create the double-layer doughnut chart

03:22
Spreadsheet 12.8K views
Create the double-layer doughnut chart

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