There are 16 free training classes of how to use office suite for Spreadsheet
Use formula to set the conditional formatting
01:28Use pivot chart to create a dynamic chart
04:49The Advanced XLOOKUP Function
08:33How to change the page orientation
00:48Elementary arithmetic functions in WPS Spreadsheet
02:50Use VLOOKUP function to create dynamic charts
03:44The SUMPRODUCT function for quick calculation of total sales
01:44How to group data in a spreadsheet
02:01Print the spreadsheet with different orientations and zoom percentages
01:16How to create a Form in spreadsheet
01:26How to view two sheets side by side
01:09How to set custom symbols and symbols shortcut key in WPS Spreadsheet
01:51How to add watermarks to a table
02:19Use the ROW function to mark the row number
02:04How to use the Spell Check function in WPS Spreadsheet
02:15Use format painter to adjust the styles in batches
01:28