I will automate your excel tasks with python and vba macros
Data Scientist specializing in Python ML and Power BI
About this Gig
Welcome! I'm a Data Scientist who specializes in turning boring, repetitive Excel work into clean, automated workflows. Save hours every week with custom-built solutions.
WHAT YOU GET:
- Custom Excel automation (VBA macros or Python scripts)
- Auto-generated reports and summaries
- Data cleaning, deduplication, and validation
- Multi-sheet and multi-file processing
- Formulas, pivot tables, and dashboards
- Documented source code you can reuse
WHAT I CAN AUTOMATE:
- Data consolidation from multiple files
- Monthly or daily reporting tasks
- Email or PDF generation from Excel
- API data pulls into Excel
- Database integration (SQL, BigQuery)
- Scheduled scripts that run on their own
TOOLS:
- Python (openpyxl, pandas, xlsxwriter)
- VBA and Excel macros
- Power Query and pivot tables
- Google Sheets automation
- Selenium for web data into Excel
WHY CHOOSE ME:
- 960-hour Data Science bootcamp + engineering background
- Real automation projects delivered on time
- Clear communication and clean code
BEFORE ORDERING:
Please message me with your current Excel file and a description of the task. I will confirm scope and timeline.
Let's save you hours!
Technology:
BigQuery
•
Excel
•
Google Sheets
•
Python
•
SQL
My Portfolio
FAQ
What kind of Excel tasks can you automate?
Data consolidation, reporting, cleaning, formula calculations, dashboard updates, API/database pulls, email sending, and PDF generation. If you have a repetitive task, I can likely automate it.
Do you use VBA or Python?
Both. VBA for tasks that stay inside Excel, Python for heavy data processing, API calls, or scheduled scripts. I pick the best tool for your case.
Will I get the source code?
Yes, you receive the full VBA macro or Python script with comments so you can rerun and edit it anytime.
Can the automation run on a schedule?
Yes, in the Premium package. I can set up Python scripts to run daily, weekly, or on triggers using Windows Task Scheduler or cron.

