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
Testimonials (4)
Knowledge, substantive content, contact with others, willingness to help even with trivial problems, ability to interest listeners.
Michał
Course - Python for Excel
Machine Translated
What I liked most was that the training was tailored to our needs and level of knowledge, the trainer shared her experiences and solutions. Discussing common errors and what to pay attention to when analyzing errors will certainly be very useful. The training was not very official and rigid, you could joke a little and thanks to that the atmosphere was relaxed and open - there was no fear of asking questions. I would definitely recommend this training to others.
Wioletta Dańków
Course - Python for Excel
Machine Translated
Learning new things, the trainer's vast knowledge. Contact and the ability to explain complex issues.
Aleksander
Course - Python for Excel
Machine Translated
Practical applications and adaptation of training to individual needs. Answering questions.
Mateusz
Course - Python for Excel
Machine Translated