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.
 42 Hours

Testimonials (5)

Upcoming Courses

Related Categories