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.

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

Delivery Options

Private Group Training

Our identity is rooted in delivering exactly what our clients need.

Pre-course call with your trainer
Customisation of the learning experience to achieve your goals -

Bespoke outlines
Practical hands-on exercises containing data / scenarios recognisable to the learners

Training scheduled on a date of your choice
Delivered online, onsite/classroom or hybrid by experts sharing real world experience

Private Group Prices RRP from £3800 online delivery, based on a group of 2 delegates, £1200 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.

Public Training

Please see our public courses

Need help picking the right course?

Testimonials (5)

Lab exercise

Tse Kiat - ST Engineering Training & Simulation Systems Pte. Ltd.

Course - Automated Monitoring with Zabbix

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 liked Pablo's style, the fact that he covered a lot of subjects from report design , customization with html to implementing simple ML algortithms. Good balance theoretical information / exercices. Pablo really covered all topics i was interested in and gave comprehensive answers to my questions.

Cristian Tudose - SC Automobile Dacia SA

Course - Advanced Data Analysis with TIBCO Spotfire

Actual application of spotfire and all basic functions.

Michael Capili - STMicroelectronics, Inc.

Course - Introduction to Spotfire

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