alvinuari yufinta (alvinuari_yufinta)

2025: Cleaned and organized raw transactional data (debit and credit) using Microsoft Excel. The dataset contained incomplete and inconsistent entries, such as empty cells, missing values, and unclassified categories.

Key Tasks:
Replaced blank cells in numeric columns with "0" to ensure calculation accuracy.
Standardized transaction categories based on descriptive information (e.g. Transfer, Transaction Book, Tax, Interest).
Formatted the data into structured tables suitable for analysis.
Prepared the cleaned dataset for advanced use, including the creation of Pivot Tables for summary reporting.

Tools Used:
Microsoft Excel (Find & Replace, IF formulas, Data Validation, Pivot Table)

2025: Developed an interactive payroll lookup system in Microsoft Excel to display employee salary and bonus information based on the selected employee name.

Key Tasks:
Created a drop-down menu containing employee names using Data Validation.
Used VLOOKUP to automatically retrieve and display the corresponding salary and bonus when a name is selected.
Organized the employee data in a structured table including name, position, base salary, and bonus.
Improved efficiency in reviewing payroll data without manual search.

Tools Used:
Microsoft Excel (VLOOKUP, Data Validation, Table formatting)

2025: Created a dynamic report system in Microsoft Excel to display complete transaction details (date, item name, price, quantity, and total) based on a specific item ID input.

Key Tasks:
Compiled raw sales data into a structured table containing item IDs, dates, names, prices, quantities, and totals.
Applied the VLOOKUP formula to automatically retrieve and display item information when an item ID is entered.
Ensured accurate calculations of totals using formulas (e.g., =Price * Quantity).
Improved data search efficiency and reduced manual lookup time with an interactive and user-friendly format.

Tools Used:
Microsoft Excel (VLOOKUP, basic formulas, table formatting)