I will create an excel macro with vba to automate your repetitive tasks

China

I speak English, Chinese

Excel VBA Automation Specialist

I turn messy spreadsheets into clean, automated, decision-ready workbooks. I build Excel VBA macros that kill repetitive tasks, design attractive templates and business reports, and convert PDFs/scans...
About this Gig

Hi, welcome to my GIG!

Wouldn't it be nice if the redundant parts of your Excel work were done automatically? Are you handling larger amounts of data and worried about manual mistakes? Do you spend time every day cleaning and formatting data by hand?

If you answered YES, I can help by creating an Excel macro with VBA.

I'm an Excel specialist with 10+ years of experience across risk advisory (EY) and China's leading credit-rating institution, where I led the end-to-end build of the company's largest data product. I understand both the spreadsheet mechanics and the business logic behind your data.


Macros massively save you time and expand what Excel can do. I can automate:

- Generation of quotes, purchase orders, and invoices

- Removing duplicates across two spreadsheets

- User forms that guide people through your file

- Custom buttons added to the Excel menu

- Finding and deleting corrupt or blank entries

- Importing / exporting data to and from other files

- Creating charts from your data with one click

- Any repetitive, click-heavy process - just tell me

Platform:

Excel

•

VBA

•

PowerPoint

Development technology:

VBA

•

Excel

•

VLOOKUP

Expertise:

Pivot tables

•

Formulas

•

Functions

•

Macros

•

Charts