There are 16 free training tutorials of how to use office suite for Spreadsheet
How to insert calculated fields in PivotTable
01:06How to Insert Pie Chart in WPS Spreadsheet
02:17Refresh pivotTable and change data source
01:28Print out tables
02:43How to convert numbers into percentages
01:08Set the Table Header and Footer
02:10INDEX MATCH formulas
02:11Use IFS function to check whether multiple conditions are met
02:47Conditional Formatting for data virtualization
01:23Use formula to set the conditional formatting
01:28The INDEX function
03:50Conditional Formatting to highlight top three items
01:37Use color scales to make the temperature chart
00:43Skillfully use Conditional Formatting to highlight performance
01:21Create the double-layer doughnut chart
03:22Create simple and intuitive mini charts
03:10