SAMPLE WORKS

During our training, one of the assignments involved creating a comprehensive customer database using Excel. For this project, I focused on a list of customers based in the U.S., incorporating details such as customer ID, gender, location, job title, educational background, salary, and remaining mortgage balance. This experience taught me the significance of accuracy and organization, particularly when handling sensitive information. I gained insight into how customer data can enhance services and inform better business decisions. Additionally, this task provided me with the opportunity to practice managing large datasets in a clear and efficient manner.

Sample Of Loan Amortization or Loan Payment Tracker

This Excel spreadsheet was designed to track customer loan information alongside essential income details. It features fields such as Customer ID, First Name, Last Name, Gross Yearly Salary, Monthly Salary, Loan Amount, Interest Rate, Loan Term in Months, Months Already Paid, Remaining Months, Monthly Payment, and Total Amount Paid to date. This file allows me to practice monitoring loan payments in connection with customer income data. Additionally, it improves my skills in organizing financial records clearly and effectively utilizing formulas to compute loan progress and outstanding balances.

Sample Of Customer Data Management Sheet

This sample Excel file is designed to monitor essential customer information, along with their financial and purchase histories. It features fields such as Customer ID, Full Name, Gender, Location, Job Position, Educational Background, Salary (in PHP), Purchase History, Notes or Comments, and Outstanding Mortgage. This task has enhanced my skills in effectively organizing and managing customer data.

Sample Of Inventory Table

This sample inventory table developed during training highlights essential details such as products, categories, suppliers, stock quantities, prices, and descriptions. This assignment, given by our trainer, demonstrates my abilities in managing inventory data effectively.

This project refined my data entry skills on a grand scale. The task, given by our trainer, required me to compile information on the top 20 CEOs. I conducted independent research to gather details such as their names, titles, company websites, social media links, email address and company addresses. After collecting this information, I carefully entered everything into a well-organized spreadsheet, demonstrating my capability to manage a large dataset with precision and efficiency.