Ruth E.

I build reliable Excel and Google Sheets systems that replace repetitive work, reduce errors, and make reporting faster.

Top Rated Plus with 100% Job Success, 168 completed jobs, 11K+ Upwork hours, and a 4.9/5 client rating—specializing in Excel VBA, Google Apps Script, Power Query, dashboards, and API integrations.

Microsoft Certified | Former Accenture Software Engineer

I specialize in building complete, user-friendly business systems—not just fixing individual formulas.

WHAT I CAN BUILD

• Excel automation using VBA, macros, advanced formulas, Power Query, Power Pivot, pivot tables, and Office Scripts
• Google Sheets automation using Apps Script, custom menus, triggers, scheduled workflows, and advanced formulas
• KPI dashboards, management reports, financial models, trackers, calculators, and forecasting tools
• API integrations connecting spreadsheets with external business systems
• Google Forms, Sheets, Docs, Gmail, Drive, and automated PDF workflows
• Microsoft 365 automation using Excel, Outlook, Power Automate, SharePoint, and OneDrive
• Data consolidation, cleanup, validation, reconciliation, and high-volume processing

I have worked with datasets containing more than 500,000 rows and developed automation solutions for healthcare, finance, inventory, education, construction, and service-based businesses.

RECENT SOLUTIONS

• Automated invoice creation from Google Sheets through an external API, including validation, status tracking, error logging, and retry handling
• Built an Excel inventory turnover and ABC analysis system with dynamic calculations and management dashboards
• Developed a multi-user scheduling, caseload, and reporting system in Google Sheets
• Created dynamic imports and reports that continue working when columns are added, removed, or rearranged
• Automated recurring reports, email workflows, document generation, and data consolidation

WHAT YOU CAN EXPECT

• Clear project scope, timeline, and recommendations
• Frequent and straightforward communication
• Clean, efficient, and maintainable automation
• Thorough testing, documentation, and handover
• Reliable support after delivery

If your team is spending too much time on manual spreadsheet work—or your current workbook or script is slow, fragile, or difficult to maintain—send me a message. I’ll review your process and recommend the most practical solution.