I will create excel dashboards with pivot tables and power query

I
iqrarkhan20
I
iqrarkhan20
Iqrar Khan

About this gig

Turn your Excel data into a clear dashboard for sales, expenses or customer activity.

BASIC: One dashboard from one clean table, with up to 2 charts and 2 summary metrics.

STANDARD: One dashboard with up to 4 charts, 4 metrics, 2 slicers and one source table prepared with Power Query.

PREMIUM: One dashboard with up to 6 charts, 6 metrics, 3 slicers and up to three source tables prepared with Power Query.

A source means one structured table from an Excel worksheet or CSV file. Multiple tables in one file count separately.

Standard and Premium include basic preparation: correcting data types, removing blank rows and removing exact duplicates. Manual data entry, complex cleanup and Power Pivot models require a separate quote.

You receive an editable workbook and refresh instructions. Website scraping, live APIs, Power BI and forecasting are excluded.

Please send sample data, your Excel version and the metrics you need before ordering. Revisions cover the agreed requirements.

Get to know Iqrar Khan

Iqrar Khan

Excel VBA Automation, Data Entry Forms and Reports

  • FromPakistan
  • Member sinceNov 2026
  • Avg. response time1 hour
  • Languages

    Urdu, English
I'm Iqrar Khan, an Excel specialist with over two years of hands-on accounting and record-keeping experience. I build VBA data entry forms, automate repetitive tasks, fix formulas and create practical dashboards and reports. My experience includes cash books, invoices, customer accounts and basic bank reconciliation. I use advanced Excel formulas, Pivot Tables and Power Query to help small businesses organise their work. Send me your workbook and requirements to discuss a suitable solution.

My Portfolio