Specialist Needed for Excel Dashboard & Automation

via Freelancer ·

Budget / Salary$250–750
TypeFreelance project
LocationRemote
Posted2 hours ago
Excel Automation, Dashboard & Reporting Specialist

We are looking for an experienced Microsoft Excel expert to develop an automated reporting workbook that converts raw business data into clear dashboards and recurring reports. The project will involve data cleaning, Power Query, advanced formulas, PivotTables, KPI calculations, dashboard development, and automation.

The scope includes importing and cleaning raw data, building automated calculations, creating KPIs, developing an interactive dashboard with charts and slicers, setting up automated summary reports, and structuring the workbook so new monthly data can be added and refreshed easily. VBA/macros can be used where required to automate repetitive processes and reporting tasks.

Deliverables: A fully cleaned and structured Excel workbook, automated data-processing system, interactive management dashboard, KPI and reporting sheets, PivotTables and charts, Power Query refresh setup, VBA/macros where applicable, and brief instructions for updating the workbook.

The ideal candidate should have strong experience with Excel, Power Query, PivotTables, advanced formulas, dashboards, VBA/macros, and automated reporting. Please provide examples of similar Excel automation, dashboard, or reporting projects you have completed.
visual basic data processing excel visual basic for apps charts data visualization
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.