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
Excel Fundamentals
- Navigating the interface
- Data manipulation techniques
- Working with formulas and cell references
- Building charts
Advanced Excel
- Using logical functions
- Conducting scenario analysis
- Utilizing the Solver tool
- Recording and managing macros
- Initial introduction to VBA coding
VBA Programming
- Understanding data types
- Creating custom functions
- Program control through conditional logic and loops
- Applying debugging strategies
Data Analytics with Python
- Getting started with Python
- Variables and data types
- Data manipulation using Pandas
- Developing Python functions
- Visualizing data with Matplotlib and Seaborn
- Data cleaning and wrangling with Pandas
Introduction to Machine Learning with Python
- Implementing Linear Regression with scikit-learn
- Building classification and regression trees in Python
- Classification using Support Vector Machines and Random Forests
- Applying clustering techniques via scikit-learn
Requirements
No prior specific requirements are necessary 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.
