Python for Excel Training Course

Saigon Tower, 29 Lê Duẩn, Bến Nghé, District 1, Ho Chi Minh City, Vietnam

Description

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 (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.

Course Details :

Course Code : pythonexcel
Duration: 14 hours (usually 2 days including breaks)
Workday courses take place between 09:30 and 16:30
Requirements
– Python programming experience
– Basic experience or familiarity with Excel
Audience
– Developers
– Programmers
Fees : 203240236 VND(Price per participant)
Venue : Ho Chi Minh City, Saigon Tower, Vietnam

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

REGISTER FOR THE COURSE

Add A Review


Please enter input field

sanu
NobleProg Limited
Training Service

Book your course now

Enquiry

Your enquiry submitted successfully

Enquiry Submission failed

Please enter input field(s)

Claim this course

To manage this course details kindly claim this course.