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.
Testimonials (4)
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
All the topics which he covered including examples. And also explained how they are helpful in our daily job.
madduri madduri - Boskalis Singapore Pte Ltd
Course - QGIS for Geographic Information System
I really enjoyed the training. I found all modules to be applicable to problems that I am trying to solve at work. The integration of the training with jupyter notebooks was really impressive.
Mark Firmin - Environment and Climate Change Canada
Course - Python for Geographic Information System (GIS)
The thing I liked the most about the training was the organization and the location