Python for Excel Training Course

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.

This course is available as onsite live training in Spain or online live training.

Thank you for sending your enquiry! One of our team members will contact you shortly.

Thank you for sending your booking! One of our team members will contact you shortly.

Course Outline

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

Requirements

Python programming experience
Basic experience or familiarity with Excel

Audience

Developers
Programmers

14 Hours

Custom Corporate Training

Training solutions designed exclusively for businesses.

Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
Flexible Schedule: Dates and times adapted to your team's agenda.
Format: Online (live), In-company (at your offices), or Hybrid.

Investment

Price per private group, online live training, starting from 3200 € + VAT*

(*The final price may vary depending on the technical specialization of the course, the level of customization, the method of delivery and the number of learners)

Need help picking the right course?

Testimonials (4)

Hands-on examples allowed us to get an actual feel for how the program works. Good explanations and integration of theoretical concepts and how they relate to practical applications.

Ian - Archeoworks Inc.

Course - ArcGIS Fundamentals

All the topics which he covered including examples. And also explained how they are helpful in our daily job.

madduri madduri - Boskalis Singapore Pte Ltd

Course - QGIS for Geographic Information System

I really enjoyed the training. I found all modules to be applicable to problems that I am trying to solve at work. The integration of the training with jupyter notebooks was really impressive.

Mark Firmin - Environment and Climate Change Canada

Course - Python for Geographic Information System (GIS)

The thing I liked the most about the training was the organization and the location