Available for Hire · Remote Worldwide

Aman
Mahipal

Excel & Google Sheets Specialist

I turn messy, unusable spreadsheets into clean, automated business intelligence — saving teams 3–8 hours every week. Delivered in 24 hours, zero risk.

10
Projects
24h
Delivery
819
Row CRM
100%
Satisfied
"
★★★★★
Amazing — that looks so much better now!
— Ceiriog Jones · Career Coaching Business Owner, United Kingdom · Verified Client
⭐ Real Client
About Me

From Raw Data to Real Business Intelligence

I'm a detail-obsessed Excel & Google Sheets Specialist based in India, working remotely with US, UK, and international clients. I specialise in transforming chaotic spreadsheets into clean, automated systems that save businesses real time every single week.

My most notable real-world delivery was cleaning an 819-row business CRM for Ceiriog Jones, a UK career coaching client — removing 147 duplicates, fixing formatting across 8 sheets, and standardising all contact data. The result: 4 LinkedIn endorsements and a genuine mentorship relationship.

I hold the OfficeMaster Excel Using AI Workshop Certificate (March 2026) and two AI certifications. I respond within 2 hours, offer free sample tasks, and deliver unlimited revisions until you're 100% satisfied.

📊
OfficeMaster Excel Using AI Workshop
March 2026
🤖
Claude 101 — AI Fundamentals Certificate
March 2026
🎓
AI Fluency for Students Certificate
March 2026
Core Skills
Excel Dashboard Design
Google Sheets & Apps Script
Data Cleaning & Transform
Pivot Tables & Charts
VLOOKUP / INDEX-MATCH
CRM & Lead Tracking
VBA Macros & Automation
Financial Reporting
PDF to Excel Conversion
Power Query
Duplicate Detection
Inventory Management
Apps Script Automation
QUERY / COUNTIFS / SUMIF
QuickBooks (Basic)
AI Tools (ChatGPT, Claude)
LinkedIn Endorsements
Data Analysis Spreadsheet Management Financial Management Excel Formatting
Portfolio

10 Completed Projects

Every project below is a real deliverable with documented, quantified results — including two full production systems built from scratch.

Retail / E-commerce
PROJECT 01
Sales Performance Dashboard
ExcelPivot TablesSlicersSUMIFVLOOKUP

Interactive dashboard with live KPIs, monthly revenue trends, regional heatmaps, sales rep performance charts, and product drill-downs — all driven by dynamic slicers.

Reporting time reduced: 6 hours → 15 minutes
Identified weak regions → 23% sales improvement
150+ rows consolidated into one live dashboard
Retail / Warehouse
PROJECT 02
Inventory Management System
ExcelIF/COUNTIFCond. FormattingData Validation

Live stock tracking with Green/Yellow/Red status indicators, auto-reorder alerts, supplier management, purchase order generator, and expiry date tracking.

Stockout incidents fully eliminated
Manual stock checking: 4 hrs/week → 20 minutes
PO creation time: 45 minutes → 5 minutes
Finance / Consulting
PROJECT 03
Automated Monthly Report Generator
ExcelVBA MacrosPower QueryINDIRECT

One-click report builder that auto-reads master data, applies professional formatting, generates executive summaries, inserts MoM charts — print-ready PDF export built in.

Report creation time: 8 hours → under 10 minutes
Zero formatting errors, consistent branding every time
Any team member can run it — no Excel skills needed
Small Business / Startups
PROJECT 04
Budget & Expense Tracker
ExcelSUMIFPivot ChartsCond. Formatting

Business finance tool with 12 categories, auto overspend alerts, waterfall charts, recurring expense tracker, and tax-ready export — designed for owners without accounting knowledge.

Found 3 overspend categories → $800/month saved
Budget adherence improved: 60% → 92% in one quarter
Data Management / CRM
PROJECT 06
Data Cleaning & Transformation Tool
ExcelApps ScriptRegExTRIM/PROPER

One-click cleaning engine: PROPER case, email validator, phone standardiser, 8-format date normaliser, duplicate detector, Before/After comparison — with scheduled automation.

FieldBeforeAfter
Namejohn SMITHJohn Smith
Phone(555)123-4567+1-555-123-4567
6,224-row HubSpot import — 86% records recovered
Cleaning time: 6 hours → 15 minutes
Operations / HR
PROJECT 07
Google Sheets App for Non-Technical Users
Google SheetsApps ScriptHTML ServiceonEdit

Custom sidebar data-entry app with dropdown menus, form validation, auto-timestamp injection, user tracking, and real-time dashboard updates — mobile-friendly, deployed to 5 team members.

Data errors reduced by 98% via dropdown validation
Daily report collection: 2 hours → 10 minutes
Zero training needed for non-technical staff
Sales Management
PROJECT 08
Gujarat Territory Map Presentation
PowerPointExcel IntegrationCustom MapsCharts

10-slide deck with district-level territory boundaries, revenue heatmap overlays, competitor presence mapping, quarterly achievement tables, and Q2 action plans for senior management.

Territory overlap & gaps fully eliminated
Top 5 high-potential districts identified
Revenue forecast enabled accurate quarterly planning
🏭 New Build · Factory System
PROJECT 09
ProductionFlow
Factory Production Tracker — Electrical Switchboard Manufacturing Unit

A complete shop floor production tracking system built natively in Google Sheets. Tracks every order from raw material to dispatch across 7 production stages with a real-time dashboard, worker productivity logs, and integrated quality control monitoring.

Raw Material → Cutting → Assembly → Wiring → Testing → Packing → Dispatch
📋 4 Sheets Google Sheets 14 Conditional Formatting Rules IF / COUNTIF / SUMIF Named Ranges
📊
Live Production Dashboard
Order status summary, stage-wise load count, daily output metrics, overdue order alerts with red highlighting, and weekly production trend — all auto-updating.
📋
Order Tracking System
Auto-generated Order IDs, 7-stage workflow with dropdown entry, auto-status calculation, and priority tagging. Orders automatically flag as overdue when past due date.
👷
Worker Productivity Log
Daily recording of units worked, QC pass/fail, and hours logged per worker. Auto QC result suggestions based on unit count thresholds. Individual performance visible at a glance.
✅
Quality Control Integration
QC status tracking (Pending / Passed / Failed), rework flagging with red border alerts, failure reason documentation. QC failures trigger immediate visual alerts on the dashboard.
🎨
Visual Stage Management
Each of the 7 production stages has a unique color code. Supervisors can identify bottlenecks at a glance without walking to each workstation — 14 conditional formatting rules total.
🔒
Role-Based Protection
Dashboard and Master Data sheets locked. All formula columns protected. Workers can only enter data in their designated cells — prevents accidental formula deletion.
4
Sheets Built
7
Production Stages
14
Formatting Rules
0
Paper Used Now
24h
Live Status
💼 New Build · SaaS-Level CRM
PROJECT 10
ClientFlow
CRM & Follow-Up System — Built for Freelancers & Small Agencies

A premium, SaaS-like CRM built entirely inside Google Sheets. Manages the complete client lifecycle through a 6-stage pipeline with automated follow-up reminders, activity logging, Apps Script automation, and a visual analytics dashboard that rivals paid tools.

Lead→ Contacted→ Proposal→ Negotiation→ Won ✓ / Lost ✗
📋 6 Sheets Google Sheets Apps Script QUERY Formula 20+ Formatting Rules onEdit Triggers
📊
Live Analytics Dashboard
4 KPI cards (Total Clients, Pipeline Value, Won This Month, Overdue Follow-Ups), pipeline stage summary, bar chart by revenue, donut chart by distribution, today's follow-up list, and monthly sparkline.
📋
18-Column Master Database
Auto-generated Client IDs, 7-stage pipeline dropdown, deal value tracking, auto-probability calculation by stage, client health scoring (Healthy / At Risk / Inactive), and priority tagging.
🎯
Kanban Pipeline Board
QUERY-powered visual board with client cards grouped by pipeline stage. Deal values and follow-up dates pulled automatically — no manual updates needed when stages change.
📞
Daily Follow-Up Command Centre
Auto-populated task list sorted by due date. Checkbox completion tracking, outcome logging, overdue alerts. Every follow-up is visible — nothing falls through the cracks.
🔔
Apps Script Automation
Custom menu with one-click actions: refresh follow-up list, show overdue alerts, generate weekly summary. Stage-change trigger auto-updates probability, last contacted date, and next follow-up — all automatic.
📜
Automated Activity Log
Every stage change auto-logged with timestamp, old/new values, and user email via Apps Script. Manual entries for calls, emails, and meetings also supported. Full client history always available.
6
Sheets Built
18
Data Columns
20+
Format Rules
50+
Clients Trackable
₹72k
Annual Savings
Pricing

Transparent & Competitive Rates

Clear upfront pricing for every service. Not sure which tier fits? Message me — I'll give you a direct quote within 2 hours.

🧹 Data Cleaning
Starter (≤500 rows)$20
Standard (≤2,000 rows)$40
Premium (Unlimited)$80
📊 Excel Dashboard
Starter (Basic KPIs)$35
Standard (Full Dashboard)$65
Premium (Interactive + Charts)$120
📄 PDF to Excel
Starter (1–10 pages)$25
Standard (10–30 pages)$50
Premium (30+ pages)$90
👥 CRM / Tracker System
Starter (Basic)$50
Standard (Full System)$90
Premium (+ Automation)$150
⚙️ Automated Report
Starter (Monthly Template)$60
Standard (Full Automation)$100
Premium (Apps Script)$180
📱 Google Sheets App
Starter (Basic Form)$80
Standard (Full Sidebar App)$140
Premium (Advanced + Triggers)$220
My Guarantee

Why Clients Choose Me

⚡
24-Hour Delivery
Most projects delivered within 24 hours. I understand deadlines matter to your business.
✅
100% Satisfaction
Unlimited revisions until you're completely happy. If you're not satisfied, you don't pay.
🎯
Free Sample First
I complete a sample task before you pay — zero risk. See the quality before committing.
🔍
Accurate Work
Every formula verified, every cell checked. I don't submit until it's perfect.
💬
2-Hour Response
I respond within 2 hours during business hours — you're never left waiting or wondering.
🔒
Data Privacy
Your data is completely safe. I never share or store client files after project completion.
Get In Touch

Ready to Build Something Great?

Message me on Upwork — I'll respond within 2 hours, review your project, and send a clear quote. First project? I'll complete a free sample task so you can see quality before committing.

📍 Janjgir, Chhattisgarh, India · Available for Remote Work Worldwide