Automate Excel Using Python

Learn Excel automation using python programming.

What you'll learn

At the end of the course you will learn how to automate excel using python openpyxl library.

You no need to have any coding experience to start this course. Everything from the basics we have explained.

Just we are required to spend your time and maintain the schedule to prepare.

We will be adding more examples to the course.

Requirements

Computer or Laptop - Windows or Mac. Setup and installation instructions clearly explained along with with python basics.

Excel Application should be installed in your PC.

Description

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-1Course IntroductionSection-2Configuration softwares1. List of softwares required for configurationPython InstallationOpenpyxl : Python Package installationPycharm IDE (IDE for writing the code)ExcelSection-3Python BasicsIntroduction to PythonVariablesData TypesType CastingOperatorsString Data TypeListTupleDictionarySets ConceptsConditional Statements ( if , if else , if elif else etc)While LoopFor LoopDifferent types of functionsLambda ExpressionsPackages and ModulesOOPS - Classes and ObjectsInheritanceSuper keywordData HidingPython DecoratorsSection-4Overview on Workbook and WorksheetCreate Workbook and WorksheetOverview on WorksheetWrite OperationsWrite the data in cellsWrite the data in Multiple cellsRead OperationsRead the data from the Excel file.Read the data row wise.Access excel file in Read only mode.Comments in Excel sheet.Add the comments to the cell.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 stylesPattern StylesMerge and Unmerge the cellsAdd image to excel file.Add FormulasAdd Formulas to the cellCopy Formula to other cellsFilter Operations.ChartsCreate Pie ChartsCreate 3D Pie ChartsChange Title and Colors for Pie Chart.Create Bar ChartCreate 3D Bar ChartManipulating WorksheetDeleting Rows and ColumnsInserting Rows and ColumnsData iteratingIterating Data of Columns and Rows.Find data with the last column and row in the excel sheet.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.

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Configuration softwares for Windows and Mac.

Lecture 2 List of softwares required for configuration

Lecture 3 Windows : Python Installation

Lecture 4 Windows : Openpyxl - Python Package installation

Lecture 5 Windows : Pycharm IDE (IDE for writing the code)

Lecture 6 Mac : Python and Openpyxl installation

Lecture 7 Mac : Pycharm IDE (IDE for writing the code)

Lecture 8 Excel Update

Section 3: Python Basics

Lecture 9 Introduction to Python

Lecture 10 Variables

Lecture 11 Data Types

Lecture 12 Type Casting

Lecture 13 Operators

Lecture 14 String Data Type

Lecture 15 List

Lecture 16 Tuple

Lecture 17 Dictionary

Lecture 18 Sets Concepts

Lecture 19 Conditional Statements ( if , if else , if elif else etc)

Lecture 20 While Loop

Lecture 21 For Loop

Lecture 22 Different types of Functions

Lecture 23 Lambda Expressions

Lecture 24 Packages and Modules

Lecture 25 OOPS - Classes and Objects

Lecture 26 Inheritance

Lecture 27 Super keyword

Lecture 28 Data Hiding

Lecture 29 Python Decorators

Section 4: Overview on Workbook and Worksheet

Lecture 30 Create Workbook and Worksheet

Lecture 31 Overview on Worksheet

Section 5: Write Operations

Lecture 32 Write the data in cells

Lecture 33 Write the data in Multiple cells

Section 6: Read Operations

Lecture 34 Read the data from the Excel file.

Lecture 35 Read the data row wise.

Lecture 36 Access excel file in Read only mode.

Section 7: Comments in Excel sheet.

Lecture 37 Add the comments to the cell.

Section 8: Add Styles to Excel sheet data.

Lecture 38 Part 1: Styles to the text data in Excel sheet : Bold , Italic ,Underline, etc

Lecture 39 Part 2 : Named Styles.

Lecture 40 Border styles

Lecture 41 Pattern Styles

Lecture 42 Merge and Unmerge the cells

Section 9: Add image to excel file.

Lecture 43 Add image to excel file.

Section 10: Add Formulas

Lecture 44 Add Formulas to the cell

Section 11: Filter Operations.

Lecture 45 Filter Operations.

Section 12: Charts

Lecture 46 Create Pie Charts

Lecture 47 Create 3D Pie Charts

Lecture 48 Change Title and Colors for Pie Chart.

Lecture 49 Create Bar Chart

Lecture 50 Bar Chart Properties

Section 13: Manipulating Worksheet

Lecture 51 Deleting Rows and Columns

Lecture 52 Inserting Rows and Columns

Section 14: Data iterating

Lecture 53 Iterating Data of Columns and Rows.

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

Section 15: Read and Write Operations from different files.

Lecture 55 Copy Data from one sheet to another sheet.

Lecture 56 Read and write data from text file to excel sheet.

Lecture 57 Read data from multiple sheets to a single worksheet.

People who willing to Automate Excels using python