I will automate excel with vba macros and python scripts

China

I speak Chinese, English

Senior QA Engineer Python Test Automation Data Analysis

I'm a QA Engineer with expertise in Python test automation, data analysis, and office automation. I build robust test frameworks (Selenium, PyTest) to ensure bug-free releases, and use Pandas/NumPy to...
About this Gig

Tired of manually repeating the same Excel tasks every day?

Ill help you automate them with clean VBA macros and Python scripts that actually work.

As a QA Engineer with years of experience in software testing and automation, I bring a unique approach to spreadsheets: I dont just write code that works once I write code that works reliably, handles edge cases, and wont break when your data changes.

What I can automate for you:

  • Generate invoices, quotes, and reports with one click
  • Clean and format messy data automatically
  • Merge data from multiple files (Excel, CSV, TXT)
  • Remove duplicates and validate entries
  • Send automated emails from Excel
  • Create custom user forms for data entry
  • Build interactive dashboards with pivot tables and charts
  • Convert Excel to PDF/CSV automatically

Why work with me:

  • Clean, well-documented code
  • Edge-case tested I think like a tester
  • Easy-to-follow instructions included
  • Fast delivery and clear communication
  • Free consultation before ordering

Message me before placing an order so we can confirm your requirements and Ill provide a custom timeline.

Platform:

Excel

Google Sheets

VBA

Development technology:

Google Apps Script

Python

Excel

Expertise:

Formatting

Forms

Formulas

Cleaning

Data validation

Other Data Processing Services I Offer