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
Basic Excel
- Navigation
- Data manipulation
- Working with formulas and cell addresses
- Charts
Advanced Excel
- Logical functions
- Scenario analysis
- Solver
- Macros
- Introduction to code: VBA
VBA
- Data types
- Writing a function
- Program control: conditional evaluation and loops
- Debugging techniques
Data Analytics with Python
- Introduction to 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 prerequisites required to attend this course.
42 Hours
Testimonials (2)
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.
