Skip to content
BackNov 7
Khaled Dawood Ismail K.
Upwork badge

Khaled Dawood Ismail K.

Excel Power Query (ETL) VBA Automation | KPI Dashboards (PivotTables)

My Title is [ Excel Power Query (ETL) + VBA Automation | KPI Dashboards (PivotTables/Slicers) & Data Cleanup ] I build Excel solutions that turn messy data into clean, reliable reporting—fast. My core strength is Power Query (ETL): I use it in essentially every Excel project to import, clean, transform, and prepare data so dashboards and reports are easy to maintain. What I can deliver • Power Query ETL (data cleaning & transformation) Merge/append queries, remove duplicates, fix data types, handle errors, standardize columns, and build repeatable pipelines. • Excel dashboards & reporting PivotTables + slicers, KPI dashboards, drill-down reports, and well-structured workbooks that are easy for end users. • VBA automation (when needed) Buttons/macros to generate reports, format outputs, export to PDF/Excel, and streamline repetitive tasks. • Excel troubleshooting & performance improvements Fix broken workbooks, improve formula reliability, and reduce errors. • Index/Match + formula-driven refresh (when required) I can also set up dashboards that update results via Index/Match + supporting formulas (not always relying on refresh). How I work I start by confirming your input data, the final output, and your rules/formatting. Then I deliver a working Excel file with clear instructions so you can use it immediately. If you’d like, I can begin with a small paid test using your sample file to confirm structure, approach, and output quality before we proceed.

🇪🇬Giza, Egypt$20/hr100% JSS5.00 (5)Since Oct 2019

Earnings and projects

MRR
$626

Last 6 months ÷ 6

World#68,568 / 412k
🇪🇬Country#881 / 6,384
Revenue, last 30 days
$933

Last 6 months: $3.8k

World#44,874 / 412k
🇪🇬Country#521 / 6,384
Total earnings
$5.3k

Billed in all: $5.5k

World#250,126 / 412k
🇪🇬Country#3,399 / 6,384
Per project
$527

$1.9k in the last 6 months

World#177,859 / 412k
🇪🇬Country#2,244 / 6,384
Projects, last 6 months
2
50% fixed50% hourly
World#88,918 / 412k
🇪🇬Country#1,221 / 6,384
Projects in all
10
70% fixed30% hourly
World#201,797 / 412k
🇪🇬Country#3,173 / 6,384

Earnings, last 30 days

$5.5k+$840 earned since Oct 11Billed in all, before Upwork's fee · drag across the chart to see what was earned in any stretch
$4.5k$5.0k$5.5k$6.0kOct 11Oct 25Nov 7

Tracked from Oct 11, 2026.

Skill rankings: Top 14% in Microsoft Excel PowerPivot

Ranked by MRR among everyone on Upwork with the skill.

  1. #18Data Chart101 freelancers · 🇪🇬 #1Top 18%
  2. #62Expense Reporting281 freelancers · 🇪🇬 #1Top 22%
  3. #142Excel Macros900 freelancers · 🇪🇬 #5Top 16%
  4. #151Power Query958 freelancers · 🇪🇬 #6Top 16%
  5. #153Microsoft Excel PowerPivot1,098 freelancers · 🇪🇬 #4Top 14%
  6. #203Visual Basic for Applications1,453 freelancers · 🇪🇬 #2Top 14%
  7. #210Excel Formula1,280 freelancers · 🇪🇬 #6Top 16%
  8. #264Financial Report1,343 freelancers · 🇪🇬 #2Top 20%