Excel Basic Data Entry

A data entry role involves entering data from various sources into the organization's computer system for processing and management. A worker working on data input is required to efficiently manage a large amount of information that is often sensitive or confidential

1. 2022
Well Wow tail
Home from Work
2/11/2022
Data Entry Operator Guide
K.SANJEEVI, Data Entry Operator [DEO]
Contact ID: [email protected]
[email protected]
[email protected]
[email protected]

2. Excel Function Basic Examples:
Data Entry Programming Format:
Data Entry Operator:
1. What is data?
Row facts and figure data are known as data.
2. Data types?
 Data,
 Public data,
 Customer support data,
 Research data,
 Manufacturing data, etc.
3. What is data entry job?
 Update, add or maintain data.
 Insert data in form of text or in numbers
 Verification
 Sorting the data
 Filling the documents
4. Data entry type:
 Book entry,
 Hand written entry
 Forms processing
 Image processing
 Legal document entry

3. Required skill:
1. Basic communication skill English.
2. Good spelling, grammar and punctuation skills are also necessary as
well as strong reading ability.
3. Typing speed min 20 wpm with 75 accuracy.
4. Short-term courses offered by many computer institutes.
5. Knowledge of computer operations.
6. MS Office, MS Word, MS Excel, etc.
7. Able to work in shifts, Remote.
8. Working at home online and offline.
Type One:
Step1: Excel Book Open

Step2: Office Button Click or File Menu Click


Step3: Select Option Button Click

4. Step4: Open Excel Option Windows
Step5: Choose Customize Button Click

5. Step6: Choose Commend Form
Step7: Dropdown box Click
Step8: Commands not in the Ribbon Click


Step9: Scroll Box, Select “Form “Click

6. Step10: Select “Add” Button Click



Step11: Customize Box bar Available “OK” Button Click

7. Step12: Select 3RX11C

Step13: Choose Home Alignment Ripen Merge & Center Click
Step14: Select Merge Cell Click


Step15: Select box Type Head Line Text.

Step16: Choose Left Site Date Function Into
=now () Enter. [Result: 2/9/2022 22:02]

Step17: Type the Following Rows S/N, Name, Roll No, S1 to S5

Step18: Select Name Type Rows.

8. Step19: Choose “Form” Click

Step20: Type the following Data Entry Box Into

Step21: New Button Click

Step22: Type to Step to Step

=now () Enter, Result: Date and Time.

9. Type Two Sort & Filter
Step1: Choose Data Menu Click
Step2: Choose Sort & Filter Ribbon “Filter” Click

10. Step3: Choose Trade Filter Button Click
Step4: Select all button not tick, choose one trade “Assistant” Tick

Step5: Result to Filter only Assistant Trades

11. Type Tree: Salary Data Entry Table

Salary Data Entry Format Tree Type: 31 days, 30 days, 29 days.
Working Amount
= (Salary*Working day/31) Enter.
Over Time Amount
= (Salary*Over time day/31) Enter.
Advance
= (Total amount-Advance) Enter.
Result: Net Amount

12. Type Four: Pivot Table
Step1: Data all select
Step2: Choose Insert Tab Table Ribbon “Pivot Table” Click
Step3: View Create Pivot Table

Step4: Choose the Pivot Table Report to be placed “OK” Button Click

13. Step5: Choose Your Report and Field
Example:
Report Filter: Designation
Row or Column Labels: Name
Value: Salary
Result: Data Pivot Table


Type Six: Chart Table
Step1: Create New Data

14. Step2: Select all Data Charts Table
Step3: Choose Insert Charts Column or any Ribbon Click

Step4: Result see “Rate Chart”

15. Step5: Choose Data Charts Table
Step6: Type the following Rate Column “1”
Step7: Result: See Chart “Rate”

Step8: Type the following Rate Column “74”

16. Step9: Type the following Rate Column “88”

Step10: Type the following Rate Column “0.1”
Step11: See Result Data Charts Table
Example: Euro and Dollar Rate High, Rupees and Coins Rate Low.