I program automation of tedious tasks on Excel using Python.
Using libraries such as:
- XLWINGS
- PANDAS
- NUMPY
- MATPLOTLIB ( for data visualization )
I can automate stuffs such as:
- Repetitive copy paste
- Conditional formatting using code
- Generation of summaries and reports
- Generation of pivot tables
- Creation of new worksheets
- Deletion of existing worksheets
- Merging multiple Excel workbooks
- Data Analysis
- Data visualisation
- Data cleaning
And much more.