Automate Excel Using Python

Learn Excel automation using python programming.

In this course you're going to learn how to automate excel using python.

Coding snippets we have uploaded at the respective video lecture itself.

Below are the topics we are going to cover in this course.

Section-1

1. Course Introduction

Section-2

Configuration softwares

1. List of softwares required for configuration

2. Python Installation

3. Openpyxl : Python Package installation

4. Pycharm IDE (IDE for writing the code)

5. Excel

Section-3

Python Basics

1. Introduction to Python

2. Variables

3. Data Types

4. Type Casting

5. Operators

6. String Data Type

7. List

8. Tuple

9. Dictionary

10. Sets Concepts

11. Conditional Statements ( if , if else , if elif else etc)

12. While Loop

13. For Loop

14. Different types of functions

15. Lambda Expressions

16. Packages and Modules

17. OOPS - Classes and Objects

18. Inheritance

19. Super keyword

20. Data Hiding

21. Python Decorators

Section-4

1. Overview on Workbook and Worksheet

• Create Workbook and Worksheet

• Overview on Worksheet

2. Write Operations

• Write the data in cells

• Write the data in Multiple cells

3. Read Operations

• Read the data from the Excel file.

• Read the data row wise.

• Access excel file in Read only mode.

4. Comments in Excel sheet.

• Add the comments to the cell.

5. Add Styles to Excel sheet data.

• Part 1: Styles to the text data in Excel sheet : Bold , Italic , Underline , strike the text, Font color , Font size etc.

• Part 2 : Named Styles.

• Border styles

• Pattern Styles

• Merge and Unmerge the cells

6. Add image to excel file.

7. Add Formulas

• Add Formulas to the cell

• Copy Formula to other cells

8. Filter Operations.

9. Charts

• Create Pie Charts

• Create 3D Pie Charts

• Change Title and Colors for Pie Chart.

• Create Bar Chart

• Create 3D Bar Chart

10. Manipulating Worksheet

• Deleting Rows and Columns

• Inserting Rows and Columns

11. Data iterating

• Iterating Data of Columns and Rows.

• Find data with the last column and row in the excel sheet.

12. Read and Write Operations from different files.

• Copy Data from one sheet to another sheet.

• Read and write data from text file to excel sheet.

• Read data from multiple sheets to a single worksheet.