Excel ETL Workbook by Leon RiceExcel ETL Workbook by Leon Rice

Excel ETL Workbook

Leon Rice

Leon Rice

Coded excel to open another file within the workbook. Used Power Query to ETL data, and coded the workbook to then export the completed file. The client exports data from their QuickBooks and it needs to be formatted to upload to Sage Inventory.
Like this project

Posted Oct 14, 2024

I used coding and Power Query to ETL and format data from Quickbooks to match Sage Inventory uploads.