🧩 Background

Finance needed a solution to consolidate multiple spreadsheets from various folders — manually combining data was time-consuming and risky.

🧠 My Role

I built a master spreadsheet using Power Query that automatically pulls new files from a designated folder and updates pivot tables to reflect current financial metrics.

🛠️ Tools Used

• Excel
• Power Query
• Pivot Tables

🚀 Outcome

• Enabled real-time reporting with minimal manual effort
• Supported financial decision-making with dynamic reporting
• Scaled well across multiple months and departments