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 WHAT YOU CAN EXPECT • A clear project scope, timeline, and practical recommendations • Responsive and straightforward communication • Clean, efficient, and maintainable automation • Thorough testing, documentation, and handover • Reliable support after delivery If your team spends too much time on manual spreadsheet work—or your current workbook or script is slow, fragile, or difficult to maintain—send me a message. Tell me what you currently do manually, and I’ll recommend the most practical way to automate it.