IIRF Online > Office Productivity > Other Office Productivity > Automation > Excel Automation Using Python
Excel Automation Using Python by Udemy
Transition from excel to python and enhance your productivity
Course Highlights
- Excel automation using python
Skills you will learn!
Curriculum
4 Topics
Excel vs Python
Course Objectives & Prerequisites
Anaconda Distribution Introduction
Creating Virtual Environment (Optional)
5 Topics
What & Why of Numpy and Pandas
Numpy 1d Arrays
Higher Dimensional Arrays
Numpy Operations
Indexing and Slicing
12 Topics
The Power of Pandas (Teaser Video)
Pandas Series
Pandas Dataframe
Importing/Exporting Data from Excel Spreadsheet
Handling Python/Dataframe Data Types
Handling NaN Values
Combining DataFrames (Concatenate Merge & Join)
Data Aggregation/Summarization using Groupby
Numpy Assignment
Numpy Assignment Solution
Pandas Assignment
Pandas Assignment Solution
8 Topics
How Do We Interact With OS?
Python OS Library
File Handling using Python
Python Glob Library and Handling Filenames
Assignment - Organize Your Files Using Python
Assignment Solution - Organizing Files
Assignment - Consolidate Numerous Files from Various Locations
Assignment Solution - Consolidating files
11 Topics
Vlookup - I
Vlookup - II
Pivot Table - I
Pivot Table - II
Pivot Table - III
IF Function - I
IF Function - II
Text Manipulation in Excel
String Manipulation in Python
Assignment - SUMIF(s) and COUNTIF(s)
Assignment Solution - SUMIF(s) and COUNTIF(s)
14 Topics
Excel Visualization
Python Visualization Intro
Pandas Visualization
Matplotlib Object Oriented Interface
Hands on With Matplotlib OO Interface - I
Hands on With Matplotlib OO Interface - II
Hands on With Matplotlib OO Interface - III
Combining Pandas Visualization with OO Capabilities - I
Combining Pandas Visualization with OO Capabilities - II
Visualization Assignment 1
Visualization Assignment 1 Solution - I
Visualization Assignment 1 Solution - II
Visualization Assignment 2
Visualization Assignment 2 Solution
Excel Automation Using Python
Related Automation Courses
Thank You!
Your review has been submitted successfully.