I will organize and automate excel data with power query and vba
PhD level Statistical Analyst and Research Data Specialist
Level 1
Has met certain performance criteria and shows strong potential in the marketplace.
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
