I’ve built custom VBA and PowerShell tools to automate repetitive finance and investment banking workflows. Some examples include:
- Excel file merger
- Word to PDF converter
- .xls to .xlsx converter
- .csv to .xlsx converter
- PowerShell script to create folders and subfolders from a list of names
- Script to clean and standardize client file names for data rooms
- PowerShell script to clean Excel files across a folder and its subfolders, including cycling through worksheets, setting the active cell to A1, and standardizing zoom to 100%
- Miscellaneous formatting scripts for ad hoc investment banking requests
Most of these tools were built to solve specific workflow problems I encountered in finance and reduce repetitive manual work.
If you’re interested in a custom solution, feel free to email me.