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
Foundational Spreadsheet Operations
- Interface navigation and workflow
- Data management and structuring
- Formula construction and cell referencing
- Chart creation and interpretation
Advanced Analytical Capabilities
- Application of logical functions
- Scenario planning and analysis
- Optimization using Solver
- Macro development and automation
- Introduction to VBA programming concepts
VBA Programming
- Data type definitions and usage
- Function development and implementation
- Program control structures: conditionals and loops
- Debugging strategies and error resolution
Python for Data Analytics
- Python fundamentals and environment setup
- Variable management and data typing
- Data handling with the Pandas library
- Function creation in Python
- Visualization techniques using Matplotlib and Seaborn
- Data cleaning and transformation via Pandas
Machine Learning Fundamentals in Python
- Linear Regression models using scikit-learn
- Decision trees for classification and regression
- Support Vector Machines and Random Forest algorithms
- Clustering methods implemented in scikit-learn
Requirements
No specific 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)
Equipped with examples