In this video, I will show you some ways through which you can automate your excel workbooks. Python is known to be an excellent programming language for automation. It has many libraries that can help you manipulate data very easily. Two of my favorites are openpyxl and pandas. I will show you how we can effectively use them to retrieve information, merge, search and filter data, and compute operations in excel.

Github repository: https://github.com/DavideMerlin/Excel_Automation

Subscribe : https://www.youtube.com/channel/UCbg0ptFI3yZ4Pe5vmUiEzzA

#python