Python for Excel

• Python programming experience
• Basic experience or familiarity with Excel

Audience

• Developers
• Programmers

Python is a high-level programming language famous for its clear syntax and code readability. Excel is a spreadsheet application developed by Microsoft which is widely used in many industries. Adding Python to Excel makes it a powerful tool for data analytics.

In this instructor-led, live training (onsite or remote), participants will learn how to combine the capabilities of Python and Excel.

By the end of this training, participants will be able to:

• Install and configure packages for integrating Python and Excel.
• Read, write, and manipulate Excel files using Python.
• Call Python functions from Excel.

Format of the course

• Part lecture, part discussion, exercises and heavy hands-on practice

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Introduction

Overview of Python Packages for Excel

• pandas
• openpyxl
• xlsxwriter
• xlrd
• xlwt
• xlutils
• pyexcel

Installing the Python Packages for Excel

Preparing Your Spreadsheet and Data

• Performing Quality Check
• Best Practices for Spreadsheet Data

Preparing Your Workspace

Importing Your Excel Files and Loading Your Data Using pandas

Writing Data, Formatting Information, and Modifying Charts in Excel

• Using openpyxl
• Using xlsxwriter
• Using xlwt
• Using pyexcel

Reading and Formatting Data from Older Excel Files

• Using openpyxl
• Using xlrd
• Using pyexcel

Implementing Final Check of Your Data

Calling Python Functions from Excel

Create User Defined Functions with Python and Excel

Troubleshooting

Summary and Conclusion