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
Fundamental Excel Skills
- Navigation and interface mastery
- Data entry and manipulation techniques
- Utilizing formulas and cell references
- Creating and formatting charts
Advanced Excel Capabilities
- Implementation of logical functions
- Conducting scenario analysis
- Using the Solver add-in
- Automating tasks with Macros
- Introduction to VBA programming for government operations
VBA Programming
- Understanding data types
- Developing custom functions
- Program control via conditional statements and loops
- Essential debugging methods
Data Analytics with Python
- Overview of the Python language
- Variables and data typing fundamentals
- Data manipulation using the Pandas library
- Function creation and implementation
- Visualizing data with Matplotlib and Seaborn for government reporting
- Advanced data wrangling techniques with Pandas
Introduction to Machine Learning with Python
- Linear Regression implementation using scikit-learn
- Classification and Regression Trees (CART) in Python
- Classification methods: Support Vector Machines and Random Forests
- Clustering algorithms utilizing scikit-learn
Requirements
No prerequisites are required for individuals seeking to participate in this training program for government personnel.
42 Hours
Testimonials (3)
Learning that the QGIS and a tool that can used by other different professionals such land survey
Bame Duncan Koko - Bentel Technologies (Pty) Ltd
Course - QGIS for Geographic Information System
How to use open satellites data for real applications
Tshering Dorji - Druk Holding and Investments
Course - Advanced Geographic Information Systems (GIS)
Equipped with examples