Basic to Advance Python for Excel Automation Part3
Published 5/2023
Created by ajay parmar
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 17 Lectures ( 6h 13m ) | Size: 2.71 GB

Excel Automation using Python

What you'll learn
You shall be able to implement Lists, Tuples, Loops that you had learnt in previous series over here on real data
You shall be able to automate all Excel related Tasks
We will learn how to modify, delete, append the data from excel sheets and workboooks
Any easy or complex job in excel like VLOOKUP, Searching data in 1000s files , working with folders - all practical knowledge is coming your way

Requirements
If you have seen Part1 and Part2 as well then this is good to go.

Description
Learn how to work with existing Excel files and manage your day to day task fast and easilyHow to create new excel files using python code and how to save the workbooks.How to refer to sheets and ranges in excel across spreadsheetsHow to change the data Your doubts on filter with criterias also answered - What you need to know How to create Pivots How to add columns in Pivots and calculate the percentages- PowerfulHow to edit the data or tables which has a data in spreadsheetsHow to work with folders and files which can have hundreds of file and each of the file may have too many spreadsheetsHow to loop through excel or text files only and read the data inside them.How to apply Vlookup across 1000s files. Lookup the information is no more a tedious and slow process. Vlookup in python -different approachesHow to use Loops in Spreadsheets and copy and paste the dataData accumulation across excel workbooksHow to add sheetsHow to remove the sheets from spreadsheetHow to move sheets from one index to anotherLet us know the Glob module - why it is required and how we can take the knowledge to next levelKnow the os library too and how it is useful in excel data management work

Who this course is for
Data Analysts who want to automate excel work using python language

 https://www.udemy.com/course/basic-to-advance-python-for-excel-automation-part3/