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:49Elementary arithmetic functions in WPS Spreadsheet
02:50The Advanced XLOOKUP Function
08:33How to change the page orientation
00:48Print the spreadsheet with different orientations and zoom percentages
01:16How to group data in a spreadsheet
02:01How to create a Form in spreadsheet
01:26The SUMPRODUCT function for quick calculation of total sales
01:44Use VLOOKUP function to create dynamic charts
03:44How to add watermarks to a table
02:19How to set custom symbols and symbols shortcut key in WPS Spreadsheet
01:51Use the ROW function to mark the row number
02:04How to view two sheets side by side
01:09Use format painter to adjust the styles in batches
01:28Create the double-layer doughnut chart
03:22