I will create an excel macro with vba to automate your repetitive tasks
Excel VBA Automation Specialist
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

