MS Excel with Python: Beginner to Advanced Operations

Become a Pythonista and Excel Wizard after completing this course

A well tailored course for beginners and intermediate Python and Excel users to integrate Python and Excel.This video course explores how Microsoft Excel spreadsheets can be created, opened, and modified programmatically from within Python. Learners will review the Microsoft Excel object model, the attributes of the worksheet cell object which can be leveraged to create and modify workbooks programmatically. First, you will review VBA (Visual Basic for Applications) technology, before exploring how Python and its ecosystem of libraries are fast emerging as a popular choice for easy spreadsheet automation. Then you will learn how to use openpyxl (open pixel library) to manipulate Excel’s object model programmatically from within Python. Continue by learning how to write spreadsheets by using openpyxl, and examining how existing Excel workbooks can be opened, as well as how new spreadsheet files can be created, and written out to disk. Finally, you will learn how Python iterators and indexing can be used to access and manipulate individual cells, ranges consisting of many cells, as well as entire rows and columns. Upon completion of the course, you will be able to open spreadsheet work much more efficiently by incorporating Python together with Excel. Enjoy your lesson and become a Pythonista and Excel Wizard.

What you’ll learn

  • Create a Microsoft Excel workbook by choosing from a list of templates.
  • Create a Microsoft Excel workbook using the openpyxl library.
  • Access individual cells programmatically using openpyxl.
  • Use lists and other Python containers to read to and write from Excel files.

Course Content

  • Introduction –> 1 lecture • 1min.
  • Getting Started with Excel from Python –> 12 lectures • 1hr 12min.
  • Performing Advanced Operations –> 17 lectures • 1hr 26min.

MS Excel with Python: Beginner to Advanced Operations

Requirements

  • No programming experience needed. You will learn along the way.

A well tailored course for beginners and intermediate Python and Excel users to integrate Python and Excel.This video course explores how Microsoft Excel spreadsheets can be created, opened, and modified programmatically from within Python. Learners will review the Microsoft Excel object model, the attributes of the worksheet cell object which can be leveraged to create and modify workbooks programmatically. First, you will review VBA (Visual Basic for Applications) technology, before exploring how Python and its ecosystem of libraries are fast emerging as a popular choice for easy spreadsheet automation. Then you will learn how to use openpyxl (open pixel library) to manipulate Excel’s object model programmatically from within Python. Continue by learning how to write spreadsheets by using openpyxl, and examining how existing Excel workbooks can be opened, as well as how new spreadsheet files can be created, and written out to disk. Finally, you will learn how Python iterators and indexing can be used to access and manipulate individual cells, ranges consisting of many cells, as well as entire rows and columns. Upon completion of the course, you will be able to open spreadsheet work much more efficiently by incorporating Python together with Excel. Enjoy your lesson and become a Pythonista and Excel Wizard.

Get Tutorial