✅ Automate Excel Using Python
Published 11/2023
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.11 GB | Duration: 4h 24m
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
------------------------------------*****------------------------------------
[color=#ff9900]✅ Automate Excel Using Python[/color] (2.17 GB)
NitroFlare Link(s)
https://nitroflare.com/view/B2E32CD27E783B9/Automate.Excel.Using.Python.part1.rar https://nitroflare.com/view/C915215F6807A2B/Automate.Excel.Using.Python.part2.rar https://nitroflare.com/view/A3C72894C5ACF78/Automate.Excel.Using.Python.part3.rar
RapidGator Link(s)
https://rapidgator.net/file/93fe083404d28d9ba7c4ed5649ece176/Automate.Excel.Using.Python.part1.rar https://rapidgator.net/file/a783f6ed0dcc9a6f63006d4c24533ca3/Automate.Excel.Using.Python.part2.rar https://rapidgator.net/file/2fa1c8108b5553415bf34d7c4aaca27a/Automate.Excel.Using.Python.part3.rar
