Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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
Testimonials (1)
Knowledge, substantive content, contact with others, willingness to help even with trivial problems, ability to interest listeners.
Michał
Course - Python for Excel
Machine Translated