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
Foundations of Excel
- Interface navigation
- Data manipulation techniques
- Utilizing formulas and cell references
- Chart creation
Advanced Excel Features
- Logical functions
- Scenario analysis
- Solver tool application
- Macro implementation
- Introduction to coding via VBA
VBA Programming
- Data type management
- Function development
- Program control through conditional logic and loops
- Debugging strategies
Data Analytics using Python
- Introduction to Python
- Variables and data types
- Data manipulation using Pandas
- Function writing
- Data visualization with Matplotlib and Seaborn
- Data wrangling with Pandas
Getting Started with Machine Learning in Python
- Linear Regression via scikit-learn
- Classification and regression trees using Python
- Classification with Support Vector Machines and Random Forests
- Clustering methods using scikit-learn
Requirements
No specific prerequisites are required to participate in this course.
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)
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.
