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

Set formulas as the validation condition

00:59
Spreadsheet 669 views
Set formulas as the validation condition

Use Validation to restrict date entries

01:10
Spreadsheet 729 views
Use Validation to restrict date entries

Customize the formats to show data changes

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

Use Validation to prevent duplicate values

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

Use Validation to restrict data change

02:24
Spreadsheet 502 views
Use Validation to restrict data change

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

How to insert a text box in Spreadsheet

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

How to insert the object in WPS Spreadsheet

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

How to insert an attachment in WPS Spreadsheet

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

Ctrl+E smart filling

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

Fill handle: Use Ctrl+D to fill

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

Set input conditions and drop-down menus

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

Use the fill handle to quickly enter data

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

How can we format cell values

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

How to enter a number starting with 0 in the Spreadsheet

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

How to use the Smart Split Columns feature

02:34
Spreadsheet 4.2K 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 Google Docs perfectly. It's the best alternative to Google Docs. Efficient your work and quick download WPS Office now. Free Download WPS Office