You will get Excel formula fix, automation, pivot table and spreadsheet optimization
Project details
You built the sheet. You entered the data. But the
formulas won't work — or they show wrong
answers without any error message.
I've seen it all: VLOOKUP returning #N/A, IFs that
ignore certain conditions, SUMIFs that sum the wrong
column, and pivot tables that refuse to refresh. I
fix all of it — quickly and correctly.I don't just patch the problem. I
rebuild the logic properly so it won't break again
when new data comes in next month.
What I work with:
✔ Lookup formulas — VLOOKUP, XLOOKUP, INDEX-MATCH
✔ Logical formulas — IF, IFS, SWITCH, AND, OR, NOT
✔ Math formulas — SUMIF, COUNTIF, AVERAGEIF, SUMIFS
✔ Text formulas — TRIM, PROPER, LEFT, RIGHT, CONCAT
✔ Date formulas — DATEDIF, NETWORKDAYS, EDATE
✔ Error handling — IFERROR, IFNA, ISERROR
✔ Pivot tables — build, fix, refresh, restructure
✔ Data validation — dropdowns, rules, restrictions
✔ Conditional formatting — color rules, icon sets
✔ Dynamic ranges — auto-expand with new data
Who this is for:
Business owners, HR managers, accountants, sales
teams — anyone using Excel daily who needs it to
actually work the way it should.
What you send me: your file + a description of
what's broken or what you need. I'll handle the rest.
formulas won't work — or they show wrong
answers without any error message.
I've seen it all: VLOOKUP returning #N/A, IFs that
ignore certain conditions, SUMIFs that sum the wrong
column, and pivot tables that refuse to refresh. I
fix all of it — quickly and correctly.I don't just patch the problem. I
rebuild the logic properly so it won't break again
when new data comes in next month.
What I work with:
✔ Lookup formulas — VLOOKUP, XLOOKUP, INDEX-MATCH
✔ Logical formulas — IF, IFS, SWITCH, AND, OR, NOT
✔ Math formulas — SUMIF, COUNTIF, AVERAGEIF, SUMIFS
✔ Text formulas — TRIM, PROPER, LEFT, RIGHT, CONCAT
✔ Date formulas — DATEDIF, NETWORKDAYS, EDATE
✔ Error handling — IFERROR, IFNA, ISERROR
✔ Pivot tables — build, fix, refresh, restructure
✔ Data validation — dropdowns, rules, restrictions
✔ Conditional formatting — color rules, icon sets
✔ Dynamic ranges — auto-expand with new data
Who this is for:
Business owners, HR managers, accountants, sales
teams — anyone using Excel daily who needs it to
actually work the way it should.
What you send me: your file + a description of
what's broken or what you need. I'll handle the rest.
Data Tool
Microsoft ExcelWhat's included
| Service Tiers |
Starter
$5
|
Standard
$10
|
Advanced
$20
|
|---|---|---|---|
| Delivery Time | 1 day | 2 days | 3 days |
Number of Revisions | Unlimited | Unlimited | Unlimited |
Number of Pages Mined/Scraped | 1 | 1 | 1 |
Number of Sources Mined/Scraped | 1 | 1 | 1 |
Optional add-ons
You can add these on the next page.
Fast Delivery
+$5
Formula Explanation
+$10Frequently asked questions
About Umar
Data Analyst & Python Automation | Excel SQL Power BI
Attock City, Pakistan - 8:12 pm local time
I'm a Data Analyst and Python Automation developer based in Islamabad, Pakistan. My background in philosophy trained me to ask precise questions before touching any data — a habit that separates genuinely useful analysis from dashboards nobody acts on.
But I don't just analyze. I build.
Over the past year I've moved from understanding data to automating what people do with it — writing scripts that replace hours of manual work, building systems that collect, clean, and report data without human intervention, and delivering outputs that non-technical stakeholders can actually use.
─────────────────────────────
🛠️ WHAT I WORK WITH
─────────────────────────────
▸ Python — automation scripts, data pipelines, web scraping, AI integrations
▸ SQL — complex queries, CTEs, window functions, business reporting
▸ Excel — dashboards, pivot tables, formula automation, report templates
▸ Power BI — interactive visual reports and performance dashboards
─────────────────────────────
📦 WHAT I ACTUALLY DELIVER
─────────────────────────────
▸ Automated reports that generate and send themselves — no manual effort
▸ Web scrapers that pull live data from websites into clean, structured files
▸ SQL query systems that answer specific business questions on demand
▸ Excel dashboards your team opens and immediately understands
▸ AI-powered tools that handle repetitive communication and support tasks
▸ Python scripts that turn raw, messy data into polished, ready-to-use outputs
─────────────────────────────
🎯 WHERE I ADD THE MOST VALUE
─────────────────────────────
I work best when the problem is one of these:
→ "We collect a lot of data but don’t know what it’s telling us"
→ "Our team spends hours every week on reports that could be automated"
→ "We need data pulled from websites or external sources regularly"
→ "Our Excel files are a mess and nobody trusts the numbers"
→ "We want a simple AI tool to handle customer queries or internal tasks"
If any of these sound familiar — that's exactly the work I do.
─────────────────────────────
✅ HOW I WORK
─────────────────────────────
→ I ask focused questions before I start — to understand the real goal, not just the task
→ I deliver clean, documented work that’s easy to hand off or build on
→ I explain findings in plain language — no jargon, no confusion
→ I flag problems early rather than quietly guessing my way through
─────────────────────────────
I work with sales data, customer behavior datasets, business performance metrics, and operational reporting. I also take on automation projects where the goal is to reduce manual, repetitive work using Python.
If your data is sitting unused, your reports are taking too long, or you need a system that just runs — let's talk.
📩 Send me a message and let's figure out exactly what you need.
Steps for completing your project
After purchasing the project, send requirements so Umar can start the project.
Delivery time starts when Umar receives requirements from you.
Umar works on your project following the steps below.
Revisions may occur after the delivery date.
Diagnose the Problem
I'll open your file, identify every broken or missing formula, and map out exactly what needs fixing or building.
Fix & Build Formulas
I'll fix broken formulas, write new ones, and apply proper error-handling so nothing breaks when data changes.