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 in Excel
- Interface navigation
- Data management and manipulation
- Utilizing formulas and cell references
- Creating and interpreting charts
Advanced Excel Techniques
- Applying logical functions
- Conducting scenario analysis
- Using the Solver add-in
- Recording and using Macros
- Introductory coding concepts with VBA
Programming with VBA
- Understanding data types
- Developing custom functions
- Program control through conditionals and loops
- Effective debugging strategies
Python for Data Analysis
- Getting started with Python
- Managing variables and data types
- Data processing using the Pandas library
- Creating reusable functions
- Visualizing data with Matplotlib and Seaborn
- Advanced data cleaning and wrangling with Pandas
Machine Learning Fundamentals in Python
- Implementing Linear Regression with scikit-learn
- Building classification and regression trees
- Applying Support Vector Machines and Random Forests for classification
- Executing clustering algorithms using scikit-learn
Requirements
No prior specific knowledge or prerequisites are required to participate in this program.
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.