There are 16 free training skills of how to use office suite for Spreadsheet

Split the screen for data comparison

01:21
Spreadsheet 9.5K views
Split the screen for data comparison

Refresh pivotTable and change data source

01:28
Spreadsheet 17.0K views
Refresh pivotTable and change data source

Print out tables

02:43
Spreadsheet 6.9K views
Print out tables

How to convert numbers into percentages

01:08
Spreadsheet 18.3K views
How to convert numbers into percentages

Page setup and print-out for spreadsheets

02:07
Spreadsheet 11.6K views
Page setup and print-out for spreadsheets

Set the Table Header and Footer

02:10
Spreadsheet 9.3K views
Set the Table Header and Footer

INDEX MATCH formulas

02:11
Spreadsheet 9.8K views
INDEX MATCH formulas

Use IFS function to check whether multiple conditions are met

02:47
Spreadsheet 9.1K views
Use IFS function to check whether multiple conditions are met

Conditional Formatting for data virtualization

01:23
Spreadsheet 5.4K views
Conditional Formatting for data virtualization

Use formula to set the conditional formatting

01:28
Spreadsheet 14.0K views
Use formula to set the conditional formatting

The INDEX function

03:50
Spreadsheet 14.0K views
The INDEX function

Conditional Formatting to highlight top three items

01:37
Spreadsheet 6.8K views
Conditional Formatting to highlight top three items

Use color scales to make the temperature chart

00:43
Spreadsheet 6.4K views
Use color scales to make the temperature chart

Use VLOOKUP function to create dynamic charts

03:44
Spreadsheet 13.1K views
Use VLOOKUP function to create dynamic charts

Skillfully use Conditional Formatting to highlight performance

01:21
Spreadsheet 6.1K views
Skillfully use Conditional Formatting to highlight performance

Create the double-layer doughnut chart

03:22
Spreadsheet 12.7K views
Create the double-layer doughnut chart

About WPS Academy

WPS academy supplies free office software training skills with quality videos and useful tips online, which could help office beginners to specialists. WPS office could compatible with LibreOffice perfectly. It's the best alternative to LibreOffice. Efficient your work and quick download WPS Office now.
Free Download WPS Office