Excel Data Analyst – Advanced Excel + VBA Expert to Build Automated Digital Dashboard

Project Overview

We are looking for an experienced Data Analyst with strong skills in Advanced Excel and VBA Macros to build a stunning, automated Excel Digital Dashboard.

We currently have multiple Excel workbooks containing data. The freelancer’s job is to:
Understand and interpret the data from all workbooks
Consolidate and transform the data as needed
Create an interactive, visual dashboard in Excel
Automate routine tasks (data refresh, calculations, reports) using VBA macros

Deliverables

1 final Excel file containing:
The Digital Dashboard
All data model / helper sheets
VBA macros for automation

A short user guide (one page) explaining:
How to update data
How to use filters
How to run macros

Required Skills

Strong Advanced Excel (formulas, PivotTables, charts, conditional formatting)
Experience with Power Query / Power Pivot (optional but preferred)
Strong VBA Macro skills (automating tasks, writing clean code)
Solid data analysis and data cleaning experience
Ability to design clean, professional-looking dashboards