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
Basic Excel for Government
- Navigation within spreadsheets
- Data manipulation and organization
- Utilizing formulas and cell references
- Creating and customizing charts
Advanced Excel for Government
- Logical functions for decision-making
- Scenario analysis for informed planning
- Solver for optimization problems
- Macros to automate repetitive tasks
- Introduction to coding with VBA
VBA for Government
- Understanding data types in VBA
- Writing custom functions
- Controlling program flow with conditional statements and loops
- Techniques for debugging VBA code
Data Analytics with Python for Government
- Overview of Python programming
- Working with variables and data types
- Data manipulation using the Pandas library
- Creating reusable functions
- Data visualization with Matplotlib and Seaborn
- Advanced data wrangling techniques in Pandas
Introduction to Machine Learning with Python for Government
- Implementing linear regression using scikit-learn
- Building classification and regression trees
- Applying Support Vector Machines and Random Forests for classification
- Utilizing clustering techniques with scikit-learn
Requirements
No specific prerequisites are required to participate in this course for government.
42 Hours
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
