Data Entry
DATA ENTRY 1: List of Customer's Mortgage Using Excel or Google Sheets. List at least 20 customers First Name| Last name| Customer ID| Gender | Location (any country or city) | Position | Education | Salary | Mortgage Outstanding
Task: Create a Customer Database
Objective: Create a customer database using Google Sheets. This database will help the
company manage customer information effectively.
Instructions:
1. Data Collection:
o All information will be dummy.
o Ensure you have the following information for each customer:
▪ Full Name
▪ Email Address
▪ Phone Number
▪ Address
▪ Date of Birth
▪ Purchase History (Date of purchase, Item/s purchased, Quantity, Price,
Total Amount, Order Number, Payment method (credit card/cash)
▪ Notes/Comments (Ex. discounts applied, special requests, delivery details)
2. Data Entry:
o Open Google Sheets and create a new spreadsheet.
o Create columns for each data field: Full Name, Email Address, Phone Number,
Address, Date of Birth, Purchase History, and Notes/Comments.
o Enter the collected data into the respective columns.
3. Formatting:
o Format the spreadsheet for readability. Use bold headings, adjust column widths,
and apply text wrapping where necessary.
o Use data validation to ensure correct data formats (e.g., dates, phone numbers).
4. Data Organization: Sort the data alphabetically by Full Name. Use filters to allow easy searching and filtering of the data.
DATA ENTRY TASK: List of Top 30 CEO in the U.S.A. First Name | Last Name | Title | Website | Facebook URL LInk | Instagram URL LInk | LinkedIn URL Link | Email Address | Company Name | Company Address
DATA ENTRY TASK: OB DESCRIPTION:
I am seeking a data entry specialist to scrape 10 leads for beauty spas in the United States. You will be responsible for sourcing the required data using your tools or any available platforms.
Strong proficiency in organizing data is essential; all information must be accurate and valid.
The specific details I need for each lead are:
Name of the head officer
Email Address (personal)
Location of the company
Title/Position
LinkedIn profile of the person
Company email
Company name
Please input all the collected data into a spreadsheet, and once completed, submit the list to me in an Excel file.