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 Malta 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

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 €4560 online delivery, based on a group of 2 delegates, €1440 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 (3)

Doing Exercise

Joe Pang - Lands Department, Hong Kong

Course - QGIS for Geographic Information System

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

I'm looking forward to having a training again with Any, he was really good, I'm just a GIS guy, but Any made everything clear to me, he explained complex processes in layman's terms. Keep it up, thank you.

Python for Excel Training Course

Course Outline