There are 16 free training skills of how to use office suite for Spreadsheet
The SUMPRODUCT function for quick calculation of total sales
01:44Use the ROW function to mark the row number
02:04Use the ROUND function to round decimals quickly
01:57Use Date function to convert date format
01:50Look up data quickly with LOOKUP function
04:23How can we use RANK function
01:18Use the Today function to quickly calculate days between dates
01:57How to customize draw borders for tables
01:19Insert a symbol in the table
02:36Set the page printing area in WPS Office Spreadsheet
00:47Set the date format cells
01:40How can we create a drop-down list
01:33How can we use the data validation feature
02:46Clear and avoid duplicates entries in WPS Spreadsheet
01:56How can we change the font in a cell
01:09Wrap text in a cell
00:53