Browse categories
Explore
Fiverr Pro
English
$
USD
I will create an excel dashboard, pivot tables and automated reports with vba
Data Analyst, AppSheet Expert, Excel VBA Specialist, Python, Tableau, Power BI
Data Analyst | AppSheet Expert | Automation Specialist
I am Amir Khan, an expert in transforming raw data into meaningful insights to make right decisions. With a decade of experience, I offer a comp...
Level 2
Has met high performance criteria and has a proven track record for meeting client expectations.
About this Gig
Turn messy spreadsheets into a clear, interactive Excel dashboard.
With 10+ years in Excel and 200+ reviews, I build dashboards that show your numbers at a glance and update automatically.
I can build:
- Sales, inventory, finance, HR and KPI dashboards
- Pivot tables, pivot charts and slicers
- Dynamic charts and drop-down filters
- Automated monthly/weekly reports with VBA
- Power Query connections that refresh with one click
- Google Sheets dashboards
Why buyers choose me:
- Professional, clean design that's easy to read
- Formulas and macros that are documented and easy to update
- Fast replies and free support after delivery
Send me your data (or a sample) and tell me what you want to track. I'll suggest the best layout before we start.
Platform:
Excel
•
Google Sheets
Development technology:
VBA
Expertise:
Formatting
•
Fixing
•
Forms
•
Pivot tables
•
Formulas
Clients I’ve worked with
Red Rose Bakery
- Developed Excel/VBA database for food product management (ingredients, allergens, shelf-life). - Built intuitive UI for managing product records, customer selection, and production runs. - Engineered automated label generation with custom batch codes (YYMMDDGB) and expiry date calculations. - Integrated batch printing for 4"x3" thermal printers, featuring print preview and multi-item queues.
Jun 2026-Jun 2026
My Portfolio
FAQ
Can you use my company colors or logo?
Yes, I'll match your branding.
Will the dashboard update when I add new data?
Yes. I use tables, Power Query and dynamic formulas so it refreshes automatically.
Excel or Google Sheets?
Both. Tell me which one you use.
Reviews
7 reviews for this Gig
| (7) | ||
| (0) | ||
| (0) | ||
| (0) | ||
| (0) |
Rating Breakdown
- Seller communication level
- Recommend to a friend
- Service as described
Sort By
Most relevant
M matthewainsc409
Thailand
Great delivery and comms.
$50
Price
1 day
Duration
A 
Seller's Response
Helpful?C colleentreid
United States
Ongoing collaborationgreat job helping and super fast
$50-$100
Price
1 day
Duration
A Seller's Response
Helpful?L lakerfan2020
United States
Amir was easy to work with and created my Excel UDF as specified.
$50
Price
4 days
Duration
A Seller's Response
Helpful?D 
drugarpe
United States
Ongoing collaborationEasy and fast to communicate with Amir, his files turnaround time is very fast and accurate, and he is very good following directions and request. very easy to work with him.
$50
Price
A Seller's Response
Helpful?U user78223748
Singapore
Ongoing collaborationAnother success for new project task. Thank you for your great skill Super recommended :)
$50
Price
A Seller's Response
Helpful?
Reviews
7 reviews for this Gig
| (7) | ||
| (0) | ||
| (0) | ||
| (0) | ||
| (0) |
Rating Breakdown
- Seller communication level
- Recommend to a friend
- Service as described
Sort By
Most relevant
M matthewainsc409
Thailand
Great delivery and comms.
$50
Price
1 day
Duration
A Seller's Response
Helpful?C colleentreid
United States
Ongoing collaborationgreat job helping and super fast
$50-$100
Price
1 day
Duration
A Seller's Response
Helpful?L lakerfan2020
United States
Amir was easy to work with and created my Excel UDF as specified.
$50
Price
4 days
Duration
A Seller's Response
Helpful?D drugarpe
United States
Ongoing collaborationEasy and fast to communicate with Amir, his files turnaround time is very fast and accurate, and he is very good following directions and request. very easy to work with him.
$50
Price
A Seller's Response
Helpful?U user78223748
Singapore
Ongoing collaborationAnother success for new project task. Thank you for your great skill Super recommended :)
$50
Price
A Seller's Response
Helpful?
