Browse categories
Explore
Fiverr Pro
English
$
USD
I will automate excel reports with power query, pivot tables and advanced formulas
I'm Khadija, a data analyst with 5+ years of turning messy data into clear decisions. At WeCrunch I built Power BI dashboards, automated Excel and KNIME workflows, and cleaned data from ServiceNow and...
About this Gig
Spending hours every week copying, pasting and fixing the same Excel reports? I'll automate them so they refresh in a click.
I've used Excel daily for 5+ years as a data analyst, building automated workflows for real business data.
What I can do:
- Power Query to combine and clean files automatically
- Advanced formulas (XLOOKUP, INDEX/MATCH, SUMIFS, LET, dynamic arrays)
- PivotTables and PivotCharts
- Automated monthly or weekly reports
- Dashboards inside Excel
- Data validation, dropdowns and conditional formatting
- Fixing broken or slow formulas
You get a clean, documented workbook and short notes on how to refresh and use it.
Please send me your file (or a sample) and a short description of what you do manually today. I'll reply with the best approach and package.
Platform:
Excel
•
Google Sheets
•
Microsoft Office
Development technology:
Power Query
•
Excel
•
VLOOKUP
Expertise:
Fixing
•
Pivot tables
•
Formulas
•
Dashboard
•
Power Query
FAQ
What do you need from me to start?
Your Excel file (or a sample with dummy data) and a short note on what you do manually today and what the final report should show.
Do you use VBA macros?
I mainly use Power Query and formulas because they are easier to maintain and work without enabling macros. Simple macros can be added if your workflow needs them.
Will I be able to update the report myself?
Yes. You just drop in new data and click Refresh All. I include short notes explaining how to refresh and use the workbook.
