Data Entry Specialist
I.A DATA ENTRY SPECIALIST
Experience:
1. Data Entry Specialist / Sales Officer/ Sales Engineer
PROVA
Description: As a Sales Officer at Rockspeed Elevator and Escalator Corporation, I was responsible for accurately entering generated quotation details and list of client payment summary and outstanding balances into MS Excel and Google Sheets. This included recording information such as pricing, product specifications, and customer details to keep our records up to date. I used these spreadsheets to organize data, create reports, and assist with sales planning. I worked closely with the sales team to ensure all information was correct and provided timely updates to support client interactions. My role required attention to detail and proficiency in spreadsheet software to help make our sales processes more efficient.
These are the details of the generated quotation for the new elevator and escalator equipment (as shown above).
These are the details of the generated quotation for the elevator and escalator preventive maintenance service (as shown above).
These are the details of the generated quotation for the elevator and escalator parts (as shown above).
These are the Master List of Client Payment Summary and Outstanding Balances (as shown above).
I.B DATA ENTRY SPECIALIST (TASK)
Experience:
1. Data Entry Specialist - TASK 1
PROVA
Task Description: Data Entry of Customer Mortgage Information
As part of our task at PROVA, I needed to enter a
list of customer mortgage details into an Excel spreadsheet. To make the job
easier and reduce mistakes, I used Excel’s Data Entry Form. This tool
made it simpler to fill in the information accurately by providing a clear and
organized way to enter each piece of data. Using the Data Entry Form
helped me complete the task faster and with fewer errors, ensuring the
information was correct and well-organized.
Experience:
2. Data Entry Specialist - TASK 2
PROVA
Task Description: Research and Data Entry for Top CEOs in Singapore
As part of our task at PROVA, I was tasked with researching and compiling information on the top 30 CEOs of a country of my choice. I chose Singapore and gathered details such as their names, titles, company information, and social media links. To make this process easier, I used Google Sheets and created a Data Entry Form with JavaScript in Google Apps Script. This form made data entry faster and more accurate. Although I was new to JavaScript, I quickly learned by watching YouTube tutorials and applied this knowledge to develop the form. This project not only helped me complete the task efficiently but also enhanced my skills in JavaScript and Google Apps Script.
This is where you will input the details (as shown above).
This is where you can edit the JavaScript in Google Apps Script (as shown above).
These are the resulting data in Google Sheets (as shown above).
II. MICROSOFT OFFICE & GOOGLE SUITE
A. MICROSOFT OFFICE
1. Microsoft Word
Description: As a Sales Officer at Rockspeed Elevator and Escalator Corporation, I generated quotations in response to client requests using Microsoft Word. These quotations were based on each client's specific preferences and requirements, ensuring clarity on pricing, product details, and services offered.
2. PowerPoint
Description: As a Sales Officer at Rockspeed Elevator and Escalator Corporation, I created and presented a PowerPoint presentation to clients, showcasing our elevator and escalator products and services. The presentation highlighted key features, technical specifications, and the benefits of our solutions, tailored to meet the client's specific requirements. It also included visuals such as product images, project timelines, and cost breakdowns to ensure a clear and engaging client proposal.
B. GOOGLE SUITE
1. Google Docs
Description: This Google Docs sample demonstrates my ability to create well-structured and formatted documents. It includes clear headings, organized content, and professional formatting for readability. The document showcases my skills in writing, editing, and using Google Docs features like comments, sharing permissions, and collaboration tools for efficient teamwork.
2. Google Calendar
Description: This Google Calendar sample from January 2024 illustrates how I managed and organized our office and client meetings in my previous role as a Sales Officer. It includes scheduled meetings with clients, internal team discussions, and project updates. The calendar helped ensure that appointments were well-coordinated and deadlines were met, while also allowing easy adjustments and real-time sharing with colleagues for smooth collaboration.
3. Google Form
Description: This Google Form sample demonstrates my ability to create a well-designed, user-friendly form for gathering information. The form includes various question types such as multiple-choice, short answers, and dropdowns, allowing for flexible data collection. It is organized with clear instructions, logical flow, and customizable sections, making it easy for respondents to complete. The form also integrates automated response tracking and summary features for efficient data analysis.
III.A EXCEL BASIC FORMULA AND FUNCTION
1. Sum & Multiplication
Description: This Excel sample showcases my use of SUM and multiplication formulas to calculate total amounts for a table of items. The table includes item names, quantities, and unit prices, with a total column generated by multiplying the quantity and price for each item. Additionally, I applied the SUM function to calculate the overall total, providing a clear and organized breakdown of costs. This demonstrates my ability to efficiently handle basic data analysis and calculations in Excel.
2. Average
Description: This Excel sample demonstrates my use of the AVERAGE formula to calculate the average scores across multiple quarters for a table of subjects. The table includes subjects with corresponding grades for the 1st, 2nd, 3rd, and 4th quarters. Using the AVERAGE function, I calculated the overall average grade for each subject, providing a clear summary of performance throughout the year. This showcases my ability to perform essential data analysis and summarization in Excel.
3. Min & Max
Description: This Excel sample demonstrates my use of the MIN and MAX functions to analyze a table of patient data, which includes patient numbers, ages, time-in, and time-out. I used the MIN function to determine the youngest patient, the earliest time-in, and the earliest time-out. Similarly, the MAX function was applied to find the oldest patient, the latest time-in, and the latest time-out. This showcases my ability to efficiently analyze data using Excel formulas to extract important details from various sets of information.
4. Concatenate
Description: This Excel sample demonstrates my use of the CONCATENATE function to merge data from multiple columns. The table includes separate columns for first, middle, and last names. By using the CONCATENATE formula, I combined these into a single column for the full name, ensuring proper spacing between the names. This showcases my ability to efficiently manipulate and organize data in Excel by merging text from different fields into a cohesive format.
5. Countif
Description: This Excel sample demonstrates my use of the COUNTIF function to calculate the number of days employees were present. The table includes employee names, wages, and daily attendance records (M, T, W, H, F, S), with 'P' for present and 'A' for absent. I used the COUNTIF function in the '# of Days' column to count how many days each employee was present ('P'). Based on this, I calculated their salary by multiplying the number of days present by their daily wage rate. This showcases my ability to efficiently use Excel formulas to track attendance and compute accurate salaries.
6. If and Conditional Formatting If
Description: In this Excel sample, I used the IF function to determine if students passed or failed based on their average scores. The left-side table shows names, averages, and a 'Passed/Fail' column, where the IF formula marks 'Passed' if the score is above 74.5, and 'Failed' if below.
On the right-side table, I applied conditional formatting. 'Passed' is highlighted in green, and 'Failed' in red, making the results easy to see.
B. ADVANCED FORMATTING AND EDITING DATA
1. Data Validation
Description: In this Excel sample, I created a table of names with data validation for the 'Gender' and 'T-shirt Size' columns. For 'Gender', I set options for Male (M), Female (F), and Prefer Not to Say. For 'T-shirt Size,' I included sizes ranging from XS to XXL. This data validation ensures that users can only select from the specified options, maintaining data consistency and accuracy.
2. Sorting & Filtering
Description: In this Excel sample, I created a table containing an inventory list with columns for Inventory No., Item, Unit Price, Qty Stock, Inventory Value, Reorder Value, and Factory Location. I applied sorting to organize the data, allowing users to easily view items by Inventory No. or Unit Price. Additionally, I used filtering options to enable quick searches for specific items, quantities, or locations, making data management efficient and user-friendly.
3. Chart
Description: In this Excel sample, I created a table that lists departments, campaigns, and projected sales. I used a chart to visually represent the projected sales data, making it easier to analyze trends and comparisons. Additionally, I added a slicer, allowing users to filter the chart and table by specific departments. This interactive feature enhances data visualization and helps users quickly focus on the information that matters most.
4. Pivot Tables
Description: In this Excel sample, I created a pivot table to analyze sales data for different colors and regions based on units sold. This pivot table helps summarize the sales figures, making it easy to compare performance across colors and regions.
5. Hlookup & Vlookup
Description: In this Excel sample, I demonstrated the use of HLOOKUP and VLOOKUP functions to manage data efficiently. On the left side, I used HLOOKUP to retrieve grades in Math, Science, and History based on a list of student names. On the right side, I applied VLOOKUP to pull information about employees, including their title, department, and salary, based on their names. This setup showcases my ability to use lookup functions for quick data retrieval and organization.
6. Index and Match
Description: In this Excel sample, I used the INDEX and MATCH functions to find prices and tickers for cryptocurrencies. This method allows for quick data lookup and organization in my table of company names and their corresponding prices.
