Description
Automating Excel with Python course. Excel Automation Course with Python. In Automating Excel with Python: Processing Spreadsheets with OpenPyXL, you will 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. Python allows you 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 you don’t have Excel installed. In this course, you will learn:
- Open and save workbooks
- Reading cells and leaves
- Table creation (add/remove rows and sheets, merge cells, fold, fixed windows)
- Cell style (font, alignment, page, borders, images)
- conditional formatting
- the graphic
- Comments
- and more!
After completing this course, you will be able to use the Python programming language to automate Microsoft Excel, making you more productive and valuable in your work. You can use the knowledge from this course to speed up your everyday work! Python is a great language that can help you improve your daily work, whether you are an experienced developer or a beginner!
What you will learn in the course “Automating Excel with Python”
-
Automate your work with Microsoft Excel using Python
-
Convert Excel documents to other formats
-
Format Excel tables programmatically
-
Create charts in Excel tables with Python
This course is suitable for people who
- Beginners in Python programming or people who want to automate their office work
Automating Excel with Python Course Specifications
- Editor: Udemy
- Teacher: Michael Driscoll
- Training level: beginner to advanced
- Training duration: 3 hours and 9 minutes
- Number of courses: 12
Course headings
Course “Prerequisites for Automating Excel with Python”.
- Basic Python programming experience
Course pictures
Sample video of the course
installation Guide
After extracting, you can watch it with your favorite player.
Subtitles: None
Quality: 720p
Download link
free download software
Size
1.1GB