Python for Excel Training Course

Course Code

pythonexcel

Duration

14 hours (usually 2 days including breaks)

Requirements

  • Python programming experience
  • Basic experience or familiarity with Excel

Overview

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

Audience

  • Developers
  • Programmers

Format of the course

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

Note

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

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

Testimonials

★★★★★
★★★★★

Course Discounts

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in Canada!

As a Business Development Manager you will:

  • expand business in Canada
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!