Ruth E.

Tired of doing a same task repeatedly?? Let me help you in AUTOMATING your tasks with EXCEL! This will help you save a lot TIME!

I am an Electronics Engineer with wide knowledge in EXCEL automation and Data Analysis. I am passionate in creating a story behind large data's and process them based on your business needs. Over the years, I handled over 100,000 raw datas processing at the same time! Let's make your numbers speaks for you and your business. I build reliable Excel and Google Sheets systems that automate repetitive work, reduce errors, and give businesses faster access to the information they need.

I’m a Microsoft-certified professional and former Accenture Software Engineer with:

• Top Rated Plus status
• 100% Job Success Score
• 168 completed Upwork jobs
• 11,000+ Upwork hours
• 4.9/5 client rating

My focus is building complete, user-friendly business systems—not just fixing individual formulas.

WHAT I CAN HELP YOU WITH

• Excel automation using VBA, macros, Power Query, Power Pivot, Office Scripts, pivot tables, and advanced formulas
• 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 to external platforms and 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 processed 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