Excel Automation Using Python (Transition from excel to python and enhance your productivity)
Use below link to enroll in my course
https://www.udemy.com/course/excel-au...
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
On this page of the site you can watch the video online Excel Automation Using Python (Transition from excel to python and enhance your productivity) with a duration of hours minute second in good quality, which was uploaded by the user Rasuquant 12 December 2020, share the link with friends and acquaintances, this video has already been watched 1,328 times on youtube and it was liked by 17 viewers. Enjoy your viewing!
