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 Applications
- Performing Quality Check for Government Standards
- Best Practices for Spreadsheet Data in the Public Sector
Preparing Your Workspace for Government Operations
Importing Your Excel Files and Loading Your Data Using pandas for Government Purposes
Writing Data, Formatting Information, and Modifying Charts in Excel for Government Use
- Using openpyxl for Government Tasks
- Using xlsxwriter for Government Projects
- Using xlwt for Government Needs
- Using pyexcel for Government Operations
Reading and Formatting Data from Older Excel Files for Government Use
- Using openpyxl for Legacy Data in Government
- Using xlrd for Historical Records in Government
- Using pyexcel for Archived Data in Government
Implementing Final Check of Your Data for Government Compliance
Calling Python Functions from Excel for Government Applications
Create User Defined Functions with Python and Excel for Government Use
Troubleshooting for Government Operations
Summary and Conclusion for Government Users
Requirements
- Proficiency in Python programming
- Fundamental experience or familiarity with Excel
Audience
- Software developers for government
- 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
