Excel Power Query expert

Posted 2 days ago

Worldwide

Summary

Expert Excel Developer for Power Query & Data Automation Project Overview: We are looking for an experienced Excel automation expert to build Excel worksheets from scratch and improve Excel workbooks used for inventory, sales, distributor, rebate, pricing, and financial reporting. This is not a basic data entry or reporting role. We're looking for someone who can design efficient Excel solutions, automate repetitive tasks, and build reliable reporting systems.   What we need: INVENTORY TABLE containing SKU, Product, Size, Unit Weight, Qty received SALES TABLE containing Date, Order number, SKU, Quantity sold, Customer Price in AUD, cost price in USD, Freight Cost,    Using Pivot Tables or Power Query to calculate: Current stock on hand Most and least popular products  Best-selling size Monthly sales Revenue Profit Slow-moving stock   System with linked tables: Products – every cleat with SKU, size, unit weight, cost, and selling price in AUD. Inventory Movements – stock received, sold, returned, or adjusted. Orders – order number, customer, date, payment status, shipping status, cost in USD Customers – contact details and order history.

  • $300.00

    Fixed-price
  • Expert
    Experience Level
  • Remote Job
  • One-time project
    Project Type

Contract-to-hire opportunity

This lets talent know that this job could become full time.
Learn more
Skills and Expertise
Mandatory skills
Microsoft Excel
Microsoft Excel PowerPivot
Activity on this job
  • Proposals:50+
  • Last viewed by client:yesterday
  • Interviewing:
    1
  • Invites sent:
    2
  • Unanswered invites:
    1
About the client
Member since Jun 2, 2011
  • Australia
    Milton9:35 PM
  • $68K total spent
    47 hires, 11 active
  • 6,771 hours

Explore similar jobs on Upwork

Documentation SpecialistHourly‐ Posted 2 months ago
Administrative Support
IFC Mapping Specialist NeededFixed-price‐ Posted 1 month ago
Data Entry
IFC
Architectural Design

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