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

Set formulas as the validation condition

00:59
Spreadsheet 4.6K views
Set formulas as the validation condition

Use Validation to restrict date entries

01:10
Spreadsheet 5.1K views
Use Validation to restrict date entries

Customize the formats to show data changes

01:28
Spreadsheet 6.2K views
Customize the formats to show data changes

Use Validation to prevent duplicate values

01:23
Spreadsheet 5.0K views
Use Validation to prevent duplicate values

Use Validation to restrict data change

02:24
Spreadsheet 4.3K views
Use Validation to restrict data change

01:21
Spreadsheet 8.5K views
Use Freeze Panes to freeze rows and columns

How to insert a text box in Spreadsheet

03:13
Spreadsheet 12.0K views
How to insert a text box in Spreadsheet

How to insert the object in WPS Spreadsheet

01:30
Spreadsheet 7.3K views
How to insert the object in WPS Spreadsheet

How to insert an attachment in WPS Spreadsheet

01:28
Spreadsheet 6.1K views
How to insert an attachment in WPS Spreadsheet

Ctrl+E smart filling

02:50
Spreadsheet 20.4K views
Ctrl+E smart filling

Fill handle: Use Ctrl+D to fill

01:07
Spreadsheet 5.2K views
Fill handle: Use Ctrl+D to fill

Set input conditions and drop-down menus

01:54
Spreadsheet 6.1K views
Set input conditions and drop-down menus

Use the fill handle to quickly enter data

02:59
Spreadsheet 12.2K views
Use the fill handle to quickly enter data

How can we format cell values

01:57
Spreadsheet 25.7K views
How can we format cell values

How to enter a number starting with 0 in the Spreadsheet

01:38
Spreadsheet 12.9K views
How to enter a number starting with 0 in the Spreadsheet

How to use the Smart Split Columns feature

02:34
Spreadsheet 18.6K views
How to use the Smart Split Columns feature

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 FreeOffice perfectly. It's the best alternative to FreeOffice. Efficient your work and quick download WPS Office now.
Free Download WPS Office