General format and special format

General format and special format

01:27
icon Spreadsheet 465 views
General format and special format
How can we create a drop-down list

How can we create a drop-down list

01:33
icon Spreadsheet 454 views
How can we create a drop-down list
How can we set header and footer

How can we set header and footer

02:17
icon Spreadsheet 427 views
How can we set header and footer
Rows and columns tools in WPS Spreadsheet

Rows and columns tools in WPS Spreadsheet

02:34
icon Spreadsheet 424 views
Rows and columns tools in WPS Spreadsheet
Use the Today function to quickly calculate days between dates

Use the Today function to quickly calculate days between dates

01:57
icon Spreadsheet 401 views
Use the Today function to quickly calculate days between dates
How can we freeze the pane in WPS Spreadsheet

How can we freeze the pane in WPS Spreadsheet

02:28
icon Spreadsheet 358 views
How can we freeze the pane in WPS Spreadsheet
Set the page printing area in WPS Office Spreadsheet

Set the page printing area in WPS Office Spreadsheet

00:47
icon Spreadsheet 358 views
Set the page printing area in WPS Office 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 352 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 333 views
Use COUNT function to count the number of cells with parameters
How can we format cell values

How can we format cell values

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

Insert a symbol in the table

02:36
icon Spreadsheet 302 views
Insert a symbol in the table
TEXT formula in WPS Spreadsheet

TEXT formula in Excel

03:09
icon Spreadsheet 283 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 280 views
Use the ROUND function to round decimals quickly 
How to set the calculated field of the pivot table

How to set the calculated field of the pivot table

01:49
icon Spreadsheet 271 views
How to set the calculated field of the pivot table
How to change the table format

How to change the table format

00:51
icon Spreadsheet 251 views
How to change the table format
COUNTIFS function: count data of multiple criteria

COUNTIFS function: count data of multiple criteria

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