Description
Automating Excel with Python course. Excel automation course with Python. In Automating Excel with Python: Processing Spreadsheets with OpenPyXL, you’ll learn how to use Python to create, edit, or read Microsoft Excel documents using OpenPyXL. This course is based on the book Automating Excel with Python by Michael Driscoll. Python is a versatile programming language. You can use Python to read, write and edit Microsoft Excel documents. You can use several different Python packages, but this course focuses on OpenPyXL. The OpenPyXL package allows you to work with Microsoft Excel files on Windows, Mac, and Linux, even if Excel is not installed. In this course, you will learn about the following:
- Open and save workbooks
- Reading cells and sheets
- Spreadsheet creation (add/remove rows and sheets, merge cells, fold, fixed windows)
- cell styling (font, alignment, side, border, images)
- Conditional formatting
- the chart
- Comments
- and more!
After completing this course, you will be proficient in using the Python programming language to automate Microsoft Excel. This will make you more productive and valuable in your work. You can use the knowledge from this course to speed up your workday! Python is a great language that you can use to improve your daily work, whether you are an experienced developer or a beginner!
What you will learn in Automating Excel with Python course
-
Automating work with Microsoft Excel using Python
-
Convert Excel documents to other formats
-
Format Excel spreadsheets programmatically
-
Create charts in Excel spreadsheets with Python
This course is suitable for people who
- Beginner Python programmers or people who want to automate their office work
Automating Excel with Python course specifications
- Publisher: Udemy
- teacher: Michael Driscoll
- Training level: beginner to advanced
- Training duration: 3 hours and 9 minutes
- Number of courses: 12
Course headings
Prerequisites of Automating Excel with Python course
- Basic Python programming experience
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
Size
1.1 GB
Be the first to comment