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
Foundational Excel Skills
- Navigating the interface
- Data manipulation techniques
- Utilizing formulas and cell references
- Creating charts
Advanced Excel Capabilities
- Applying logical functions
- Conducting scenario analysis
- Using the Solver tool
- Recording and managing macros
- Introduction to programming with VBA
Visual Basic for Applications (VBA)
- Understanding data types
- Developing custom functions
- Program control through conditionals and loops
- Applying debugging techniques
Data Analytics with Python
- Getting started with Python
- Variables and data types
- Data manipulation using the Pandas library
- Writing reusable functions
- Visualizing data with Matplotlib and Seaborn
- Data wrangling 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 techniques using scikit-learn
Requirements
No specific prerequisites are required to enroll 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.
