Get in Touch
 Duration 42 hours

Course Outline

Foundational Spreadsheet Operations

  • Interface navigation and workflow
  • Data management and structuring
  • Formula construction and cell referencing
  • Chart creation and interpretation

Advanced Analytical Capabilities

  • Application of logical functions
  • Scenario planning and analysis
  • Optimization using Solver
  • Macro development and automation
  • Introduction to VBA programming concepts

VBA Programming

  • Data type definitions and usage
  • Function development and implementation
  • Program control structures: conditionals and loops
  • Debugging strategies and error resolution

Python for Data Analytics

  • Python fundamentals and environment setup
  • Variable management and data typing
  • Data handling with the Pandas library
  • Function creation in Python
  • Visualization techniques using Matplotlib and Seaborn
  • Data cleaning and transformation via Pandas

Machine Learning Fundamentals in Python

  • Linear Regression models using scikit-learn
  • Decision trees for classification and regression
  • Support Vector Machines and Random Forest algorithms
  • Clustering methods implemented in scikit-learn

Requirements

No specific prerequisites are required to participate in this course.

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories