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.
Duration 42 hours
Course Outline
Foundations of Excel
- Navigating the interface
- Managing and manipulating data
- Utilizing formulas and cell references
- Creating charts
Advanced Excel Techniques
- Logical functions
- Scenario analysis
- Using Solver
- Automating tasks with Macros
- Introduction to coding via VBA
VBA Programming
- Understanding data types
- Developing functions
- Program control through conditionals and loops
- Debugging strategies
Data Analytics with Python
- Python overview
- Variables and data types
- Manipulating data with Pandas
- Function implementation
- Visualizing data using Matplotlib and Seaborn
- Data cleaning and transformation with Pandas
Introduction to Machine Learning with Python
- Linear Regression via scikit-learn
- Classification and regression trees in Python
- Classification using Support Vector Machines and Random Forests
- Clustering methods with scikit-learn
Requirements
No prior prerequisites are required to participate in this course.
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.
