Get in Touch
 Duration 42 hours

Course Outline

Foundations in Excel

  • Interface navigation
  • Data management and manipulation
  • Utilizing formulas and cell references
  • Creating and interpreting charts

Advanced Excel Techniques

  • Applying logical functions
  • Conducting scenario analysis
  • Using the Solver add-in
  • Recording and using Macros
  • Introductory coding concepts with VBA

Programming with VBA

  • Understanding data types
  • Developing custom functions
  • Program control through conditionals and loops
  • Effective debugging strategies

Python for Data Analysis

  • Getting started with Python
  • Managing variables and data types
  • Data processing using the Pandas library
  • Creating reusable functions
  • Visualizing data with Matplotlib and Seaborn
  • Advanced data cleaning and wrangling with Pandas

Machine Learning Fundamentals in Python

  • Implementing Linear Regression with scikit-learn
  • Building classification and regression trees
  • Applying Support Vector Machines and Random Forests for classification
  • Executing clustering algorithms using scikit-learn

Requirements

No prior specific knowledge or prerequisites are required to participate in this program.

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories