Basic To Advance Python For Excel Automation Part3

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

Overview

Section 1: Introduction

Lecture 1 How to Change Values

Lecture 2 Basic functions - Sum Count Unique & nlargest ,,Value Count etc

Lecture 3 Group By

Lecture 4 Loops in Group By

Lecture 5 Create a Pivot - Summarization of reports

Lecture 6 Create a new Column in pivot

Lecture 7 Project - Calculate Zone Wise percentage

Lecture 8 Project - Which shop has highest Items Sold

Lecture 9 Your Doubt is solved - Change Values issues explained and resolved

Lecture 10 Export to Excel

Lecture 11 Create and Open an Excel application

Lecture 12 Append Data into Excel

Lecture 13 Append with more parameters explained

Lecture 14 Excel Sheet Commands

Lecture 15 Project - Compile Data from sheets

Lecture 16 Files and Folders data handling

Lecture 17 Data Compilation into different sheets

Data Analysts who want to automate excel work using python language