I will automate excel data consolidation with power query and sharepoint

Are you manually combining multiple Excel files every week? I can automate it for you.

I will build a professional Excel data consolidation system using Power Query, Excel and SharePoint, allowing multiple workbooks to feed into one centralized reporting system.

What I can build:

Combine multiple Excel workbooks

Power Query data consolidation

SharePoint Folder connections

Centralized management dashboards

Staff/team reporting systems

Automated KPI reporting

Multi-file data integration

Data cleaning and transformation

Duplicate/error handling

Automated refresh workflows

PivotTables & PivotCharts

Management reporting systems

Example workflow:

Staff Workbook 1 + Staff Workbook 2 + Staff Workbook 3

SharePoint

Power Query

Master Excel Workbook

Management Dashboard

Your manager can simply use Refresh All to update reports instead of manually copying and pasting data.

I can also structure your system so new staff members and additional workbooks can be added easily without rebuilding the entire solution.

Ideal for: Small businesses, HR, operations, care/support organizations, project managers, sales teams, and administrators.

Please message me before ordering with your workbook.