There are 16 free training skills of how to use office suite for Spreadsheet
Use format painter to adjust the styles in batches
01:28Worksheet and workbook
01:48How to set the cell alignment in WPS Spreadsheet
02:31How to consolidate data in WPS Spreadsheet
01:28How can we protect a worksheet in WPS Spreadsheets
01:49How to clear content format and comments for cells
01:43Quickly filter classified data
01:41General format and special format
01:27Look up data quickly with LOOKUP function
04:23How can we create a drop-down list
01:33How can we use the data validation feature
02:46How can we add and set borders for cells
01:54How to add watermarks to a table
02:19Why error message NA occurs and how to solve it
02:56Use Validation to prevent duplicate values
01:23How to sort with a custom list
01:36