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