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
 

Number of participants


Starts

Ends


Dates are subject to availability and take place between 09:30 and 16:30.
Open Training Courses require 5+ participants.

Testimonials (4)

Related Courses

Related Categories