Skip to content
BackNov 7
Gyan R.
Upwork badge

Gyan R.

Excel & Google Sheets Expert | Automation, Analysis & Dashboards

I turn messy, manual spreadsheets into clean, automated Excel and Google Sheets systems, so you stop copy-pasting, fixing formulas, and rebuilding the same report every week. An MBA, ex-Bank of America professional, with hands-on business operations experience across Financial & Retail sectors — I design the whole flow, from raw data to finished analysis, around how your team actually works. ➡️WHAT I CAN DO FOR YOU 🔸Data entry, cleaning & structuring: fix duplicates and inconsistent formats, consolidate scattered sources, and handle data migration between systems so it's ready to use 🔸Data analysis & reporting: sales, inventory & operations MIS reports, KPI tracking, and performance and commission trackers you can act on 🔸Dashboards & data visualization: clear, interactive views and reusable templates built around the decisions you make 🔸Automation: VBA macros for Excel and Apps Script for Google Sheets to replace repetitive data processing, file consolidation, report prep, and formatting 🔸New builds or rescues: a system or data model from scratch, or a clean-up of a workbook that has become slow, fragile, or confusing ➡️THIS IS FOR YOU IF… 🔸Your weekly or monthly report takes hours and shouldn't 🔸Your data is spread across many files and you don't fully trust the numbers 🔸Your workbook is slow, breaks often, or only one person understands it 🔸You need a dashboard or tracker but aren't sure how to structure it ➡️WHY WORK WITH ME 🔸Bring 10+ years of overall professional experience across Financial & Retail businesses, including hands-on Excel-based MIS, inventory tracking, and operational reporting. 🔸Lean Six Sigma Green Belt (KPMG India): I look for the process problem behind the spreadsheet, not just the formula 🔸I also teach Excel & Google Sheets to professionals, so I explain what I build and hand it over clearly ➡️TOOLS 🔸Excel: • Advanced Formulas (VLOOKUP, XLOOKUP, INDEX/MATCH, SUMIFS, Pivot Tables) • VBA & Macros • Power Query • Power Pivot & Data Modeling 🔸Google Sheets: • Advanced Formulas • Apps Script • Automation & Templates ➡️HOW I WORK Understand your goal and data → Design the structure → Build and test → Automate → Hand over with a walkthrough so your team can keep using it without me ➡️NEXT STEP Send me your file, or describe your workflow and what's frustrating about it. I'll reply with a clear view of what can be improved and how I'd approach it. Your data stays confidential.

🇮🇳Gurgaon, India$12/hr100% JSS5.00 (2)Since Oct 2024

Earnings and projects

MRR
$224

Last 6 months ÷ 4.9 months active (since Jun 2026)

World#109,354 / 412k
🇮🇳Country#11,492 / 45.9k
Revenue, last 30 days
—

Read daily since Oct 27, under 30 days

Total earnings
$1.1k

Billed in all: $1.2k

World#385,446 / 412k
🇮🇳Country#41,919 / 45.9k
Per project
$370

$365 in the last 6 months

World#211,425 / 412k
🇮🇳Country#25,929 / 45.9k
Projects, last 6 months
3
0% fixed100% hourly
World#66,479 / 412k
🇮🇳Country#7,740 / 45.9k
Projects in all
3
0% fixed100% hourly
World#304,140 / 412k
🇮🇳Country#37,108 / 45.9k

Earnings, last 30 days

$1.2k+$154 earned since Oct 27Billed in all, before Upwork's fee · drag across the chart to see what was earned in any stretch
$1.0k$1.1k$1.2k$1.3kOct 27Nov 2Nov 7

Tracked from Oct 27, 2026.

Skill rankings: Top 21% in Visual Basic for Applications

Ranked by MRR among everyone on Upwork with the skill.

  1. #54VLOOKUP201 freelancers · 🇮🇳 #6Top 27%
  2. #77Templates268 freelancers · 🇮🇳 #9Top 29%
  3. #242Excel Macros900 freelancers · 🇮🇳 #19Top 27%
  4. #265Microsoft Excel PowerPivot1,098 freelancers · 🇮🇳 #22Top 24%
  5. #265Power Query958 freelancers · 🇮🇳 #24Top 28%
  6. #275KPI Metric Development775 freelancers · 🇮🇳 #9Top 35%
  7. #293Data Modeling1,203 freelancers · 🇮🇳 #35Top 24%
  8. #299Visual Basic for Applications1,453 freelancers · 🇮🇳 #30Top 21%