All

Spreadsheet

Writer

Presentation

PDF

Other

Data Entry and Editing

Data Analysis

Functions and Formulas

Data Visualization

Page Layout

Review and Security

More

Get Started

Data Entry

Spreadsheet Basics

Cell Editing

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

Set formulas as the validation condition

Set formulas as the validation condition

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

Use Validation to restrict date entries

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

Customize the formats to show data changes

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

Use Validation to prevent duplicate values

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

Use Validation to restrict data change

02:24
Spreadsheet 12 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
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
Spreadsheet 93 views
How to insert a text box in Spreadsheet
How to insert the object in WPS Spreadsheet

How to insert the object in WPS Spreadsheet

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

How to insert an attachment in WPS Spreadsheet

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

Ctrl+E smart filling

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

Fill handle: Use Ctrl+D to fill

01:07
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
Spreadsheet 181 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
Spreadsheet 605 views
Use the fill handle to quickly enter data
How can we format cell values

How can we format cell values

01:57
Spreadsheet 1527 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
Spreadsheet 586 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
Spreadsheet 2229 views
How to use the Smart Split Columns feature

Relate tags of office software Data Entry

More

export data from gridview to excel in c# windows application export datatable to excel in vb net windows application excel entry point not found windows xp excel 2003 crashes when entering data windows 10 work in access database using data validation in excel 2010 use query in database use microsoft office database turn on data on tablet transfer data from macbook pro to macbook pro

About WPS Academy

WPS academy supplies free office software training tutorials 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