Advanced Excel
-
Automated Multi-File Excel Reporting with Python
An in-progress Python script that merges and appends data from multiple Excel files into one dataset and generates the report automatically, cutting preparation from 12–16 hours to around 2.
-
Automated Dataset Generation Using Power Query
Automated dataset generation using Power Query to consolidate and transform data from multiple files into a dashboard-ready dataset.