Excel Automation Using Python (Transition from excel to python and enhance your productivity)

preview_player
Показать описание
Use below link to enroll in my course

Are you someone whose day job requires a lot of manual handling of buggy macros and working on voluminous excel files?

Are you fed up with the tyranny of vlookups, Sumifs, pivot tables and excel dashboards and looking to upskill?

Are you the type of person who would prefer the convenience of python over the unsightliness of VBA code?

If the answer to any of the above questions is yes then you should consider this course. This course will start from the basics and will help you automate reasonably sophisticated excel based tasks. The course will also provide you with enough preparation to explore more advanced topics pertaining to automation/data analysis.

The course covers following topics

Creating python environment

Importing excel into python

Aggregating data from multiple files

Splitting data into multiple files

Interacting with your OS programmatically

Automating popular excel functions such as vlookup, sumif, countif etc

Replicating excel visualizations

Automating pivot tables
Рекомендации по теме
Комментарии
Автор

Hello @Mayank Rasu, I am planning to enroll this course in udemy
but just know are you using Indian Broker to create this one ?

chandansinha
join shbcf.ru