• views: 84
• date: 28 November 2023
• posted by: voska89

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.
Who this course is for
People who willing to Automate Excels using python
Homepage

https://www.udemy.com/course/automate-excel-using-python/

   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.