I will organize and automate excel data with power query and vba
PhD level Statistical Analyst and Research Data Specialist
About this Gig
Spending hours cleaning, organizing, or repeating the same Excel tasks?
I will automate your Excel workflow and transform messy spreadsheets into clean, structured, and efficient systems using Power Query, VBA, formulas, and advanced Excel tools.
I can help with:
- Data cleaning and transformation
- Power Query automation
- CSV and raw data import
- Combining multiple files or spreadsheets
- Custom VBA macros
- Automated reports and recurring tasks
- Formulas, lookups, and data validation
- Structured tables and dashboards
- Automated data-processing workflows
Statistical analysis once your data is ready
Whether you are a researcher, student, freelancer, or small business, I will build a practical solution tailored to your workflow rather than a generic template.
You receive clean, organized, and maintainable work, with commented formulas or code when applicable.
Have a repetitive Excel task that takes too much time? Send me your spreadsheet or describe your workflow. I'll show you how it can be automated before you order.
Technology:
Excel
•
Google Sheets
•
SPSS
•
RStudio
•
VBA
Expertise:
Statistics
•
Regression testing
•
Time series analysis
Programming language:
Python
•
R
•
SPSS
•
SQL
