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

Set formulas as the validation condition

Set formulas as the validation condition

00:59
icon Spreadsheet 17 views
Set formulas as the validation condition
Use Validation to restrict date entries

Use Validation to restrict date entries

01:10
icon Spreadsheet 28 views
Use Validation to restrict date entries
Customize the formats to show data changes

Customize the formats to show data changes

01:28
icon Spreadsheet 2 views
Customize the formats to show data changes
Use Validation to prevent duplicate values

Use Validation to prevent duplicate values

01:23
icon Spreadsheet 14 views
Use Validation to prevent duplicate values
Use Validation to restrict data change

Use Validation to restrict data change

02:24
icon Spreadsheet 4 views
Use Validation to restrict data change
Use Freeze Panes to freeze rows and columns

Use Freeze Panes to freeze rows and columns

01:21
icon Spreadsheet 6 views
Use Freeze Panes to freeze rows and columns
How to insert a text box in Spreadsheet

How to insert a text box in Spreadsheet

03:13
icon Spreadsheet 45 views
How to insert a text box in Spreadsheet
How to insert the object in WPS Spreadsheet

How to insert the object into WPS Spreadsheet

01:30
icon Spreadsheet 88 views
How to insert the object in WPS Spreadsheet
How to insert an attachment in WPS Spreadsheet

How to insert an attachment into WPS Spreadsheet

01:28
icon Spreadsheet 86 views
How to insert an attachment in WPS Spreadsheet
Ctrl+E smart filling

Ctrl+E smart filling

02:50
icon Spreadsheet 111 views
Ctrl+E smart filling
Fill handle: Use Ctrl+D to fill

Fill handle: Use Ctrl+D to fill

01:07
icon Spreadsheet 65 views
Fill handle: Use Ctrl+D to fill
Set input conditions and drop-down menus

Set input conditions and drop-down menus

01:54
icon Spreadsheet 173 views
Set input conditions and drop-down menus
Use the fill handle to quickly enter data

Use the fill handle to quickly enter data

02:59
icon Spreadsheet 595 views
Use the fill handle to quickly enter data
How can we format cell values

How can we format cell values

01:57
icon Spreadsheet 1,490 views
How can we format cell values
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 578 views
How to enter a number starting with 0 in the Spreadsheet
How to use the Smart Split Columns feature

How to use the Smart Split Columns feature

02:34
icon Spreadsheet 2,179 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