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

★★★★★
★★★★★

Bookings, Prices and Enquiries

Guaranteed to run even with a single delegate!

Private Classroom

From CA$6,484

Private Remote

From CA$3,784

Public Classroom

Location Date Course Price [Remote/Classroom]
SK, Saskatoon2019-03-19 09:30:00CA$3,784 / CA$6,284
Victoria - The Atrium2019-03-19 09:30:00CA$3,784 / CA$5,424
Ottawa – Albert & Metcalfe2019-03-21 09:30:00CA$3,784 / CA$5,604
Vancouver - Pacific Centre2019-03-21 09:30:00CA$3,784 / CA$5,614
Ottawa - 343 Preston2019-03-25 09:30:00CA$3,784 / CA$5,704
Oakville - Winston Park2019-03-25 09:30:00CA$3,784 / CA$5,484
Scarborough – 10 Milner Business Court2019-03-28 09:30:00CA$3,784 / CA$5,584
Winnipeg - 201 Portage Avenue2019-04-02 09:30:00CA$3,784 / CA$5,604
Burnaby - Metrotown2019-04-03 09:30:00CA$3,784 / CA$5,614
Quebec - Sainte Foy2019-04-08 09:30:00CA$3,784 / CA$5,684
Mississauga - Airways2019-04-09 09:30:00CA$3,784 / CA$5,544
Brampton - Brampton County Court2019-04-10 09:30:00CA$3,784 / CA$5,544
Halifax - Purdy's Wharf2019-04-17 09:30:00CA$3,784 / CA$5,674
London - London City Centre2019-04-17 09:30:00CA$3,784 / CA$5,604
Calgary - Sun Life2019-04-22 09:30:00CA$3,784 / CA$5,644
Cannot find a suitable date? Choose Your Course Date >>Too expensive? Suggest your price

Course Discounts

CourseVenueCourse DateCourse Price [Remote / Classroom]
Drupal Responsive DesignOttawa - 343 PrestonThu, Mar 28 2019, 9:30 amCA$2,475 / CA$4,185
JBossEdmonton - First Edmonton PlaceMon, Apr 29 2019, 9:30 amCA$4,257 / CA$6,107
Go for Systems ProgrammingCalgary - Macleod Place IIMon, May 6 2019, 9:30 amCA$10,346 / CA$12,746
Anti-Money Laundering (AML) and Combating Terrorist Financing (CTF)Calgary - Macleod Place IIMon, Jun 24 2019, 9:30 amCA$4,257 / CA$6,117
Blockchain: Hyperledger FabricOttawa – Albert & MetcalfeTue, Jul 16 2019, 9:30 amCA$4,257 / CA$6,077
Introduction to Embedded Linux (Hands-on training)Halifax - Purdy's WharfThu, Sep 5 2019, 9:30 amCA$4,257 / CA$6,147

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!