Ishita Singh's Work | ContraWork by Ishita SinghIshita Singh
Excel | Word | Data Entry | Transcription| Emails
Title: Data Formatting & Cleaning in Excel
Description: I turn messy spreadsheet exports into clean, consistent, analysis-ready data. I remove duplicates and extra spaces, standardize names, dates and currency, and flag missing values for review instead of guessing.
Tags: Data Cleaning, Excel, Data Formatting, Data Entry, Spreadsheets, Virtual Assistant Sample Data - Finance: invoices and receivables, collections and overdue-payment buckets.
Dashboard: a colored title banner, 4 KPI cards, a “Key Highlights” box and 4 charts. The highlights are written by formulas, so they update when the data changes.
Data: 250 records in a filterable table, with drop-down lists, color-coded status cells, bar shading on amounts and calculated columns.
Pivot Summary: 5 summary tables (by category, region, month, status, and so on) with grand totals.
Raw vs Clean: messy sample rows next to a checklist of the cleanup steps. This shows clients the data-entry and cleanup work they’d be paying for. Sample Data - I translated a formal business letter about an order confirmation and delivery schedule from English to Hindi. I also translated a customer support message from Hindi to English.
My goal was a translation that sounds natural to a native Hindi reader, not a word-for-word copy. I used formal Hindi for the business letter, including the right greeting and sign-off. Common business words like ऑर्डर (order), डिलीवरी (delivery) and ईमेल (email) are kept the way Indian businesses actually use them.
I checked every date, quantity and order number against the original to make sure nothing changed. The file also includes a glossary of key business terms and short translator’s notes explaining my choices. Excel | Formatting | Splitting |Modifying| Converting| Cleaning| Charts and Bar Graphs