Course Outline
Basic Excel
- Navigation
- Manipulating data
- Working with formulas and addresses
- Charts
Advanced Excel
- Logical functions
- Scenario analysis
- Solver
- Macros
- First glimpse of code: VBA
VBA
- Data types
- Writing a function
- Controlling a program: conditional evaluation and loops
- Debugging techniques
Data Analytics with Python
- Introducing Python
- Variables and types
- Data manipulation in Python using Pandas
- Writing functions
- Data visualization using Matplotlib and Seaborn
- Data wrangling with Pandas
Introduction to Machine Learning with Python
- Linear Regression using scikit-learn
- Classification and regression trees with Python
- Classification using Support Vector Machines and Random Forests
- Clustering techniques using scikit-learn
Requirements
There are no specific requirements needed to attend 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 8000 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (3)
Doing Exercise
Joe Pang - Lands Department, Hong Kong
Course - QGIS for Geographic Information System
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.
Ian - Archeoworks Inc.
Course - ArcGIS Fundamentals
I'm looking forward to having a training again with Any, he was really good, I'm just a GIS guy, but Any made everything clear to me, he explained complex processes in layman's terms. Keep it up, thank you.