There are 16 free training skills of how to use office suite for Spreadsheet
How to insert calculated fields in PivotTable
01:06How to create a scatter chart in WPS Spreadsheet
02:53How to Insert Pie Chart in WPS Spreadsheet
02:17Split the screen for data comparison
01:21Refresh pivotTable and change data source
01:28How to convert numbers into percentages
01:08Page setup and print-out for spreadsheets
02:07Set 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:43Use VLOOKUP function to create dynamic charts
03:44