You will get Clean up to 1,000 rows + Audit sheet (Power Query steps)
Project details
I clean and standardize datasets (up to 1,000 rows) using Power Query so results are fast, accurate, and repeatable. You’ll receive a tidy sheet, an Audit sheet (matched / unmatched / issues), brief notes, and replayable steps so your team can refresh with new data.
What I do:
• Normalize formats (dates, phone, casing, currency) and fix data types
• Remove duplicates using agreed keys; optional simple 2-sheet merge
• Light validation rules and a clear Audit sheet for QA
Process:
1) Review 50–100 sample rows and confirm keys + output columns
2) Build Power Query steps and share a small sample for approval
3) Run the full dataset, perform QA, and deliver the outputs
Deliverables:
• Cleaned Excel/Google Sheet
• Audit sheet
• Notes + Power Query “Applied Steps”
Timezone: GMT+7. Responsive and organized.
What I do:
• Normalize formats (dates, phone, casing, currency) and fix data types
• Remove duplicates using agreed keys; optional simple 2-sheet merge
• Light validation rules and a clear Audit sheet for QA
Process:
1) Review 50–100 sample rows and confirm keys + output columns
2) Build Power Query steps and share a small sample for approval
3) Run the full dataset, perform QA, and deliver the outputs
Deliverables:
• Cleaned Excel/Google Sheet
• Audit sheet
• Notes + Power Query “Applied Steps”
Timezone: GMT+7. Responsive and organized.
Data Entry Type
Data Cleansing, Error DetectionData Entry Tool
Microsoft Excel, Microsoft Office, Microsoft WordWhat's included
| Service Tiers |
Starter
$19
|
Standard
$25
|
Advanced
$45
|
|---|---|---|---|
| Delivery Time | 1 day | 2 days | 3 days |
Number of Revisions | 1 | 1 | 2 |
Number of Hours of Work | 1 | 2 | 4 |
Formatting & Clean Up | |||
Graph & Table Creation | - |
Optional add-ons
You can add these on the next page.
Additional Revision
+$5
Additional Hour of Work
+$5
+500 rows
(+ 1 Day)
+$10
Merge 2 sheets (simple key)
(+ 1 Day)
+$10Frequently asked questions
About Manh Luong
Excel & Google Sheets Expert | Data Cleaning & Analysis | PMO Support
Hanoi, Vietnam - 12:11 am local time
Hi there! I am a Rising Talent freelancer with 5+ years of experience in PMO (Project Management Office) at a top Global IT Service Company. I specialize in solving complex data problems that slow down your business.
Why hire me?
Accuracy: I handle data with the precision of a PMO Analyst.
Speed: I use advanced tools (Power Query, Formulas) to automate boring tasks.
Security: Your data privacy is my top priority.
My Services:
Advanced Excel/Google Sheets: Repairing broken formulas (#REF, #N/A), VLOOKUP/XLOOKUP, Pivot Tables.
Data Cleaning: Deduplication, splitting names/addresses, formatting standardization.
Data Entry & Migration: Moving data from PDF/Images to Excel with 100% accuracy.
Specialized Tech: Metadata sanitization for privacy compliance (PDF/Office files).
Let's get your data organized today. Invite me to your job!
Steps for completing your project
After purchasing the project, send requirements so Manh Luong can start the project.
Delivery time starts when Manh Luong receives requirements from you.
Manh Luong works on your project following the steps below.
Revisions may occur after the delivery date.
Step 1 — Kickoff & requirements
Confirm keys for dedupe/match, output columns/formats, row count, and deadline.
Step 2 — Sample pass (50–100 rows)
Build initial Power Query steps and share a small sample + Audit sheet for approval.