Topic

2 entries

All topics

Advanced Excel

  1. 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.

  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.