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

Split the screen for data comparison

Split the screen for data comparison

01:21
Spreadsheet 135 views
Split the screen for data comparison
Refresh pivotTable and change data source

Refresh pivotTable and change data source

01:28
Spreadsheet 227 views
Refresh pivotTable and change data source
Print out tables

Print out tables

02:43
Spreadsheet 188 views
Print out tables
How to convert numbers into percentages

How to convert numbers into percentages

01:08
Spreadsheet 299 views
How to convert numbers into percentages
Page setup and print-out for spreadsheets

Page setup and print-out for spreadsheets

02:07
Spreadsheet 158 views
Page setup and print-out for spreadsheets
Set the Table Header and Footer

Set the Table Header and Footer

02:10
Spreadsheet 97 views
Set the Table Header and Footer
INDEX MATCH formulas

INDEX MATCH formulas

02:11
Spreadsheet 187 views
INDEX MATCH formulas
Use IFS function to check whether multiple conditions are met

Use IFS function to check whether multiple conditions are met

02:47
Spreadsheet 142 views
Use IFS function to check whether multiple conditions are met
Conditional Formatting for data virtualization

Conditional Formatting for data virtualization

01:23
Spreadsheet 39 views
Conditional Formatting for data virtualization
Use formula to set the conditional formatting

Use formula to set the conditional formatting

01:28
Spreadsheet 204 views
Use formula to set the conditional formatting
The INDEX function

The INDEX function

03:50
Spreadsheet 502 views
The INDEX function
Conditional Formatting to highlight top three items

Conditional Formatting to highlight top three items

01:37
Spreadsheet 32 views
Conditional Formatting to highlight top three items
Use color scales to make the temperature chart

Use color scales to make the temperature chart

00:43
Spreadsheet 37 views
Use color scales to make the temperature chart
Use VLOOKUP function to create dynamic charts

Use VLOOKUP function to create dynamic charts

03:44
Spreadsheet 171 views
Use VLOOKUP function to create dynamic charts
Skillfully use Conditional Formatting to highlight  performance

Skillfully use Conditional Formatting to highlight performance

01:21
Spreadsheet 55 views
Skillfully use Conditional Formatting to highlight performance
Create the double-layer doughnut chart

Create the double-layer doughnut chart

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

About WPS Academy

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