Use COUNTIF function for conditional statistics

Use COUNTIF function for conditional statistics

01:32
icon Spreadsheet 246 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 241 views
Use pivot chart to create a dynamic chart
Use SUMIFS function with multiple criteria

Use SUMIFS function with multiple criteria

02:27
icon Spreadsheet 236 views
Use SUMIFS function with multiple criteria
How to set the cell style

How to set the cell style

01:39
icon Spreadsheet 234 views
How to set the cell style
Print the spreadsheet with different orientation and zoom percentage

Print the spreadsheet with different orientation and zoom percentage

01:16
icon Spreadsheet 197 views
Print the spreadsheet with different orientation and zoom percentage
How to delete blank rows of table in batches

How to delete blank rows of table in batches

00:51
icon Spreadsheet 170 views
How to delete blank rows of table in batches
How to clear content format and comments for cells

How to clear content format and comments for cells

01:43
icon Spreadsheet 166 views
How to clear content format and comments for cells
Use data check method to quickly find difference items

Use data check method to quickly find difference items

01:40
icon Spreadsheet 162 views
Use data check method to quickly find difference items
How can we draw a line chart

How can we draw a line chart

02:36
icon Spreadsheet 161 views
How can we draw a line chart
Format Cells Locked and Hidden

Format Cells Locked and Hidden

01:21
icon Spreadsheet 149 views
Format Cells Locked and Hidden
Get to know the cell widget

Get to know the cell widget

02:38
icon Spreadsheet 146 views
Get to know the cell widget
How to use Name Manager

How to use Name Manager

01:13
icon Spreadsheet 144 views
How to use Name Manager
How to set a worksheet in WPS Spreadsheet

How to set a worksheet in WPS Spreadsheet

03:53
icon Spreadsheet 138 views
How to set a worksheet in WPS Spreadsheet
How can we set the margins of the table

How can we set the margins of the table

01:13
icon Spreadsheet 131 views
How can we set the margins of the table
The SUMPRODUCT function for quick calculation of total sales

The SUMPRODUCT function for quick calculation of total sales

01:44
icon Spreadsheet 127 views
The SUMPRODUCT function for quick calculation of total sales
How to enter a number starting with 0 in the Spreadsheet

How to enter a number starting with 0 in the Spreadsheet

01:38
icon Spreadsheet 125 views
How to enter a number starting with 0 in the Spreadsheet