Course Outline
Foundational Excel
- Navigation
- Data manipulation
- Utilizing formulas and cell references
- Charts
Advanced Excel
- Logical functions
- Scenario analysis
- Solver
- Macros
- Initial introduction to code: VBA
VBA
- Data types
- Defining functions
- Program control: conditional logic and loops
- Debugging methods
Data Analytics with Python
- Getting started with Python
- Variables and data types
- Data manipulation in Python using Pandas
- Creating functions
- Data visualization with Matplotlib and Seaborn
- Data wrangling using Pandas
Machine Learning Foundations with Python
- Linear Regression with scikit-learn
- Classification and regression trees in Python
- Classification using Support Vector Machines and Random Forests
- Clustering methods with scikit-learn
Requirements
No specific prerequisites are required for participation in this course.
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 7250 € + VAT*
Contact us for an exact quote and to hear our latest promotions
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.