Course Outline
Introduction
Overview of Python Packages for Excel for Government Use
- pandas
- openpyxl
- xlsxwriter
- xlrd
- xlwt
- xlutils
- pyexcel
Installing the Python Packages for Excel for Government Use
Preparing Your Spreadsheet and Data for Government Operations
- Performing Quality Check
- Best Practices for Spreadsheet Data for Government
Preparing Your Workspace for Government Use
Importing Your Excel Files and Loading Your Data Using pandas for Government
Writing Data, Formatting Information, and Modifying Charts in Excel for Government
- Using openpyxl
- Using xlsxwriter
- Using xlwt
- Using pyexcel
Reading and Formatting Data from Older Excel Files for Government Use
- Using openpyxl
- Using xlrd
- Using pyexcel
Implementing Final Check of Your Data for Government Operations
Calling Python Functions from Excel for Government Applications
Create User Defined Functions with Python and Excel for Government Use
Troubleshooting for Government Users
Summary and Conclusion for Government Audiences
Requirements
- Experience in Python programming
- Familiarity or basic experience with Excel
Audience for Government:
- Developers
- Programmers
Testimonials (3)
Hands-on examples allowed us to get an actual feel for how the program works. Good explanations and integration of theoretical concepts and how they relate to practical applications.
Ian - Archeoworks Inc.
Course - ArcGIS Fundamentals
All the topics which he covered including examples. And also explained how they are helpful in our daily job.
madduri madduri - Boskalis Singapore Pte Ltd
Course - QGIS for Geographic Information System
The thing I liked the most about the training was the organization and the location
