Excel Automation & Reporting Specialist (Macros, VBA, Power Query) | Ongoing Work

Posted last week

Worldwide

Summary

Job Overview I am looking for an experienced Excel expert to help automate several recurring business reports. The ideal candidate will be highly skilled in Excel automation, VBA macros, Power Query, and report optimization. My goal is to reduce manual effort, improve accuracy, and create scalable reporting solutions. The specific reporting requirements will be discussed after we connect, but this will involve automating multiple reports and potentially building a repeatable framework for future reporting needs. Responsibilities Analyze existing Excel reports and workflows Develop automated reporting solutions using Excel VBA, Macros, Power Query, or other Excel-based automation tools Streamline and optimize data processing Create user-friendly reporting templates Document solutions and provide basic knowledge transfer Support ongoing enhancements as new reporting automation needs arise Required Skills Advanced Microsoft Excel VBA / Macro Development Power Query Data Analysis and Reporting Excel Dashboards Troubleshooting and Optimization Strong communication skills Nice-to-Have Skills Power BI Development Power BI Data Modeling Dashboard Design and Visualization Power Automate SQL experience What I'm Looking For Proven experience automating complex Excel reports Ability to understand business requirements and recommend efficient solutions Strong attention to detail Reliable communication and responsiveness Available for ongoing project work as additional reports are identified

  • More than 30 hrs/week
    Hourly
  • 3-6 months
    Duration
  • Expert
    Experience Level
  • Remote Job
  • Ongoing project
    Project Type
Skills and Expertise
Mandatory skills
Data Analysis
Microsoft Excel
Activity on this job
  • Proposals:50+
  • Interviewing:
    0
  • Invites sent:
    0
  • Unanswered invites:
    0
About the client
Member since Oct 26, 2025
  • USA
    New York8:24 PM
  • $3K total spent
    5 hires, 1 active
  • 220 hours

Explore similar jobs on Upwork

O2C Technical Implementation SpecialistHourly‐ Posted 4 weeks ago
System Configuration
Data Migration
API Integration
CRM Automation
WhatsApp
Zoho CRM
Lead Generation

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo