MS Excel with Python: Beginner to Advanced Operations
After taking this class, you’ll be able to use Python and Excel like a pro.
What you’ll learn
MS Excel with Python: Beginner to Advanced Operations
- When you want to make a Microsoft Excel workbook, you can choose from a list of templates.
- Use the openpyxl library to make a Microsoft Excel workbook.
- Using openpyxl, you can programmatically access individual cells.
- Python lists and other containers can be used to read and write to and from Excel files, so you can do that.
Requirements
-
There is no need to know how to write code. You will learn as you go.
Description
A well-tailored course for beginners and intermediate Python and Excel users who want to learn how to work with both Python and Excel at once. This video course talks about how to make, open, and change Microsoft Excel spreadsheets from inside Python. Learners will look at the Microsoft Excel object model and the properties of the worksheet cell object that can be used to make and change workbooks programmatically.
First, you’ll learn about VBA (Visual Basic for Applications) technology. Then, you’ll learn about how Python and its many libraries are becoming a popular choice for easy spreadsheet automation. Afterwards, you’ll find out how to use openpyxl (open pixel library), which is a Python library, to manipulate Excel’s object model from inside Python.
When you’re done, you’ll learn about how Python iterators and indexing can help you work with individual cells, whole ranges of cells, and whole rows or columns of cells. By the end of the course, you will be able to open spreadsheets more quickly by putting Python and Excel together. Then, have fun with your class and become a Pythonista and Excel master.
Who this course is for:
- Beginner Python programmers want to learn how to connect Python with Microsoft Excel.
