Excel Automation Using Python

[LeeAndro]

Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: aac, 44100 Hz
Language: English | VTT | Size: 2.82 GB | Duration: 5h 24m

Python basics (data types, loops, functions etc.

What you'll learn

Excel automation using python

Requirements

)

Description

Excel spreadsheets are ubiquitous and no corporate job is possible without them. Like you, I have been working with them since I started my career. However, I rarely use excel now since I have automated most of my excel based tasks using python which has done wonders to my productivity and I want to help you do the same. I have created this course to help you automate your excel spreadsheets based tasks using python and improve your productivity manifold.

#############################################################################################

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, iserror etc

Automating pivot tables

Automating dashboards

#############################################################################################

Important note - Course prerequisites:

Please note that this course requires basic python proficiency. At the minimum, you should be comfortable with:

basic python data types and format

basic python data structures such as list, dictionary, tuple etc.

how to create python functions

how to implement loops in python

#############################################################################################

Who this course is for:

Heavy users of excel curious about automating their work using python

People who are tired of working with buggy macros and voluminous spreadsheets



DOWNLOAD
uploadgig

https://uploadgig.com/file/download/6d62a964b40B2afa/zjX9wjeY__Excel_Auto.part1.rar
https://uploadgig.com/file/download/fEd25Cd2726D9709/zjX9wjeY__Excel_Auto.part2.rar
https://uploadgig.com/file/download/05c1077bdf45A405/zjX9wjeY__Excel_Auto.part3.rar

rapidgator

https://rapidgator.net/file/5c25c91444434ff5863f65ad0dda6dbe/zjX9wjeY__Excel_Auto.part1.rar.html
https://rapidgator.net/file/76c70e3a8002daaf3c1a6ff8133bdfef/zjX9wjeY__Excel_Auto.part2.rar.html
https://rapidgator.net/file/e20489dd3b4f03b125b6cf618d430249/zjX9wjeY__Excel_Auto.part3.rar.html

nitroflare

http://nitroflare.com/view/B17E0E0A1540A6B/zjX9wjeY__Excel_Auto.part1.rar
http://nitroflare.com/view/8DE7DDC96AB839F/zjX9wjeY__Excel_Auto.part2.rar
http://nitroflare.com/view/28F2B0E4BBEF7FF/zjX9wjeY__Excel_Auto.part3.rar