Set the page printing area in WPS Office Spreadsheet

Set the page printing area in WPS Office Spreadsheet

00:47
icon Spreadsheet 409 views
Set the page printing area in WPS Office Spreadsheet
Quickly fill cells with multiple methods

Quickly Fill Cells with Multiple Filling Methods

04:07
icon Spreadsheet 405 views
Quickly fill cells with multiple methods
How can we freeze the pane in WPS Spreadsheet

How can we freeze the pane in WPS Spreadsheet

02:28
icon Spreadsheet 384 views
How can we freeze the pane in WPS Spreadsheet
SUBTOTAL function: Calculate the data with the hidden value

SUBTOTAL function: Calculate the data including or ignoring the hidden value

02:33
icon Spreadsheet 376 views
SUBTOTAL function: Calculate the data with the hidden value
Use COUNT function to count the number of cells with parameters

Use COUNT function to count the number of cells with parameters

01:20
icon Spreadsheet 372 views
Use COUNT function to count the number of cells with parameters
How to create a table with one click

How to create a table with one click

01:35
icon Spreadsheet 366 views
How to create a table with one click
How can we format cell values

How can we format cell values

01:57
icon Spreadsheet 353 views
How can we format cell values
Insert a symbol in the table

Insert a symbol in the table

02:36
icon Spreadsheet 322 views
Insert a symbol in the table
How to set the calculated field of the pivot table

How to set the calculated field of the pivot table

01:49
icon Spreadsheet 315 views
How to set the calculated field of the pivot table
TEXT formula in WPS Spreadsheet

TEXT formula in Excel

03:09
icon Spreadsheet 311 views
TEXT formula in WPS Spreadsheet
Use the ROUND function to round decimals quickly 

Use the ROUND function to round decimals quickly 

01:57
icon Spreadsheet 303 views
Use the ROUND function to round decimals quickly 
How to change the table format

How to change the table format

00:51
icon Spreadsheet 279 views
How to change the table format
Use COUNTIF function for conditional statistics

Use COUNTIF function for conditional statistics

01:32
icon Spreadsheet 270 views
Use COUNTIF function for conditional statistics
Use pivot chart to create a dynamic chart

Use pivot chart to create a dynamic chart

04:49
icon Spreadsheet 261 views
Use pivot chart to create a dynamic chart
Look up data quickly with LOOKUP function

Look up data quickly with LOOKUP function

04:23
icon Spreadsheet 259 views
Look up data quickly with LOOKUP function
COUNTIFS function: count data of multiple criteria

COUNTIFS function: count data of multiple criteria

01:57
icon Spreadsheet 256 views
COUNTIFS function: count data of multiple criteria