Expert Excel Developer | Advanced Formulas, VBA, Power Query & Data Automation

Project Overview We're looking for an experienced Excel automation expert to build and improve complex Excel workbooks used for inventory, sales, distributor, rebate, pricing, and RMA 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. This project may become a long-term engagement. Responsibilities Build advanced Excel workbooks from scratch. Create complex formulas (XLOOKUP, INDEX/MATCH, SUMIFS, LET, LAMBDA, FILTER, UNIQUE, dynamic arrays, etc.). Develop VBA macros and Excel automation. Build Power Query workflows to clean and consolidate data from multiple files. Import and transform CSV, Excel, and other data sources. Design dashboards with Pivot Tables, Pivot Charts, and KPIs. Optimize large workbooks for speed and performance. Troubleshoot existing spreadsheets and improve efficiency. Document solutions so they are easy to maintain. Required Skills Expert-level Microsoft Excel Advanced formulas VBA / Macros Power Query Pivot Tables Dashboard creation Data validation Conditional formatting Large dataset management Strong analytical and problem-solving skills Nice to Have Python (Pandas/OpenPyXL) Power BI SQL Experience working with inventory or ERP systems Experience with eCommerce data (Amazon, Shopify, distributors) Knowledge of RMA, inventory, pricing, or rebate reporting What You'll Be Working With Examples of projects include: Inventory reconciliation Pricing reports Distributor reports Sales analysis RMA tracking Rebate calculations Profitability reports Automated monthly reporting Dashboard development To Apply Please include: Examples of complex Excel files you've built. Screenshots or videos of dashboards you've created. Examples of VBA or automation projects. Experience with Power Query or Python. Your hourly rate. Your availability. Project Type Initial project with the opportunity for ongoing work. We regularly build new Excel tools and automate reporting processes, so we're looking for someone interested in a long-term relationship. Preferred Freelancer 5+ years of advanced Excel experience Excellent English communication Responsive and detail-oriented Able to recommend better ways to automate workflows rather than simply following instructions This version will attract true Excel developers and automation specialists rather than general data analysts, increasing your chances of finding someone who can build sophisticated Excel systems and automate repetitive business processes.