I have 2 years experience in PowerShell scripting and i have worked on a similar use case before. I have developed scripts for complex use cases as well.
I have created scripts for excel that can edit, delete,create sheet, create charts, create pivot tables etc in the Excel Sheet.