Automate Excel Data Formatting and basic coding also typing skill
Budget: $250 – $750 USD
Open
Posted
I’m working with several Excel workbooks that hold mixed data—text, numbers, the occasional date—and they all need to look the same before I can move on to analysis. I’d like you to combine careful data entry with a bit of smart coding to make that happen.
• Build a small, reusable script or macro—Python with pandas / open, or native Excel VBA, whichever you prefer—that:
– re-orders and renames columns to match my template,
– normalises number, text, and date formats,
Posted
I’m working with several Excel workbooks that hold mixed data—text, numbers, the occasional date—and they all need to look the same before I can move on to analysis. I’d like you to combine careful data entry with a bit of smart coding to make that happen.
• Build a small, reusable script or macro—Python with pandas / open, or native Excel VBA, whichever you prefer—that:
– re-orders and renames columns to match my template,
– normalises number, text, and date formats,
Related categories:
Copywriting
Data Entry
Excel
Ghostwriting
Book Writing
Copy Typing
Content Writing
Typing