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 through worksheets and workbooks
- Manipulating data for accurate reporting and analysis
- Working with formulas and cell references for efficient calculations
- Creating charts to visualize data trends and insights
Advanced Excel for Government
- Utilizing logical functions for complex decision-making processes
- Conducting scenario analysis to support strategic planning
- Using Solver to optimize resource allocation and budgeting
- Automating tasks with macros to enhance productivity
- Introduction to VBA for customizing Excel applications
VBA for Government
- Understanding data types and their applications in government datasets
- Writing functions to automate repetitive tasks and improve efficiency
- Controlling program flow using conditional statements and loops
- Employing debugging techniques to ensure code reliability and accuracy
Data Analytics with Python for Government
- Introduction to Python programming for government applications
- Managing variables and data types in Python
- Data manipulation using the Pandas library for comprehensive analysis
- Writing functions to streamline data processing tasks
- Creating visualizations with Matplotlib and Seaborn for clear data presentation
- Advanced data wrangling techniques with Pandas for enhanced insights
Introduction to Machine Learning with Python for Government
- Implementing linear regression models using scikit-learn for predictive analytics
- Applying classification and regression trees to categorize government data
- Utilizing Support Vector Machines and Random Forests for robust classification tasks
- Employing clustering techniques with scikit-learn to identify patterns in large datasets
Requirements
There are no specific prerequisites required for attendance in this course for government participants.
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
