Employee Data Management System
A complete HR database built in Excel, tracking employee records across departments. Includes employee ID, full name, department, designation, date of joining, employment type, location, contact details, annual CTC, leave balance, and active status — all formatted with color-coded conditional formatting (e.g. low leave balances highlighted in red, high balances in green). The file is organized across multiple sheets: Employee Directory, Recruitment Tracker, and Performance Dashboard, demonstrating multi-sheet data organization and HR data structuring.
0
6
SaaS Competitor Research — 25 Companies
Researched and compiled data on 25 SaaS project management companies including Notion, Airtable, Monday.com (http://Monday.com), ClickUp, and Asana. Collected 6 data points per company — website, employee count, revenue range, G2 rating, and headquarters location. All 150 data points were verified from trusted sources like LinkedIn, G2, and Crunchbase. Delivered in 6 hours in a clean Excel sheet.
0
25
Invoice PDF → Structured Excel Sheet
Converted an unstructured PDF invoice into a clean, fully functional Excel spreadsheet. The original PDF had no formulas, no filters, and data was hard to read. I restructured it with proper columns (Product, Qty, Unit Price, Total), added auto-calculation formulas for subtotal, tax, and grand total. Delivered in 2 hours with 100% accuracy.
0
30
Client Database Management — Excel Data Entry
Organized and entered 8 international client records into a structured Excel spreadsheet. Each record included client name, email, phone number, country, deal status, and revenue. Data was color-coded by status (Active, Pending, Closed) for easy filtering. Delivered with zero errors in under 4 hours. Total revenue tracked: $26,120 across 8 clients.