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
Excel Fundamentals
- Interface navigation
- Data manipulation techniques
- Utilizing formulas and cell references
- Creating charts
Advanced Excel Techniques
- Logical functions
- Scenario analysis
- Using the Solver add-in
- Macros
- Introduction to code: VBA
VBA Programming
- Understanding data types
- Constructing custom functions
- Program control: conditional logic and loops
- Debugging strategies
Data Analytics with Python
- Overview of Python
- Variables and data types
- Manipulating data with Pandas
- Defining functions
- Visualizing data using Matplotlib and Seaborn
- Data wrangling with Pandas
Introduction to Machine Learning with Python
- Linear Regression with scikit-learn
- Classification and Regression Trees (CART) in Python
- Classification methods: Support Vector Machines and Random Forests
- Clustering techniques using scikit-learn
Requirements
No specific prerequisites are required to enroll in 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.
