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

Private Remote

From CA$4,730 (83)

Public Classroom

Location Date Course Price [Remote/Classroom]
Edmonton - First Edmonton Place2018-12-31 09:30:00CA$4,730 / CA$6,580
Halifax - Purdy's Wharf2019-01-01 09:30:00CA$4,730 / CA$6,620
Calgary - Macleod Place II2019-01-01 09:30:00CA$4,730 / CA$6,590
London - London City Centre2019-01-01 09:30:00CA$4,730 / CA$6,550
Calgary - Sun Life2019-01-03 09:30:00CA$4,730 / CA$6,590
Vancouver - Park Place2019-01-03 09:30:00CA$4,730 / CA$6,560
Montreal - University Street2019-01-08 09:30:00CA$4,730 / CA$6,660
Toronto - West Toronto - Etobicoke2019-01-08 09:30:00CA$4,730 / CA$6,490
Burnaby Centre2019-01-09 09:30:00CA$4,730 / CA$6,500
Toronto - Toronto Street2019-01-10 09:30:00CA$4,730 / CA$6,620
NS, Halifax - Hampton Inn2019-01-14 09:30:00CA$4,730 / CA$6,730
Ottawa – Albert & Metcalfe2019-01-22 09:30:00CA$4,730 / CA$6,550
Ottawa - 343 Preston2019-01-24 09:30:00CA$4,730 / CA$6,650
Victoria - The Atrium2019-01-28 09:30:00CA$4,730 / CA$6,370
Vancouver - Pacific Centre2019-01-30 09:30:00CA$4,730 / CA$6,560
Cannot find a suitable date? Choose Your Course Date >>Too expensive? Suggest your price

Course Discounts

CourseVenueCourse DateCourse Price [Remote / Classroom]
Arduino: Programming a Microcontroller for BeginnersToronto - Toronto StreetTue, Dec 18 2018, 9:30 amCA$4,683 / CA$6,573
Public Speaking 101Oakville - Winston ParkTue, Jan 1 2019, 9:30 amCA$4,730 / CA$6,430
R for Data Analysis and Research Ottawa - 343 PrestonThu, Jan 17 2019, 9:30 amCA$2,450 / CA$4,160
Data Mining with RNS, Halifax - Hampton InnThu, Jan 31 2019, 9:30 amCA$3,870 / CA$5,870
OCEB 2 Certified Expert in BPM - Business Advanced Exam PreparationCalgary - Sun LifeFri, Feb 15 2019, 9:30 amCA$2,025 / CA$3,705
Go for Systems ProgrammingCalgary - Macleod Place IIMon, May 6 2019, 9:30 amCA$10,346 / CA$12,746

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!