Description
Automate Excel Using Python course. In this course you will learn how to automate Excel using Python. The coding snippets we have uploaded in the respective video lecture itself. Below are the topics we cover in this course.
Section 1
- Course introduction
Section-2
Configuration software
1. List of software required for configuration
- Install Python
- Openpyxl: Python package installation
- Pycharm IDE (IDE for writing code)
- have superiority
Section-3
Python basics
- Introduction to Python
- Variables
- Types of data
- Type Casting
- Operators
- String data type
- List it
- a few
- Dictionary
- Collection of concepts
- Conditional statements (if, else, if elif else, etc.)
- While the loop
- for the ring
- Different types of functions
- Lambda expressions
- Packages and modules
- OOPS – Classes and Objects
- Inheritance
- Awesome keyword
- Hiding data
- Python decorators
Section-4
- An overview of the workbook and worksheet
- Create workbooks and worksheets
- Overview in the worksheet
- Write the operation
- Write the data in the cells
- Enter data into multiple cells
- Read the operation
- Read the data from the Excel file.
- Read the data row wisely.
- Access the Excel file in read-only mode.
- Comments in Excel sheet.
- Add comments to the cell.
- Add style to Excel sheet data.
- Part 1: Text Data Styles in Excel Sheet: Bold, Italic, Underline, Text Strike, Font Color, Font Size, etc.
- Part 2: Named styles.
- Fringe styles
- Template styles
- Merge and unmerge cells
- Add image to Excel file
- Add formulas
- Add the formulas to the cell
- Copy the formula to other cells
- And…
What you will learn in the Automate Excel Using Python course
-
At the end of the course you will learn how to automate Excel using Python’s openpyxl library.
-
You do not need to have any coding experience to start this course. Everything from the principles we explained.
-
Only we are required to spend your time and keep schedule for preparation.
-
We will add more examples to the course.
This course is suitable for people who
- People who want to automate Excel using Python
Automate Excel Using Python course specifications
- Publisher: Udemy
- teacher: Sujith Reddy
- Training level: beginner to advanced
- Training duration: 4 hours and 23 minutes
- Number of courses: 57
Headlines of Automate Excel Using Python course
Automate Excel Using Python course prerequisites
- Computer or Laptop – Windows or Mac. Setup and installation instructions clearly explained along with python basics.
- Excel Application should be installed in your PC.
Course images
Sample video of the course
Installation guide
After Extract, view with your favorite Player.
Subtitle: None
Quality: 720p
download link
File(s) password: www.downloadly.ir
Volume
1.91 GB
Be the first to comment